GPBR_WTX_LNG_VW

(SQL View)
 Index Back

Xlat Lang Vw for FGTS Incidenc

This view will be used to provide language translate table prompt values for FGTS Incidence field on Wage Types Table setup page.

SELECT A.FIELDNAME , A.FIELDVALUE , A.EFFDT , A.LANGUAGE_CD , A.XLATSHORTNAME , A.XLATLONGNAME FROM PSXLATITEMLANG A WHERE A.FIELDNAME = 'GPBR_FG_TYPE'

  • Related Language Record for GPBR_WT_XLAT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
    3 EFFDT Date(10) DATE Effective Date
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    6 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name