Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AR24BE17
Product: Human Resources (414)
Series: 3rd Party
Display Name: Archive_HR_Benefit_Life_Hist Group Display Name: HR Third Party
Physical Name: AR24BE17
Technical Name: Archive_HR_Benefit_Life_Hist
Group Technical Name: HR_Third_Party
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
|---|---|---|---|---|---|---|
| 1 | EMPID_I  | Emp ID | STR15_Employee_ID_I | String | 16 | 15 |
| 2 | BNFBEGDT | Benefit Beg Date | DT | Date | 4 | 8 |
| 3 | BENEFIT | Benefit | STR6_Payroll_Code | String | 8 | 6 |
| 4 | I1_I | i1 | INT5_NoFormat | Integer | 2 | 5 |
| 5 | BENEFICIARYPRIMARY_I | Beneficiary Primary | STR30_I0 | String | 32 | 30 |
| 6 | BENCONTINGENT_I | Beneficiary Contingent | STR30_I0 | String | 32 | 30 |
| 7 | NAMEA15_I | NameA15 | STR15 | String | 16 | 15 |
| 8 | NAMEB15_I | NameB15 | STR15 | String | 16 | 15 |
| 9 | NAMEA50_I | NameA50 | STR50_I | String | 52 | 50 |
| 10 | AGEEMPLOYEE_I | Age Employee | INT3_NoFormat | Integer | 2 | 3 |
| 11 | AGESPOUSE_I | Age Spouse | INT3_NoFormat | Integer | 2 | 3 |
| 12 | CHILDREN_I | Children | IINT2 | Integer | 2 | 2 |
| 13 | LIFEAMTMAX_I | Life Amt Max | DLR14_Whole | Currency | 10 | 14 |
| 14 | LIFEAMTMAXSPOUSE_I | Life Amt Max Spouse | DLR14_Whole | Currency | 10 | 14 |
| 15 | LIFEAMTMAXCHILD_I | Life Amt Max Child | DLR14_Whole | Currency | 10 | 14 |
| 16 | NEAREST_I | Nearest | DLR14_Whole | Currency | 10 | 14 |
| 17 | NEARESTSPOUSE_I | Nearest(Spouse) | DLR14_Whole | Currency | 10 | 14 |
| 18 | NEARESTCHILD_I | Nearest(Child) | DLR14_Whole | Currency | 10 | 14 |
| 19 | BNFTFREQ | Benefit Frequency | DDL_Ded/Ben Frequency | Integer | 2 | 0 |
| 20 | SMOKER_I | Smoker | CB_Smoker | Boolean | 2 | 0 |
| 21 | SMOKERSP_I | SmokerSp | CB_I | Boolean | 2 | 0 |
| 22 | GB_I | GB | GB_I | Integer | 2 | 0 |
| 23 | NEARESTEMPLOYER_I | Nearest(Employer) | DLR14_Whole | Currency | 10 | 14 |
| 24 | PREMIUMEMPLOYER_I | Premium Employer | DLR11_$U2 | Currency | 10 | 14 |
| 25 | PREMIUMEMPLOYEE_I | Premium Employee | DLR11_$U2 | Currency | 10 | 14 |
| 26 | PREMIUMSMOKER_I | Premium Smoker | DLR11_$U2 | Currency | 10 | 14 |
| 27 | PREMIUMSPOUSE_I | Premium Spouse | DLR11_$U2 | Currency | 10 | 14 |
| 28 | PREMSMOKESPOUSE_I | Premium Smoking Spouse | DLR11_$U2 | Currency | 10 | 14 |
| 29 | PREMIUMCHILD_I | Premium Child | DLR11_$U2 | Currency | 10 | 14 |
| 30 | LIFEINSURTYPE | Life Insurance Type | GB | Integer | 2 | 0 |
| 31 | DEX_ROW_ID | int | int | 10 | 10 | |
DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column. | ||||||