PC_ETC_DATE_VW (SQL View)	Index Back
View of ETC Date by Project View of Forecasted Estimate to Complete Date for each Project. Projects with a Forecasting level other than 'A' (activity) will be excluded. We do not report on projects that are only forecasted at the 'P' (project) level.

PC_ETC_DATE_VW

(SQL View)

View of ETC Date by Project

View of Forecasted Estimate to Complete Date for each Project. Projects with a Forecasting level other than 'A' (activity) will be excluded. We do not report on projects that are only forecasted at the 'P' (project) level.

SELECT A.BUSINESS_UNIT_PC , A.PROJECT_ID , D.PROJECT_TYPE , D.END_DT , MAX(A.COMPLETION_DATE) FROM PS_FC_TIME_DTL A , PS_FC_TIME_HDR B , PS_PC_HORIZON_VW C , PS_PROJECT D WHERE A.EMPLID = B.EMPLID AND A.BEGIN_DT = B.BEGIN_DT AND B.BUSINESS_UNIT_GL = C.BUSINESS_UNIT_GL AND B.BEGIN_DT = C.BEGIN_DT AND A.BUSINESS_UNIT_PC = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID AND D.FORECAST_LEVEL = 'A' GROUP BY A.BUSINESS_UNIT_PC, A.PROJECT_ID, D.PROJECT_TYPE, D.END_DT

# 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 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment

4 END_DT Date(10) DATE End Date

5 COMPLETION_DATE Date(10) DATE Completion Date

#	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	PROJECT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Type A=Activity G=Grant H=Phase P=Project S=Segment
4	END_DT	Date(10)	DATE	End Date
5	COMPLETION_DATE	Date(10)	DATE	Completion Date