SP_BURCHD_OPRVW

(SQL View)
 Index Back

Self-Service HD BU OPR

Self-Service Help Desk Business Units. This View does not consider Market as key. This is wrote to handle Search Solution Component. Since Search Solution is not Verticalizised this is needed. Operator Security SVC002 - 6/28/2012 - ADDED RC_CASE_SS

SELECT DISTINCT C.OPRID , A.BUSINESS_UNIT , A.RC_DESCR_SS FROM PS_BUS_UNIT_TBL_RC A , PS_BUS_UNIT_RC_DEF B , PS_SEC_BU_OPR C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND (B.PNLGRPNAME = 'RC_CASE_HD_SS_RPT' OR B.PNLGRPNAME = 'RC_CASE_SS') AND A.BU_STATUS = '1' AND A.RC_DESCR_SS <> ' ' AND C.BUSINESS_UNIT = A.BUSINESS_UNIT

  • Related Language Record: SP_BURCHDLOPRVW

    • # 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
    3 RC_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Description to be shown on Self-Service Pages