PC_BUD_ALERT_LVL1=Business Unit
2=Project
3=Activity
BUSINESS_UNITPROJECT_IDACTIVITY_IDPC_BUD_ALERT_TYPH=High Alert
M=Medium Alert
LANGUAGE_CDPC_BUD_ALRT_LNG(SQL Table) |
Index Back |
|---|---|
Budget Alert language tableLanguage table for the Budget Alert record. |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |