Home > EmpEligb

EmpEligb

  • DataSet name: EligibleEmp
  • Description: Benefit Eligibility by Employee
  • Maintained only so we can upgrade old data in these tables
  • Last altered in the Pomona 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
    BeneStart Benefit Start Date Enum 1
    ENUM
    HOn the hire date
    FFirst of month following hire date
    ONext open enrollment effective date
    IOn the hire date if hired on 1st, 1st of next month otherwise
    MFirst of month following the waiting period
    DThe day following the waiting period
    NNext open enrollment date following the waiting period
    EligByJob Eligible By Job Title Flag Varchar 1
    EligByLoc Eligible By Location Flag Varchar 1
    HourEmpFlg Hourly Employee Flag Varchar 1
    MaxAge Maximum Age Long 12
    MaxAgeFlg Maximum Age Flag Varchar 1
    MinAge Minimum Age Long 12
    MinAgeFlg Minimum Age Flag Varchar 1
    MinHours Minimum Hours Number 22
    MinHrsFlg Minimum Hours Flag Varchar 1
    OpenEnrFlg Open Enrollment Period Flag Varchar 1
    SalEmpFlg Salaried Employee Flag Varchar 1
    WaitFlg Waiting Period Flag Varchar 1
    WaitPeriod Waiting Period Long 12
    WaitPrUnit Waiting Period Unit Enum 1
    ENUM
    DDays
    WWeeks
    MMonths
    YYears
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12