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. |