BUSINESS_UNITTIME_SHEET_IDWORK_ORDER_IDSPA_INCT_BYWO_V(SQL View) |
Index Back |
|---|---|
Time sheet IncidentsTime sheet Incidents |
| SELECT BUSINESS_UNIT ,TIME_SHEET_ID , WORK_ORDER_ID ,ASSIGNMENT_ID ,CURRENCY_CD , SUM(NUM_OF_INCIDENTS) ,SUM(TIME_AMOUNT) FROM PS_SPA_TIM_INCIDNT GROUP BY BUSINESS_UNIT ,TIME_SHEET_ID , WORK_ORDER_ID ,ASSIGNMENT_ID ,CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TIME_SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 3 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 4 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | NUM_OF_INCIDENTS | Number(16,0) | DECIMAL(16) NOT NULL | Number of incidents |
| 7 | TIME_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Time Amount |