EssRowChgLog
| ApprStatus | Pending | Approved | Reject | Enum | 1 | Enum | |
| 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 | |
| RecordType | Dependent, personal, benefit, etc. | Enum | 1 | Enum | |
| 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 |