RF_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_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 4 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Identification number for the provider group.
Prompt Table: RF_PROVGRP_VW2 |
| 5 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 6 | TOTAL_SO | Number(5,0) | INTEGER NOT NULL | This field is used to store the total number of Service Orders. |
| 7 | TOT_SOLN_OPEN | Number(5,0) | INTEGER NOT NULL | Total Service Order Lines Open |
| 8 | TOT_SOLN_ACPT | Number(5,0) | INTEGER NOT NULL | Total Service Order Lines Accepted |
| 9 | TOT_SOLN_OHC | Number(5,0) | INTEGER NOT NULL | Total Service Order Line On Hold Customer |
| 10 | TOT_SOLN_OHP | Number(5,0) | INTEGER NOT NULL | Total Service Order Lines On Hold Parts |
| 11 | TOT_SOLN_OOS | Number(5,0) | INTEGER NOT NULL | Total Service Order Line On Site |
| 12 | TOT_SOLN_URG | Number(5,0) | INTEGER NOT NULL | Total Service Order Lines Urgent |
| 13 | TOT_SOLN_MCOMMIT | Number(5,0) | INTEGER NOT NULL | Total Service Order Lines Missed Commitment |