| PlanID
|
Plan Identifier |
BigID |
12 |
|
| TypeFlag
|
Type Flag |
Enum |
1 |
|
 ENUM
| S | Stub |
| M | Medical |
| L | Life |
| E | Supp Life Employee |
| P | Supp Life Spouse |
| D | Supp Life Dependent |
| T | STD |
| U | LTD |
| X | Stop Loss |
| R | Employer Defined |
| Y | Employee |
| Z | Spouse |
| C | COBRA |
|
| BeneStart
|
Benefit Start Date |
Enum |
1 |
|
 ENUM
| H | On the hire date |
| F | First of month following hire date |
| O | Next open enrollment effective date |
| I | On the hire date if hired on 1st, 1st of next month otherwise |
| M | First of month following the waiting period |
| D | The day following the waiting period |
| N | Next open enrollment date following the waiting period |
|
| EligByJob
|
Eligible By Job Title Flag |
Varchar |
1 |
|
| EligByLoc
|
Eligible By Location Flag |
Varchar |
1 |
|
| HourEmpFlg
|
Hourly Employee Flag |
Varchar |
1 |
|
| MaxAge
|
Maximum Age |
Long |
12 |
|
| MaxAgeFlg
|
Maximum Age Flag |
Varchar |
1 |
|
| MinAge
|
Minimum Age |
Long |
12 |
|
| MinAgeFlg
|
Minimum Age Flag |
Varchar |
1 |
|
| MinHours
|
Minimum Hours |
Number |
22 |
|
| MinHrsFlg
|
Minimum Hours Flag |
Varchar |
1 |
|
| OpenEnrFlg
|
Open Enrollment Period Flag |
Varchar |
1 |
|
| SalEmpFlg
|
Salaried Employee Flag |
Varchar |
1 |
|
| WaitFlg
|
Waiting Period Flag |
Varchar |
1 |
|
| WaitPeriod
|
Waiting Period |
Long |
12 |
|
| WaitPrUnit
|
Waiting Period Unit |
Enum |
1 |
|
 ENUM
| D | Days |
| W | Weeks |
| M | Months |
| Y | Years |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|