PC_VP_PLAN_VW

(SQL View)
 Index Back

Rate Plan View

View consists of Rate Plans

SELECT A.BUSINESS_UNIT , A.RATE_PLAN , A.RATE_PLAN_TYPE , A.DESCR , A.CONTRACT_NUM , A.CONTRACT_LINE_NUM FROM PS_PC_RATE_PLAN A WHERE EXISTS ( SELECT 'X' FROM PS_PC_RATE_PLAN_LN B , PS_PC_RATE C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RATE_PLAN = B.RATE_PLAN AND A.RATE_PLAN_TYPE = B.RATE_PLAN_TYPE AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PC_TEMPLATE_ID = C.PC_TEMPLATE_ID AND B.TEMPLATE_TYPE = C.TEMPLATE_TYPE AND C.TEMPLATE_TYPE IN ('R', 'C') AND C.EFF_STATUS = 'A' AND C.ENABLE_VARIANCE = 'Y')

  • Related Language Record: PC_VP_PLAN_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_VP Character(5) VARCHAR2(5) NOT NULL 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
    5 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    6 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num