BUSINESS_UNITBURDEN_PLANBUSINESS_UNIT_PCPC_TEMPLATE_IDRATE_TMPL_OPTIONCRTP=Contract Rate Plan
NSTD=Contract Rate Set
TMPL=Rate Set
URTP=Rate Plan
UPG_CA_RP2_TAO(SQL Table) |
Index Back |
|---|---|
CA Rates UpgradeTemp table copy of UPG_CA_RP_TAO used to sequence the new Rate Plan Id in the UPG_CA_RP_TAO. |
| # | 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 |