| PlanID
|
Plan Identifier |
BigID |
12 |
|
| CstID
|
Custom field def id |
BigID |
12 |
|
| CustomFlag
|
Y/N |
Varchar |
1 |
|
| EssVolAccess
|
[Change | View | No Access] |
Enum |
1 |
None | View | Change |
 ENUM
|
| EssVolAltNm
|
Alternate name shown in ESS |
Varchar |
80 |
|
| EssEECntAccess
|
[Change | View | No Access] |
Enum |
1 |
None | View | Change |
 ENUM
|
| RateTableFlag
|
Y/N |
Varchar |
1 |
|
| EssEECntAltNm
|
Alternate name shown in ESS |
Varchar |
80 |
|
| EssERCntAccess
|
[Change | View | No Access] |
Enum |
1 |
None | View | Change |
 ENUM
|
| EssERCntAltNm
|
Alternate name shown in ESS |
Varchar |
80 |
|
| AltPlanType
|
Alternate plan type for custom plans |
Enum |
2 |
|
 ENUM
| M0 | Medical |
| D0 | Dental |
| V0 | Vision |
| H0 | Hearing |
| P0 | Prescription Drug |
| I0 | Life and AD&D |
| J1 | Employee Supplemental Life and AD&D |
| J2 | Spouse Supplemental Life and AD&D |
| J3 | Dependent Supplemental Life and AD&D |
| S0 | Short Term Disability |
| X0 | Long Term Disability |
| K0 | Retirement |
| C1 | Healthcare Spending Account |
| C2 | Dependent Care Spending Account |
| E0 | Other |
|
| VolumeFlag
|
Y/N |
Varchar |
1 |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|