Get worksite history

References event_events.event_key. Entered every time a system event occurs. If this table gets large, it may need to be moved to a NOSQL db at some point.

Timestamp when the event was logged.

user.id of the user who created the event. This is usually the actor_id unless an administrator manually creates events.

The ID of the actor, if the actor is a database object. This is usually, but not necessarily, a reference to the user_id. The table reference is contained in actor_model. If the actor is not a database object (e.g., an external resource like a client or caller), then use actor_external_id and actor_external_resource to identify the actor.

A randomized version of actor_location, suitable for use on public maps.

A plain-text name from location_locations of the polygon in which the actor_location exists.

A randomized version of patient_location, suitable for use on public maps.

A plain-text name from location_locations of the polygon in which the patient_location exists.

A randomized version of recipient_location, suitable for use on public maps.

A plain-text name from location_locations of the polygon in which the recipient_location exists.