PY_BALPRD_VW

(SQL View)
Index Back

Balance Prds View w/o Company

View from Balance_Id_Def for PA Act 32 reporting.

SELECT DISTINCT balance_id ,balance_year ,balance_period FROM PS_BALANCE_ID_DEF WHERE BALANCE_YEAR > 2011

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID
2 BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balances for Year
3 BALANCE_PERIOD Number(3,0) SMALLINT NOT NULL Balances for Period