| 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 |
|
| CPayAmount
|
Flat amt emp contributes |
Number |
22 |
|
| CPay100Flg
|
Company Pays 100 Pct Flag |
Varchar |
1 |
|
| CPayFltFlg
|
Company Pays Flat Rate Flag |
Enum |
1 |
|
ENUM
| A | Employee pays 100% |
| P | Employee pays a percentage |
| F | Employee Pays a flag amount |
| O | Other - employee contribution varies |
|
| CPayPercnt
|
Company Pays Percentage |
Number |
22 |
|
| CPaySpPct
|
Company Pays Spouse Percentage |
Number |
22 |
|
| CPayDepPct
|
Company Pays Dependent Percent |
Number |
22 |
|
| CPaySmoke
|
Company Pays Smoker Same |
Varchar |
1 |
|
| PreTaxOptn
|
Pre Tax Option |
Enum |
1 |
|
ENUM
| B | Before Tax |
| A | After Tax |
| E | Either |
| N | Neither |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|