PC_TIME_DISTRIB

(SQL View)
 Index Back

Processed Timesheet

This view will return all timesheets that have been processed through EX to PC.

SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.TIME_SHEET_ID FROM PS_PROJ_RESOURCE A WHERE A.TIME_SHEET_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)