CA_WC_RT_VW

(SQL View)
 Index Back

Rates

To be used in Workcenter

SELECT DTL.CONTRACT_NUM , DTL.CONTRACT_LINE_NUM , EFFDT , EFF_STATUS , DTL.BUSINESS_UNIT_PC , PC_TEMPLATE_ID , RATE_PLAN , RATE_TMPL_OPTION FROM PS_CA_DETAIL DTL LEFT OUTER JOIN PS_CA_RATE RT ON RT.CONTRACT_NUM = DTL.CONTRACT_NUM AND RT.CONTRACT_LINE_NUM = DTL.CONTRACT_LINE_NUM WHERE DTL.PRICING_STRUCTURE = 'RATE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
3 EFFDT Date(10) DATE Effective Date
4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: SP_BU_PC_NONVW

6 PC_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rate Template ID
7 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.
8 RATE_TMPL_OPTION Character(4) VARCHAR2(4) NOT NULL Rate Option
CRTP=Contract Rate Plan
NSTD=Contract Rate Set
TMPL=Rate Set
URTP=Rate Plan