PGM_RISK_NOTES

(SQL Table)
 Index Back

Project Risk Notes

This table contains additional notes associated with a Project Risk

  • Related Language Record: PGM_RSK_NOTE_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: PGM_PROJ_RISK.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Default Value: PGM_PROJ_RISK.PROJECT_ID

    Prompt Table: SP_PROJS_NONVW

    3 RISK_ID Character(10) VARCHAR2(10) NOT NULL Risk ID
    4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1

    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 DESCRLONG Long Character CLOB Long Description
    7 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    8 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    9 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    10 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.