SETIDPRODUCT_IDEFFDTDefault Value: %date
BUSINESS_UNIT_PCPrompt Table: SP_BU_PC_NONVW
Prompt Table: CA_PC_RATE_VW2
Prompt Table: CA_PC_RPLAN_VW
CRTP=Contract Rate Plan
NSTD=Contract Rate Set
TMPL=Rate Set
URTP=Rate Plan
Default Value: TMPL
CA_OFF_RATE_TBL(SQL Table) |
Index Back |
|---|---|
Product: Default Rate Template |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 5 | PC_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL |
Rate Template ID
Prompt Table: CA_PC_RATE_VW2 |
| 6 | 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: CA_PC_RPLAN_VW |
| 7 | RATE_TMPL_OPTION | Character(4) | VARCHAR2(4) NOT NULL |
Rate Option
CRTP=Contract Rate Plan NSTD=Contract Rate Set TMPL=Rate Set URTP=Rate Plan Default Value: TMPL |