HDEPBEN - Dependent Benefits (DB) Database

HDEPBEN field information

 

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