| 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
|
|
|
|
|
| LIFEINSURTYPE |
smallint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|