RC_HD_SLM_DB_VW(SQL View) |
Index Back |
---|---|
SLM Helpdesk ACE report viewInput view for SLM Helpdesk ACE report |
SELECT K.PROBINST , A.CASE_ID , A.BO_NAME , A.RC_DEPT_DESCR , A.RC_LOC_DESCR , A.PRODUCT_DESCR , A.PROVIDER_GRP_NAME , A.BO_NAME_DISPLAY , A.RC_PRIORITY_SDESCR , A.RC_SHORT_DESCR , A.DESCR20 , A.RC_RESP_IND , A.RC_REST_IND , A.HOLD_FLAG , COUNT(*) FROM PS_RC_HD_SLM_RPT A , PS_RC_HD_SLMA J , PS_RC_HD_SLM_INST K WHERE J.OPRID = K.OPRID AND J.RUN_CNTL_ID = K.RUN_CNTL_ID AND A.UUID_RAW = K.UUID_RAW GROUP BY K.PROBINST , A.CASE_ID, A.BO_NAME , A.RC_DEPT_DESCR , A.RC_LOC_DESCR , A.PRODUCT_DESCR , A.PROVIDER_GRP_NAME , A.BO_NAME_DISPLAY , A.RC_PRIORITY_SDESCR , A.RC_SHORT_DESCR , A.DESCR20 , A.RC_RESP_IND , A.RC_REST_IND , A.HOLD_FLAG |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
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 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
4 | RC_DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description to be displayed on HelpDesk page. |
5 | RC_LOC_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Descripton of the Location to be displayed in helpdesk page. |
6 | PRODUCT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Product Description |
7 | PROVIDER_GRP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Provider Group Name |
8 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
9 | RC_PRIORITY_SDESCR | Character(20) | VARCHAR2(20) NOT NULL | Priority Short Descr |
10 | RC_SHORT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables |
11 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description 20 |
12 | RC_RESP_IND | Character(4) | VARCHAR2(4) NOT NULL |
Response Indicator, to indicate different stage of response for SLA.
A=Pending N=Late NA=Not Applicable Y=On-Time |
13 | RC_REST_IND | Character(4) | VARCHAR2(4) NOT NULL |
Restore Indicator, indicate different stage of restore for SLA
A=Pending N=Late NA=Not Applicable Y=On-Time |
14 | HOLD_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Hold |
15 | RC_CASE_COUNT | Number(7,0) | INTEGER NOT NULL | Case Count |