Overview

The UDP Event store's record is designed to facilitate common event query patterns. The UDP Event store record captures identifiers extracted from the event payload. Where possible, the UDP Event store record also captures the commonly modeled identifiers for the commonly modeled data in the UDP relational store. These identifiers align event data with already-commonly modeled relational data in the UDP and, hence, with the Unizin Common Data Model. The 'UCDM' identifiers for an event make it convenient to join event and relational warehouse data in the UDP.

Event record schema

The follow table describes the Event record schema for the UDP Event store.

Column	Description
id	The event UUID as generated by the Caliper sensor that emitted the event or, if no UUID was part of the event, as generated by the UDP Caliper endpoint.
type	The value of the Caliper 1.1 type, as required by the standard.
action	The value of the Caliper 1.1 action, as required by the standard.
event_time	The value of the Caliper 1.1 timestamp, as required by the standard.
ed_app	The value for the edApp attribute in the original event JSON.
course_offering_id	If available, the value for the Course offering identifier in the original event JSON.
actor_id	The value for the Actor identifier in the original event JSON.
event	The full JSON payload of the event. If it was eligible for enrichment, the full JSON payload will also include addition attributes in the extensions node of the JSON object.
store_time	The date and time when the event record was written to the event store.
ucdm_course_offering_id	The UCDM surrogate identifier for the Course offering. This identifier can be used to join event data with relational data in the Course table of the UCDM.
ucdm_actor_id	The UCDM surrogate identifier for the Person. This identifier can be used to join event data with relational data in the Person table of the UCDM.