PO_BU_SECSES_VW

(SQL View)
Index Back

Purchasing BU Security for SF


SELECT BU.BUSINESS_UNIT , 'A:ALL' FROM PS_BUS_UNIT_TBL_FS BU UNION SELECT OPR.BUSINESS_UNIT , 'B:' %Concat OPR.BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_FS OPR UNION SELECT CLS.BUSINESS_UNIT , 'P:' %Concat CLS.OPRCLASS FROM PS_SEC_BU_CLS CLS UNION SELECT 'B:NOB' , 'N:NULL' FROM PS_INSTALLATION_FS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BU_SECURITY_SES Character(40) VARCHAR2(40) NOT NULL Business Unit Security