EOPCADSC_SKEYLG

(SQL View)
 Index Back

EOPCADSC_SKEYVW language table

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

SELECT R.RECDESCR || ': ' || L.LONGNAME , A.EOPCDEFN_ID , A.EOPCMAIN_ID , S.EOPCAPP_SRCREC_ID , K.EOPCAPP_KEYFLD_ID , L.LANGUAGE_CD FROM PSDBFLDLABL LB , PSDBFLDLABLLANG L , PSRECDEFNLANG R , PS_EOPCAPP_KEY_FLD K , PS_EOPCAPP_SRC_REC S , PS_EOPCMAIN_DISP A WHERE S.EOPCMAIN_ID = A.EOPCMAIN_ID AND K.EOPCMAIN_ID = S.EOPCMAIN_ID AND K.EOPCAPP_SRCREC_ID = S.EOPCAPP_SRCREC_ID AND LB.FIELDNAME = K.FIELDNAME AND LB.DEFAULT_LABEL = 1 AND LB.LABEL_ID = L.LABEL_ID AND R.RECNAME = 'EOPCAPP_KEY_FLD' AND L.LANGUAGE_CD = R.LANGUAGE_CD

  • Related Language Record for EOPCADSC_SKEYVW

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