SP_APR_TS_SR_VW

(SQL View)
 Index Back

SELECT H.PERSON_ID ,H.BUSINESS_UNIT ,H.TIME_SHEET_ID ,H.TIME_HDR_STATUS , H.PERIOD_START_DT ,H.PERIOD_END_DT ,SUM(W.SP_TIME_QTY) ,H.SPA_TIMESHEET_NAME , ' ' , B.DESCRSHORT ,WO.WORK_ORDER_ID ,WO.WO_NAME FROM PS_SPA_TIME_HDR H , PS_SPA_TIME_WO W , PS_BUS_UNIT_TBL_FS B , PS_SPF_WORDERREC WO WHERE H.BUSINESS_UNIT = W.BUSINESS_UNIT AND W.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = WO.BUSINESS_UNIT AND W.WORK_ORDER_ID = WO.WORK_ORDER_ID AND H.TIME_SHEET_ID = W.TIME_SHEET_ID GROUP BY H.PERSON_ID ,H.BUSINESS_UNIT ,H.SPA_TIMESHEET_NAME ,H.TIME_HDR_STATUS , H.PERIOD_START_DT,H.PERIOD_END_DT,H.TIME_SHEET_ID, B.DESCRSHORT,WO.WORK_ORDER_ID,WO.WO_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
4 TIME_HDR_STATUS Character(3) VARCHAR2(3) NOT NULL Time Line Status
ADJ=Adjusted
APR=Approved
DEN=Denied
LAJ=Line Adjusted
LDN=Line Denied
LPD=Line Pending
OPN=Open
PND=Pending
SUB=Submitted
5 PERIOD_START_DT Date(10) DATE Represents the date commencement point for a given time set utilized in cash worksheet processing.
6 PERIOD_END_DT Date(10) DATE NOT NULL Represents the date termination point for a given time set utilized in cash worksheet processing.
7 SP_TIME_QTY Signed Number(18,4) DECIMAL(16,4) NOT NULL Time Quantity
8 SPA_TIMESHEET_NAME Character(30) VARCHAR2(30) NOT NULL Time Sheet Name
9 SPA_DATE_RANGE Character(23) VARCHAR2(23) NOT NULL Date Range
10 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
11 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
12 WO_NAME Character(30) VARCHAR2(30) NOT NULL Work Order Name