PROCESS_INSTANCEBUSINESS_UNITRATE_PLANPC_TEMPLATE_IDDefault Value: %date
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
Default Value: N
UPG_PC_EFF3_TAO(SQL Table) |
Index Back |
|---|---|
PC Pricing UpgradeTemp table used in the PC upgrade with list of rate plans from UPG_PC_RSEF_TAO where there is an exact match between one of the rate plan effective dates and the rate template effective date. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | 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. |
| 4 | PC_TEMPLATE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Rate Template ID |
| 5 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success Default Value: N |