CAN_ERN_BALANCE

(SQL Table)
Index Back

EE CAN Earnings Balance

This record is used to store employee Earnings Year-to-Date, Quarterly and Monthly balances

  • Parent record: PER_ORG_ASGN_VW
  • # 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 WAGE_LOSS_PLAN Character(3) VARCHAR2(3) NOT NULL Wage Loss Replacement Plan

    Prompt Table: WAGELS_PLAN_TBL

    6 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    7 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter

    Prompt Table: BALANCE_ID_QTR

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

    Prompt Table: BALANCE_ID_DEF

    9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    10 SPCL_BALANCE Character(1) VARCHAR2(1) NOT NULL Spl Accumulator Bal/Earn Code

    Y/N Table Edit

    11 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: EARNINGS_TBL

    12 HRS_YTD Signed Number(8,2) DECIMAL(6,2) NOT NULL Hours YTD
    13 HRS_QTD Signed Number(8,2) DECIMAL(6,2) NOT NULL Hours QTD
    14 HRS_MTD Signed Number(8,2) DECIMAL(6,2) NOT NULL Hours Mtd
    15 GRS_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Gross Earnings YTD
    16 GRS_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Gross Earnings QTD
    17 GRS_MTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Gross Earnings MTD