PC_LATETIME_VW6

(SQL View)
 Index Back

Project Late Timesheets

Missing Timesheets.

SELECT DISTINCT A.BUSINESS_UNIT , A.PROJECT_ID , A.TEAM_MEMBER , B.PERIOD_END_DT , %DateDiff(B.PERIOD_END_DT, %currentdatein) FROM PS_PROJECT_TEAM A , PS_PROJECT PR , PS_PC_EX_TIME_PER B , PS_EX_EE_ORG_DTL C WHERE A.BUSINESS_UNIT = PR.BUSINESS_UNIT AND A.PROJECT_ID = PR.PROJECT_ID AND PR.END_DT >= %CurrentDateIn AND B.PERIOD_END_DT BETWEEN A.PLAN_STARTDT AND A.PLAN_ENDDT AND A.TEAM_MEMBER = C.EMPLID AND B.BUSINESS_UNIT_GL = C.BUSINESS_UNIT_GL AND C.DFLT_EE_PROF_FLG = 'Y' AND EXISTS ( SELECT 'X' FROM PS_EX_TIME_HDR HDR , PS_EX_TIME_DTL DTL WHERE HDR.TIME_SHEET_ID = DTL.TIME_SHEET_ID AND HDR.VERSION_NUM = DTL.VERSION_NUM AND B.BUSINESS_UNIT_GL = HDR.BUSINESS_UNIT_GL AND B.PERIOD_END_DT = HDR.PERIOD_END_DT AND DTL.BUSINESS_UNIT_PC = PR.BUSINESS_UNIT AND DTL.PROJECT_ID = PR.PROJECT_ID AND NOT EXISTS ( SELECT 'X' FROM PS_EX_TIME_HDR D WHERE A.TEAM_MEMBER = D.EMPLID AND B.PERIOD_END_DT = D.PERIOD_END_DT))

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.
5 DAYS_OVERDUE Signed Number(6,0) DECIMAL(5) NOT NULL Calculated number of days overdue from Due date.