UPG_PC_BPL2_TAO (SQL Table)	Index Back
PC Pricing upgrade Temp table used in the PC upgrade to convert the CA Burden Plans into CA line Rate Plan.

UPG_PC_BPL2_TAO

(SQL Table)

PC Pricing upgrade

Temp table used in the PC upgrade to convert the CA Burden Plans into CA line Rate Plan.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 RATE_PLAN Character(15) VARCHAR2(15) NOT NULL Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.

4 PC_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rate Template ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	RATE_PLAN	Character(15)	VARCHAR2(15) NOT NULL	Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.
4	PC_TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Rate Template ID