RC_CASE3PGLT_VW

(SQL View)
Index Back

Call Center Case view

View used to display call center case information. Used specifically on "Cases by Source" pagelet.

SELECT A. CASE_ID , A.BUSINESS_UNIT , A.CREATION_DATE , A.CLOSED_DATE , A.YEAR , A.MONTH_DISPLAY , A.RC_MONTH_YEAR , A.NBR_OF_DAYS , A.RC_CASE_COUNT , A.RC_CASE_COUNT_2 ,A.RC_PRIORITY ,B.RC_SHORT_DESCR FROM PS_RC_CASE_PGLT_VW A , PS_RC_SOURCE_TBL B WHERE A.RC_SOURCE = B.RC_SOURCE AND B.SETID IN ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'RC_SOURCE_TBL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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.
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 CREATION_DATE Date(10) DATE Creation date of the case.
4 CLOSED_DATE Date(10) DATE Date Closed
5 YEAR Character(4) VARCHAR2(4) NOT NULL Char(4) field used to display the year part of date fields.
6 MONTH_DISPLAY Character(2) VARCHAR2(2) NOT NULL Month
7 RC_MONTH_YEAR Character(10) VARCHAR2(10) NOT NULL Used for concatenating month and year of a date field
8 NBR_OF_DAYS Number(4,0) SMALLINT NOT NULL Estimated Days
9 RC_CASE_COUNT Number(7,0) INTEGER NOT NULL Case Count
10 RC_CASE_COUNT_2 Number(7,0) INTEGER NOT NULL Used for queries to display number of Cases for a specific criteria.
11 RC_SOURCE Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated
12 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables