PGM_DELV_OVD_VW (SQL View)	Index Back
View of No. of Overdue Deliver This view will count the number of deliverables that are overdue by project.

PGM_DELV_OVD_VW

(SQL View)

View of No. of Overdue Deliver

This view will count the number of deliverables that are overdue by project.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , COUNT(*) FROM PS_PC_DELIVERABLES A WHERE A.PC_DELV_STATUS IN ('I', 'N') AND A.DUE_DATE < %CurrentDateIn GROUP BY A.BUSINESS_UNIT , A.PROJECT_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 PC_DELV_OVERDUE Number(4,0) SMALLINT NOT NULL Number of Overdue Deliverables

#	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	PC_DELV_OVERDUE	Number(4,0)	SMALLINT NOT NULL	Number of Overdue Deliverables