HCSC_NOTIF_SRCH(SQL View) |
Index Back |
|---|---|
Search Record for AdHoc NotifySearch record used by the Ad Hoc Notify and Announce component. |
| SELECT DISTINCT A.OPRID ,A.HCSC_NOTIF_TRNS_ID ,A.HCSC_NOTIF_DESCR ,A.HCSC_DATE_POSTED ,A.HCSC_DELIVERY_METH ,B.XLATLONGNAME ,A.HCSC_NOTIF_SUBJECT FROM PS_HCSC_NOTIF_SRC1 A , PSXLATITEM B WHERE B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PSXLATITEM B_ED WHERE B.FIELDNAME = B_ED.FIELDNAME AND B.FIELDVALUE = B_ED.FIELDVALUE AND B_ED.EFFDT <= %CurrentDateIn) AND B.FIELDNAME = 'HCSC_DELIVERY_METH' AND A.HCSC_DELIVERY_METH = B.FIELDVALUE AND A.HCSC_DELIVERY_METH <> 'A' AND A.HCSC_MSG_STATUS <> 'D' |
| # | 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_DELIVERY_DESC | Character(50) | VARCHAR2(50) NOT NULL | Delivery method description. |
| 7 | HCSC_NOTIF_SUBJECT | Character(240) | VARCHAR2(240) NOT NULL | Message Subject |