CASE_IDBUSINESS_UNITRC_CASE_PGLT_VW(SQL View) |
Index Back |
|---|---|
Call Center Case viewView used for displaying call center case information on queries. |
| SELECT A.CASE_ID , A.BUSINESS_UNIT , A.CREATION_DATE , A.CLOSED_DATE , TO_CHAR(A.CREATION_DATE , 'YYYY') , TO_CHAR(A.CREATION_DATE ,'MM') , SUBSTR(TO_CHAR(A.CREATION_DATE ,'MONTH') ,1 ,3) || '-' || TO_CHAR(A.CREATION_DATE , 'YY') , (CASE WHEN A.CLOSED_DATE IS NOT NULL THEN ABS(( A.CLOSED_DATE) - (A.CREATION_DATE)) ELSE 0 END) + 1 , CASE WHEN A.CLOSED_DATE IS NOT NULL THEN CASE WHEN A.RES_FIRST_CNTCT = 'Y' THEN 1 ELSE 0 END ELSE 0 END , CASE WHEN A.CLOSED_DATE IS NOT NULL THEN 1 ELSE 0 END , A.RC_SOURCE , A.RC_PRIORITY FROM PS_RC_CASE A |
| # | 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_PRIORITY | Character(5) | VARCHAR2(5) NOT NULL | Case Priority |