EOPCADSC_LGCSLG

(SQL View)
 Index Back

EOPCADSC_LGCSVW language table

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

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

  • Related Language Record for EOPCADSC_LGCSVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOPCADS_DESCR254 Character(254) VARCHAR2(254) NOT NULL Compositions
    2 EOPCDEFN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Definition ID
    3 EOPCMAIN_FIELD_HSH Character(28) VARCHAR2(28) NOT NULL Composition Hash Key
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code