Events Table Data Mappings for PeopleSoft
- 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 | PeopleSoft Table | PeopleSoft Field Name | Notes | Description |
misCode |
| CCTC_EVENT_STG | CCTC_MIS_CD | SG 5.1.0 | The three-digit college code (e.g., 111). |
eventId | id | CCTC_EVENT_STG | CCTC_EVENT_ID | SG 5.1.0 | A unique identifier for each event. |
eventType | detail-type | CCTC_EVENT_STG | CCTC_EVENT_TYPE | SG 5.1.0 | The type of event (e.g., UPDATE_PROFILE' and 'FEDERATED_IDENTITY_LINK') |
eventPayload | detail | CCTC_EVENT_STG | CCTC_EVENT_PAYLOAD | SG 5.1.0 | The detailed information for the event, which is often structured as a JSON object. |
eventTimestamp | timestamp | CCTC_EVENT_STG | CCTC_EVENT_TS | SG 5.1.0 | The timestamp when the event occurred. |
sisEventId |
| CCTC_EVENT_STG |
| SG 5.1.0 | Identifier for the event in the college's SIS. |
tstmpSISProcessed |
| CCTC_EVENT_STG | STATUS_DTTM | SG 5.1.0 | Timestamp of when the event was processed by the college's SIS system. |
sisProcessedFlag |
| CCTC_EVENT_STG | STATUS_FLAG | SG 5.1.0 | A flag indicating whether the event has been processed in the SIS. |
sisProcessedNotes |
| CCTC_EVENT_STG | DESCRLONG_NOTES | SG 5.1.0 | Additional notes related to the event processing in the SIS. |
|
|
| LASTUPDOPRID |
| The default value is "CCTC” when a row is created, but this value should be updated to whichever operatorID the college's IT department changes it to, if desired. |
|
|
| LASTUPDDTTM |
| Last updated date/time |