Events Table Data Mappings - MSQL

The tables below pertain to the Events Table and related data field mappings.

Events Table Data Fields Mapping - MSQL

For data field specifications, see the [TBD].

Data Element Name	Data Dictionary Friendly Name	College Adaptor Field Name	Type	Length	Fraud Report Table Name	Fraud Reports Column Name	Fraud Reports Column Type	Field Precision

Data Element Name	Data Dictionary Friendly Name	College Adaptor Field Name	Type	Length	Fraud Report Table Name	Fraud Reports Column Name	Fraud Reports Column Type	Field Precision
		misCode			SZREVNT	misCode	NVARCHAR(4)	4
id	event id	eventId			SZREVNT	eventId	NVARCHAR(32)	32
detail-type	event type	eventType	Text	32	SZREVNT	eventType	NVARCHAR(50)	50
detail	event payload	eventPayload	Text	50	SZREVNT	eventPayload	VARCHAR(MAX)	MAX
idme_confirmation_timestamp	event confirmation timestamp	eventTimestamp	Text	2000	SZREVNT	eventTimestamp	NVARCHAR(50)	50
		sisEventId	Date with UTC time	24	SZREVNT	sisEventId	BIGINT	38
		tstmpSISProcessed			SZREVNT	tstmpSISProcessed	DATETIME2	24
		sisProcessedFlag			SZREVNT	sisProcessedFlag	NVARCHAR(1 CHAR)	1
		sisProcessedNotes			SZREVNT	sisProcessedNotes	NVARCHAR(100 CHAR)	100

The table below specifies the fields delivered in the EventPayload field.