HR_Benefit_MSTR (BE010130)

azurecurve Products Human Resources (414)3rd PartyHR_Benefit_MSTR (BE010130)

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

Display Name: HR_Benefit_MSTR
Physical Name: BE010130
Technical Name: HR_Benefit_MSTR

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
56	TIERSUSED_I	Tiers Used	Boolean	CB_Tiers_Used	0
57	MAJMEDCOVERAGE_I	Major Medical Coverage	Integer	INT5_%2	5
58	MAXOUTOFPOCKET_I	Max Out-Of-Pocket	Currency	DLR14_RB2_ST$	14
59	ELIGIBILITYDATE_I	Eligibility Date	Date	DT	8
60	PRIMARYBENEFICIARY_I	Primary Beneficiary	String	STR30_I0	30
61	SECBENEFICIARY_I	Secondary Beneficiary	String	STR30_I0	30
62	BNFTMTHD	Benefit Method	Integer	DDL_Benefit_Method	0
63	BNFFRMLA	Benefit Formula	Integer	GB	0
64	BNFPRCNT_1	Benefit Percent[1]	Currency	DLR8_U5%	8
65	BNFPRCNT_2	Benefit Percent[2]	Currency	DLR8_U5%	8
66	BNFPRCNT_3	Benefit Percent[3]	Currency	DLR8_U5%	8
67	BNFPRCNT_4	Benefit Percent[4]	Currency	DLR8_U5%	8
68	BNFPRCNT_5	Benefit Percent[5]	Currency	DLR8_U5%	8
69	DEDNMTHD	Deduction Method	Integer	DDL_Deduction_Method	0
70	DEDFRMLA	Deduction Formula	Integer	GB	0
71	DEDNPRCT_1	Deduction Percent[1]	Currency	DLR8_U5%	8
72	DEDNPRCT_2	Deduction Percent[2]	Currency	DLR8_U5%	8
73	DEDNPRCT_3	Deduction Percent[3]	Currency	DLR8_U5%	8
74	DEDNPRCT_4	Deduction Percent[4]	Currency	DLR8_U5%	8
75	DEDNPRCT_5	Deduction Percent[5]	Currency	DLR8_U5%	8
76	DEPYPRMX	Deduction Pay Period Max	Currency	DLR11_$S2	14
77	DEDYRMAX	Deduction Year Max	Currency	DLR11_$S2	14
78	DEDLTMAX	Deduction Lifetime Max	Currency	DLR11_$S2	14
79	DEDINITBAL	Deduction Initial Balance	Currency	DLR11_$S2	14
80	INACTBENEMPLOYEE	Inactive Benefit Employee	Boolean	CB_Inactive_Benefit_Employee	0
81	INACTBENEMPLR	Inactive Benefit Employer	Boolean	CB_Inactive_Benefit_Employer	0
82	Benefit_Fiscal_Max	Benefit Fiscal Max	Currency	DLR11_$U2	14
83	Deduction_Fiscal_Yr_Max	Deduction Fiscal Year Max	Currency	DLR11_$S2	14
84	LIFEINSURTYPE	Life Insurance Type	Integer	GB	0
85	OfferOfCoverageCode	Offer of Coverage Code	Integer	DDL_1095_Line_Code	0
86	SafeHarborCode	Safe Harbor Code	Integer	DDL_1095_Line_Code	0
87	LowestCostPremium	Lowest Cost Premium	Currency	DLR11_$U2	14

azurecurve Products Human Resources (414)3rd PartyHR_Benefit_MSTR (BE010130)

Leave a Reply Cancel reply