EONC_EOEN_VW (SQL View)	Index Back
EOEN Notifications Notifications for Events and Notifications Framework.

EONC_EOEN_VW

(SQL View)

EOEN Notifications

Notifications for Events and Notifications Framework.

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 = 'EOEN' 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

#	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