RC_MGMT_DBD_VW

(SQL View)
 Index Back

Support Case Analytic View

Input view to Support Case ACE report

SELECT K.PROBINST , A.BO_NAME , A.PRODUCT_DESCR , A.PROVIDER_GRP_NAME , A.NAME , A.RC_PRIORITY , A.RC_OPENED_COUNT , A.RC_CLOSED_COUNT , A.RC_CANCELLED_COUNT , A.RC_SO_COUNT , A.RC_RMA_COUNT FROM PS_RC_MGMT_RPT_TBL A , PS_RC_SUP_MGDB J , PS_RC_SUP_MGD_INST K WHERE A.BUSINESS_UNIT = J.BUSINESS_UNIT AND J.OPRID = K.OPRID AND J.RUN_CNTL_ID = K.RUN_CNTL_ID AND A.UUID_RAW = K.UUID_RAW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
3 PRODUCT_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
4 PROVIDER_GRP_NAME Character(50) VARCHAR2(50) NOT NULL Provider Group Name
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
7 RC_OPENED_COUNT Number(10,0) DECIMAL(10) NOT NULL Used in BAM Reporting
8 RC_CLOSED_COUNT Number(10,0) DECIMAL(10) NOT NULL Used in BAM Reporting
9 RC_CANCELLED_COUNT Number(10,0) DECIMAL(10) NOT NULL Used in BAM Reporting
10 RC_SO_COUNT Number(10,0) DECIMAL(10) NOT NULL Used in BAM Reporting
11 RC_RMA_COUNT Number(10,0) DECIMAL(10) NOT NULL Used in BAM Reporting