SPA_TRC_SUM_NB

(SQL View)
Index Back

SELECT H.BUSINESS_UNIT ,H.TIME_SHEET_ID ,H.WORK_ORDER_ID ,'NOBIL' ,'Non-Billable' ,SUM(H.SP_TIME_QTY) FROM PS_SPA_TIM_DTL_DLY H , PS_SPA_TIME_DTL D WHERE D.SPA_BILLING_ACTION = 'U' AND D.BUSINESS_UNIT = H.BUSINESS_UNIT AND D.TIME_SHEET_ID = H.TIME_SHEET_ID AND D.LINE_NBR = H.LINE_NBR AND D.WORK_ORDER_ID = H.WORK_ORDER_ID GROUP BY H.BUSINESS_UNIT ,H.TIME_SHEET_ID ,H.WORK_ORDER_ID

# 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

Prompt Table: SPA_TIME_WO2_VW

4 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 SP_TIME_QTY Signed Number(18,4) DECIMAL(16,4) NOT NULL Time Quantity