HCSC_LOG_DTL_VW(SQL View) |
Index Back |
|---|---|
Notification Log TableNotification Log Table to review the sent status |
| SELECT PROCESS_INSTANCE , HCSC_NOTIF_TRNS_ID , HCSC_DELIVERY_METH , SET_NOTIFY_FLAG , USERID , ROLENAME , EMPLID , EMAILID , HCSC_NOTIF_BY_USER , HCSC_NOT_SENT_DTTM , HCSC_NOTIF_SENT , COMMENTS FROM PS_HCSC_NLOG_TBL |
| # | 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_DELIVERY_METH |
Character(1) | VARCHAR2(1) NOT NULL |
The delivery methods available for ad-hoc notifications and announcements.
A=Announcement B=Email and Announcement E=Email N=Notification N=In-App X=Email and Notification X=Email and In-App Y=Announcement and In-App Y=Announcement and Notification Z=All |
| 4 | HCSC_DISTRIB_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Distribution Type
B=Bcc C=Cc T=To |
| 5 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 6 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 7 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 8 | EMAILID |
Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 9 | HCSC_NOTIF_BY_USER | Character(30) | VARCHAR2(30) NOT NULL | Notified By User |
| 10 | HCSC_NOT_SENT_DTTM | DateTime(26) | TIMESTAMP | Notification Sent on |
| 11 | HCSC_NOTIF_SENT | Character(1) | VARCHAR2(1) NOT NULL |
Field to track if a notification has been sent.
Notification can be sent from the Ad Hoc Notifications page when posting date is current date at time of save.
Or,
It can be sent from the Process Ad Hoc Notifications run control if the posting date <= current date AND HCSC_NOTIF_SENT = N.
If the posting date = current date then update HCSC_NOTIF_SENT = Y, otherwise if the Process Ad Hoc notifications run control page processes announcements, then update HCSC_NOTIF_SENT flag to Y.
Y/N Table Edit |
| 12 | COMMENTS | Long Character | CLOB | Comment |