RC_MYCASE_VW (SQL View)	Index Back
Agent Case Details Chart drill to details for open cases assigned to an agent.

RC_MYCASE_VW

(SQL View)

Agent Case Details

Chart drill to details for open cases assigned to an agent.

SELECT A.BUSINESS_UNIT , A.CASE_ID , A.BO_ID_CUST , A.ASSIGNED_TO , A.RC_STATUS , C.RC_SHORT_DESCR , A.RC_PRIORITY , E.RC_SHORT_DESCR , A.CREATION_DATE , A.RC_SUMMARY , A.RC_REST_TIME , A.RC_REST_DATE , %Dttm(A.RC_REST_DATE, %timenull) , A.RC_RED_DTTM , A.RC_YELLOW_DTTM , A.DISP_TMPL_FAM_CD FROM PS_RC_STATUS_TBL C , PS_RC_CASE A LEFT JOIN PS_RC_CASEPRIO_VW E ON E.CASE_ID=A.CASE_ID WHERE C.RC_STATUS = A.RC_STATUS AND C.STATUS_CATEGORY = 'O' AND C.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'RC_STATUS_TBL')

Related Language Record: RC_MYCASE_VLN

# 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 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

4 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

5 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
Prompt Table: RC_STATUS_TBL

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

7 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
Prompt Table: RC_PRIORITY_TBL

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

9 CREATION_DATE Date(10) DATE Creation date of the case.

10 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.

11 RC_REST_TIME Time(15) TIMESTAMP Restore Time

12 RC_REST_DATE Date(10) DATE Restore Date

13 RC_REST_DTTM DateTime(26) TIMESTAMP Entitled restore date time. Used for SLA.

14 RC_RED_DTTM DateTime(26) TIMESTAMP The date time that this case will turn Red if it has not yet been resolved.

15 RC_YELLOW_DTTM DateTime(26) TIMESTAMP The date time that this case will turn yellow if it has not yet been resolved.

16 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

#	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	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
4	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
5	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status Prompt Table: RC_STATUS_TBL
6	RC_SHORT_DESCR	Character(20)	VARCHAR2(20) NOT NULL	Short Description. Used on may CallCenter set-up tables
7	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority Prompt Table: RC_PRIORITY_TBL
8	RC_SHORT_DESCR1	Character(20)	VARCHAR2(20) NOT NULL	Short Description. Used on may CallCenter set-up tables
9	CREATION_DATE	Date(10)	DATE	Creation date of the case.
10	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
11	RC_REST_TIME	Time(15)	TIMESTAMP	Restore Time
12	RC_REST_DATE	Date(10)	DATE	Restore Date
13	RC_REST_DTTM	DateTime(26)	TIMESTAMP	Entitled restore date time. Used for SLA.
14	RC_RED_DTTM	DateTime(26)	TIMESTAMP	The date time that this case will turn Red if it has not yet been resolved.
15	RC_YELLOW_DTTM	DateTime(26)	TIMESTAMP	The date time that this case will turn yellow if it has not yet been resolved.
16	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code