Home > EEEnroll

EEEnroll

  • DataSet name: Enrollment
  • Description: Employee Enrollment Master Information
  • Last altered in the 1.5 project.
  • EmpUID Employee Unique ID BigID 12
    PlanID Plan Identifier BigID 12
    CompanyID Company Identifier SmallID 12
    HistSeqNbr History Sequence Number Long 12
    EligStart Eligibility Start Date Date 32
    EligReason Eligibility Reason Text Text 16000
    EventDate Event Date Date 32
    GenCodeID Generic Code Identifier BigID 12
    EnrollStat Enrollment Status Enum 1
    ENUM
    AActive
    WWaived
    ECOBRA Eligible
    CCOBRA Active
    NNot Enrolled
    StartDate Starting Date SmallDate 32
    StopDate Ending Date Date 32
    TermDate Termination Date Date 32
    WaiveDate Waive Benefit Date Date 32
    WaiveFlag Waive Benefit Flag Varchar 1
    EffectDate Enrollment Effective Date Date 32
    DependTags Dependent Enrollment Tags Varchar 20
    EnrlCounts Enrollment Counts String Varchar 30
    SmokerRate Smoker Rate Varchar 1
    BiCycleDt Billing Cycle End Date Date 32
    ContbCmpny Company Contribution Amount Number 22
    ContbEmply Employee Contribution Amount Number 22
    EEOnlyEEC EE Only - Emply Contribution Number 22
    EEOnlyERC EE Only - Emplr Contribution Number 22
    CostReason Benefit Cost Reason Text Text 16000
    EnrOverFlg Enrolled as Over Age Child Varchar 1
    RateCategy Rate Category Long 12
    RateSched Rate Schedule Varchar 1
    AmtPctFlg Amount/Percentage Flag Enum 1
    ENUM
    AAmount
    PPercent
    PayPeriod Pay Period Enum 1
    ENUM
    DDaily
    WWeekly
    BBi-Weekly
    SSemi-Monthly
    MMonthly
    ContbPayck Contribution Per Paycheck Number 22
    Period Period Long 12
    VolumeAmt1 Volume Amount Number 22
    VolumeAmt2 Volume Amount Number 22
    PerAmt1 Volume Per Amount Number 22
    PerAmt2 Volume Per Amount Number 22
    PctOfPay1 Percentage of Pay Number 22
    PctOfPay2 Percentage of Pay Number 22
    VolMpy Volume Muliplier Number 22
    VolReason Volume Amounts Reason Text Text 16000
    Coverage Coverage Literal Varchar 20
    ProofOfGH Proff of Good Health Flag Date 32
    AmtApprovd Amount Approved Number 22
    PreTaxOptn Pre Tax Option Enum 1
    ENUM
    BBefore Tax
    AAfter Tax
    EEither
    NNeither
    AdminFee Admin Fee Number 22
    PlanFeeFrq Plan Wide Fee Frequency Enum 1
    ENUM
    MMonthly
    QQuarterly
    YAnnually
    CobraCEAmt Cobra Covered Employee Amt Number 22
    CobraFreq Cobra Fees Frequency Enum 1
    ENUM
    MMonthly
    QQuarterly
    YAnnually
    CobraNote Cobra Notice Types Varchar 8
    HardshipAc Hardship Withdrawl Active Varchar 1
    LoanActive Loan Active Flag Varchar 1
    BuyUpSalAmt Buy Up Salary Amount Number 22
    CstF1 Benefit Custom Fld 1 Varchar 40
    CstF2 Benefit Custom Fld 2 Varchar 40
    CstF3 Benefit Custom Fld 3 Varchar 40
    CstF4 Benefit Custom Fld 4 Varchar 40
    CstF5 Benefit Custom Fld 5 Varchar 40
    CstF6 Benefit Custom Fld 6 Varchar 40
    VolOverride Y/N Varchar 1
    HpChgTS Timestamp 32
    LstModBy Last Modified By Name Varchar 40
    LstModDate Last Modified Date Date 32
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12