PI_SUBTYPE_VW

(SQL View)
Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.ASSET_SUBTYPE FROM PS_PI_EXTRACT_VW A WHERE A.ASSET_SUBTYPE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype