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 Rcd Nbr
    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(8,2) DECIMAL(6,2) NOT NULL Hours YTD
    11 HRS_QTD Signed Number(8,2) DECIMAL(6,2) NOT NULL Hours QTD
    12 HRS_MTD Signed Number(8,2) DECIMAL(6,2) NOT NULL Hours Mtd
    13 GRS_YTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Gross Earnings YTD
    14 GRS_QTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Gross Earnings QTD
    15 GRS_MTD Signed Number(12,2) DECIMAL(10,2) NOT NULL Gross Earnings MTD