HDEPBEN - Dependent Benefits (DB) Database
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
D_BENECODE |
C |
10 |
0 |
Benefit Plan Code |
2 |
D_CHADATE |
T |
8 |
0 |
Last Change Date |
3 |
D_COMPANY |
C |
3 |
0 |
Company Code |
4 |
D_COVERAGE |
N |
7 |
0 |
Coverage Amount |
5 |
D_DEPID |
N |
9 |
0 |
Dependent ID Number |
6 |
D_EFFDATE |
T |
8 |
0 |
Coverage Effective Date |
7 |
D_EMPNO |
C |
9 |
0 |
Employee ID |
8 |
D_EXPDATE |
T |
8 |
0 |
Coverage Expiration Date |
9 |
D_MISC1 |
C |
10 |
0 |
Miscellaneous Field 1 |
10 |
D_MISC2 |
C |
10 |
0 |
Miscellaneous Field 2 |
11 |
D_MISC3 |
C |
10 |
0 |
Miscellaneous Field 3 |
12 |
D_MISC4 |
C |
10 |
0 |
Miscellaneous Field 4 |
13 |
D_PREMIUM |
N |
7 |
2 |
Dependent Premium |