HBEPLAN - Benefit Plan Table (BT) Database

HBEPLAN field information

 

Seq Field Name Type Length Dec Description

1

BT_401RAMT

C

254

0

Employer 401(k)/RSP Contribution Am

2

BT_401RPCT

C

254

0

 Employer 401(k)/RSP Contribution Pc

3

BT_AGE

N

5

2

Eligibility Age

4

BT_AUTOADD

C

1

0

Automatically Add this Benefit (Y/N)

5

BT_BENEID

C

1

0

 Benefit Type Code (I/S)

6

BT_CHGEFF

T

8

0

Effective Date for Benefit Amounts

7

BT_COBRA

L

1

0

Automatically Add for COBRA (Y/N)

8

BT_COMPANY

C

3

0

Company Code

9

BT_CONTRIB

C

254

0

Employee Contribution Amt/Formula

10

BT_COVER

C

254

0

Coverage Amount/Formula

11

BT_COVIND

C

1

0

Coverage Indicator

12

BT_DAYSEMP

N

3

0

Eligibility Days Employed

13

BT_DCOVAMT

C

254

0

Dependent Coverage Amount Formula

14

BT_DCOVIND

C

1

0

Dependent Coverage Indicator

15

BT_DEFDATE

N

1

0

New Benefit Effective Date

16

BT_DPREIND

C

1

0

Dependent Premium Indicator

17

BT_DPREM

C

254

0

Dependent Premium Amount/Formula

18

BT_EFFDATE

T

8

0

Coverage Period Start Date

19

BT_EPREM

C

254

0

Employee Premium Amount/Formula

20

BT_EXPDATE

T

8

0

Coverage Period Expiration Date

21

BT_FOFMON

L

1

0

Indicator For Benefit Effective Date

22

BT_HRSDAY

N

5

2

Eligibility Normal Units

23

BT_MONTHS

N

2

0

Start benefit following ? months

24

BT_OTHER

C

254

0

Eligibility Other Criteria

25

BT_OTHERAM

C

254

0

Other Calculated Amount Criteria

26

BT_PERIOD

C

1

0

Employer Contribution Period

27

BT_RULE

C

1

0

Rule Record (Y/N)

28

BT_SALHOUR

C

1

0

Eligibility Salary/Hourly Code

29

BT_STATUS

C

3

0

Eligibility Employee Status

30

BT_TYPE

C

1

0

(M)edical, (D)ental, (V)ision, ...

31

CODE

C

10

0

Benefit Code

32

FDESC

C

25

0

Benefit Description

33

_AUTOADD

C

3

0

Automatically Add this Benefit Desc

34

_BENEID

C

25

0

Benefit Type Description (Insurance

35

_COBRA

C

3

0

Automatically Add for COBRA Descrip

36

 _ZFILTER

C

25

0

 Filter Function