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 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
2 | BU_SECURITY_SES | Character(40) | VARCHAR2(40) NOT NULL | Business Unit Security |