EOPCADSC_LGCSVW

(SQL View)
 Index Back

Composition Compare Display VW

ADS display view for ADS Workbench compare. View for Page Composer ADS display view for EOPCMAIN_LOGICL record.

SELECT MSG.MESSAGE_TEXT || ' ' || L1.SHORTNAME || '/' || L2.SHORTNAME || ': ' || D.EOPCDEFN_NAME || '/' || L.EOPCLOGICAL_NAME , L.EOPCDEFN_ID , L.EOPCMAIN_FIELD_HSH FROM PSDBFLDLABL L2 , PSDBFLDLABL L1 , PS_EOPCMAIN_LOGICL L , PS_EOPC_DEFN D , PSMSGCATDEFN 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

  • Related Language Record: EOPCADSC_LGCSLG

    • # 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