PC_ED_RISK_DTTM

(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 , MAX(A.FMS_LASTUPDDTTM) FROM PS_PGM_PROJ_RISK A 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 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.