SPA_BILL_HRS_VW(SQL View) |
Index Back |
|---|
| SELECT A.TIME_SHEET_ID ,A.work_order_id , SUM(B.SP_TIME_QTY) FROM PS_SPA_TIME_DTL A , PS_SPA_TIM_DTL_DLY B WHERE A.TIME_SHEET_ID = B.TIME_SHEET_ID AND A.LINE_NBR = B.LINE_NBR AND A.business_unit = B.business_unit AND A.work_order_id = B.work_order_id AND A.SPA_BILLING_ACTION = 'B' GROUP BY A.TIME_SHEET_ID,a.work_order_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SPA_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Sheet ID |
| 2 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 3 | DTL_TOTAL_B | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Total Billable Hours |