Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
PLANCODE | Plan |
String | 16 | View | |
JOBTITLE | Job Title |
String | 8 | View | |
SEAT | Seat |
Long Integer | 4 | View | |
SEQNUMBR | Sequence Number |
Long Integer | 4 | View | |
BENEFIT | Benefit |
String | 8 | View | |
DEDCAMNT_1 | Deduction Amount[1] |
Currency | 10 | View | |
DEDCAMNT_2 | Deduction Amount[2] |
Currency | 10 | View | |
DEDCAMNT_3 | Deduction Amount[3] |
Currency | 10 | View | |
DEDCAMNT_4 | Deduction Amount[4] |
Currency | 10 | View | |
DEDCAMNT_5 | Deduction Amount[5] |
Currency | 10 | View | |
BNFBEGDT | Benefit Beg Date |
Date | 4 | View | |
BENEFITCB | Benefit CB |
Boolean | 2 | View | |
DEDNMTHD | Deduction Method |
Integer | 2 | View | |
DEDNPRCT_1 | Deduction Percent[1] |
Currency | 10 | View | |
DEDNPRCT_2 | Deduction Percent[2] |
Currency | 10 | View | |
DEDNPRCT_3 | Deduction Percent[3] |
Currency | 10 | View | |
DEDNPRCT_4 | Deduction Percent[4] |
Currency | 10 | View | |
DEDNPRCT_5 | Deduction Percent[5] |
Currency | 10 | View | |
DEDFRMLA | Deduction Formula |
Integer | 2 | View | |
BENEFITSTATUS_I | Benefit Status |
Integer | 2 | View | |
DEDTRMAX_1 | Deduction Tier Max[1] |
Currency | 10 | View | |
DEDTRMAX_2 | Deduction Tier Max[2] |
Currency | 10 | View | |
DEDTRMAX_3 | Deduction Tier Max[3] |
Currency | 10 | View | |
DEDTRMAX_4 | Deduction Tier Max[4] |
Currency | 10 | View | |
DEDTRMAX_5 | Deduction Tier Max[5] |
Currency | 10 | View | |
DETRMXUN_1 | Deduction Tier Max Units[1] |
Long Integer | 4 | View | |
DETRMXUN_2 | Deduction Tier Max Units[2] |
Long Integer | 4 | View | |
DETRMXUN_3 | Deduction Tier Max Units[3] |
Long Integer | 4 | View | |
DETRMXUN_4 | Deduction Tier Max Units[4] |
Long Integer | 4 | View | |
DETRMXUN_5 | Deduction Tier Max Units[5] |
Long Integer | 4 | View | |
CHILDREN_I | Children |
Integer | 2 | View | |
CONTRIBAFTERTAX_I | Contrib After Tax |
Currency | 10 | View | |
CONTAFTERTAXDLR_I | Contrib After Tax Dollar |
Currency | 10 | View | |
CONTRIBBONUS_I | Contrib Bonus |
Currency | 10 | View | |
CONTRIBBONUSDOLLAR_I | Contrib Bonus Dollar |
Currency | 10 | View | |
CONTRIBPRETAX_I | Contrib Pre Tax |
Currency | 10 | View | |
CONTPRETAXDLR_I | Contrib Pre Tax Dollar |
Currency | 10 | View | |
EARNINGSCODE | Earnings Code |
String | 16 | View | |
PREMMETHOD_I | Prem Method |
Integer | 2 | View | |
LIFEAMTCHILDREN_I | Life Amt Child(ren) |
Currency | 10 | View | |
LIFEAMTEMPL_I | Life Amt Empl |
Currency | 10 | View | |
LIFEAMTSPOUSE_I | Life Amt Spouse |
Currency | 10 | View | |
SMOKER_I | Smoker |
Boolean | 2 | View | |
SMOKERSP_I | SmokerSp |
Boolean | 2 | View | |
TIERSUSED_I | Tiers Used |
Boolean | 2 | View |