Home > BCustom

BCustom

  • DataSet name: BCustom
  • Description: Custom Benefit Plan
  • Last altered in the Omsk project.
  • PlanID Plan Identifier BigID 12
    CstID Custom field def id BigID 12
    CustomFlag Y/N Varchar 1
    EssVolAccess [Change | View | No Access] Enum 1 None | View | Change
    ENUM
    NNo Access
    VView
    CChange
    EssVolAltNm Alternate name shown in ESS Varchar 80
    EssEECntAccess [Change | View | No Access] Enum 1 None | View | Change
    ENUM
    NNo Access
    VView
    CChange
    RateTableFlag Y/N Varchar 1
    EssEECntAltNm Alternate name shown in ESS Varchar 80
    EssERCntAccess [Change | View | No Access] Enum 1 None | View | Change
    ENUM
    NNo Access
    VView
    CChange
    EssERCntAltNm Alternate name shown in ESS Varchar 80
    AltPlanType Alternate plan type for custom plans Enum 2
    ENUM
    M0Medical
    D0Dental
    V0Vision
    H0Hearing
    P0Prescription Drug
    I0Life and AD&D
    J1Employee Supplemental Life and AD&D
    J2Spouse Supplemental Life and AD&D
    J3Dependent Supplemental Life and AD&D
    S0Short Term Disability
    X0Long Term Disability
    K0Retirement
    C1Healthcare Spending Account
    C2Dependent Care Spending Account
    E0Other
    VolumeFlag Y/N Varchar 1
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12