EOPCADSC_DEFNLG

(SQL View)
 Index Back

EOPCADSC_DEFNVW language table

ADS display view language table for ADS Workbench compare. langauge View for Page Composer ADS display view EOPCADSC_DEFNVW record.

SELECT MSG.MESSAGE_TEXT || ' ' || L1.SHORTNAME || ': ' || D.EOPCDEFN_NAME , D.EOPCDEFN_ID , L1.LANGUAGE_CD FROM PSDBFLDLABLLANG L1 , PS_EOPC_DEFN D , PSMSGCATLANG MSG WHERE L1.FIELDNAME = 'EOPCDEFN_NAME' AND L1.LABEL_ID = 'EOPCDEFN_NAME' AND MSG.MESSAGE_SET_NBR = 18111 AND MSG.MESSAGE_NBR = 30000 AND L1.LANGUAGE_CD = MSG.LANGUAGE_CD

  • Related Language Record for EOPCADSC_DEFNVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOPCADS_DESCR254 Character(254) VARCHAR2(254) NOT NULL Definitions
    2 EOPCDEFN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Definition ID
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code