SP_BURCSSLCLSVW(SQL View) |
Index Back |
---|---|
LNG for SS HelpDesk BU's CLSSelf-Service Help Desk Business Units. SVC002 - 6/28/2012 - ADDED RC_CASE_SS |
SELECT DISTINCT C.OPRCLASS , B.MARKET , B.DISP_TMPL_FAM_CD , A.BUSINESS_UNIT , A.LANGUAGE_CD , B.PNLGRPNAME , A.RC_DESCR_SS FROM PS_BUS_UNITTBL_RCL A , PS_BUS_UNIT_RC_DEF B , PS_SEC_BU_CLS C , PS_BUS_UNIT_TBL_RC D , PS_BUS_UNIT_RC_RDT E WHERE C.BUSINESS_UNIT= A.BUSINESS_UNIT AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND (B.PNLGRPNAME = 'RC_CASE_HD_SS_RPT' OR B.PNLGRPNAME = 'RC_CASE_SS') AND D.BU_STATUS = '1' AND D.RC_DESCR_SS <> ' ' AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND B.DISP_TMPL_FAM_CD = E.DISP_TMPL_FAM_CD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | Operator Class | |
2 | Character(3) | VARCHAR2(3) NOT NULL | Market | |
3 | Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code | |
4 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
5 | Character(3) | VARCHAR2(3) NOT NULL | Language Code | |
6 | PNLGRPNAME | Character(18) | VARCHAR2(18) NOT NULL | Component Name |
7 | RC_DESCR_SS | Character(30) | VARCHAR2(30) NOT NULL | Description to be shown on Self-Service Pages |