EONC_NOTIF_VW2

(SQL View)
 Index Back

Notification ID Prompt

Notification ID Prompt for the Notification Cross-reference table.

SELECT A.EONC_NOTIF_NAME , A.DESCR100 , A.EONC_NOTIF_CAT , X.XLATLONGNAME , A.EONC_PROCESS_NAME , P.EONC_PROC_DESCR , C.PTPN_CATEGORY_NAME , C.PTPN_FUNC_CATEGORY , A.OBJECTOWNERID FROM PS_EONC_NOTFY_HDR A , PS_EONC_PROC_TBL P , PS_PTPN_CAT_REG C , PSXLATITEM X WHERE P.EONC_PROCESS_NAME = A.EONC_PROCESS_NAME AND C.PTPN_CATEGORY_NAME = A.EONC_PTNOTIF_NAME AND X.FIELDNAME = 'EONC_NOTIF_CAT' AND X.FIELDVALUE = A.EONC_NOTIF_CAT AND X.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)

  • Related Language Record: EONC_NOTIF_LW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EONC_NOTIF_NAME Character(50) VARCHAR2(50) NOT NULL Notification Name
    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_CAT_DESCR Character(30) VARCHAR2(30) NOT NULL Notification Category Description
    5 EONC_PROCESS_NAME Character(50) VARCHAR2(50) NOT NULL Business Process Name

    Prompt Table: EONC_PROC_TBL

    6 EONC_PROC_DESCR Character(100) VARCHAR2(100) NOT NULL Business Process Description
    7 EONC_PTNOTIF_NAME Character(50) VARCHAR2(50) NOT NULL PeopleTools Notification Name

    Prompt Table: EONC_CAT_REG_VW

    8 PTPN_FUNC_CATEGORY Character(30) VARCHAR2(30) NOT NULL Functional Category

    Prompt Table: PTPN_FUNCAT_DVW

    9 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier