BAL_ADJ_CN_DED

(SQL Table)
Index Back

EE CAN Deduction Bal Adjustmnt

Adjustment record for CAN Deduction Balances.

  • Parent record: PERSON
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    3 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID

    Prompt Table: BALANCE_ID_TBL

    4 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year

    Prompt Table: BALANCE_YR_VW

    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 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan

    Prompt Table: WAGELS_PLAN_TBL

    7 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    8 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.
    9 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

    Prompt Table: BENEF_PLAN_TBL

    10 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

    Prompt Table: DEDUCTION_TBL

    11 DED_CLASS Character(1) VARCHAR2(1) NOT NULL Deduction Classification
    A=After-Tax
    B=Before-Tax
    L=QC Taxable Benefit
    N=Nontaxable Benefit
    P=Nontaxable Btax Benefit
    T=Taxable Benefit
    12 DED_SLSTX_CLASS Character(1) VARCHAR2(1) NOT NULL Sales Tax Type
    B=None
    G=Goods and Services Tax
    H=Harmonized Sales Tax
    I=Provincial Sales Tax Insurance
    P=Provincial Sales Tax
    Q=QC Prov Sales Tax Insurance
    S=QC Provincial Sales Tax
    T=Provincial Premium Tax
    U=QC Provincial Premium Tax
    13 BAL_ADJ_SEQ Number(3,0) SMALLINT NOT NULL Balance Adjust Sequence Number
    14 DT_ENTERED Date(10) DATE NOT NULL Date Entered
    15 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter

    Prompt Table: BALANCE_ID_QTR

    16 BALANCE_PERIOD Number(3,0) SMALLINT NOT NULL Balances for Period

    Prompt Table: BALANCE_ID_DEF

    17 DED_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Deduction Balance YTD
    18 DED_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Deduction Balance QTD
    19 DED_MTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Deduction Balance MTD
    20 DED_YTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Deduction Balance YTD Adjusted
    21 DED_QTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Deduction Balance QTD Adjusted
    22 DED_MTD_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Deduction Balance MTD Adjusted
    23 DED_ADJ Signed Number(12,2) DECIMAL(10,2) NOT NULL Deduction Adjustment Balance field.
    24 ADJ_REASON Character(50) VARCHAR2(50) NOT NULL Adjustment Reason