PC40802 - PC Position Benefit Inheritance
Query Builder
| 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 |