HR_Benefit_Life_Hist (HR24BE17)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/HR24BE17

Display Name: HR_Benefit_Life_Hist
Physical Name: HR24BE17
Technical Name: HR_Benefit_Life_Hist

Group Display Name: HR Third Party
Group Technical Name: HR_Third_Party

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPID_I	Emp ID	String	STR15_Employee_ID_I	15
2	BNFBEGDT	Benefit Beg Date	Date	DT	8
3	BENEFIT	Benefit	String	STR6_Payroll_Code	6
4	I1_I	i1	Integer	INT5_NoFormat	5
5	BENEFICIARYPRIMARY_I	Beneficiary Primary	String	STR30_I0	30
6	BENCONTINGENT_I	Beneficiary Contingent	String	STR30_I0	30
7	NAMEA15_I	NameA15	String	STR15	15
8	NAMEB15_I	NameB15	String	STR15	15
9	NAMEA50_I	NameA50	String	STR50_I	50
10	AGEEMPLOYEE_I	Age Employee	Integer	INT3_NoFormat	3
11	AGESPOUSE_I	Age Spouse	Integer	INT3_NoFormat	3
12	CHILDREN_I	Children	Integer	IINT2	2
13	LIFEAMTMAX_I	Life Amt Max	Currency	DLR14_Whole	14
14	LIFEAMTMAXSPOUSE_I	Life Amt Max Spouse	Currency	DLR14_Whole	14
15	LIFEAMTMAXCHILD_I	Life Amt Max Child	Currency	DLR14_Whole	14
16	NEAREST_I	Nearest	Currency	DLR14_Whole	14
17	NEARESTSPOUSE_I	Nearest(Spouse)	Currency	DLR14_Whole	14
18	NEARESTCHILD_I	Nearest(Child)	Currency	DLR14_Whole	14
19	BNFTFREQ	Benefit Frequency	Integer	DDL_Ded/Ben Frequency	0
20	SMOKER_I	Smoker	Boolean	CB_Smoker	0
21	SMOKERSP_I	SmokerSp	Boolean	CB_I	0
22	GB_I	GB	Integer	GB_I	0
23	NEARESTEMPLOYER_I	Nearest(Employer)	Currency	DLR14_Whole	14
24	PREMIUMEMPLOYER_I	Premium Employer	Currency	DLR11_$U2	14
25	PREMIUMEMPLOYEE_I	Premium Employee	Currency	DLR11_$U2	14
26	PREMIUMSMOKER_I	Premium Smoker	Currency	DLR11_$U2	14
27	PREMIUMSPOUSE_I	Premium Spouse	Currency	DLR11_$U2	14
28	PREMSMOKESPOUSE_I	Premium Smoking Spouse	Currency	DLR11_$U2	14
29	PREMIUMCHILD_I	Premium Child	Currency	DLR11_$U2	14
30	LIFEINSURTYPE	Life Insurance Type	Integer	GB	0