PC_BUD_ALERT

(SQL Table)
 Index Back

User Defined Budget Alerts

This table allows the user to enter and maintain alert levels for Projects and Activities. These alerts control what status is displayed on the Budget Analysis pages.

  • Related Language Record: PC_BUD_ALRT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PC_BUD_ALERT_LVL Character(1) VARCHAR2(1) NOT NULL This field stores the Projects Budgeting Alert Level. This tells the system how to calculate the amount that needs to be monitored for an alert. I.E. Projects level alerts will sum all resource amounts for that project and compare against the values set in the alert threshold to determine wether or not to issue an alert.
    1=Business Unit
    2=Project
    3=Activity
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    4 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    5 PC_BUD_ALERT_TYP Character(1) VARCHAR2(1) NOT NULL This field stores the type of alert for Projects Budgeting. There are currently two types of alerts: High and Medium. The system will only send email notification to a Project Manager for High alerts that have the email flag set to 'Y'.
    H=High Alert
    M=Medium Alert
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 OPERATION Character(3) VARCHAR2(3) NOT NULL Arithmetic Operation
    <=Less Than
    <==Less Than or Equal To
    <>=Not Equal To
    ==Equal To
    >=Greater Than
    >==Greater Than or Equal To

    Default Value: <=

    8 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
    9 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    11 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
    C=Complete
    E=Errors
    N=Initialize
    P=In Process