RS_2090AVST_WS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DATE_REPORT | Date(10) | DATE | Report Date |
| 2 | NUM_OF | Number(25,1) | DECIMAL(24,1) NOT NULL | Number of |
| 3 | TOTAL_SO | Number(23,0) | DECIMAL(23) NOT NULL | Total Service Orders |
| 4 | AVG_STAFFING_TIME | Number(25,1) | DECIMAL(24,1) NOT NULL | Average Staffing Time |
| 5 | AVG_NUM_REQ | Number(25,1) | DECIMAL(24,1) NOT NULL | Average Number Of Requests |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |