Events Table Data Mappings for Colleague
More details can be found in the https://cccnext.jira.com/wiki/spaces/GLUEPD/pages/4162879498.
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. |