PC_VP_CAT_LVW

(SQL View)
 Index Back

Rate Set View

Language record for view consists of Rate Sets of template type = R and C

SELECT A.SETID , A.PC_RATE_CATEGORY , A.LANGUAGE_CD , A.DESCR FROM PS_PC_RATE_CAT_LG A WHERE A.EFFDT=( SELECT MAX(B.EFFDT) FROM PS_PC_RATE_CAT B WHERE A.SETID=B.SETID AND A.PC_RATE_CATEGORY = B.PC_RATE_CATEGORY AND B.EFF_STATUS = 'A') AND EXISTS ( SELECT 'X' FROM PS_PC_RATE_HDR C , PS_PC_RATE D WHERE C.BUSINESS_UNIT = D.BUSINESS_UNIT AND C.PC_TEMPLATE_ID = D.PC_TEMPLATE_ID AND C.TEMPLATE_TYPE = D.TEMPLATE_TYPE AND C.TEMPLATE_TYPE IN ('R', 'C') AND A.PC_RATE_CATEGORY = C.PC_RATE_CATEGORY AND D.EFF_STATUS = 'A' AND D.ENABLE_VARIANCE = 'Y')

  • Related Language Record for PC_VP_CAT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PC_RATE_CATEGORY Character(15) VARCHAR2(15) NOT NULL Rate Set Category

    Prompt Table: PC_RATE_CAT_VW2
    Set Control Field: BUSINESS_UNIT

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