BUSINESS_UNITPROJECT_IDACTIVITY_IDEFFDTDefault Value: %date
PC_CPY_UNIQUEIDA=Active
I=Inactive
Default Value: A
1=Rate Set
2=Rate Plan
Prompt Table: PC_RATE_VW2
Prompt Table: PC_RATE_PLAN_A
PC_CPY_ARAT_TAO(SQL Table) |
Index Back |
|---|---|
Temp tbl Pricing/Rate TemplateTemp table used in copy utility to copy PC_PRICE_RATES for activities. |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | PC_CPY_UNIQUEID |
Character(15) | VARCHAR2(15) NOT NULL | Copy Unique ID |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 7 | RATE_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
This will determine selection of 1) Rate Set and 2) Rate Plan in Project Type, Project and Activity.
1=Rate Set 2=Rate Plan |
| 8 | PC_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL |
Rate Template ID
Prompt Table: PC_RATE_VW2 |
| 9 | 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_A |