RC_HD_SLM_DB_VW

(SQL View)
Index Back

SLM Helpdesk ACE report view

Input 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