RC_SLADISPLA_V1

(SQL View)
Index Back

Drill To Case Details

A view of case details for chart pagelets and drilling.

SELECT BUSINESS_UNIT , CASE_ID , DISP_TMPL_FAM_CD , CASE_TYPE , BO_ID_CUST ,BO_ID_CONTACT , PROVIDER_GRP_ID , RC_SUMMARY , RC_PRIORITY , RC_STATUS ,RC_SEVERITY , PRODUCT_GROUP , PRODUCT_ID ,RC_CATEGORY ,RC_TYPE ,RC_DESCRLONG ,RC_DETAIL , CREATION_DATE ,%Dttm(RC_REST_DATE, %timenull) , RC_REST_DATE , RC_REST_TIME , ASSIGNED_TO ,SECURE_CASE_FLG , RC_YELLOW_DTTM ,RC_RED_DTTM , CLOSED_DATE FROM PS_RC_CASE

# 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