BUSINESS_UNITBURDEN_PLANBUSINESS_UNIT_PCPC_TEMPLATE_IDRATE_TMPL_OPTIONCRTP=Contract Rate Plan
NSTD=Contract Rate Set
TMPL=Rate Set
URTP=Rate Plan
UPG_CA_RP_TAO(SQL Table) |
Index Back |
|---|---|
CA Rates UpgradeTemp table used in the CA upgrade ae to convert the CA Header Burden Plan into CA line Rate Plan. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BURDEN_PLAN |
Character(5) | VARCHAR2(5) NOT NULL | Burden Plan 05/26/2004 - FS LABEL - "RATES" added |
| 3 | BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 4 | PC_TEMPLATE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Rate Template ID |
| 5 | 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 |
| 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. |
| 7 | UPG_CA_BP_RP | Number(9,0) | DECIMAL(9) NOT NULL | Field used in the CA upgrade into the UPG_CA_RP_TAO to sequence the new Rate Plans. |