BUSINESS_UNITDefault Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW
RATE_PLAN_TYPEC=Contract
R=Standard
CONTRACT_NUMCONTRACT_LINE_NUMPC_TEMPLATE_IDPrompt Table: PC_RATE_SET
B=Billing
C=Cost
M=Cost / Billing
R=Revenue
PC_RATE_SET_CNT(SQL View) |
Index Back |
|---|---|
Contracts Rate Set ViewView consists of Rate Sets of template type = C |
| SELECT A.BUSINESS_UNIT , %Substring(A.TEMPLATE_TYPE, 1, 1) , A.CONTRACT_NUM , A.CONTRACT_LINE_NUM , A.PC_TEMPLATE_ID , A.RATE_DEF_TYPE , A.DESCR FROM PS_PC_RATE_HDR A WHERE A.TEMPLATE_TYPE = 'C' |
| # | 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_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 |
| 3 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 4 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 5 | PC_TEMPLATE_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Rate Template ID
Prompt Table: PC_RATE_SET |
| 6 | RATE_DEF_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Rate Definition Type
B=Billing C=Cost M=Cost / Billing R=Revenue |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |