EONC_SRC_RES_VW

(SQL View)
 Index Back

EONC Search Result View

Notification Composer Search Result View

SELECT A.EONC_NOTIF_NAME , A.DESCR100 , A.EONC_NOTIF_CAT , A.EONC_AGC_CATEGORY , A.EONC_PTNOTIF_NAME , C.DESCR100 , A.EONC_PROCESS_NAME , D.EONC_PROC_DESCR , A.OBJECTOWNERID , A.EONC_PRIORITY , A.EONC_NOTIF_STATUS , B.EONC_PREF1 , B.EONC_PREF2 , B.EONC_PREF3 , B.EONC_PREF4 , B.EONC_PREF5 FROM ( ( PS_EONC_NOTFY_HDR A LEFT OUTER JOIN PS_PTPN_CAT_REG C ON C.PTPN_CATEGORY_NAME = A.EONC_PTNOTIF_NAME ) LEFT OUTER JOIN PS_EONC_PROC_TBL D ON D.EONC_PROCESS_NAME = A.EONC_PROCESS_NAME ) , PS_EONC_NOTFY_PREF B WHERE ( A.EONC_NOTIF_NAME = B.EONC_NOTIF_NAME AND A.EONC_DRAFT_STATUS <> 'Y' )

  • Related Language Record: EONC_SRC_RES_LW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EONC_NOTIF_NAME Character(50) VARCHAR2(50) NOT NULL Notification Name

    Prompt Table: EONC_NOTFY_HDR

    2 EONC_NOTIF_DESCR Character(100) VARCHAR2(100) NOT NULL Notification Event Description
    3 EONC_NOTIF_CAT Character(4) VARCHAR2(4) NOT NULL Notification Event Source (source of the notification): APPL - Application Code (default) AWE - Approvals Framework EOEN - Enterprise Objects Events and Notifications Framework AGC - Activity Guide Composer EOQF - Questionnaire Framework
    AGC=Activity Guide Composer
    APPL=Applications Notification
    AWE=Approval Workflow
    EOEN=EO Events & Notifications
    EOQF=Questionnaire Framework
    4 EONC_AGC_CATEGORY Character(15) VARCHAR2(15) NOT NULL Activity Guide Category

    Prompt Table: AGC_CAT_SRCH_VW

    5 PTPN_NOTIF_NAME Character(50) VARCHAR2(50) NOT NULL Notification Name

    Prompt Table: EONC_CAT_REG_VW

    6 EONC_PTNOTIF_DESCR Character(100) VARCHAR2(100) NOT NULL PTPN Notification description
    7 EONC_PROCESS_NAME Character(50) VARCHAR2(50) NOT NULL Business Process Name
    8 EONC_PROC_DESCR Character(100) VARCHAR2(100) NOT NULL Business Process Description
    9 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    10 EONC_PRIORITY Character(1) VARCHAR2(1) NOT NULL Notification priority.
    0=Medium
    1=High
    2=Low
    11 EONC_NOTIF_STATUS Character(1) VARCHAR2(1) NOT NULL Notification Status: A - Active, I - Inactive, D - Draft.
    A=Active
    D=Draft
    I=Inactive
    12 EONC_PREF1 Character(1) VARCHAR2(1) NOT NULL URL Configuration
    13 EONC_PREF2 Character(1) VARCHAR2(1) NOT NULL Use Event Mapping
    14 EONC_PREF3 Character(1) VARCHAR2(1) NOT NULL Define Recipients List
    15 EONC_PREF4 Character(1) VARCHAR2(1) NOT NULL Define Notification Name
    16 EONC_PREF5 Character(1) VARCHAR2(1) NOT NULL Override Default Handler