Home > EnrBenef

EnrBenef

  • DataSet name: Beneficiaries
  • Description: Beneficiaries Information
  • Should become obsolete during Pomona
  • Last altered in the 1.5 project.
  • EmpUID Employee Unique ID BigID 12
    PlanID Plan Identifier BigID 12
    HistSeqNbr History Sequence Number Long 12
    CompanyID Company Identifier SmallID 12
    BenefyID Beneficiary Identifier BigID 12
    FirstName First Name Varchar 80
    LastName Last Name Varchar 80
    MiddleName Middle Name Varchar 40
    BenRelatn Beneficiary Relationship Enum 1
    ENUM
    SSpouse
    CChild
    PParent
    BSibling
    RRelative
    FFriend
    OOther
    City City Varchar 80
    State State Code Varchar 2
    Country Country Varchar 80
    Designater Designater Options Enum 1
    ENUM
    PPrimary
    CContingent
    Percentg Percentage Number 22
    LstModBy Last Modified By Name Varchar 40
    LstModDate Last Modified Date Date 32
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12