ARO_YEAR_VW

(SQL View)
Index Back

ARO Accreation Year


SELECT A.BUSINESS_UNIT , A.ASSET_ID , A.FISCAL_YEAR FROM PS_ARO_ACCR_SCHED A UNION SELECT C.BUSINESS_UNIT , E.ASSET_ID , C.FISCAL_YEAR FROM PS_ARO_DEPR_RPT C , PS_ASSET E WHERE C.BUSINESS_UNIT = E.BUSINESS_UNIT AND C.ASSET_ID = E.ARO_ID AND E.ARO_SW = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year