PC_CPY_PRCP_TAO

(SQL Table)
Index Back

Copy of Pricing/Rate Plan

Used in copy utility for PC_PRICE_R_PLAN.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
4 PC_CPY_UNIQUEID Character(15) VARCHAR2(15) NOT NULL Copy Unique ID
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

7 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.

Prompt Table: PC_RATE_PLAN_VW