PC_HLTH_CRITERA

(SQL Table)
 Index Back

Projects Health Criteria

Used to determine project health based on user specified criteria.

  • Parent record: BUS_UNIT_TBL_PC

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

    Prompt Table: SP_BU_PC_NONVW

    2 PC_HEALTH_IND Character(1) VARCHAR2(1) NOT NULL Project Health Indicator.
    B=Cost to Budget Variance
    C=Cost to Budget Variance
    D=Overdue Deliverables
    I=High Issues
    K=% Risks Without Action Plan
    P=Overdue % Complete
    R=Overloaded Resources
    S=Schedule
    U=User Defined Indicator
    3 PC_HLTH_ALERT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Project Health Alert percentage.
    4 PC_HLTH_WARN_PCT Number(6,2) DECIMAL(5,2) NOT NULL Project Health Warning percentage.
    5 PRJ_WT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Project Weight Percent
    6 ACT_WT_PCT Number(6,2) DECIMAL(5,2) NOT NULL A field that stores Activity Weight Percent