PC_CPY_BDAL_TAO (SQL Table)	Index Back
Temp Table for copy function Copy utility temp table for Budget Alerts.

PC_CPY_BDAL_TAO

(SQL Table)

Temp Table for copy function

Copy utility temp table for Budget Alerts.

# 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
Default Value: M

6 PC_CPY_UNIQUEID Character(15) VARCHAR2(15) NOT NULL Copy Unique ID

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 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

9 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

10 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD
Prompt Table: CURRENCY_CD_TBL

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

#	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 Default Value: M
6	PC_CPY_UNIQUEID	Character(15)	VARCHAR2(15) NOT NULL	Copy Unique ID
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	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
9	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
10	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
12	PROCESSED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Plan Processed Flag C=Complete E=Errors N=Initialize P=In Process