The tables below pertain to the Events Table and related data field mappings.
On This Page:
Events Table Data Fields Mapping - MSQL
For data field specifications, see the [TBD].
Data Element Name | Data Dictionary Friendly Name | College Adaptor | Type | Length | Fraud Report | Fraud Reports | Fraud Reports | 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 |
EventPayload Data Fields - MSQL
The table below specifies the fields delivered in the EventPayload field.