BAS_PARTIC_PLAN

(SQL Table)
 Index Back

BAS Participant Plan

BAS_PARTIC_PLAN is the plan type level output record that is generated during Benefits Aministration processing. It contains one record per eligible plan type. Additionally, election entry will be stored on these records.

  • Parent record: BAS_PARTIC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
    4 EVENT_ID Number(6,0) INTEGER NOT NULL Event Identification
    5 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.

    Default Value: 01

    6 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.
    7 EVENT_DT Date(10) DATE NOT NULL Event Date
    8 DISPLAY_PLN_SEQ Character(2) VARCHAR2(2) NOT NULL Display Plan-type Sequence
    9 PLAN_ENROLL_DT Date(10) DATE Plan Enroll Date
    10 COVERAGE_BEGIN_DT Date(10) DATE Coverage Begin Date
    11 DEDUCTION_BEGIN_DT Date(10) DATE Deduction Begin Date
    12 COVERAGE_ELECT Character(1) VARCHAR2(1) NOT NULL Coverage Election
    E=Elect
    T=Terminate
    W=Waive

    Default Value: E

    13 COVERAGE_ELECT_DT Date(10) DATE Coverage Elect Date
    14 ELECT_ALLOWED Character(1) VARCHAR2(1) NOT NULL Elections Allowed

    Y/N Table Edit

    Default Value: Y

    15 CUR_ELECT_IND Character(1) VARCHAR2(1) NOT NULL Current Election Indicator
    F=Future
    N=No
    O=Only
    Y=Yes
    16 APAY_EFFDT Date(10) DATE Additional Pay Date
    17 ENROLL_ACTION Character(1) VARCHAR2(1) NOT NULL Enroll Action
    E=Enroll
    N=None
    T=Terminate

    Default Value: N

    18 BAS_ERROR Character(1) VARCHAR2(1) NOT NULL BAS Error Type

    Y/N Table Edit

    Default Value: N

    19 DEFAULT_ASSIGNED Character(1) VARCHAR2(1) NOT NULL Default Assigned

    Y/N Table Edit

    Default Value: N

    20 ELECTION_MADE Character(1) VARCHAR2(1) NOT NULL Employee Made an Election

    Y/N Table Edit

    Default Value: N

    21 PROOF_RCVD Character(1) VARCHAR2(1) NOT NULL Proof Received

    Y/N Table Edit

    Default Value: N

    22 OPTION_CD Character(3) VARCHAR2(3) NOT NULL Option Code

    Prompt Table: BAS_PAR_OPTN_V2

    23 FLAT_AMOUNT Signed Number(9,0) DECIMAL(8) NOT NULL Flat Amount
    24 SAVINGS_COVRG Character(1) VARCHAR2(1) NOT NULL Savings Coverage
    1=Flat Amount
    2=Percent of Gross

    Default Value: 1

    25 FLAT_DED_AMT Number(9,2) DECIMAL(8,2) NOT NULL Flat Deduction Amount
    26 PCT_GROSS Number(7,3) DECIMAL(6,3) NOT NULL Percent of Gross
    27 SAVINGS_COVRG_ATAX Character(1) VARCHAR2(1) NOT NULL Savings Coverage After-Tax
    1=Flat Amount
    2=Percent of Gross

    Default Value: 1

    28 FLAT_DED_AMT_ATAX Number(9,2) DECIMAL(8,2) NOT NULL Flat Deduction Amt After-Tax
    29 PCT_GROSS_ATAX Number(7,3) DECIMAL(6,3) NOT NULL Percent of Gross After-Tax
    30 ANN_EX_CREDITS Number(9,2) DECIMAL(8,2) NOT NULL Annual Excess Credits
    31 PLAN_TYPE_RB Character(2) VARCHAR2(2) NOT NULL Plan Type BTAX Rollover

    Prompt Table: PLAN_TYPE_RB_VW

    32 BENEFIT_PLAN_RB Character(6) VARCHAR2(6) NOT NULL Benefit Plan BTAX Rollover

    Prompt Table: BEN_PLN_RB_VW

    33 DEDCD_RB Character(6) VARCHAR2(6) NOT NULL Deduction Code BTAX Rollover

    Prompt Table: DEDCD_RB_VW

    34 DED_CLASS_RB Character(1) VARCHAR2(1) NOT NULL Deduction Class BTAX Rollover

    Prompt Table: DEDCLASS_RB_VW

    35 PLAN_TYPE_RA Character(2) VARCHAR2(2) NOT NULL Plan Type ATAX Rollover

    Prompt Table: PLAN_TYPE_RA_VW

    36 BENEFIT_PLAN_RA Character(6) VARCHAR2(6) NOT NULL Benefit Plan ATAX Rollover

    Prompt Table: BEN_PLN_RA_VW

    37 DEDCD_RA Character(6) VARCHAR2(6) NOT NULL Deduction Code ATAX Rollover

    Prompt Table: DEDCD_RA_VW

    38 DED_CLASS_RA Character(1) VARCHAR2(1) NOT NULL Deduction Class ATAX Rollover

    Prompt Table: DEDCLASS_RA_VW

    39 EMPL_CONTRBUTN_AMT Number(7,2) DECIMAL(6,2) NOT NULL Employee Contribution Amount
    40 ANN_EX_CREDIT_FSA Number(8,2) DECIMAL(7,2) NOT NULL Annual Credit Rollover FSA
    41 ANNUAL_PLEDGE Signed Number(10,2) DECIMAL(8,2) NOT NULL Annual Pledge
    42 PENSION_BASE Number(11,2) DECIMAL(10,2) NOT NULL Salary for Pension Calculation
    43 VOLUNTARY_AMT Number(11,2) DECIMAL(10,2) NOT NULL Voluntary Contribution Amount
    44 VOLUNTARY_PCT Number(7,3) DECIMAL(6,3) NOT NULL Voluntary Contr. Pct
    45 VACN_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Vacation Buy/Sell Hours
    46 VACN_BUY_FLAT_AMT Number(8,2) DECIMAL(7,2) NOT NULL Vacation Buy Flat Amount
    47 VACN_SELL_FLAT_AMT Number(8,2) DECIMAL(7,2) NOT NULL Vacation Sell Flat Amount
    48 GOAL_AMT Signed Number(12,2) DECIMAL(10,2) NOT NULL Goal Amount
    49 IGNORE_PLAN Character(1) VARCHAR2(1) NOT NULL Ignore Plan
    C=Excess Credit Only
    N=No
    Y=Yes

    Default Value: N

    50 BILL_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
    E=End Billing
    N=None
    S=Start Billing

    Default Value: N

    51 PERCENT_CALC Character(1) VARCHAR2(1) NOT NULL Percent Calculation

    Y/N Table Edit

    Default Value: N

    52 RATE_QUALIFIER Character(1) VARCHAR2(1) NOT NULL Rate Qualifier
    E=Employee Rate
    T=Total Rate

    Default Value: E

    53 RATE_PERCENT Number(3,0) SMALLINT NOT NULL Rate Percent
    54 FLAT_CALC Character(1) VARCHAR2(1) NOT NULL Flat Amount of

    Y/N Table Edit

    Default Value: N

    55 RATE_AMOUNT Signed Number(9,2) DECIMAL(7,2) NOT NULL Rate Amount
    56 BILL_EFFDT Date(10) DATE Billing Begin Date
    57 HLTH_PROVIDER_ID Character(30) VARCHAR2(30) NOT NULL Health Provider ID
    58 PREVIOUSLY_SEEN Character(1) VARCHAR2(1) NOT NULL Previously Seen

    Y/N Table Edit

    Default Value: N

    59 OTH_INSURANCE_IND Character(1) VARCHAR2(1) NOT NULL This is a yes/no flag that will indicate if the employee has an insurance other than the one provided by the employer.

    Y/N Table Edit

    Default Value: N

    60 OTH_INSURANCE_NAME Character(30) VARCHAR2(30) NOT NULL This edit box is directly related to the OTH_INSUR_IND field. If OTH_INSUR_IND is 'Y' then this will provide a place to put the name of the provider.
    61 EXCESS_CREDIT_ONLY Character(1) VARCHAR2(1) NOT NULL Excess Credit Only

    Y/N Table Edit

    Default Value: N