BLM HR Benefit Setup History (APR_BLM31100)

azurecurve Products HRM Solution Series (1911)PayrollBLM HR Benefit Setup History (APR_BLM31100)

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

Product: HRM Solution Series (1911)
Series:

Display Name: BLM HR Benefit Setup History
Physical Name: APR_BLM31100
Technical Name: APR_BLM_HRBenefit_SETP_History

Group Display Name: HRM Solution Series
Group Technical Name: APR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BENEFIT	Benefit	String	STR6_Payroll_Code	6
2	DSCRIPTN	Description	String	STR30	30
3	BENEFITSTATUS_I	Benefit Status	Integer	DDL_Benefit_Status	0
4	COMPLETIONSTATUS_I	Completion Status	Integer	DDL_Completion_Status	0
5	INACTIVE	Inactive	Boolean	CB_Inactive	0
6	BENEFITKIND_I	Benefit Kind	Integer	DDL_Benefit_Kind	0
7	BNFBEGDT	Benefit Beg Date	Date	DT	8
8	BNFENDDT	Benefit End Date	Date	DT	8
9	VARBENFT	Variable Benefit	Boolean	CB_Variable	0
10	BNFTFREQ	Benefit Frequency	Integer	DDL_Ded/Ben Frequency	0
11	CARRIER	Carrier	String	STR30	30
12	GROUPNUMBER_I	Group Number	String	STR30_I0	30
13	PORTABLEBENEFIT_I	Portable Benefit	Boolean	CB	0
14	PORABLEINDEX_I	Portable Index	Integer	IINT2	2
15	MAXAGEEMP_I	Max Age-Emp	Integer	IINT2	2
16	MAXAGEDEP_I	Max Age-Dep	Integer	IINT2	2
17	MAXAGESP_I	Max Age-Sp	Integer	IINT2	2
18	COSTEMPLOYEE_I	Cost Employee	Currency	DLR11_$U2	14
19	COSTEMPLOYER_I	Cost Employer	Currency	DLR11_$U2	14
20	COSTOTHER1_I	Cost Other 1	Currency	DLR11_$S2	14
21	COSTOTHER2_I	Cost Other 2	Currency	DLR11_$S2	14
22	I1_I	i1	Integer	INT5_NoFormat	5
23	I2_I	i2	Integer	INT5_NoFormat	5
24	I3_I	i3	Integer	INT5_NoFormat	5
25	I4_I	i4	Integer	INT5_NoFormat	5
26	GB_I	GB	Integer	GB_I	0
27	COSTTOTAL_I	Cost Total	Currency	DLR11_$S2	14
28	COSTCOBRA_I	Cost COBRA	Currency	DLR11_$U2	14
29	BENAMOUNT_I	Ben Amount	Currency	DLR11_$S2	14
30	BENEFITDEDUCTIBLE_I	Benefit Deductible	Currency	DLR11_$U2	14
31	BNPAYPMX	Benefit Pay Period Max	Currency	DLR11_$U2	14
32	BNFYRMAX	Benefit Year Max	Currency	DLR11_$U2	14
33	BNFLFMAX	Benefit Lifetime Max	Currency	DLR11_$U2	14
34	CHANGEBY_I	Change By	String	STR15_User_ID	15
35	CHANGEDATE_I	Change Date	Date	DT	8
36	NOTESINDEX_I	Notes Index	Currency	DOLLAR	0
37	NEAREST_I	Nearest	Currency	DLR14_Whole	14
38	NEARESTCHILD_I	Nearest(Child)	Currency	DLR14_Whole	14
39	NEARESTSPOUSE_I	Nearest(Spouse)	Currency	DLR14_Whole	14
40	NEARESTEMPLOYER_I	Nearest(Employer)	Currency	DLR14_Whole	14
41	PREMMETHOD_I	Prem Method	Integer	GB_Premiums	0
42	PREMIUMEMPLOYEE_I	Premium Employee	Currency	DLR11_$U2	14
43	PREMIUMSPOUSE_I	Premium Spouse	Currency	DLR11_$U2	14
44	PREMIUMCHILD_I	Premium Child	Currency	DLR11_$U2	14
45	PREMIUMEMPLOYER_I	Premium Employer	Currency	DLR11_$U2	14
46	PREMIUMSMOKER_I	Premium Smoker	Currency	DLR11_$U2	14
47	FACTOR_I	Factor	Integer	INT4.2	4
48	ROUNDUP_I	Round Up	Boolean	CB_I	0
49	PDLIFE_I	Pd Life	Boolean	CB_I	0
50	CONTEMPMATCH_I	Contrib Employer Match	Currency	DLR8_U5%	8
51	CONTRIBEMPLOYERMAX_I	Contrib Employer Max	Currency	DLR5_%2	8
52	MINAGE_I	Min Age	Integer	IINT2	2
53	BONUSELACTIVE_I	Bonus Election Active	Boolean	CB_I	0
54	LOANSALLOWED_I	Loans Allowed	Boolean	CB_I	0
55	HARDSHPWITHDRAW_I	Hardship Withdrawals	Boolean	CB_I	0
56	TYPEOFCODE_I	Type of Code	Integer	DDL_Code_Type	0
57	CONTRIBDOLLAR_I	Contrib Dollar	Currency	DLR11_$U2	14
58	CONTRIBPERCENT_I	Contrib Percent	Currency	DLR8_U5%	8
59	MAJMEDCOVERAGE_I	Major Medical Coverage	Integer	INT5_%2	5
60	MAXOUTOFPOCKET_I	Max Out-Of-Pocket	Currency	DLR14_RB2_ST$	14
61	WAITINGPERIOD_I	Waiting Period	Integer	INT3_NoFormat	3
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	INACTBENEMPLOYEE	Inactive Benefit Employee	Boolean	CB_Inactive_Benefit_Employee	0
80	INACTBENEMPLR	Inactive Benefit Employer	Boolean	CB_Inactive_Benefit_Employer	0
81	GARNISHMENT	Garnishment	Boolean	CB_Garnishment	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	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
86	CHANGEREASON_I	Change Reason	String	STR30_I	30

azurecurve Products HRM Solution Series (1911)PayrollBLM HR Benefit Setup History (APR_BLM31100)

Leave a Reply Cancel reply