RC_HDCATYDET_VW (SQL View)	Index Back
CASE CTD Case Category Type and Detail view.

RC_HDCATYDET_VW

(SQL View)

CASE CTD

Case Category Type and Detail view.

SELECT r.BUSINESS_UNIT , r.CASE_ID , c.RC_SHORT_DESCR , t.RC_SHORT_DESCR , d.RC_SHORT_DESCR FROM PS_RC_CASE r , PS_RC_CATEGORY_TBL c , PS_RC_TYP_TBL t , PS_RC_DET_TBL d WHERE r.RC_CATEGORY = c.RC_CATEGORY (+) AND r.RC_TYPE = t.RC_TYPE (+) AND r.RC_DETAIL = d.RC_DETAIL (+) AND c.SETID = t.SETID AND t.SETID = d.SETID AND c.SETID IN ( SELECT sc.SETID FROM PS_SET_CNTRL_REC sc WHERE sc.SETCNTRLVALUE = r.BUSINESS_UNIT AND sc.RECNAME = 'RC_CATEGORY_TBL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 CASE_ID Number(15,0) DECIMAL(15) NOT NULL Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.

3 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables

4 RC_SHORT_DESCR1 Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables

5 RC_SHORT_DESCR2 Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CASE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table.
3	RC_SHORT_DESCR	Character(20)	VARCHAR2(20) NOT NULL	Short Description. Used on may CallCenter set-up tables
4	RC_SHORT_DESCR1	Character(20)	VARCHAR2(20) NOT NULL	Short Description. Used on may CallCenter set-up tables
5	RC_SHORT_DESCR2	Character(20)	VARCHAR2(20) NOT NULL	Short Description. Used on may CallCenter set-up tables