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