Archive_HR_Benefit_History_2 (AR2BEN10)

azurecurve Products Human Resources (414)3rd PartyArchive_HR_Benefit_History_2 (AR2BEN10)

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

Display Name: Archive_HR_Benefit_History_2
Physical Name: AR2BEN10
Technical Name: Archive_HR_Benefit_History_2

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	BENEFITTYPE_I	Benefit Type	String	STR6_U0	6
6	IINDEX_I	IIndex	Integer	IINT2	2
7	POLICYNUMBER_I	Policy Number	String	STR30_I0	30
8	GROUPNUMBER_I	Group Number	String	STR30_I0	30
9	DATE1	Date	Date	DT6	6
10	BENEFITSTATUS_I	Benefit Status	Integer	DDL_Benefit_Status	0
11	INACTIVE	Inactive	Boolean	CB_Inactive	0
12	OVERRIDE_I	Override	Boolean	CB_I	0
13	CHECK1_I	Check1	Boolean	CB_I	0
14	CHECK2_I	Check2	Boolean	CB_I	0
15	CHECK3_I	Check3	Boolean	CB_I	0
16	CHECK4_I	Check4	Boolean	CB_I	0
17	CHECK5_I	Check5	Boolean	CB_I	0
18	DATEDUE_I	Date Due	Date	DT	8
19	DSCRIPTN	Description	String	STR30	30
20	COMMENTSTR10_I	CommentStr10	String	STR10	10
21	IBENEFITAMOUNT_I	IBenefit Amount	Currency	DLR11_$U2	14
22	LIFEAMTEMPL_I	Life Amt Empl	Currency	DLR14_Whole	14
23	LIFEAMTSPOUSE_I	Life Amt Spouse	Currency	DLR14_Whole	14
24	LIFEAMTCHILDREN_I	Life Amt Child(ren)	Currency	DLR14_Whole	14
25	BENELIGIBILEDATE_I	Benefit Eligibility Date	Date	DT	8
26	BNFENDDT	Benefit End Date	Date	DT	8
27	VARBENFT	Variable Benefit	Boolean	CB_Variable	0
28	BNFTFREQ	Benefit Frequency	Integer	DDL_Ded/Ben Frequency	0
29	COSTEMPLOYEE_I	Cost Employee	Currency	DLR11_$U2	14
30	COSTEMPLOYER_I	Cost Employer	Currency	DLR11_$U2	14
31	COSTOTHER1_I	Cost Other 1	Currency	DLR11_$S2	14
32	COSTOTHER2_I	Cost Other 2	Currency	DLR11_$S2	14
33	COSTOTHER3_I	Cost Other 3	Currency	DLR11_$S2	14
34	I2_I	i2	Integer	INT5_NoFormat	5
35	I3_I	i3	Integer	INT5_NoFormat	5
36	I4_I	i4	Integer	INT5_NoFormat	5
37	NUMBEROFCHILDREN_I	Number of children	Integer	INT2	2
38	COSTTOTAL_I	Cost Total	Currency	DLR11_$S2	14
39	COSTCOBRA_I	Cost COBRA	Currency	DLR11_$U2	14
40	BENEFITDEDUCTIBLE_I	Benefit Deductible	Currency	DLR11_$U2	14
41	BNPAYPMX	Benefit Pay Period Max	Currency	DLR11_$U2	14
42	BNFYRMAX	Benefit Year Max	Currency	DLR11_$U2	14
43	BNFLFMAX	Benefit Lifetime Max	Currency	DLR11_$U2	14
44	BENEFICIARYINDEX_I	Beneficiary Index	Long Integer	LONGINT	0
45	CHANGEBY_I	Change By	String	STR15_User_ID	15
46	CHANGEDATE_I	Change Date	Date	DT	8
47	NOTESINDEX_I	Notes Index	Currency	DOLLAR	0
48	CONTRIBPRETAX_I	Contrib Pre Tax	Currency	DLR8_U5%	8
49	CONTPRETAXDLR_I	Contrib Pre Tax Dollar	Currency	DLR11_$U2	14
50	CONTRIBAFTERTAX_I	Contrib After Tax	Currency	DLR8_U5%	8
51	CONTAFTERTAXDLR_I	Contrib After Tax Dollar	Currency	DLR11_$U2	14
52	CONTRIBBONUS_I	Contrib Bonus	Currency	DLR8_U5%	8
53	CONTRIBBONUSDOLLAR_I	Contrib Bonus Dollar	Currency	DLR11_$U2	14
54	HIGHLYCOMPENSATED_I	Highly Compensated	Boolean	CB_I	0
55	LOANACTIVE_I	Loan Active	Boolean	CB_I	0
56	LIFEINSURTYPE	Life Insurance Type	Integer	GB	0

azurecurve Products Human Resources (414)3rd PartyArchive_HR_Benefit_History_2 (AR2BEN10)

Leave a Reply Cancel reply