UPG_PC_CONT_TAO (SQL Table)	Index Back
PC pricing upgrade Temp table used in the PC upgrade to handle contract rates that could not be converted due to one contract line being associated to multiple burden plans.

UPG_PC_CONT_TAO

(SQL Table)

PC pricing upgrade

Temp table used in the PC upgrade to handle contract rates that could not be converted due to one contract line being associated to multiple burden plans.

# 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

5 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

6 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

#	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
5	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
6	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num