PY_GARN_CAL_LNG

(SQL View)
 Index Back

Garn Calculation routine promp

This view displays all the translate values for the deduction calculation routine used on the garn spec pages This is the related language view for PY_GARN_CALC_VW

SELECT A.FIELDVALUE , A.LANGUAGE_CD , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'GARN_DED_CALC' AND %EffdtCheck(PSXLATITEMLANG XL, A, %CurrentDateIn) AND A.FIELDVALUE IN ('M','P','R','G','H')

  • Related Language Record for PY_GARN_CALC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name