HCSC_NOTIF_RCPT

(SQL Table)
Index Back

HR Notification Recipient List

Recipient list for each notification. SET_NOTIFY_FLAG = T (TO) SET_NOTIFY_FLAG = C (CC) SET_NOTIFY_FLAG = B (BCC) NOTIFY_TO = Recipient Code

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 SET_NOTIFY_FLAG Character(1) VARCHAR2(1) NOT NULL Set Notify Flag
4 NOTIFY_TO Long Character CLOB Notify To
5 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.