CA_RATE_PLAN_VW (SQL View)	Index Back
Contract Rate Plans This view defines the Contract Rate Plans.

CA_RATE_PLAN_VW

(SQL View)

Contract Rate Plans

This view defines the Contract Rate Plans.

SELECT BUSINESS_UNIT , RATE_PLAN , RATE_PLAN_TYPE , DESCR FROM PS_PC_RATE_PLAN WHERE RATE_PLAN_TYPE = 'C'

Related Language Record: CA_RPLAN_VW_LG

# 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.

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

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	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.
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
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description