| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
HCSC_NOTIF_TRNS_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction ID for AD-Hoc Notification.
|
| 5 |
HCSC_DATE_POSTED |
Date(10) |
DATE |
Posting date for Ad-Hoc notification
|
| 6 |
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
|
| 7 |
HCSC_CATEGORY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Notification Category Name
|
| 8 |
HCSC_EONC_NOTIF_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Notification Name
|
| 9 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 10 |
HCSC_TRUNCATED_MSG |
Character(100) |
VARCHAR2(100) NOT NULL |
First 100 Character of Ad-Hoc notification message.
|
| 11 |
HCSC_EMAIL_TMPL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Email Template ID
|
| 12 |
HCSC_NOTIFY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify Individually
|
| 13 |
HCSC_NTF_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Notification Priority
0=Default
1=High
2=Medium
3=Low
|
| 14 |
HCSC_NOTIF_SENDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Notification Sender
1=User
2=System
3=Other
|
| 15 |
HCSC_NOTIF_EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
From Email Address
|
| 16 |
HCSC_NOTIF_SUBJECT |
Character(240) |
VARCHAR2(240) NOT NULL |
Message Subject
|
| 17 |
EMAIL_RTELONG |
Long Character |
CLOB |
Message Text
|
| 18 |
HCSC_EXPIRE_DATE |
Date(10) |
DATE |
Announcement Expiration Date for Adhoc Notification
|
| 19 |
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
|
| 20 |
HCSC_RECURR |
Character(1) |
VARCHAR2(1) NOT NULL |
Recurring Options
Y/N Table Edit
Default Value: N
|
| 21 |
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
Default Value: W
|
| 22 |
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
Default Value: 1
|
| 23 |
HCSC_MONTHDAY |
Character(2) |
VARCHAR2(2) NOT NULL |
Days of a month
Default Value: 01
|
| 24 |
HCSC_RECURR_END_DT |
Date(10) |
DATE |
Recurring end date
|
| 25 |
HCSC_LOG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Logging
E=Email
W=None
Default Value: W
|
| 26 |
HCSC_LOG_EXCP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Exceptions Only
Y/N Table Edit
|
| 27 |
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
|
| 28 |
HCSC_LAST_RUN_DATE |
Date(10) |
DATE |
Last run Date For Ad-Hoc Notification
|
| 29 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 30 |
SET_NOTIFY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Set Notify Flag
|
| 31 |
HCSC_PROCESSED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Processed Flag
Y/N Table Edit
|
| 32 |
HCSC_NOT_BIND_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bind Parameters
|