EOPCADSC_FMTLG

(SQL View)
 Index Back

EOPCADSC_FMTVW language table

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

SELECT L2.SHORTNAME || ' ' || L1.LONGNAME || ': ' || F.EOPCBIND_IDX , A.EOPCDEFN_ID , A.EOPCMAIN_ID , F.EOPCFORMAT_ID , L1.LANGUAGE_CD FROM PSDBFLDLABLLANG L2 , PSDBFLDLABLLANG L1 , PS_EOPC_FORMAT F , PS_EOPCMAIN_DISP A WHERE F.EOPCMAIN_ID = A.EOPCMAIN_ID AND L1.FIELDNAME = 'COLUMNNUM' AND L1.LABEL_ID = 'COLUMN' AND L2.FIELDNAME = 'DESCR254' AND L2.LABEL_ID = 'EOPC_SECTION' AND L1.LANGUAGE_CD = L2.LANGUAGE_CD

  • Related Language Record for EOPCADSC_FMTVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOPCADS_DESCR254 Character(254) VARCHAR2(254) NOT NULL Section Columns
    2 EOPCDEFN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Definition ID
    3 EOPCMAIN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Section ID
    4 EOPCFORMAT_ID Character(20) VARCHAR2(20) NOT NULL EOPC Format ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code