EONC_XREF_VW2 (SQL View)	Index Back
Notification Events View Notification Events View

EONC_XREF_VW2

(SQL View)

Notification Events View

SELECT A.EONC_APPL_NOTIF_ID , CASE WHEN EXISTS ( SELECT 'X' FROM PS_EONC_NOTIF_OVRD X WHERE X.EONC_APPL_NOTIF_ID = A.EONC_APPL_NOTIF_ID) THEN X.EONC_NOTIF_NAME ELSE A.EONC_NOTIF_NAME END AS EONC_NOTIF_NAME , CASE WHEN EXISTS ( SELECT 'X' FROM PS_EONC_NOTIF_OVRD X WHERE X.EONC_APPL_NOTIF_ID = A.EONC_APPL_NOTIF_ID) THEN 'Y' ELSE 'N' END FROM PS_EONC_NOTIF_XREF A LEFT OUTER JOIN PS_EONC_NOTIF_OVRD X ON X.EONC_APPL_NOTIF_ID = A.EONC_APPL_NOTIF_ID

# 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_NOTIF_NAME Character(50) VARCHAR2(50) NOT NULL Notification Name
Prompt Table: EONC_NOTIF_VW

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

#	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_NOTIF_NAME	Character(50)	VARCHAR2(50) NOT NULL	Notification Name Prompt Table: EONC_NOTIF_VW
3	EONC_OVRD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Override flag: Yes/No. N=No Y=Yes