EOPCADSC_DAPKLG

(SQL View)
 Index Back

EOPCADSC_DAPKVW Language table

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

SELECT L1.SHORTNAME || '/' || L2.SHORTNAME || ': ' || R.RECDESCR || '/' || L3.LONGNAME , K.EOPCDEFN_ID , K.EOPCDEFN_APPKEY_ID , L1.LANGUAGE_CD FROM PSDBFLDLABL LB , PSDBFLDLABLLANG L3 , PSDBFLDLABLLANG L2 , PSDBFLDLABLLANG L1 , PSRECDEFNLANG R , PS_EOPCDEFN_APPKEY K WHERE R.RECNAME = K.RECNAME AND L3.FIELDNAME = K.FIELDNAME AND LB.LABEL_ID = L3.LABEL_ID AND LB.DEFAULT_LABEL = 1 AND L2.FIELDNAME = 'FIELDNAME' AND L2.LABEL_ID = 'FIELDNAME' AND L1.FIELDNAME = 'RECNAME' AND L1.LABEL_ID = 'RECNAME' AND L1.LANGUAGE_CD = L2.LANGUAGE_CD AND L2.LANGUAGE_CD = L3.LANGUAGE_CD AND R.LANGUAGE_CD = L3.LANGUAGE_CD

  • Related Language Record for EOPCADSC_DAPKVW

    • # 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
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code