Home > BEELife

BEELife

  • DataSet name: EmployeeLife
  • Description: Employee Life Plan Information
  • Last altered in the 1.5 project.
  • PlanID Plan Identifier BigID 12
    TypeFlag Type Flag Enum 1
    ENUM
    SStub
    MMedical
    LLife
    ESupp Life Employee
    PSupp Life Spouse
    DSupp Life Dependent
    TSTD
    ULTD
    XStop Loss
    REmployer Defined
    YEmployee
    ZSpouse
    CCOBRA
    ComCovrFlg Common Coverage Flag Varchar 1
    CovrgClass Coverage Classifier Enum 1
    ENUM
    EEmployment Status
    SSalary vs Hourly
    PPosition Name
    LLocation
    DDepartment
    GLength of Service
    RSalary Range
    CClass
    X$$Category
    LifeADDFlg Life or AD+D Plan Type Flag Enum 1
    ENUM
    LLife
    AAD+D
    BBoth
    MaxCovrAmt Maximum Coverage Amount Number 22
    MaxWOProof Max Amount W/O Proof Good Hlth Number 22
    MaxSupFlag Max Supplemental Life Flag Enum 1
    ENUM
    LLife Only
    SSupp Life Only
    CCombined
    MaxCovrMpy Maximum times salary Number 22
    MaxCovrOptn Amount | Multiplier | Both Enum 1
    ENUM
    AAmount
    MMultiplier
    BBoth
    MaxGtLtOptn > or < Enum 1
    ENUM
    GGreater Than
    LLess Than
    MinCovrAmt Minimum Coverage Amount Number 22
    RoundAmt Round Amount Number 22
    RoundFlg Round Flag Enum 1
    ENUM
    YUp
    NNo
    DDown
    RRound to Nearest
    SalaryMpy Salary Multiplier Number 22
    SmokerRate Smoker Rate Varchar 1
    SpecVolAmt Specific Volume Amount Number 22
    SpecVolFlg Specific Volume Flag Varchar 1
    WaiverFlg Waiver of Premium Flag Varchar 1
    WaiverWPrd Waiver of Premium Wait Period Long 12
    LstModBy Last Modified By Name Varchar 40
    LstModDate Last Modified Date Date 32
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12