HDEPEND - Employee Dependent (DE) Database
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
D_ADDRESS1 |
C |
28 |
0 |
Street Address Line 1 |
2 |
D_ADDRESS2 |
C |
28 |
0 |
Street Address Line 2 |
3 |
D_ADDRESS3 |
C |
28 |
0 |
City |
4 |
D_BENE |
C |
20 |
0 |
Selected Benefit Types |
5 |
D_BIRTH |
T |
8 |
0 |
Birth Date |
6 |
D_CHADATE |
T |
8 |
0 |
Last Change Date |
7 |
D_COMPANY |
C |
3 |
0 |
Company Code |
8 |
D_DEPID |
N |
9 |
0 |
Dependent ID Number |
9 |
D_DTYPE |
C |
1 |
0 |
Dependent or Beneficiary |
10 |
D_EFFDATE1 |
T |
8 |
0 |
Benefit Plan 1 Effective Date |
11 |
D_EFFDATE2 |
T |
8 |
0 |
Benefit Plan 2 Effective Date |
12 |
D_EFFDATE3 |
T |
8 |
0 |
Benefit Plan 3 Effective Date |
13 |
D_EFFDATE4 |
T |
8 |
0 |
Benefit Plan 4 Effective Date |
14 |
D_EFFDATE5 |
T |
8 |
0 |
Benefit Plan 5 Effective Date |
15 |
D_EMPNO |
C |
9 |
0 |
Employee ID |
16 |
D_EXPDATE1 |
T |
8 |
0 |
Benefit Plan 1 Expiration Date |
17 |
D_EXPDATE2 |
T |
8 |
0 |
Benefit Plan 2 Expiration Date |
18 |
D_EXPDATE3 |
T |
8 |
0 |
Benefit Plan 3 Expiration Date |
19 |
D_EXPDATE4 |
T |
8 |
0 |
Benefit Plan 4 Expiration Date |
20 |
D_EXPDATE5 |
T |
8 |
0 |
Benefit Plan 5 Expiration Date |
21 |
D_FNAME |
C |
12 |
0 |
First Name |
22 |
D_LNAME |
C |
25 |
0 |
Last Name |
23 |
D_MI |
C |
1 |
0 |
Middle Initial |
24 |
D_OTHER1 |
C |
10 |
0 |
Other |
25 |
D_RELATION |
C |
6 |
0 |
Relation Code |
26 |
D_SEX |
C |
1 |
0 |
Gender Code (M/F) |
27 |
D_SMOKER |
C |
1 |
0 |
Smoker Code (Y/N) |
28 |
D_SSNO |
C |
11 |
0 |
Social Security Number/Social Insur |
29 |
D_SSNSIN |
C |
2 |
0 |
SSN or SIN (US/CN) |
30 |
_NAME1 |
C |
25 |
0 |
Name: Last, First Middle |
31 |
_NAME2 |
C |
25 |
0 |
Name: First Middle Last |
32 |
_SEX |
C |
25 |
0 |
Gender Description (Male/Female) |
33 |
_SMOKER |
C |
3 |
0 |
Smoker Description (Yes/No) |
34 |
_ZFILTER |
C |
25 |
0 |
Filter Function |