Home > EmpEligb

EmpEligb

  • DataSet name: EligibleEmp
  • Uses the old RulesAPI style
  • 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
    BeneStart Benefit Start Date Enum 1 Enum
    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
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12