CASE_IDBUSINESS_UNITSETIDN=No
Y=Yes
N=No
Y=Yes
N=No
Y=Yes
RC_AGT_ARCLR_VW(SQL View) |
Index Back |
|---|---|
Arrival vs closureView used for arrival vs closure Agent Pivot Analytics. |
| SELECT CASE_ID , BUSINESS_UNIT , SETID , RC_MANAGER , PROVIDER_GRP_ID , 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 ,RC_SUMMARY , MONTH , QUARTER_VIEW , CREATION_DATE , CLOSED_DATE , FROM_DATE %Concat ' to ' %Concat TO_DATE , ANNUAL_VIEW , ASSIGNED_TO ,ROW_ADDEDDATE , ROW_LAST_UPDATE , BO_NAME_DISPLAY FROM PS_RC_PG_AGT_ARR_V UNION SELECT CASE_ID , BUSINESS_UNIT , SETID , RC_MANAGER , PROVIDER_GRP_ID , 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 ,RC_SUMMARY , MONTH , QUARTER_VIEW , CREATION_DATE , STATUS_CHANGE_DTTM ,FROM_DATE %Concat ' to ' %Concat TO_DATE , ANNUAL_VIEW , ASSIGNED_TO ,ROW_ADDEDDATE ,ROW_LAST_UPDATE , BO_NAME_DISPLAY FROM PS_RC_PG_AGT_CLS_V |
| # | 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 | CATEGORY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Category Description field. Used in Text Tray |
| 7 | PROVIDER_GRP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Provider Group Name |
| 8 | 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. |
| 9 | 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. |
| 10 | RC_SHORT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables |
| 11 | RC_SHORT_DESCR4 | Character(20) | VARCHAR2(20) NOT NULL | Field created for pivot grid analytics |
| 12 | PB_1 | Character(1) | VARCHAR2(1) NOT NULL |
Push Button
N=No Y=Yes |
| 13 | PB_2 | Character(1) | VARCHAR2(1) NOT NULL |
Push Button to be used in pages for actions
N=No Y=Yes |
| 14 | PB_3 | Character(1) | VARCHAR2(1) NOT NULL |
Push Button
N=No Y=Yes |
| 15 | BO_NAME_DISPLAY_5 | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 16 | RC_SHORT_DESCR1 | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables |
| 17 | RC_SHORT_DESCR2 | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables |
| 18 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 19 | CASE_ARRIVALS | Character(10) | VARCHAR2(10) NOT NULL | Contains the string 'Arrivals' for use with charting. |
| 20 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 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 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 28 | ROW_ADDEDDATE | Character(30) | VARCHAR2(30) NOT NULL | Field created for row added date in pivots |
| 29 | ROW_LAST_UPDATE | Character(30) | VARCHAR2(30) NOT NULL | Field created for row last updated |
| 30 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |