| 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 |
|
| BorVstFund
|
Borrow Vested Funds Flag |
Varchar |
1 |
|
| EmpMaxAmt
|
Employee Maximum Amount |
Number |
22 |
|
| EmpMaxPct
|
Employee Maximum Percentage |
Number |
22 |
|
| EmprMAmtPr
|
Employer Minimum Amount Per |
Enum |
1 |
|
 ENUM
| D | Day |
| W | Week |
| B | Bi-Weekly |
| S | Semi-Monthly |
| M | Month |
| Y | Year |
|
| EmprMinAmt
|
Employer Minimum Amount |
Number |
22 |
|
| EmprMinPct
|
Employer Minimum Percentage |
Number |
22 |
|
| HspWthVFnd
|
Hardship Withdrawal Flag |
Varchar |
1 |
|
| MinAmtPctF
|
Min Amount or Percentage Flag |
Enum |
1 |
|
 ENUM
|
| MinEmprFlg
|
Minimum Employer Contrib Flag |
Varchar |
1 |
|
| Age50CatchUpFlag
|
Age 50 Ketchup Flag |
Varchar |
1 |
|
| MatchLOSFlag
|
|
Enum |
1 |
|
 ENUM
|
| HireEnrFlag
|
|
Enum |
1 |
|
 ENUM
| H | LOS table starts on hire date |
| E | LOS table starts on enrollment date |
|
| TrackFunds
|
Track Funds Flag |
Varchar |
1 |
|
| VestStart
|
Vesting Begins Flag |
Enum |
1 |
|
 ENUM
|
| LOSMatchStart
|
|
Enum |
1 |
|
 ENUM
| A | Current calendar year |
| B | Next calendar year |
| C | Current calendar year or mid year |
| D | Next calendar year or mid year |
| E | Current calendar quarter |
| F | Next calendar quarter |
| G | Current month |
| H | Next month |
| I | Prior open enrollment period |
| J | Next open enrollment period |
|
| RothAfterTaxFlag
|
For Roth 401k, is deduction made after tax |
Varchar |
1 |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|