PGM_ACTION_PLAN

(SQL Table)
 Index Back

Project Risk Action Plan

This table contains the Action Plans associated with a Project Risk

  • Related Language Record: PGM_PLAN_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 ACTION_PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Action Plan Type
    1=Acceptance
    2=Avoidance
    3=Mitigation
    4=Transference
    6 PRIMARY_FLAG Character(1) VARCHAR2(1) NOT NULL Primary
    N=No
    Y=Yes
    7 ACTION_PLAN_SUMMRY Character(30) VARCHAR2(30) NOT NULL Action Plan Summary
    8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    9 RISK_FIN_IMPACT Signed Number(28,3) DECIMAL(26,3) NOT NULL Financial Impact
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: PROJECT.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    11 BUSINESS_IMPACT Character(254) VARCHAR2(254) NOT NULL Description
    12 IMPACT_DT Date(10) DATE Date
    13 IMPACT_DAYS Number(16,2) DECIMAL(15,2) NOT NULL Schedule Days Impacted
    14 SCHEDULE_IMPACT Character(254) VARCHAR2(254) NOT NULL Schedule Impact Description
    15 RESOURCE_IMPACT Number(16,2) DECIMAL(15,2) NOT NULL Resource Impact
    16 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: UNITS_TBL

    17 RES_IMPACT_DESCR Character(254) VARCHAR2(254) NOT NULL Resource Impact Description
    18 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    19 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    20 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    21 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.