CA_PC_RATE_VW2

(SQL View)
 Index Back

Proj Rate Set view

This view excludes Contract specific rate sets

SELECT RATE.BUSINESS_UNIT , RATE.PC_TEMPLATE_ID , RATE.EFFDT , RATE.EFF_STATUS , HDR.DESCR FROM PS_PC_RATE RATE , PS_PC_RATE_HDR HDR WHERE %Join(COMMON_KEYS, PC_RATE RATE, PC_RATE_HDR HDR) AND HDR.TEMPLATE_TYPE = 'R' AND RATE.EFF_STATUS = 'A'

  • Related Language Record: CA_PC_RT_VW2_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    2 PC_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rate Template ID
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFF_STATUS_CUST Character(1) VARCHAR2(1) NOT NULL Status as of Effective Date
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description