EOPCADSC_FMTVW

(SQL View)
 Index Back

Format ADS Compare Display VW

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

SELECT L2.SHORTNAME || ' ' || L1.LONGNAME || ': ' || F.EOPCBIND_IDX , A.EOPCDEFN_ID , A.EOPCMAIN_ID , F.EOPCFORMAT_ID FROM PSDBFLDLABL L2 , PSDBFLDLABL 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'

  • Related Language Record: EOPCADSC_FMTLG

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