Home > BE401K

BE401K

  • DataSet name: 401K
  • Uses the new RulesAPI style
  • Description: 401 K Plan Information
  • Converted to new style 11/14/2001
  • Last altered in the Omsk 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
    BorVstFund Borrow Vested Funds Flag Varchar 1
    EmpMaxAmt Employee Maximum Amount Number 22
    EmpMaxPct Employee Maximum Percentage Number 22
    EmprMAmtPr Employer Minimum Amount Per Enum 1
    ENUM
    DDay
    WWeek
    BBi-Weekly
    SSemi-Monthly
    MMonth
    YYear
    EmprMinAmt Employer Minimum Amount Number 22
    EmprMinPct Employer Minimum Percentage Number 22
    HspWthVFnd Hardship Withdrawal Flag Varchar 1
    MinAmtPctF Min Amount or Percentage Flag Enum 1
    ENUM
    AAmount
    PPercent
    MinEmprFlg Minimum Employer Contrib Flag Varchar 1
    Age50CatchUpFlag Age 50 Ketchup Flag Varchar 1
    MatchLOSFlag Enum 1
    ENUM
    HireEnrFlag Enum 1
    ENUM
    HLOS table starts on hire date
    ELOS table starts on enrollment date
    TrackFunds Track Funds Flag Varchar 1
    VestStart Vesting Begins Flag Enum 1
    ENUM
    EEmployment
    NEnrollment
    LOSMatchStart Enum 1
    ENUM
    ACurrent calendar year
    BNext calendar year
    CCurrent calendar year or mid year
    DNext calendar year or mid year
    ECurrent calendar quarter
    FNext calendar quarter
    GCurrent month
    HNext month
    IPrior open enrollment period
    JNext open enrollment period
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12