EOPCADSC_DEFNVW

(SQL View)
 Index Back

Definition Search View

EOPC_DEFN search view

SELECT MSG.MESSAGE_TEXT || ' ' || L1.SHORTNAME || ': ' || D.EOPCDEFN_NAME , D.EOPCDEFN_ID FROM PSDBFLDLABL L1 , PS_EOPC_DEFN D , PSMSGCATDEFN MSG WHERE L1.FIELDNAME = 'EOPCDEFN_NAME' AND L1.LABEL_ID = 'EOPCDEFN_NAME' AND MSG.MESSAGE_SET_NBR = 18111 AND MSG.MESSAGE_NBR = 30000

  • Related Language Record: EOPCADSC_DEFNLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOPCADS_DESCR254 Character(254) VARCHAR2(254) NOT NULL Definitions
    2 EOPCDEFN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Definition ID