| EmpUID
|
Employee Unique ID |
BigID |
12 |
|
| EnrlStatusType
|
New Hire | Open Enrollment |
Enum |
1 |
New Hire | Open Enrollment | Change |
 ENUM
| N | New Hire |
| O | Open Enrollment |
| C | Change Enrollment |
|
| EmpEnrlStatusID
|
Open Enrollment Status record id |
BigID |
12 |
|
| PlanTypeID
|
Unique ID for this type |
BigID |
12 |
Plan type this refers to. |
| CompanyID
|
Company Identifier |
SmallID |
12 |
|
| OpEnrlID
|
Perhaps we have one of these for each employee/open enroll? |
BigID |
12 |
|
| EnrlStatus
|
[Not Started | Started | Awaiting Approval | Approved | Rejected] |
Enum |
1 |
Not Started | In Progress | Confirmed |
ENUM
| N | Not Started |
| I | In Progress |
| C | Confirmed |
|
| EnrlReason
|
Volume Amounts Reason Text |
BigID |
12 |
|
| EventDate
|
Event Date |
Date |
32 |
|
| Notes
|
Comments |
Text |
16000 |
|
| ConfmDate
|
Confirmation Notice Date |
Date |
32 |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|