2.2.2 Care Giver

Caregivers are the medical staff who are responsible for patients during their hospital stay such as: nurses, residents or other clinicians. The caregivers are stored in the D_CAREGIVER table, and are uniquely identified by their care giver id (cgid). The caregivers table is related to many other tables such as medevents, noteevents and chartevents and is used to record the care giver who performed a particular operation, procedure or event. Figure 2.3 shows the inter table relationships of the caregivers table.

Figure 2.3: Caregivers table relationships. Although a simple table with only 2 columns, the caregivers table is related to many other tables in the database. Caregivers are assigned to inter alia medical events, problems and notes.