EOPCADSC_SRECLG

(SQL View)
 Index Back

EOPCADSC_SRECVW language table

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

SELECT R.RECDESCR || ': ' || R2.RECDESCR , A.EOPCDEFN_ID , A.EOPCMAIN_ID , S.EOPCAPP_SRCREC_ID , R.LANGUAGE_CD FROM PSRECDEFNLANG R2 , PSRECDEFNLANG R , PS_EOPCAPP_SRC_REC S , PS_EOPCMAIN_DISP A WHERE S.EOPCMAIN_ID = A.EOPCMAIN_ID AND R2.RECNAME = S.RECNAME AND R.RECNAME = 'EOPCAPP_SRC_REC' AND R.LANGUAGE_CD = R2.LANGUAGE_CD

  • Related Language Record for EOPCADSC_SRECVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOPCADS_DESCR254 Character(254) VARCHAR2(254) NOT NULL Source Record
    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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code