HCSC_NOTIF_RCPT(SQL Table) |
Index Back |
---|---|
HR Notification Recipient ListRecipient 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. |