RC_SLADISPLA_VW (SQL View)	Index Back
Drill To Case Details A view of case details for chart pagelets and drilling.

RC_SLADISPLA_VW

(SQL View)

Drill To Case Details

A view of case details for chart pagelets and drilling.

SELECT A.BUSINESS_UNIT , A.CASE_ID , A.DISP_TMPL_FAM_CD , A.CASE_TYPE , A.BO_ID_CUST ,A.BO_ID_CONTACT , A.PROVIDER_GRP_ID , A.RC_SUMMARY , A.RC_PRIORITY , A.RC_STATUS ,A.RC_SEVERITY , A.PRODUCT_GROUP , A.PRODUCT_ID ,A.RC_CATEGORY ,A.RC_TYPE ,A.RC_DESCRLONG ,A.RC_DETAIL , A.CREATION_DATE , %Dttm(A.RC_REST_DATE, %timenull) , A.RC_REST_DATE , A.RC_REST_TIME , A.ASSIGNED_TO ,A.SECURE_CASE_FLG , A.RC_YELLOW_DTTM ,A.RC_RED_DTTM , A.CLOSED_DATE ,B.STATUS_CATEGORY , E.RC_MANAGER ,C.SLA_COLOR FROM PS_RC_STATUS_TBL B , PS_RC_CASEPRG_VW E , PS_RC_SLADISPLA_V1 A LEFT JOIN PS_RC_MYSLA_VW1 C ON A.CASE_ID=C.CASE_ID WHERE B.RC_STATUS=A.RC_STATUS AND E.PROVIDER_GRP_ID = A.PROVIDER_GRP_ID AND E.CASE_ID=A.CASE_ID AND E.BUSINESS_UNIT=A.BUSINESS_UNIT AND B.SETID=( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.SETCNTRLVALUE = A.BUSINESS_UNIT AND D.RECNAME = 'RC_STATUS_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 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code

4 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type

5 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
Prompt Table: BO_NAME_VW

6 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

7 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

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

9 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority

10 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status

11 RC_SEVERITY Character(5) VARCHAR2(5) NOT NULL Case severity

12 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

13 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

14 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.

15 RC_TYPE Character(5) VARCHAR2(5) NOT NULL Specialty type. Used on HD case.

16 RC_DESCRLONG Long Character CLOB Long description used in CallCenter for Problem, Solution...

17 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.

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

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

20 RC_REST_DATE Date(10) DATE Restore Date

21 RC_REST_TIME Time(15) TIMESTAMP Restore Time

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

23 SECURE_CASE_FLG Character(1) VARCHAR2(1) NOT NULL Used in HRHD to Secure the case so that only people in the provider group assigned to the case can access the case.
N=No
Y=Yes

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

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

26 CLOSED_DATE Date(10) DATE Date Closed

27 STATUS_CATEGORY Character(1) VARCHAR2(1) NOT NULL Categories for Case Status. These drive processing.
C=Closed
D=Canceled
H=Case is on hold
O=Case is Open

28 RC_MANAGER Character(15) VARCHAR2(15) NOT NULL Call Center Manager. Used in call center business unit setup.

29 SLA_COLOR Character(6) VARCHAR2(6) NOT NULL SLA Color - can be red, green or yellow depending on how close the case is to missing the required restore time goal per the service level agreement.

#	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	DISP_TMPL_FAM_CD	Character(30)	VARCHAR2(30) NOT NULL	Display Template Family Code
4	CASE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Case Type
5	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer. Prompt Table: BO_NAME_VW
6	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
7	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
8	RC_SUMMARY	Character(80)	VARCHAR2(80) NOT NULL	Typically a summary of a long field.
9	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority
10	RC_STATUS	Character(5)	VARCHAR2(5) NOT NULL	Case Status
11	RC_SEVERITY	Character(5)	VARCHAR2(5) NOT NULL	Case severity
12	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group
13	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
14	RC_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	CallCenter Category. Used in HD.
15	RC_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specialty type. Used on HD case.
16	RC_DESCRLONG	Long Character	CLOB	Long description used in CallCenter for Problem, Solution...
17	RC_DETAIL	Character(5)	VARCHAR2(5) NOT NULL	Detail field on HD Case. Used in Quick Code.
18	CREATION_DATE	Date(10)	DATE	Creation date of the case.
19	RC_REST_DTTM	DateTime(26)	TIMESTAMP	Entitled restore date time. Used for SLA.
20	RC_REST_DATE	Date(10)	DATE	Restore Date
21	RC_REST_TIME	Time(15)	TIMESTAMP	Restore Time
22	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
23	SECURE_CASE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used in HRHD to Secure the case so that only people in the provider group assigned to the case can access the case. N=No Y=Yes
24	RC_YELLOW_DTTM	DateTime(26)	TIMESTAMP	The date time that this case will turn yellow if it has not yet been resolved.
25	RC_RED_DTTM	DateTime(26)	TIMESTAMP	The date time that this case will turn Red if it has not yet been resolved.
26	CLOSED_DATE	Date(10)	DATE	Date Closed
27	STATUS_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Categories for Case Status. These drive processing. C=Closed D=Canceled H=Case is on hold O=Case is Open
28	RC_MANAGER	Character(15)	VARCHAR2(15) NOT NULL	Call Center Manager. Used in call center business unit setup.
29	SLA_COLOR	Character(6)	VARCHAR2(6) NOT NULL	SLA Color - can be red, green or yellow depending on how close the case is to missing the required restore time goal per the service level agreement.