| 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 |
|
| ComCovrFlg
|
Common Coverage Flag |
Varchar |
1 |
|
| CovrgClass
|
Coverage Classifier |
Enum |
1 |
|
 ENUM
| E | Employment Status |
| S | Salary vs Hourly |
| P | Position Name |
| L | Location |
| D | Department |
| G | Length of Service |
| R | Salary Range |
| C | Class |
| X | $$Category |
|
| LifeADDFlg
|
Life or AD+D Plan Type Flag |
Enum |
1 |
|
 ENUM
|
| MaxCovrAmt
|
Maximum Coverage Amount |
Number |
22 |
|
| MaxWOProof
|
Max Amount W/O Proof Good Hlth |
Number |
22 |
|
| MaxSupFlag
|
Max Supplemental Life Flag |
Enum |
1 |
|
 ENUM
| L | Life Only |
| S | Supp Life Only |
| C | Combined |
|
| MaxCovrMpy
|
Maximum times salary |
Number |
22 |
|
| MaxCovrOptn
|
Amount | Multiplier | Both |
Enum |
1 |
|
 ENUM
| A | Amount |
| M | Multiplier |
| B | Both |
|
| MaxGtLtOptn
|
> or < |
Enum |
1 |
|
 ENUM
|
| MinCovrAmt
|
Minimum Coverage Amount |
Number |
22 |
|
| RoundAmt
|
Round Amount |
Number |
22 |
|
| RoundFlg
|
Round Flag |
Enum |
1 |
|
 ENUM
| Y | Up |
| N | No |
| D | Down |
| R | Round to Nearest |
|
| SalaryMpy
|
Salary Multiplier |
Number |
22 |
|
| SmokerRate
|
Smoker Rate |
Varchar |
1 |
|
| SpecVolAmt
|
Specific Volume Amount |
Number |
22 |
|
| SpecVolFlg
|
Specific Volume Flag |
Varchar |
1 |
|
| WaiverFlg
|
Waiver of Premium Flag |
Varchar |
1 |
|
| WaiverWPrd
|
Waiver of Premium Wait Period |
Long |
12 |
|
| LstModBy
|
Last Modified By Name |
Varchar |
40 |
|
| LstModDate
|
Last Modified Date |
Date |
32 |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|