FS_BU_SECSES_VW

(SQL View)
 Index Back

PTSF Business Unit Security


SELECT BU.BUSINESS_UNIT , 'A:ALL' FROM PS_BUS_UNIT_TBL_FS BU UNION ALL SELECT ' ' , 'A:ALL' FROM PS_INSTALLATION UNION ALL SELECT OPR.BUSINESS_UNIT , 'B:' %Concat OPR.BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_FS OPR

# 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