UPG_PC_RPL2_TAO(SQL Table) |
Index Back |
|---|---|
Rate Plan Line Temp TabeTemp table to store Rate Plan Line information during upgrade. |
| # | 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.
Prompt Table: PC_RATE_PLAN |
| 4 | RATE_PLAN_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Rate plan type determines whether a rate plan is created from Projects or Contracts.
C=Contract R=Standard |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 7 | PC_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL |
Rate Template ID
Prompt Table: %EDITTABLE |
| 8 | TEMPLATE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Used to identify what document/transaction is associated with a particular template. This is a translate table field whose value is either expense sheet or travel authorization. Cash advances do not use templates.
Projects is using types are R and C.
C=Contract E=Expense Report R=Standard T=Travel Authorization Default Value: R |
| 9 | RATE_PLAN_BASIS | Character(1) | VARCHAR2(1) NOT NULL |
Rate Plan Basis
A=All O=Original T=Target |
| 10 | SEQ_NUM_TO | Number(3,0) | SMALLINT NOT NULL | Sequence |