Events Table Data Mappings for Colleague
- Ben Moore
Analytics
More details can be found 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 | Colleague Table | Colleague Field Name | Notes | Description |
misCode |
| XCTC.EBUS.EVENT |
| SG 5.1.0 | The three-digit college code (e.g., 111). |
eventId | id | XCTC.EBUS.EVENT | Event Id | SG 5.1.0 | A unique identifier for each event. |
eventType | detail-type | XCTC.EBUS.EVENT | Event Detail Type | SG 5.1.0 | The type of event (e.g., UPDATE_PROFILE' and 'FEDERATED_IDENTITY_LINK') |
eventPayload | detail | XCTC.EBUS.EVENT | Event Payload | SG 5.1.0 | The detailed information for the event, which is often structured as a JSON object. |
eventTimestamp | timestamp | XCTC.EBUS.EVENT | Event Timestamp | SG 5.1.0 | The timestamp when the event occurred. |
sisEventId |
| XCTC.EBUS.EVENT |
| SG 5.1.0 | Identifier for the event in the college's SIS. |
tstmpSISProcessed |
| XCTC.EBUS.EVENT |
| SG 5.1.0 | Timestamp of when the event was processed by the college's SIS system. |
sisProcessedFlag |
| XCTC.EBUS.EVENT |
| SG 5.1.0 | A flag indicating whether the event has been processed in the SIS. |
sisProcessedNotes |
| XCTC.EBUS.EVENT |
| SG 5.1.0 | Additional notes related to the event processing in the SIS. |