RC_SUP_SLMDB_VW

(SQL View)
 Index Back

Support SLM Analysis

Input view for Support SLM Analysis ACE report

SELECT C.PROBINST , A.CASE_ID , A.BO_NAME , 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 , A.AGREEMENT_FLAG FROM PS_RC_SUP_SLM_RPT A , PS_RC_SUP_SLMA B , PS_RC_SUP_SLM_INST C WHERE B.OPRID = C.OPRID AND B.RUN_CNTL_ID = C.RUN_CNTL_ID AND A.UUID_RAW = C.UUID_RAW

# 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 PRODUCT_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
5 PROVIDER_GRP_NAME Character(50) VARCHAR2(50) NOT NULL Provider Group Name
6 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
7 RC_PRIORITY_SDESCR Character(20) VARCHAR2(20) NOT NULL Priority Short Descr
8 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables
9 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description 20
10 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
11 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
12 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
13 AGREEMENT_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates whether or not the service can be used on an agreement.
N=No
Y=Yes