GPNL_ERNSRCH_VL

(SQL View)
 Index Back

Earning Search Lang

GP NLD -- Used as a LANG Search Record for earnings

SELECT V.COUNTRY , L1.PIN_NUM , L1.LANGUAGE_CD , L1.DESCR FROM PS_GP_PIN_LANG L1 , PS_GPNL_ERN_SRCH V WHERE L1.PIN_NUM = V.PIN_NUM AND V.COUNTRY = 'NLD'

  • Related Language Record for GPNL_ERN_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description