RC_MGMT_RPT_TBL(SQL Table) |
Index Back |
|---|---|
Management Rpt TableTable 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_OPENED_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Used in BAM Reporting |
| 9 | RC_CLOSED_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Used in BAM Reporting |
| 10 | RC_CANCELLED_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Used in BAM Reporting |
| 11 | RC_SO_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Used in BAM Reporting |
| 12 | RC_RMA_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Used in BAM Reporting |