EONC_XREF_VW

(SQL View)
 Index Back

Notification Events View

Notification Events View

SELECT A.EONC_APPL_NOTIF_ID , A.EONC_APP_NOT_DESCR , A.DATA_TYPE_CD , O.EONC_NOTIF_NAME , B.DESCR100 , B.EONC_NOTIF_CAT , X.XLATLONGNAME , 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 , PSXLATITEM X WHERE O.EONC_APPL_NOTIF_ID = A.EONC_APPL_NOTIF_ID AND B.EONC_NOTIF_NAME = O.EONC_NOTIF_NAME AND BP.EONC_PROCESS_NAME = B.EONC_PROCESS_NAME AND C.PTPN_CATEGORY_NAME = B.EONC_PTNOTIF_NAME AND X.FIELDNAME = 'EONC_NOTIF_CAT' AND X.FIELDVALUE = B.EONC_NOTIF_CAT AND X.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn)

  • Related Language Record: EONC_XREF_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 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N

    4 EONC_NOTIF_NAME Character(50) VARCHAR2(50) NOT NULL Notification Name

    Prompt Table: EONC_NOTIF_VW

    5 EONC_DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    6 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
    7 EONC_CAT_DESCR Character(30) VARCHAR2(30) NOT NULL Notification Category Description
    8 EONC_PROCESS_NAME Character(50) VARCHAR2(50) NOT NULL Business Process Name

    Prompt Table: EONC_PROC_TBL

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

    Prompt Table: PTPN_FUNCAT_DVW

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

    Y/N Table Edit

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