OEBEPLAN

Benefit Plan Table for Open Enrollment (OEBT) Database

Seq Field Name Type Length Dec Description

1

BT_401RAMT

C

254

0

Employer 401(k) Contribution Amt

2

BT_401RPCT

C

254

0

Employer 401(k) Contribution Pct

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, etc.

31

CODE

C

10

0

Benefit Code

32

FDESC

C

25

0

Benefit Description

33

_AUTOADD

C

3

0

Automatically Add this Benefit Description

34

_BENEID

C

25

0

Benefit Type Description (Insurance/Savings)

35

_COBRA

C

3

0

Automatically Add for COBRA Description

36

_ZFILTER

C

25

0

Filter Function