GVT_PYLM_LT_VW

(SQL View)
 Index Back

EE Lifetime Pay Limit Bal View

View showing summary of lifetime pay limit balances for an employee by company and calendar year for all empl record numbers.

SELECT A.EMPLID , A.COMPANY , A.BALANCE_ID , A.BALANCE_YEAR , A.EMPL_RCD , A.ERNCD , A.GVT_LT_BAL FROM PS_GVT_PAY_LIM_BAL A WHERE A.BALANCE_QTR = ( SELECT MAX(A2.BALANCE_QTR) FROM PS_GVT_PAY_LIM_BAL A2 WHERE A2.EMPLID = A.EMPLID AND A2.COMPANY = A.COMPANY AND A2.EMPL_RCD = A.EMPL_RCD AND A2.BALANCE_ID = A.BALANCE_ID AND A2.BALANCE_YEAR = A.BALANCE_YEAR AND A2.ERNCD = A.ERNCD) AND A.BALANCE_PERIOD = ( SELECT MAX(A3.BALANCE_PERIOD) FROM PS_GVT_PAY_LIM_BAL A3 WHERE A3.EMPLID = A.EMPLID AND A3.COMPANY = A.COMPANY AND A3.EMPL_RCD = A.EMPL_RCD AND A3.BALANCE_ID = A.BALANCE_ID AND A3.BALANCE_YEAR = A.BALANCE_YEAR AND A3.BALANCE_QTR = A.BAlANCE_QTR AND A3.ERNCD = A.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
    4 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year
    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    6 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: EARNINGS_TBL

    7 GVT_LT_BAL Signed Number(15,2) DECIMAL(13,2) NOT NULL Life time balance.