OPRIDHCSC_NOTIF_TRNS_IDDefault Value: 9999999999
HCSC_DATE_POSTEDDefault Value: %DATE
HCSC_ANN_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_NOTIF_SUBJECT FROM PS_HCSC_NOTIF_SRC1 A WHERE A.HCSC_DELIVERY_METH = 'A' AND A.HCSC_MSG_STATUS <> 'D' AND EXISTS ( SELECT 'X' FROM PS_HCSC_ANN_ACC_VW B WHERE B.OPRID = A.OPRID) |
| # | 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_NOTIF_SUBJECT | Character(240) | VARCHAR2(240) NOT NULL | Message Subject |