DED_BAL_CALC_VW

(SQL View)
 Index Back

EE U.S. Deduction Balance view

This record is a view of the DEDUCTION_BAL table and contains employees' data which requires QTD/YTD balances recalculated.

SELECT DISTINCT A.EMPLID ,A.COMPANY ,A.BALANCE_ID ,A.BALANCE_YEAR FROM PS_DEDUCTION_BAL A WHERE EXISTS ( SELECT 'X' FROM PS_DEDUCTION_BAL WHERE A.EMPLID = EMPLID AND A.COMPANY = COMPANY AND A.BALANCE_ID = BALANCE_ID AND A.BALANCE_YEAR = BALANCE_YEAR AND A.PLAN_TYPE = PLAN_TYPE AND A.BENEFIT_PLAN = BENEFIT_PLAN AND A.DEDCD = DEDCD AND A.DED_CLASS = DED_CLASS AND A.BENEFIT_RCD_NBR <> BENEFIT_RCD_NBR) AND NOT EXISTS( SELECT 'X' FROM PS_DEDUCTION_BAL WHERE A.EMPLID = EMPLID AND A.COMPANY = COMPANY AND A.BALANCE_ID = BALANCE_ID AND A.BALANCE_YEAR = BALANCE_YEAR AND A.BALANCE_QTR = BALANCE_QTR AND A.BALANCE_PERIOD = BALANCE_PERIOD AND A.PLAN_TYPE = PLAN_TYPE AND A.BENEFIT_PLAN = BENEFIT_PLAN AND A.DEDCD = DEDCD AND A.DED_CLASS = DED_CLASS AND A.BENEFIT_RCD_NBR <> BENEFIT_RCD_NBR)

  • 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