BU_SEARCH_VW

(SQL View)
 Index Back

PTSF Business Unit Security

Source view used in PTSF Business Unit security query

SELECT NON.BUSINESS_UNIT, 'A:ALL' FROM PS_BUS_UNIT_TBL_FS NON UNION ALL SELECT SEC.BUSINESS_UNIT, 'B:' %Concat SEC.BUSINESS_UNIT FROM PS_BUS_UNIT_TBL_FS SEC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BU_SECURITY_FS Character(7) VARCHAR2(7) NOT NULL PTSF Query Security Attribute for Business Unit