EONC_APPL_VW

(SQL View)
 Index Back

Application Notifications

Notifications for Applications.

SELECT A.EONC_APPL_NOTIF_ID , A.EONC_APP_NOT_DESCR , O.EONC_NOTIF_NAME , B.DESCR100 , B.EONC_PRIORITY , B.EONC_NOTIF_STATUS , B.EONC_PROCESS_NAME , BP.EONC_PROC_DESCR , C.PTPN_CATEGORY_NAME , C.DESCR100 , C.PTPN_FUNC_CATEGORY , O.EONC_OVRD_FLG , B.OBJECTOWNERID FROM PS_EONC_XREF_VW2 O , PS_EONC_NOTIF_XREF A , PS_EONC_NOTFY_HDR B , PS_EONC_PROC_TBL BP , PS_PTPN_CAT_REG C WHERE O.EONC_APPL_NOTIF_ID = A.EONC_APPL_NOTIF_ID AND B.EONC_NOTIF_NAME = O.EONC_NOTIF_NAME AND B.EONC_NOTIF_CAT = 'APPL' AND B.EONC_NOTIF_STATUS = 'A' AND BP.EONC_PROCESS_NAME = B.EONC_PROCESS_NAME AND C.PTPN_CATEGORY_NAME = B.EONC_PTNOTIF_NAME

  • Related Language Record: EONC_APPL_LW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EONC_APPL_NOTIF_ID Character(50) VARCHAR2(50) NOT NULL Application Notification ID
    2 EONC_APP_NOT_DESCR Character(100) VARCHAR2(100) NOT NULL Application Notification Event Description
    3 EONC_NOTIF_NAME Character(50) VARCHAR2(50) NOT NULL Notification Name

    Prompt Table: EONC_NOTIF_VW

    4 EONC_DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    5 EONC_PRIORITY Character(1) VARCHAR2(1) NOT NULL Notification priority.
    0=Medium
    1=High
    2=Low
    6 EONC_NOTIF_STATUS Character(1) VARCHAR2(1) NOT NULL Notification Status: A - Active, I - Inactive, D - Draft.
    A=Active
    D=Draft
    I=Inactive
    7 EONC_PROCESS_NAME Character(50) VARCHAR2(50) NOT NULL Business Process Name

    Prompt Table: EONC_PROC_TBL

    8 EONC_PROC_DESCR Character(100) VARCHAR2(100) NOT NULL Business Process Description
    9 EONC_PTNOTIF_NAME Character(50) VARCHAR2(50) NOT NULL PeopleTools Notification Name
    10 EONC_PTNOTIF_DESCR Character(100) VARCHAR2(100) NOT NULL PTPN Notification description
    11 PTPN_FUNC_CATEGORY Character(30) VARCHAR2(30) NOT NULL Functional Category

    Prompt Table: PTPN_FUNCAT_DVW

    12 EONC_OVRD_FLG Character(1) VARCHAR2(1) NOT NULL Override flag: Yes/No.
    N=No
    Y=Yes

    Y/N Table Edit

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