HBENE - Employee Benefit (BE) Database
Order | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
B_401EAMT |
N |
7 |
2 |
401(k)/RSP Employee Contribution Am |
2 |
B_401EPCT |
N |
6 |
2 |
401(k)/RSP Employee Contribution Pc |
3 |
B_401RAMT |
N |
7 |
2 |
401(k)/RSP Employer Match Amount |
4 |
B_401RPCT |
N |
8 |
4 |
401(k)/RSP Employer Match Percent |
5 |
B_AUTOUP |
C |
1 |
0 |
Automatic Update (Y/N) |
6 |
B_BENECODE |
C |
10 |
0 |
Benefit Code |
7 |
B_BENEFIC |
C |
25 |
0 |
Beneficiary |
8 |
B_BENEID |
C |
1 |
0 |
Benefit Type Code (I/N/S/V) |
9 |
B_CERT |
C |
25 |
0 |
Certificate Number |
10 |
B_CHADATE |
T |
8 |
0 |
Last Change Date |
11 |
B_CHGEFF |
T |
8 |
0 |
Change Effective Date |
12 |
B_CHGREAS |
C |
40 |
0 |
Change Reason |
13 |
B_COMPANY |
C |
3 |
0 |
Company Code |
14 |
B_CONTRIB |
N |
7 |
2 |
Employee Contribution |
15 |
B_COVERAGE |
N |
7 |
0 |
Coverage Amount |
16 |
B_COVERTYP |
C |
20 |
0 |
Coverage Type |
17 |
B_COVIND |
C |
1 |
0 |
Coverage Indicator Code |
18 |
B_CURRENCY |
C |
3 |
0 |
Currency Type (USD/CAD) |
19 |
B_DCOVAMT |
N |
9 |
0 |
Dependent Coverage Amount |
20 |
B_DPREMIUM |
N |
7 |
2 |
Dependent Premium |
21 |
B_EFFDATE |
T |
8 |
0 |
Effective Date |
22 |
B_ELIGIBLE |
T |
8 |
0 |
Benefit Eligibility Date |
23 |
B_EMPBEG |
T |
8 |
0 |
Employee Coverage Begins |
24 |
B_EMPEND |
T |
8 |
0 |
Employee Coverage Ends |
25 |
B_EMPNO |
C |
9 |
0 |
Employee ID |
26 |
B_EPREMIUM |
N |
7 |
2 |
Employee Premium |
27 |
B_EXPDATE |
T |
8 |
0 |
Expiration Date |
28 |
B_MISC1 |
C |
10 |
0 |
Miscellaneous 1 |
29 |
B_MISC2 |
C |
10 |
0 |
Miscellaneous 2 |
30 |
B_MISC3 |
C |
10 |
0 |
Miscellaneous 3 |
31 |
B_MISC4 |
C |
10 |
0 |
Miscellaneous 4 |
32 |
B_OTHERAMT |
N |
10 |
2 |
Other Calculated Amount |
33 |
B_PERIOD |
C |
1 |
0 |
Period Code (H/W/B/M/S/Y/U) |
34 |
B_WAVDATE |
T |
8 |
0 |
Waive Date |
35 |
_AUTOUP |
C |
3 |
0 |
Automatic Update (Yes/No) |
36 |
_BENECODE |
C |
25 |
0 |
Benefit |
37 |
_BENEID |
C |
25 |
0 |
Benefit Type (Insurance/Savings) |
38 |
_PERIOD |
C |
25 |
0 |
Period (Hourly/Weekly/etc) |
39 |
_ZFILTER |
C |
25 |
0 |
Filter Function |