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
    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