BAS_P_PLAN_HST

(SQL Table)
Index Back

BAS Partic Plan History

BAS_PARTIC_PLAN history table, it's used for Archive

  • Parent record: BAS_PARTIC_HST
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 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.
    6 EVENT_ID Number(6,0) INTEGER NOT NULL Event Identification
    7 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

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

    Default Value: E

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

    Y/N Table Edit

    Default Value: Y

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

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: BAS_PAR_OPTN_V2

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

    Default Value: 1

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

    Default Value: 1

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

    Prompt Table: PLAN_TYPE_RB_VW

    34 BENEFIT_PLAN_RB Character(6) VARCHAR2(6) NOT NULL Before Tax Rollover

    Prompt Table: BEN_PLN_RB_VW

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

    Prompt Table: DEDCD_RB_VW

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

    Prompt Table: DEDCLASS_RB_VW

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

    Prompt Table: PLAN_TYPE_RA_VW

    38 BENEFIT_PLAN_RA Character(6) VARCHAR2(6) NOT NULL After Tax Rollover

    Prompt Table: BEN_PLN_RA_VW

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

    Prompt Table: DEDCD_RA_VW

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

    Prompt Table: DEDCLASS_RA_VW

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

    Default Value: N

    52 BILL_ACTION Character(1) VARCHAR2(1) NOT NULL Effect On Billing
    E=End Billing
    N=None
    S=Start Billing

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: E

    55 RATE_PERCENT Number(3,0) SMALLINT NOT NULL Rate Percent
    56 FLAT_CALC Character(1) VARCHAR2(1) NOT NULL Flat Amount

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    61 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

    62 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.
    63 EXCESS_CREDIT_ONLY Character(1) VARCHAR2(1) NOT NULL Excess Credit Only

    Y/N Table Edit

    Default Value: N