Module List > Module HR tables BE010130
You are currently viewing the COMPANY database.
Change

COMPANY..BE010130 Table Definition

(COMPANY..HR_Benefit_MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPID_I char(15)
''
Employee I...(more) Join Now TATX1030.EMPID_I
BENEFIT char(7)
''
Benefit: ...(more) Join Now UPR00600.BENEFIT
BENEFITTYPE_I char(7)
''

IINDEX_I smallint
0

BENEFITKIND_I smallint
0

COMPLETIONSTATUS_I smallint
0

POLICYNUMBER_I char(31)
''

BENEFITSTATUS_I smallint
0

INACTIVE tinyint
0
Inactive: ...(more) Join Now RM00101.INACTIVE
OVERRIDE_I tinyint
0

CHECK1_I tinyint
0

CHECK2_I tinyint
0

CHECK3_I tinyint
0

CHECK4_I tinyint
0

CHECK5_I tinyint
0

DATEDUE_I datetime
'1/1/1900'

DSCRIPTN char(31)
''
Descriptio...(more) Join Now CM20300.DSCRIPTN
COMMENTSTR10_I char(11)
''

IBENEFITAMOUNT_I numeric(19,5)
0.00

LIFEAMTEMPL_I numeric(19,5)
0.00

LIFEAMTSPOUSE_I numeric(19,5)
0.00

LIFEAMTCHILDREN_I numeric(19,5)
0.00

BENELIGIBILEDATE_I datetime
'1/1/1900'

BNFBEGDT datetime
'1/1/1900'
Benefit Be...(more) Join Now UPR00600.BNFBEGDT
BNFENDDT datetime
'1/1/1900'
Benefit En...(more) Join Now UPR00600.BNFENDDT
VARBENFT tinyint
0
Variable B...(more) Join Now UPR00600.VARBENFT
BNFTFREQ smallint
0
Benefit Fr...(more) Join Now UPR00600.BNFTFREQ
COSTEMPLOYEE_I numeric(19,5)
0.00

COSTEMPLOYER_I numeric(19,5)
0.00

COSTOTHER1_I numeric(19,5)
0.00

COSTOTHER2_I numeric(19,5)
0.00

I1_I smallint
0

I2_I smallint
0

I3_I smallint
0

I4_I smallint
0

NUMBEROFCHILDREN_I smallint
0

COSTTOTAL_I numeric(19,5)
0.00

COSTCOBRA_I numeric(19,5)
0.00

BENEFITDEDUCTIBLE_I numeric(19,5)
0.00

BNPAYPMX numeric(19,5)
0.00
Benefit Pa...(more) Join Now UPR00600.BNPAYPMX
BNFYRMAX numeric(19,5)
0.00
Benefit Ye...(more) Join Now UPR00600.BNFYRMAX
BNFLFMAX numeric(19,5)
0.00
Benefit Li...(more) Join Now UPR00600.BNFLFMAX
BENEFICIARYINDEX_I int
0

CHANGEBY_I char(15)
''
*Change By...(more) Join Now UPR00100.CHANGEBY_I
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now UPR00100.CHANGEDATE_I
NOTESINDEX_I numeric(19,5)
0.00

CONTRIBPRETAX_I numeric(19,5)
0.00

CONTPRETAXDLR_I numeric(19,5)
0.00

CONTRIBAFTERTAX_I numeric(19,5)
0.00

CONTAFTERTAXDLR_I numeric(19,5)
0.00

CONTRIBBONUS_I numeric(19,5)
0.00

CONTRIBBONUSDOLLAR_I numeric(19,5)
0.00

HIGHLYCOMPENSATED_I tinyint
0

LOANACTIVE_I tinyint
0

TYPEOFCODE_I smallint
0

TIERSUSED_I tinyint
0

MAJMEDCOVERAGE_I smallint
0

MAXOUTOFPOCKET_I numeric(19,5)
0.00

ELIGIBILITYDATE_I datetime
'1/1/1900'

PRIMARYBENEFICIARY_I char(31)
''

SECBENEFICIARY_I char(31)
''

BNFTMTHD smallint
0
Benefit Me...(more) Join Now UPR00600.BNFTMTHD
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. APR_BLM42101.BNFFRMLA
BNFPRCNT_1 numeric(19,5)
0.00
Benefit Pe...(more) Join Now UPR00600.BNFPRCNT_1
BNFPRCNT_2 numeric(19,5)
0.00

BNFPRCNT_3 numeric(19,5)
0.00

BNFPRCNT_4 numeric(19,5)
0.00

BNFPRCNT_5 numeric(19,5)
0.00

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

DEDNPRCT_3 numeric(19,5)
0.00

DEDNPRCT_4 numeric(19,5)
0.00

DEDNPRCT_5 numeric(19,5)
0.00

DEPYPRMX numeric(19,5)
0.00
Deduction ...(more) Join Now UPR00500.DEPYPRMX
DEDYRMAX numeric(19,5)
0.00
Deduction ...(more) Join Now UPR00500.DEDYRMAX
DEDLTMAX numeric(19,5)
0.00
Deduction ...(more) Join Now UPR00500.DEDLTMAX
DEDINITBAL numeric(19,5)
0.00

INACTBENEMPLOYEE tinyint
0

INACTBENEMPLR tinyint
0

Benefit_Fiscal_Max numeric(19,5)
0.00

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Deduction_Fiscal_Yr_Max numeric(19,5)
0.00

LIFEINSURTYPE smallint
0

OfferOfCoverageCode smallint
0

SafeHarborCode smallint
0

LowestCostPremium numeric
0.00

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