PC_RATE_ST_LDEF

(SQL View)
 Index Back

Rate Set Definition

Related language view for PC_RATE_SET_DEF.

SELECT C.BUSINESS_UNIT , C.PC_TEMPLATE_ID , C.TEMPLATE_TYPE , A.LANGUAGE_CD , B.XLATLONGNAME , A.DESCR FROM PS_PC_RATE_HDR_LG A , PSXLATITEMLANG B , PS_PC_RATE_HDR C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PC_TEMPLATE_ID = C.PC_TEMPLATE_ID AND A.TEMPLATE_TYPE = C.TEMPLATE_TYPE AND B.FIELDNAME = 'RATE_DEF_TYPE' AND C.RATE_DEF_TYPE = B.FIELDVALUE AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PSXLATITEM D WHERE B.FIELDNAME = D.FIELDNAME AND B.FIELDVALUE = D.FIELDVALUE AND D.EFFDT <= %CurrentDateIn) AND A.LANGUAGE_CD = B.LANGUAGE_CD UNION SELECT E.BUSINESS_UNIT , E.PC_TEMPLATE_ID , E.TEMPLATE_TYPE , F.LANGUAGE_CD , F.XLATLONGNAME , E.DESCR FROM PS_PC_RATE_HDR E , PSXLATITEMLANG F WHERE F.FIELDNAME = 'RATE_DEF_TYPE' AND E.RATE_DEF_TYPE = F.FIELDVALUE AND F.EFFDT = ( SELECT MAX(G.EFFDT) FROM PSXLATITEMLANG G WHERE G.FIELDNAME = F.FIELDNAME AND G.FIELDVALUE = F.FIELDVALUE AND G.EFFDT <= %CurrentDateIn) AND NOT EXISTS ( SELECT 'X' FROM PS_PC_RATE_HDR_LG H WHERE F.FIELDNAME = 'RATE_DEF_TYPE' AND H.LANGUAGE_CD = F.LANGUAGE_CD) UNION SELECT K.BUSINESS_UNIT , K.PC_TEMPLATE_ID , K.TEMPLATE_TYPE , I.LANGUAGE_CD , J.XLATLONGNAME , I.DESCR FROM PS_PC_RATE_HDR_LG I , PSXLATITEM J , PS_PC_RATE_HDR K WHERE J.FIELDNAME = 'RATE_DEF_TYPE' AND K.RATE_DEF_TYPE = J.FIELDVALUE AND J.EFFDT = ( SELECT MAX(L.EFFDT) FROM PSXLATITEM L WHERE J.FIELDNAME = L.FIELDNAME AND J.FIELDVALUE = L.FIELDVALUE AND L.EFFDT <= %CurrentDateIn) AND NOT EXISTS ( SELECT 'X' FROM PSXLATITEMLANG M WHERE M.FIELDNAME = 'RATE_DEF_TYPE' AND K.RATE_DEF_TYPE = M.FIELDVALUE AND I.LANGUAGE_CD = M.LANGUAGE_CD)

  • Related Language Record for PC_RATE_SET_DEF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

    2 PC_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rate Template ID

    Prompt Table: PC_RATE_SET_ALL

    3 TEMPLATE_TYPE Character(3) VARCHAR2(3) NOT NULL Used to identify what document/transaction is associated with a particular template. This is a translate table field whose value is either expense sheet or travel authorization. Cash advances do not use templates. Projects is using types are R and C.
    C=Contract
    E=Expense Report
    R=Standard
    T=Travel Authorization
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description