CASE_IDSETIDN=No
Y=Yes
RC_KBMGRARCL_VW(SQL View) |
Index Back |
|---|---|
Arrival vs closureRecord for manager's arrivals and closures for Performance Insights. This view is union of rc_kb_mgr_arrr_v and rc_kb_mgr_cls_v. |
| SELECT CASE_ID , RC_BUS_UNIT , (%Sql(RC_BUS_UNIT_DESCR, RC_BUS_UNIT)) , SETID , DISP_TMPL_FAM_CD , RC_MANAGER , (%Sql(RC_ASSIGN_NAME, RC_MANAGER)) , PROVIDER_GRP_ID , ASSIGNED_TO , CATEGORY_DESCR , RC_TYPE_DESCR , RC_DETAIL_DESCR , PROVIDER_GRP_NAME , PRIORITY_NAME , SLA_COLOR , RC_DESC_SEVERITY , RC_SHORT_DESCR3 , ESCALATION_FLAG , GLOBAL_FLAG , SECURE_CASE_FLG , BO_NAME_DISPLAY_5 , RC_DESC_SOURCE , RC_SHORT_DESCR5 , ROW_LASTMANT_DTTM , CASE_ARRIVALS , MONTH , QUARTER_VIEW , CREATION_DATE , CLOSED_DATE , FROM_DATE %Concat ' to ' %Concat TO_DATE , ANNUAL_VIEW , RC_SUMMARY , CASE_AGE_NUM , CREATION_DATE , CASE_ES_SRCH_SECID FROM PS_RC_KB_MGR_ARR_V UNION SELECT CASE_ID , RC_BUS_UNIT , (%Sql(RC_BUS_UNIT_DESCR, RC_BUS_UNIT)) , SETID , DISP_TMPL_FAM_CD , RC_MANAGER , (%Sql(RC_ASSIGN_NAME, RC_MANAGER)) , PROVIDER_GRP_ID , ASSIGNED_TO , CATEGORY_DESCR , RC_TYPE_DESCR , RC_DETAIL_DESCR , PROVIDER_GRP_NAME , PRIORITY_NAME , SLA_COLOR , RC_DESC_SEVERITY , RC_SHORT_DESCR3 , ESCALATION_FLAG , GLOBAL_FLAG , SECURE_CASE_FLG , BO_NAME_DISPLAY_5 , RC_DESC_SOURCE , RC_SHORT_DESCR5 , ROW_LASTMANT_DTTM , CASE_ARRIVALS , MONTH , QUARTER_VIEW , CREATION_DATE , CLOSED_DATE , FROM_DATE %Concat ' to ' %Concat TO_DATE , ANNUAL_VIEW , RC_SUMMARY , CASE_AGE_NUM , CLOSED_DATE , CASE_ES_SRCH_SECID FROM PS_RC_KB_MGR_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 | RC_BU_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Business Unit descr to be displayed on the case pages. |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 5 | DISP_TMPL_FAM_CD | Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code |
| 6 | RC_MANAGER | Character(15) | VARCHAR2(15) NOT NULL | Call Center Manager. Used in call center business unit setup. |
| 7 | MANAGER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Manager Name |
| 8 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
| 9 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 10 | CATEGORY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Category Description field. Used in Text Tray |
| 11 | RC_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | CTD - Type Description |
| 12 | RC_DETAIL_DESCR | Character(30) | VARCHAR2(30) NOT NULL | CTD - Detail Description |
| 13 | PROVIDER_GRP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Provider Group Name |
| 14 | 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. |
| 15 | 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. |
| 16 | RC_DESC_SEVERITY | Character(20) | VARCHAR2(20) NOT NULL | Used to display short description of Case Severity in search results grid on case search page. |
| 17 | RC_SHORT_DESCR3 | Character(20) | VARCHAR2(20) NOT NULL | Short Description |
| 18 | ESCALATION_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Escalation flag for pivot grids |
| 19 | GLOBAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Global Case flag for relationship |
| 20 | 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 |
| 21 | BO_NAME_DISPLAY_5 | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 22 | RC_DESC_SOURCE | Character(20) | VARCHAR2(20) NOT NULL | Used to display short description of Case Source in search results grid on case search page. |
| 23 | RC_SHORT_DESCR5 | Character(20) | VARCHAR2(20) NOT NULL | Short Description |
| 24 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 25 | CASE_ARRIVALS | Character(10) | VARCHAR2(10) NOT NULL | Contains the string 'Arrivals' for use with charting. |
| 26 | MONTH | Character(20) | VARCHAR2(20) NOT NULL | Used in monthly view in case arrival vs closure pivot |
| 27 | QUARTER_VIEW | Character(20) | VARCHAR2(20) NOT NULL | Field created for quarter view in pivots |
| 28 | CREATION_DATE | Date(10) | DATE | Creation date of the case. |
| 29 | CLOSED_DATE | Date(10) | DATE | Date Closed |
| 30 | WEEK_RANGE | Character(40) | VARCHAR2(40) NOT NULL | Field created for weekly view |
| 31 | ANNUAL_VIEW | Character(6) | VARCHAR2(6) NOT NULL | Field created for annual view |
| 32 | RC_SUMMARY | Character(80) | VARCHAR2(80) NOT NULL | Typically a summary of a long field. |
| 33 | CASE_AGE_NUM | Number(5,0) | INTEGER NOT NULL | Shows Case Age as number |
| 34 | REFERENCE_DATE | Date(10) | DATE | Reference date to consider case arrival and closure. |
| 35 | CASE_ES_SRCH_SECID | Character(100) | VARCHAR2(100) NOT NULL | Secuirty attribute field for Search Indexes used in Insights Dashboard |