| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HCSC_NOTIF_TRNS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction ID for AD-Hoc Notification.
Default Value: 9999999999
|
| 2 |
HCSC_TRUNCATED_MSG |
Character(100) |
VARCHAR2(100) NOT NULL |
First 100 Character of Ad-Hoc notification message.
|
| 3 |
HCSC_DATE_POSTED |
Date(10) |
DATE |
Posting date for Ad-Hoc notification
Default Value: %DATE
|
| 4 |
HCSC_NOTIF_DESCR |
Character(50) |
VARCHAR2(50) NOT NULL |
Notification Description
|
| 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
Default Value: A
|
| 6 |
HCSC_CATEGORY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Notification Category Name
Prompt Table:
HCSC_CAT_DVW
|
| 7 |
HCSC_EONC_NOTIF_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Notification Name
|
| 8 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 9 |
HCSC_EMAIL_TMPL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Email Template ID
Prompt Table:
HCSC_TMPL_S_VW
|
| 10 |
HCSC_NOTIFY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify Individually
Y/N Table Edit
Default Value: N
|
| 11 |
HCSC_NTF_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Notification Priority
0=Default
1=High
2=Medium
3=Low
Default Value: 0
|
| 12 |
HCSC_NOTIF_SENDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Notification Sender
1=User
2=System
3=Other
Default Value: 1
|
| 13 |
HCSC_NOTIF_EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
From Email Address
|
| 14 |
HCSC_NOTIF_SUBJECT |
Character(240) |
VARCHAR2(240) NOT NULL |
Message Subject
|
| 15 |
EMAIL_RTELONG |
Long Character |
CLOB |
Message Text
|
| 16 |
HCSC_EXPIRE_DATE |
Date(10) |
DATE |
Announcement Expiration Date for Adhoc Notification
|
| 17 |
HCSC_NOTIF_HIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for announcements. If the flag is turned on, a user will be able to hide an announcement on their home page.
Y/N Table Edit
Default Value: N
|
| 18 |
HCSC_RECURR |
Character(1) |
VARCHAR2(1) NOT NULL |
Recurring Options
Y/N Table Edit
Default Value: N
|
| 19 |
HCSC_FREQUENCY_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Recurring Frequency
D=Every Day
M=Every Month
OM=Every Other Month
OW=Every Other Week
W=Every Week
|
| 20 |
HCSC_WEEKDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Days of a week
1=1-Sunday
2=2-Monday
3=3-Tuesday
4=4-Wednesday
5=5-Thursday
6=6-Friday
7=7-Saturday
|
| 21 |
HCSC_MONTHDAY |
Character(2) |
VARCHAR2(2) NOT NULL |
Days of a month
|
| 22 |
HCSC_RECURR_END_DT |
Date(10) |
DATE |
Recurring end date
|
| 23 |
HCSC_LOG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Logging
E=Email
W=None
Default Value: W
|
| 24 |
HCSC_LOG_EXCP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Exceptions Only
Y/N Table Edit
Default Value: N
|
| 25 |
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
Default Value: N
|
| 26 |
HCSC_MSG_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Notification Message Status
D=Dismissed
P=Published
R=Ready To Send
Default Value: R
|
| 27 |
HCSC_LAST_RUN_DATE |
Date(10) |
DATE |
Last run Date For Ad-Hoc Notification
|
| 28 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 29 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|