PGM_RISK_TRIGGR

(SQL Table)
 Index Back

Project Risk Triggers

This table contains Risk Triggers associated with a Project Risk

  • Related Language Record: PGM_RSK_TRIG_LG

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

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

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

    Default Value: OPR_DEF_TBL_PC.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 TRIGGER_STATUS Character(1) VARCHAR2(1) NOT NULL Risk Trigger Status
    A=Active
    I=Inactive
    N=Ignore

    Default Value: I

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