EOPCADSC_SRECVW

(SQL View)
 Index Back

SrcRec ADS Compare Display VW

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

SELECT R.RECDESCR || ': ' || R2.RECDESCR , A.EOPCDEFN_ID , A.EOPCMAIN_ID , S.EOPCAPP_SRCREC_ID FROM PSRECDEFN R2 , PSRECDEFN 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'

  • Related Language Record: EOPCADSC_SRECLG

    • # 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