RC_SLM_RPT_TBL

(SQL Table)
Index Back

Management Rpt Table

Table for Management Dashboard for FieldService

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 UUID_RAW Character(36) VARCHAR2(36) NOT NULL Universal Unique Identifier - can be used as an identifier when processing a batch of data.
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
8 RC_PRIORITY_SDESCR Character(20) VARCHAR2(20) NOT NULL Priority Short Descr
9 RC_SHORT_DESCR Character(20) VARCHAR2(20) NOT NULL Short Description. Used on may CallCenter set-up tables
10 RC_AGREEMENT_COUNT Number(10,0) DECIMAL(10) NOT NULL Agreement Count
11 RC_WARRANTY_COUNT Number(10,0) DECIMAL(10) NOT NULL Warranty Count
12 RC_NO_RESP_COUNT Number(10,0) DECIMAL(10) NOT NULL No Response Count
13 RC_NO_REST_COUNT Number(10,0) DECIMAL(10) NOT NULL Not Restored Count