CA_PC_RP_VWC_LG

(SQL View)
 Index Back

Project Rate Plans Language

This view defines the Project Rate Plans Language

SELECT RPLAN.CONTRACT_NUM , RPLAN.CONTRACT_LINE_NUM , RPLAN.BUSINESS_UNIT , RPLAN.RATE_PLAN , EF.EFFDT , LANG.LANGUAGE_CD , LANG.DESCR FROM PS_PC_RATE_PLAN RPLAN , PS_PC_RATE_PLAN_EF EF , PS_PC_RATE_PLAN_LG LANG WHERE RPLAN.RATE_PLAN_TYPE = 'C' AND %Join(COMMON_KEYS, PC_RATE_PLAN RPLAN, PC_RATE_PLAN_LG LANG) AND %Join(COMMON_KEYS, PC_RATE_PLAN RPLAN, PC_RATE_PLAN_EF EF) AND EF.EFF_STATUS = 'A'

  • Related Language Record for CA_PC_RPLAN_VWC

    • # 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 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    4 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.
    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description