ERN_BAL_SUM_VW

(SQL View)
 Index Back

EE U.S. Earnings Balance

View showing summary of 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 ,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_EARNINGS_BAL GROUP BY EMPLID ,COMPANY ,BALANCE_ID ,BALANCE_YEAR ,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 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    6 BALANCE_QTR Number(3,0) SMALLINT NOT NULL Balances for Quarter

    Prompt Table: BALANCE_ID_QTR

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

    Prompt Table: BALANCE_ID_DEF

    8 SPCL_BALANCE Character(1) VARCHAR2(1) NOT NULL Spl Accumulator Bal/Earn Code

    Y/N Table Edit

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

    Prompt Table: EARNINGS_TBL

    10 HRS_YTD Signed Number(10,2) DECIMAL(8,2) NOT NULL Hours year-to-date.
    11 HRS_QTD Signed Number(10,2) DECIMAL(8,2) NOT NULL Hours quarter-to-date.
    12 HRS_MTD Signed Number(10,2) DECIMAL(8,2) NOT NULL Hours month-to-date.
    13 GRS_YTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Gross Earnings YTD
    14 GRS_QTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Gross Earnings QTD
    15 GRS_MTD Signed Number(15,2) DECIMAL(13,2) NOT NULL Gross Earnings MTD