RC_MGR_ARCLR_VW

(SQL View)
 Index Back

Arrival vs closure

Record for manager's arrivals and closures

SELECT CASE_ID , BUSINESS_UNIT , SETID , RC_MANAGER , PROVIDER_GRP_ID , ASSIGNED_TO , CATEGORY_DESCR , PROVIDER_GRP_NAME , PRIORITY_NAME , SLA_COLOR , RC_SHORT_DESCR , RC_SHORT_DESCR4 , ESCALATION_FLAG , GLOBAL_FLAG , SECURE_CASE_FLG , BO_NAME_DISPLAY_5 , RC_SHORT_DESCR1 , RC_SHORT_DESCR2 , NULL , CASE_ARRIVALS , MONTH , QUARTER_VIEW , CREATION_DATE , CLOSED_DATE , FROM_DATE %Concat ' to ' %Concat TO_DATE , ANNUAL_VIEW ,RC_SUMMARY FROM PS_RC_PG_MGR_ARRIV UNION SELECT CASE_ID , BUSINESS_UNIT , SETID , RC_MANAGER , PROVIDER_GRP_ID , ASSIGNED_TO , CATEGORY_DESCR , PROVIDER_GRP_NAME , PRIORITY_NAME , SLA_COLOR , RC_SHORT_DESCR , RC_SHORT_DESCR4 , ESCALATION_FLAG , GLOBAL_FLAG , SECURE_CASE_FLG , BO_NAME_DISPLAY_5 , RC_SHORT_DESCR1 , RC_SHORT_DESCR2 ,STATUS_CHANGE_DTTM ,CASE_ARRIVALS , MONTH , QUARTER_VIEW , CREATION_DATE , STATUS_CHANGE_DTTM ,FROM_DATE %Concat ' to ' %Concat TO_DATE , ANNUAL_VIEW ,RC_SUMMARY FROM PS_RC_PG_MGR_CLSRE

# 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 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
4 RC_MANAGER Character(15) VARCHAR2(15) NOT NULL Call Center Manager. Used in call center business unit setup.
5 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
6 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.
7 CATEGORY_DESCR Character(30) VARCHAR2(30) NOT NULL Category Description field. Used in Text Tray
8 PROVIDER_GRP_NAME Character(50) VARCHAR2(50) NOT NULL Provider Group Name
9 PRIORITY_NAME Character(30) VARCHAR2(30) NOT NULL Holds the names of the priorities. 01/16/03: Set the Format Type to "Mixedcase", from Uppercase.
10 SLA_COLOR Character(6) VARCHAR2(6) NOT NULL SLA Color - can be red, green or yellow depending on how close the case is to missing the required restore time goal per the service level agreement.
11 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables
12 RC_SHORT_DESCR4 Character(20) VARCHAR2(20) NOT NULL Field created for pivot grid analytics
13 PB_1 Character(1) VARCHAR2(1) NOT NULL Push Button
N=No
Y=Yes
14 PB_2 Character(1) VARCHAR2(1) NOT NULL Push Button to be used in pages for actions
N=No
Y=Yes
15 PB_3 Character(1) VARCHAR2(1) NOT NULL Push Button
N=No
Y=Yes
16 BO_NAME_DISPLAY_5 Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
17 RC_SHORT_DESCR1 Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables
18 RC_SHORT_DESCR2 Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables
19 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
20 CASE_ARRIVALS Character(10) VARCHAR2(10) NOT NULL Contains the string 'Arrivals' for use with charting.
21 MONTH Character(20) VARCHAR2(20) NOT NULL Used in monthly view in case arrival vs closure pivot
22 QUARTER_VIEW Character(20) VARCHAR2(20) NOT NULL Field created for quarter view in pivots
23 CREATION_DATE Date(10) DATE Creation date of the case.
24 CLOSED_DATE Date(10) DATE Date Closed
25 WEEK_RANGE Character(40) VARCHAR2(40) NOT NULL Field created for weekly view
26 ANNUAL_VIEW Character(6) VARCHAR2(6) NOT NULL Field created for annual view
27 RC_SUMMARY Character(80) VARCHAR2(80) NOT NULL Typically a summary of a long field.