Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR_BLM41100
Product: HRM Solution Series (1911)
Series:
Display Name: Future Effective HR Benefits Group Display Name: HRM Solution Series
Physical Name: APR_BLM41100
Technical Name: APR_BLM_HRBenefit_SETP
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 |