Events Table Data Mappings - MSQL
Events Table Data Fields Mapping - MSQL
More details can be found in the Identity Verification Status in the Events Table.
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 |
timestamp | Event 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 |