PC_ED_RISKS_VW

(SQL View)
 Index Back

Project Risks View

This view displays the number of risks by Project. Used in Endeca reporting.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , COUNT(A.RISK_ID) FROM PS_PGM_PROJ_RISK A WHERE A.RISK_STATUS IN ('A', 'P') GROUP BY A.BUSINESS_UNIT, A.PROJECT_ID

  • Parent record: PROJECT

    • # 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

    Prompt Table: PROJECT

    3 TOTAL_RISKS Number(8,0) INTEGER NOT NULL Total Risks