SP_BU_RCFOPRVW

(SQL View)
 Index Back

Security View

This is a business unit security view for call center for use by Time record.

SELECT A.OPRID , B.BUSINESS_UNIT , B.DESCR , B.DESCRSHORT FROM PS_SEC_BU_OPR A , PS_BUS_UNIT_TBL_FS B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND (EXISTS( SELECT 'X' FROM PS_BUS_UNIT_TBL_RC RC WHERE RC.BUSINESS_UNIT = B.BUSINESS_UNIT) OR EXISTS( SELECT 'X' FROM PS_BUS_UNIT_TBL_RF RF WHERE RF.BUSINESS_UNIT = B.BUSINESS_UNIT))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description