Events Table Data Mappings for Banner
More details can be found in the ID.me Verification Status in the Events Table.
Column headings in parentheses are to indicate what that field is called in the Apply Data Mater Crosswalk (CCCTC internal document).
College Adaptor Payload Field (College Adaptor Field Name) | Events Table Field | Banner Table | Banner Field Name | Notes | Description |
misCode |
| SZREVNT | SZREVNT_MIS_CODE | SG 5.1.0 | The three-digit college code (e.g., 111). |
eventId | id | SZREVNT | SZREVNT_EVENT_ID | SG 5.1.0 | A unique identifier for each event. |
eventType | detail-type | SZREVNT | SZREVNT_EVENT_TYPE | SG 5.1.0 | The type of event (e.g., UPDATE_PROFILE' and 'FEDERATED_IDENTITY_LINK') |
eventPayload | detail | SZREVNT | SZREVNT_EVENT_PAYLOAD | SG 5.1.0 | The detailed information for the event, which is often structured as a JSON object. |
eventTimestamp | timestamp | SZREVNT | SZREVNT_EVENT_TSTMP | SG 5.1.0 | The timestamp when the event occurred. |
sisEventId |
| SZREVNT | SZREVNT_SIS_EVENT_ID | SG 5.1.0 | Identifier for the event in the college's SIS. |
tstmpSISProcessed |
| SZREVNT | SZREVNT_SIS_TSTMP_PROC | SG 5.1.0 | Timestamp of when the event was processed by the college's SIS system. |
sisProcessedFlag |
| SZREVNT | SZREVNT_SIS_PROC_FLAG | SG 5.1.0 | A flag indicating whether the event has been processed in the SIS. |
sisProcessedNotes |
| SZREVNT | SZREVNT_SIS_PROC_NOTE | SG 5.1.0 | Additional notes related to the event processing in the SIS. |