PGM_RISKS_CNT (SQL View)	Index Back
Count of Risks by Project This view shows the count of Active/Potential Risks by Project.

PGM_RISKS_CNT

(SQL View)

Count of Risks by Project

This view shows the count of Active/Potential Risks by Project.

SELECT BUSINESS_UNIT , PROJECT_ID , COUNT(*) FROM PS_PGM_PROJ_RISK WHERE RISK_STATUS IN ('A', 'P') GROUP BY BUSINESS_UNIT , 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 TOTAL_RISKS Number(8,0) INTEGER NOT NULL Total Risks

#	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	TOTAL_RISKS	Number(8,0)	INTEGER NOT NULL	Total Risks