HCSC_LOG_SUM_VW

(SQL View)
 Index Back

Notification Log Table

Notification Log Table to review the sent status

SELECT A.PROCESS_INSTANCE , A.HCSC_NOTIF_TRNS_ID , COUNT(*) , ( SELECT COUNT(*) FROM PS_HCSC_NLOG_TBL C1 WHERE C1.PROCESS_INSTANCE= A.PROCESS_INSTANCE AND C1.HCSC_NOTIF_TRNS_ID = A.HCSC_NOTIF_TRNS_ID AND C1.HCSC_NOTIF_SENT = 'Y'), ( SELECT COUNT(*) FROM PS_HCSC_NLOG_TBL C2 WHERE C2.PROCESS_INSTANCE= A.PROCESS_INSTANCE AND C2.HCSC_NOTIF_TRNS_ID = A.HCSC_NOTIF_TRNS_ID AND C2.HCSC_NOTIF_SENT = 'N') FROM PS_HCSC_NLOG_TBL A WHERE A.PROCESS_INSTANCE = ( SELECT MAX(C.PROCESS_INSTANCE) FROM PS_HCSC_NLOG_TBL C WHERE C.HCSC_NOTIF_TRNS_ID = A.HCSC_NOTIF_TRNS_ID) GROUP BY A.PROCESS_INSTANCE, A.HCSC_NOTIF_TRNS_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 HCSC_NOTIF_TRNS_ID Number(10,0) DECIMAL(10) NOT NULL Transaction ID for AD-Hoc Notification.
3 HCSC_LOG_COUNT Number(8,0) INTEGER NOT NULL Logged
4 HCSC_SENT_COUNT Number(8,0) INTEGER NOT NULL Sent
5 HCSC_FAIL_COUNT Number(8,0) INTEGER NOT NULL Failed