Module List > Module HRM tables APR_BLM31100
You are currently viewing the COMPANY database.
Change

COMPANY..APR_BLM31100 Table Definition

(COMPANY..BLM HR Benefit Setup History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BENEFIT char(7)
''
Benefit: ...(more) Join Now UPR00600.BENEFIT
DSCRIPTN char(31)
''

BENEFITSTATUS_I smallint
0

COMPLETIONSTATUS_I smallint
0

INACTIVE tinyint
0

BENEFITKIND_I smallint
0

BNFBEGDT datetime
'1/1/1900'
Benefit Be...(more) Join Now
BNFENDDT datetime
'1/1/1900'
Benefit En...(more) Join Now
VARBENFT tinyint
0
Variable B...(more) Join Now
BNFTFREQ smallint
0
Benefit Fr...(more) Join Now
CARRIER char(31)
''

GROUPNUMBER_I char(31)
''

PORTABLEBENEFIT_I tinyint
0

PORABLEINDEX_I smallint
0

MAXAGEEMP_I smallint
0

MAXAGEDEP_I smallint
0

MAXAGESP_I smallint
0

COSTEMPLOYEE_I numeric(19,5)
0

COSTEMPLOYER_I numeric(19,5)
0

COSTOTHER1_I numeric(19,5)
0

COSTOTHER2_I numeric(19,5)
0

I1_I smallint
0

I2_I smallint
0

I3_I smallint
0

I4_I smallint
0

GB_I smallint
0

COSTTOTAL_I numeric(19,5)
0

COSTCOBRA_I numeric(19,5)
0

BENAMOUNT_I numeric(19,5)
0

BENEFITDEDUCTIBLE_I numeric(19,5)
0

BNPAYPMX numeric(19,5)
0
Benefit Pa...(more) Join Now
BNFYRMAX numeric(19,5)
0
Benefit Ye...(more) Join Now
BNFLFMAX numeric(19,5)
0
Benefit Li...(more) Join Now
CHANGEBY_I char(15)
''
*Change By...(more) Join Now TATX1030.CHANGEBY_I
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
NOTESINDEX_I numeric(19,5)
0

NEAREST_I numeric(19,5)
0

NEARESTCHILD_I numeric(19,5)
0

NEARESTSPOUSE_I numeric(19,5)
0

NEARESTEMPLOYER_I numeric(19,5)
0

PREMMETHOD_I smallint
0

PREMIUMEMPLOYEE_I numeric(19,5)
0

PREMIUMSPOUSE_I numeric(19,5)
0

PREMIUMCHILD_I numeric(19,5)
0

PREMIUMEMPLOYER_I numeric(19,5)
0

PREMIUMSMOKER_I numeric(19,5)
0

FACTOR_I smallint
0

ROUNDUP_I tinyint
0

PDLIFE_I tinyint
0

CONTEMPMATCH_I numeric(19,5)
0

CONTRIBEMPLOYERMAX_I numeric(19,5)
0

MINAGE_I smallint
0

BONUSELACTIVE_I tinyint
0

LOANSALLOWED_I tinyint
0

HARDSHPWITHDRAW_I tinyint
0

TYPEOFCODE_I smallint
0

CONTRIBDOLLAR_I numeric(19,5)
0

CONTRIBPERCENT_I numeric(19,5)
0

MAJMEDCOVERAGE_I smallint
0

MAXOUTOFPOCKET_I numeric(19,5)
0

WAITINGPERIOD_I smallint
0

BNFTMTHD smallint
0
Benefit Me...(more) Join Now
BNFFRMLA smallint
0
Benefit Formula: 0 is Single, 1 is Tiered. In SBM, this field defaults to the value from the Benefit Formula field of the Payroll Benefit Setup table. The Benefit Formula field is always set to zero (0) in SBM. This field is not exposed in the SBM user interface.
BNFPRCNT_1 numeric(19,5)
0
Benefit Pe...(more) Join Now
BNFPRCNT_2 numeric(19,5)
0

BNFPRCNT_3 numeric(19,5)
0

BNFPRCNT_4 numeric(19,5)
0

BNFPRCNT_5 numeric(19,5)
0

DEDNMTHD smallint
0
Deduction ...(more) Join Now UPR00500.DEDNMTHD
DEDFRMLA smallint
0
Deduction ...(more) Join Now UPR00500.DEDFRMLA
DEDNPRCT_1 numeric(19,5)
0
Deduction ...(more) Join Now UPR00500.DEDNPRCT_1
DEDNPRCT_2 numeric(19,5)
0

DEDNPRCT_3 numeric(19,5)
0

DEDNPRCT_4 numeric(19,5)
0

DEDNPRCT_5 numeric(19,5)
0

DEPYPRMX numeric(19,5)
0
Deduction ...(more) Join Now
DEDYRMAX numeric(19,5)
0
Deduction ...(more) Join Now
DEDLTMAX numeric(19,5)
0
Deduction ...(more) Join Now
INACTBENEMPLOYEE tinyint
0

INACTBENEMPLR tinyint
0

GARNISHMENT tinyint
0

Benefit_Fiscal_Max numeric(19,5)
0

Deduction_Fiscal_Yr_Max numeric(19,5)
0

LIFEINSURTYPE smallint
0

SEQNUMBR int
0
Sequence N...(more) Join Now
CHANGEREASON_I char(31)
''

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3