HBEPLAN - Benefit Plan Table (BT) Database
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
BT_401RAMT |
C |
254 |
0 |
Employer 401(k)/RSP Contribution Am |
2 |
BT_401RPCT |
C |
254 |
0 |
Employer 401(k)/RSP Contribution Pc |
3 |
BT_AGE |
N |
5 |
2 |
Eligibility Age |
4 |
BT_AUTOADD |
C |
1 |
0 |
Automatically Add this Benefit (Y/N) |
5 |
BT_BENEID |
C |
1 |
0 |
Benefit Type Code (I/S) |
6 |
BT_CHGEFF |
T |
8 |
0 |
Effective Date for Benefit Amounts |
7 |
BT_COBRA |
L |
1 |
0 |
Automatically Add for COBRA (Y/N) |
8 |
BT_COMPANY |
C |
3 |
0 |
Company Code |
9 |
BT_CONTRIB |
C |
254 |
0 |
Employee Contribution Amt/Formula |
10 |
BT_COVER |
C |
254 |
0 |
Coverage Amount/Formula |
11 |
BT_COVIND |
C |
1 |
0 |
Coverage Indicator |
12 |
BT_DAYSEMP |
N |
3 |
0 |
Eligibility Days Employed |
13 |
BT_DCOVAMT |
C |
254 |
0 |
Dependent Coverage Amount Formula |
14 |
BT_DCOVIND |
C |
1 |
0 |
Dependent Coverage Indicator |
15 |
BT_DEFDATE |
N |
1 |
0 |
New Benefit Effective Date |
16 |
BT_DPREIND |
C |
1 |
0 |
Dependent Premium Indicator |
17 |
BT_DPREM |
C |
254 |
0 |
Dependent Premium Amount/Formula |
18 |
BT_EFFDATE |
T |
8 |
0 |
Coverage Period Start Date |
19 |
BT_EPREM |
C |
254 |
0 |
Employee Premium Amount/Formula |
20 |
BT_EXPDATE |
T |
8 |
0 |
Coverage Period Expiration Date |
21 |
BT_FOFMON |
L |
1 |
0 |
Indicator For Benefit Effective Date |
22 |
BT_HRSDAY |
N |
5 |
2 |
Eligibility Normal Units |
23 |
BT_MONTHS |
N |
2 |
0 |
Start benefit following ? months |
24 |
BT_OTHER |
C |
254 |
0 |
Eligibility Other Criteria |
25 |
BT_OTHERAM |
C |
254 |
0 |
Other Calculated Amount Criteria |
26 |
BT_PERIOD |
C |
1 |
0 |
Employer Contribution Period |
27 |
BT_RULE |
C |
1 |
0 |
Rule Record (Y/N) |
28 |
BT_SALHOUR |
C |
1 |
0 |
Eligibility Salary/Hourly Code |
29 |
BT_STATUS |
C |
3 |
0 |
Eligibility Employee Status |
30 |
BT_TYPE |
C |
1 |
0 |
(M)edical, (D)ental, (V)ision, ... |
31 |
CODE |
C |
10 |
0 |
Benefit Code |
32 |
FDESC |
C |
25 |
0 |
Benefit Description |
33 |
_AUTOADD |
C |
3 |
0 |
Automatically Add this Benefit Desc |
34 |
_BENEID |
C |
25 |
0 |
Benefit Type Description (Insurance |
35 |
_COBRA |
C |
3 |
0 |
Automatically Add for COBRA Descrip |
36 |
_ZFILTER |
C |
25 |
0 |
Filter Function |