SPA_SP_RA_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 FROM PS_SPA_TIME_HDR H , PS_SPA_TIME_WO W , PS_BUS_UNIT_TBL_FS B WHERE H.BUSINESS_UNIT = W.BUSINESS_UNIT AND W.BUSINESS_UNIT = B.BUSINESS_UNIT AND H.TIME_SHEET_ID = W.TIME_SHEET_ID AND H.TIME_HDR_STATUS IN ('OPN', 'DEN', 'LDN') 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

# 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