Home > Beneficiary

Beneficiary

  • DataSet name: Beneficiary
  • Description: Beneficiaries Information
  • Single beneficiary; can be reused for several benefit plans.
  • Last altered in the Pomona project.

    • EmpUID Employee Unique ID BigID 12
    CompanyID Company Identifier SmallID 12
    BenefyID Beneficiary Identifier BigID 12 Unique identifier for the beneficiary record.
    LastName Last Name Varchar 80
    FirstName First Name Varchar 80
    MiddleName Middle Name Varchar 40
    Address1 Address, Line 1 Varchar 80
    Address2 Address, Line 2 Varchar 80
    City City Varchar 80
    BeneficType Beneficiary Type Enum 1 Indicates whether the type is normal, or is a dependent. If dependent, we use the DepndID to get the dependent, and don't use the other fields in this record.
    ENUM
    NNormal
    DDependent
    SSelf
    DepndID Dependent Identifier BigID 12 Used to get the dependent record, if needed.
    BenRelatn Beneficiary Relationship Enum 1 Relationship of beneficiary to the employee.
    ENUM
    SSpouse
    CChild
    PParent
    BSibling
    RRelative
    FFriend
    OOther
    State State Code Varchar 2
    Country Country Varchar 80
    LstModBy Last Modified By Name Varchar 40
    LstModDate Last Modified Date Date 32
    ZipCode Zip Code Varchar 10
    HpChgTS Timestamp 32
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12