GPAR_PIN_NME_VL

(SQL View)
 Index Back

Additional elemento for PI

Additiional element for complements ARG

SELECT A.PIN_NUM , C.LANGUAGE_CD , C.PIN_NM , C.DESCR FROM PS_GP_PIN A ,PS_GP_ERN_DED B ,PS_GP_PIN_LANG C WHERE A.COUNTRY = 'ARG' AND A.PIN_TYPE = 'ER' AND A.PIN_NUM = B.PIN_NUM AND A.PIN_NUM = C.PIN_NUM AND B.EFFDT =( SELECT MAX(B_ED.EFFDT) FROM PS_GP_ERN_DED B_ED WHERE B_ED.PIN_NUM = B.PIN_NUM) AND A.OVRD_IND_PI = 'Y'

  • Related Language Record for GPAR_PIN_NME_VW

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