Home > EssRowChgLog

EssRowChgLog

  • DataSet name: EssRowChgLog
  • Uses the new RulesAPI style
  • Description: Database row change log
  • Last altered in the Yakima project.
  • 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
    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