UPG_PC_MXDT_TAO (SQL Table)	Index Back
PC Pricing Upgrade Temp table used in the PC upgrade with list of rate plans from UPG_PC_RSEF_TAO where there is an exact match between one of the rate plan effective dates and the rate template effective date.

UPG_PC_MXDT_TAO

(SQL Table)

PC Pricing Upgrade

Temp table used in the PC upgrade with list of rate plans from UPG_PC_RSEF_TAO where there is an exact match between one of the rate plan effective dates and the rate template effective date.

# 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 EFFDT_OLD Date(10) DATE Old Effective Date

5 EFFDT_NEW Date(10) DATE New Effective Date

#	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	EFFDT_OLD	Date(10)	DATE	Old Effective Date
5	EFFDT_NEW	Date(10)	DATE	New Effective Date