RC_CLOSURED_VW2

(SQL View)
 Index Back

Case Closures

View of Case Closures for the past day.

SELECT A.BUSINESS_UNIT , A.PROVIDER_GRP_ID , B.RC_MANAGER , A.CASE_ID , A.DISP_TMPL_FAM_CD , A.BO_ID_CUST , A.RC_SUMMARY , A.RC_PRIORITY , A.RC_STATUS , A.CREATION_DATE , A.RC_REST_DATE , A.RC_REST_TIME , A.ASSIGNED_TO FROM PS_RC_CASE A , PS_RF_PROVIDER_GRP B WHERE A.CLOSED_DATE IS NOT NULL AND A.CLOSED_DATE > %DateAdd(%currentdatein , -2) AND B.PROVIDER_GRP_ID = A.PROVIDER_GRP_ID AND B.SETID = ( SELECT C.SETID FROM PS_SET_CNTRL_REC C WHERE C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'RF_PROVIDER_GRP')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
3 RC_MANAGER Character(15) VARCHAR2(15) NOT NULL Call Center Manager. Used in call center business unit setup.
4 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.
5 DISP_TMPL_FAM_CD Character(30) VARCHAR2(30) NOT NULL Display Template Family Code
6 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
7 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.
8 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
9 RC_STATUS Character(5) VARCHAR2(5) NOT NULL Case Status
10 CREATION_DATE Date(10) DATE Creation date of the case.
11 RC_REST_DATE Date(10) DATE Restore Date
12 RC_REST_TIME Time(15) TIMESTAMP Restore Time
13 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.