HBENE

Employee Benefit (BE) Database

Order Field Name Type Length Dec Description

1

B_401EAMT

N

7

2

401(k)/RSP Employee Contribution Am

2

B_401EPCT

N

6

2

401(k)/RSP Employee Contribution Pc

3

B_401RAMT

N

7

2

401(k)/RSP Employer Match Amount

4

B_401RPCT

N

8

4

401(k)/RSP Employer Match Percent

5

B_AUTOUP

C

1

0

Automatic Update (Y/N)

6

B_BENECODE

C

10

0

Benefit Code

7

B_BENEFIC

C

25

0

Beneficiary

8

B_BENEID

C

1

0

Benefit Type Code (I/N/S/V)

9

B_CERT

C

25

0

Certificate Number

10

B_CHADATE

T

8

0

Last Change Date

11

B_CHGEFF

T

8

0

Change Effective Date

12

B_CHGREAS

C

40

0

Change Reason

13

B_COMPANY

C

3

0

Company Code

14

B_CONTRIB

N

7

2

Employee Contribution

15

B_COVERAGE

N

7

0

Coverage Amount

16

B_COVERTYP

C

20

0

Coverage Type

17

B_COVIND

C

1

0

Coverage Indicator Code

18

B_CURRENCY

C

3

0

Currency Type (USD/CAD)

19

B_DCOVAMT

N

9

0

Dependent Coverage Amount

20

B_DPREMIUM

N

7

2

Dependent Premium

21

B_EFFDATE

T

8

0

Effective Date

22

B_ELIGIBLE

T

8

0

Benefit Eligibility Date

23

B_EMPBEG

T

8

0

Employee Coverage Begins

24

B_EMPEND

T

8

0

Employee Coverage Ends

25

B_EMPNO

C

9

0

Employee ID

26

B_EPREMIUM

N

7

2

Employee Premium

27

B_EXPDATE

T

8

0

Expiration Date

28

B_MISC1

C

10

0

Miscellaneous 1

29

B_MISC2

C

10

0

Miscellaneous 2

30

B_MISC3

C

10

0

Miscellaneous 3

31

B_MISC4

C

10

0

Miscellaneous 4

32

B_OTHERAMT

N

10

2

Other Calculated Amount

33

B_PERIOD

C

1

0

Period Code (H/W/B/M/S/Y/U)

34

B_WAVDATE

T

8

0

Waive Date

35

_AUTOUP

C

3

0

Automatic Update (Yes/No)

36

_BENECODE

C

25

0

Benefit

37

_BENEID

C

25

0

Benefit Type (Insurance/Savings)

38

_PERIOD

C

25

0

Period (Hourly/Weekly/etc)

39

_ZFILTER

C

25

0

Filter Function