BUSINESS_UNITDefault Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW
RATE_PLANPrompt Table: PC_RATE_PLN_ALL
RATE_PLAN_TYPEC=Contract
R=Standard
Default Value: R
Prompt Table: CA_CNTR_OPEN_VW
Prompt Table: CA_DETAIL_VW1
PC_RATE_PLAN(SQL Table) |
Index Back |
|---|---|
Rate PlansThis record defines rate plans. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 2 | 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_PLN_ALL |
| 3 | 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 Default Value: R |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CNTR_OPEN_VW |
| 6 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL |
Contract Line Num
Prompt Table: CA_DETAIL_VW1 |