HDEPEND - Employee Dependent (DE) Database

HDEPEND field information

 

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