Home > EssRowChgLog

EssRowChgLog

  • DataSet name: EssRowChgLog
  • Description: Database row change log
  • Last altered in the Yakima project.
  • ApprStatus Pending | Approved | Reject Enum 1
    ENUM
    PPending
    AApproved
    RRejected
    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
    IInsert
    MModify
    DDelete
    UAny
    WWrap
    CEnrollment Changed
    NEnrollment Not Changed
    RecordType Dependent, personal, benefit, etc. Enum 1
    ENUM
    EPersonal
    DDependents
    MEmergency Contacts
    CCustom Data
    PProviders
    FBeneficiaries
    OOther Health Insurance
    IInvestment Elections
    WWrapper
    NEnrollment
    UAny
    KDependent Enrollment
    ZEnrollment - Custom
    VEnrollment - Waive Plan
    QLeave Request
    RAdditional 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