EOPCADSC_FLDVW

(SQL View)
 Index Back

Field ADS Compare Display VW

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

SELECT L1.SHORTNAME || '/' || L2.SHORTNAME || ': ' || R.RECDESCR || '/' || L3.LONGNAME , F.EOPCMAIN_ID , F.EOPCFORMAT_ID , F.EOPCFIELD_ID FROM PSDBFLDLABL L3 , PSDBFLDLABL L2 , PSDBFLDLABL L1 , PSRECDEFN R , PS_EOPC_FIELD F WHERE R.RECNAME = F.RECNAME AND L3.FIELDNAME = F.FIELDNAME AND L3.DEFAULT_LABEL = 1 AND L2.FIELDNAME = 'FIELDNAME' AND L2.LABEL_ID = 'FIELDNAME' AND L1.FIELDNAME = 'RECNAME' AND L1.LABEL_ID = 'RECNAME'

  • Related Language Record: EOPCADSC_FLDLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOPCADS_DESCR254 Character(254) VARCHAR2(254) NOT NULL Section Fields
    2 EOPCMAIN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Section ID
    3 EOPCFORMAT_ID Character(20) VARCHAR2(20) NOT NULL EOPC Format ID
    4 EOPCFIELD_ID Character(20) VARCHAR2(20) NOT NULL EOPC Field ID