CASE_IDBUSINESS_UNITRC_CASE2PGLT_VW(SQL View) |
Index Back |
|---|---|
Call Center Case viewView used to display call center case information. Used specifically on "Cases by Priority" 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_PRIORITY_TBL B WHERE A.RC_PRIORITY = B.RC_PRIORITY AND B.SETID IN ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'RC_PRIORITY_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_PRIORITY | Character(5) | VARCHAR2(5) NOT NULL | Case Priority |
| 12 | RC_SHORT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables |