EOPCADSC_DAPKVW

(SQL View)
 Index Back

Defn App Keys CompareDisplayVw

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

SELECT L1.SHORTNAME || '/' || L2.SHORTNAME || ': ' || R.RECDESCR || '/' || L3.LONGNAME , K.EOPCDEFN_ID , K.EOPCDEFN_APPKEY_ID FROM PSDBFLDLABL L3 , PSDBFLDLABL L2 , PSDBFLDLABL L1 , PSRECDEFN R , PS_EOPCDEFN_APPKEY K WHERE R.RECNAME = K.RECNAME AND L3.FIELDNAME = K.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_DAPKLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOPCADS_DESCR254 Character(254) VARCHAR2(254) NOT NULL Definition App Keys
    2 EOPCDEFN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Definition ID
    3 EOPCDEFN_APPKEY_ID Character(20) VARCHAR2(20) NOT NULL EOPC Defn App Key ID