WCS_RULE_CD_LVW

(SQL View)
 Index Back

Job Change Rule Codes Lng View

Used to get job change rule codes from related language record.

SELECT %Substring(XLAT.FIELDVALUE, 1, 2) , XLAT.LANGUAGE_CD , XLAT.XLATLONGNAME FROM PSXLATITEMLANG XLAT WHERE XLAT.FIELDNAME = 'BUDGET_RULE_CD' AND XLAT.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PSXLATITEMLANG ED WHERE XLAT.FIELDNAME = ED.FIELDNAME AND XLAT.FIELDVALUE = ED.FIELDVALUE AND XLAT.LANGUAGE_CD = ED.LANGUAGE_CD AND ED.EFFDT <= %CurrentDateIn)

  • Related Language Record for WCS_RULE_CD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_RULE_CD Character(2) VARCHAR2(2) NOT NULL Job change types.
    01=Active to Inactive Status
    02=Currency Code
    03=Salary
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description