PC_LATETIME_VW

(SQL View)
 Index Back

Project Late Timesheets

In Progress Timesheets

SELECT B.BUSINESS_UNIT_PC , B.PROJECT_ID , A.TIME_SHEET_ID , A.VERSION_NUM , A.EMPLID , A.PERIOD_END_DT , A.TIME_SHEET_STATUS , B.BILLING_ACTION , SUM(C.TIME_QUANTITY) , 'MHR' , A.BUSINESS_UNIT_GL , MAX(A.LASTUPDDTTM) FROM PS_EX_TIME_HDR A , PS_EX_TIME_DTL B , PS_EX_TIME_DTL_DLY C WHERE A.TIME_SHEET_STATUS IN ('ADJ', 'DEN', 'DNA', 'DNU', 'HDA', 'HDU', 'HLD', 'MFS', 'PAR', 'PND', 'PRO', 'SFA', 'SUB', 'XML') AND A.TIME_SHEET_ID = B.TIME_SHEET_ID AND A.VERSION_NUM = B.VERSION_NUM AND B.TIME_SHEET_ID = C.TIME_SHEET_ID AND B.VERSION_NUM = C.VERSION_NUM AND B.LINE_NBR = C.LINE_NBR GROUP BY B.BUSINESS_UNIT_PC, B.PROJECT_ID, A.TIME_SHEET_ID, A.VERSION_NUM, A.EMPLID, A.PERIOD_END_DT, A.TIME_SHEET_STATUS, B.BILLING_ACTION, A.BUSINESS_UNIT_GL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: PROJECT_ALL_VW

3 TIME_SHEET_ID Character(10) VARCHAR2(10) NOT NULL Time Sheet Unique Identifier (System Generated)
4 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
7 TIME_SHEET_STATUS Character(3) VARCHAR2(3) NOT NULL Time Sheet Status
ADJ=Adjusted
APR=Approved
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Project Manager
HDA=Hold by Approver
HDU=Hold by Project Manager
HLD=Hold
MFS=Marked for Submit
PAR=Approvals in Process
PND=Pending
PRO=In Process
SFA=Submission in Process
SUB=Submitted for Approval
XML=Submitted, Pending Validation
8 BILLING_ACTION Character(1) VARCHAR2(1) NOT NULL Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable
9 TIME_QUANTITY Signed Number(16,2) DECIMAL(14,2) NOT NULL Time Quantity
10 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
11 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.