HCSC_NOTIF_SRC1(SQL View) |
Index Back |
|---|---|
Search Record for AdHoc NotifySearch record used by the Ad Hoc Notify and Announce component. |
| SELECT A.OPRID ,A.HCSC_NOTIF_TRNS_ID ,A.HCSC_NOTIF_DESCR ,A.HCSC_DATE_POSTED ,A.HCSC_DELIVERY_METH ,A.HCSC_NOTIF_SUBJECT ,A.HCSC_MSG_STATUS FROM PS_HCSC_NOTIF A UNION SELECT C1.ROLEUSER ,A1.HCSC_NOTIF_TRNS_ID ,A1.HCSC_NOTIF_DESCR ,A1.HCSC_DATE_POSTED ,A1.HCSC_DELIVERY_METH ,A1.HCSC_NOTIF_SUBJECT ,A1.HCSC_MSG_STATUS FROM PS_HCSC_NOTIF A1 , PS_HCSC_NTF_ACCESS B1 , PSROLEUSER C1 WHERE B1.ROLENAME = C1.ROLENAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | HCSC_NOTIF_TRNS_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Transaction ID for AD-Hoc Notification.
Default Value: 9999999999 |
| 3 | HCSC_NOTIF_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Notification Description |
| 4 | HCSC_DATE_POSTED |
Date(10) | DATE |
Posting date for Ad-Hoc notification
Default Value: %DATE |
| 5 | 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 |
| 6 | HCSC_NOTIF_SUBJECT | Character(240) | VARCHAR2(240) NOT NULL | Message Subject |
| 7 | HCSC_MSG_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Notification Message Status
D=Dismissed P=Published R=Ready To Send |