CAN_ERN_SUM_VW

(SQL View)
 Index Back

EE CAN Earnings Balance

View showing summary fo MTD,QTD,YTD earnings balances for an employee by company and calendar year for all empl record numbers.

SELECT EMPLID , COMPANY , BALANCE_ID , BALANCE_YEAR , WAGE_LOSS_PLAN , PROVINCE , EMPL_RCD , BALANCE_QTR , BALANCE_PERIOD , SPCL_BALANCE , ERNCD , SUM(HRS_YTD) , SUM(HRS_QTD) , SUM(HRS_MTD) , SUM(GRS_YTD) , SUM(GRS_QTD) , SUM(GRS_MTD) FROM PS_CAN_ERN_BALANCE GROUP BY EMPLID ,COMPANY ,BALANCE_ID ,BALANCE_YEAR ,WAGE_LOSS_PLAN ,PROVINCE ,EMPL_RCD ,BALANCE_QTR ,BALANCE_PERIOD ,SPCL_BALANCE ,ERNCD

  • 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 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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    8 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter

    Prompt Table: BALANCE_ID_QTR

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

    Prompt Table: BALANCE_ID_DEF

    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