HRP_Benefit_TEMP (HRPBEN01)

azurecurve Products Human Resources (414)3rd PartyHRP_Benefit_TEMP (HRPBEN01)

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

Display Name: HRP_Benefit_TEMP
Physical Name: HRPBEN01
Technical Name: HRP_Benefit_TEMP

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

azurecurve Products Human Resources (414)3rd PartyHRP_Benefit_TEMP (HRPBEN01)

Leave a Reply Cancel reply