SDB_PRIORITY_VW (SQL View)	Index Back
Case Priority View Used for the initial load of case priority to the contact center dashboard.

SDB_PRIORITY_VW

(SQL View)

Case Priority View

Used for the initial load of case priority to the contact center dashboard.

SELECT A.SETID , A.RC_PRIORITY , A.RC_SS_IND , A.RC_SHORT_DESCR , A.RC_DESCR_SS , A.LONG_DESC , A.RC_PRIORITY_CAT , B.XLATSHORTNAME , B.XLATLONGNAME FROM PS_RC_PRIORITY_TBL A , PSXLATITEM B WHERE B.FIELDNAME = 'RC_PRIORITY_CAT' AND B.FIELDVALUE = A.RC_PRIORITY_CAT AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSXLATITEM C WHERE C.FIELDNAME = B.FIELDNAME AND C.FIELDVALUE = B.FIELDVALUE AND C.EFFDT <= %CurrentDateIn AND C.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

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

3 RC_SS_IND Character(1) VARCHAR2(1) NOT NULL Defines if this is a self service transaction or not.

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

5 RC_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Description to be shown on Self-Service Pages

6 LONG_DESC Character(50) VARCHAR2(50) NOT NULL Long Description field.

7 RC_PRIORITY_CAT Character(1) VARCHAR2(1) NOT NULL Priority Category for Cases
H=High
L=Low
M=Medium

8 PRIORTY_CAT_SDESCR Character(10) VARCHAR2(10) NOT NULL Used for contact center dashboard to display priority category short description.

9 PRIORTY_CAT_LDESCR Character(30) VARCHAR2(30) NOT NULL Used for contact center dashboard to display priority category long description.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
2	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority
3	RC_SS_IND	Character(1)	VARCHAR2(1) NOT NULL	Defines if this is a self service transaction or not.
4	RC_SHORT_DESCR	Character(20)	VARCHAR2(20) NOT NULL	Short Description. Used on may CallCenter set-up tables
5	RC_DESCR_SS	Character(30)	VARCHAR2(30) NOT NULL	Description to be shown on Self-Service Pages
6	LONG_DESC	Character(50)	VARCHAR2(50) NOT NULL	Long Description field.
7	RC_PRIORITY_CAT	Character(1)	VARCHAR2(1) NOT NULL	Priority Category for Cases H=High L=Low M=Medium
8	PRIORTY_CAT_SDESCR	Character(10)	VARCHAR2(10) NOT NULL	Used for contact center dashboard to display priority category short description.
9	PRIORTY_CAT_LDESCR	Character(30)	VARCHAR2(30) NOT NULL	Used for contact center dashboard to display priority category long description.