| 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 |
|
| AgStpLsFlg
|
Aggregate Stop Loss Flag |
Varchar |
1 |
|
| BenAmtPct
|
Benefit Amount Percent |
Number |
22 |
|
| BuyUpFlag
|
Allow Buy Up Flag |
Varchar |
1 |
|
| 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 |
|
| EviReqFlg
|
Proof of Good Health Flag |
Varchar |
1 |
|
| MaxWOProof
|
Max Amount W/O Proof Good Hlth |
Number |
22 |
|
| MinPremFlg
|
Mimimum Premium Flag |
Varchar |
1 |
|
| NteAmtPct
|
Not to Exceed Amt or Percent |
Number |
22 |
|
| PerUnit
|
Benify Per Unit |
Enum |
1 |
|
 ENUM
|
| PreTaxOptn
|
Pre Tax Option |
Enum |
1 |
|
 ENUM
| B | Before Tax |
| A | After Tax |
| E | Either |
| N | Neither |
|
| SelfFndFlg
|
Self Funded Flag |
Varchar |
1 |
|
| StopLosFlg
|
Stop Loss Flag |
Varchar |
1 |
|
| VolumBased
|
Volume Based Flag |
Enum |
1 |
|
 ENUM
|
| VolumeAmt1
|
Volume Amount |
Number |
22 |
|
| WaiverFlg
|
Waiver of Premium Flag |
Varchar |
1 |
|
| WaiverWPrd
|
Waiver of Premium Wait Period |
Long |
12 |
|
| RoundFlg
|
Round Flag |
Enum |
1 |
|
 ENUM
| Y | Up |
| N | No |
| D | Down |
| R | Round to Nearest |
|
| RoundAmt
|
Round Amount |
Number |
22 |
|
| AlwTaxChoiceFlag
|
|
Varchar |
1 |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|