EOPCADSC_FEVTLG

(SQL View)
 Index Back

EOPCADSC_FEVTVW language table

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

SELECT R.RECDESCR || ': ' || L.LONGNAME , A.EOPCDEFN_ID , A.EOPCMAIN_ID , S.EOPCAPP_SRCREC_ID , F.EOPCAPP_FLDEVNT_ID , L.LANGUAGE_CD FROM PSDBFLDLABL LB , PSDBFLDLABLLANG L , PS_EOPCAPP_FLDEVNT F , PS_EOPCAPP_SRC_REC S , PS_EOPCMAIN_DISP A , PSRECDEFNLANG R WHERE S.EOPCMAIN_ID = A.EOPCMAIN_ID AND F.EOPCMAIN_ID = S.EOPCMAIN_ID AND F.EOPCAPP_SRCREC_ID = S.EOPCAPP_SRCREC_ID AND LB.FIELDNAME = F.FIELDNAME AND LB.DEFAULT_LABEL = 1 AND LB.LABEL_ID = L.LABEL_ID AND R.RECNAME = 'EOPCAPP_FLDEVNT' AND L.LANGUAGE_CD = R.LANGUAGE_CD

  • Related Language Record for EOPCADSC_FEVTVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOPCADS_DESCR254 Character(254) VARCHAR2(254) NOT NULL Field Event
    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 EOPCAPP_SRCREC_ID Character(20) VARCHAR2(20) NOT NULL EOPC App Source Rec ID
    5 EOPCAPP_FLDEVNT_ID Character(20) VARCHAR2(20) NOT NULL EOPC Source Field Event ID
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code