Home > EmpBenfic

EmpBenfic

  • DataSet name: EmpBenfic
  • Description: Relates beneficiaries to an employee and plan
  • Last altered in the Pomona project.

    • EmpUID Employee Unique ID BigID 12
    PlanID Plan Identifier BigID 12 Relates a beneficiary to this plan.
    BenefyID Beneficiary Identifier BigID 12 Unique identifier for the beneficiary.
    CompanyID Company Identifier SmallID 12
    Designater Designater Options Enum 1 Primary or contingent.
    ENUM
    PPrimary
    CContingent
    Percentg Percentage Number 22 What percent this beneficiary would receive.
    HpChgTS Timestamp 32
    LstModBy Last Modified By Name Varchar 40
    LstModDate Last Modified Date Date 32
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12