Data Model

Transactions:

_id: unique identifier per transaction, used as link

userId: ucb member/admin unique id

hoursSpent: amount of time a person spent at an event, self-reported

eventDuration: amount of time the event was scheduled for, set by admin. Will be the same as hoursSpent for ad-hoc

pendingEventName: ignore, internal pendingEventDescription: ignore, internal use pendingEventDate: ignore, internal use

imageId: ignore, internal use only

approvalType: who approves the event, limited to auto, super_admin, partner_admin

transactionDate: date when transaction document created, auto-generated

event.eventDate: date when event occurred, entered by user.

deleteInd: indicates a logical deletion. Ignore any records marked with "True"

eventId: ignore, internal use only

active: old, obsolete data field. ignore.

event.eventDuration: ignore, not relevant to any data analysis

partnerOrg: what organization user belongs too

event.institution: organization hosting the event. will be blank for most selfie events