GP_PIN_SRCH_LNG

(SQL View)
 Index Back

Related Language-ElementSearch

This is the related language record for Element Search View.

SELECT D.OPRID , A.PIN_NUM , A.LANGUAGE_CD , C.DESCR , A.PIN_NM , A.DESCR FROM PS_GP_PIN_LANG A , PS_GP_PIN B , PS_GP_PIN_TYP_LANG C , PS_GP_OPR_RULE_PRF D WHERE A.PIN_NUM=B.PIN_NUM AND B.PIN_TYPE=C.PIN_TYPE AND A.LANGUAGE_CD=C.LANGUAGE_CD

  • Related Language Record for GP_PINTREE_SRCH GP_PIN_REN_SRCH GP_PIN_SRCH2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 PIN_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL PIN Type
    5 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description