Home > BenRateM

BenRateM

  • DataSet name: RateMaster
  • Description: Benefit Rate Master 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
    StartDate Starting Date SmallDate 32
    HistSeqNbr History Sequence Number Long 12
    RateSched Rate Schedule Varchar 1
    SmokerRate Smoker Rate Varchar 1
    StdLtdType Short/Long Term Flag Enum 1
    ENUM
    APer $10 of Weekly Benefit
    BPer $100 of Monthly Benefit
    CPercentage of Covered Pay
    StopDate Ending Date Date 32
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12