SCC_NTF_EVENT_H

(SQL Table)
Index Back

Event Notification - History

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 SCC_NTFEVT_REQ_ID Number(16,0) DECIMAL(16) NOT NULL Event Request ID
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 SCC_NTFEVT_STATUS Character(1) VARCHAR2(1) NOT NULL Event Status
R=Read Event
U=Unread Event
6 SCC_NTFEVT_STARTDT DateTime(26) TIMESTAMP Event Start Timestamp
7 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
8 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
9 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
10 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
11 SCC_NTFEVT_MESSAGE Long Character CLOB Event Message