| ApprStatus
|
Pending | Approved | Reject |
Enum |
1 |
|
 ENUM
| P | Pending |
| A | Approved |
| R | Rejected |
|
| EmpUID
|
Employee Unique ID |
BigID |
12 |
|
| EssChgLogID
|
|
BigID |
12 |
|
| CompanyID
|
Company Identifier |
SmallID |
12 |
|
| EmpConfirmed
|
Y/N |
Varchar |
1 |
Y indicates that the employee has confirmed this Enrollment |
| TopLevel
|
Y=this is the top |
Varchar |
1 |
Y=This record is the top level. |
| Key1
|
Generic key--depends on record type. |
BigID |
12 |
Key field of indicated record--depends on record type. |
| Key2
|
Generic key--depends on record type. |
BigID |
12 |
Key field of indicated record--depends on record type. |
| ActionType
|
insert/modify/delete |
Enum |
1 |
|
 ENUM
| I | Insert |
| M | Modify |
| D | Delete |
| U | Any |
| W | Wrap |
| C | Enrollment Changed |
| N | Enrollment Not Changed |
|
| RecordType
|
Dependent, personal, benefit, etc. |
Enum |
1 |
|
 ENUM
| E | Personal |
| D | Dependents |
| M | Emergency Contacts |
| C | Custom Data |
| P | Providers |
| F | Beneficiaries |
| O | Other Health Insurance |
| I | Investment Elections |
| W | Wrapper |
| N | Enrollment |
| U | Any |
| K | Dependent Enrollment |
| Z | Enrollment - Custom |
| V | Enrollment - Waive Plan |
| Q | Leave Request |
| R | Additional Contact Information |
|
| EntryTS
|
|
Timestamp |
32 |
|
| ApprDate
|
Date approved |
Date |
32 |
|
| AssignedTo
|
Who is responsible for the items, equal to UserPID |
Varchar |
80 |
UserPID of assignee |
| AssignedOnTS
|
When this assignment was made |
Timestamp |
32 |
UserPID of assignee |
| ApprBy
|
Change approved by user |
Varchar |
40 |
Username of approver. |
| UserFrndDesc
|
like "Addition of a child." |
Varchar |
100 |
|
| ParentChgRowID
|
This records parent |
BigID |
12 |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|