HIC Person

This describes the minimal data required in order to allow patients to be matched between sites.

Additional integrity rules:

• The CARE_SITE table must feature each hospital that is contributing data.
• Most (90 - 95% of) Person records must have all the standard identifiers.
• Every Visit Occurrence must be linked to a specific hospital or trust (as appropriate given the local trust practices).
• Every Visit Occurrence must be linked to one or more Visit Details.

This milestone requires the tables:

• PERSON - Records people
• DEATH - Records deaths
• LOCATION - For recording street addresses
• VISIT_OCCURRENCE - For recording hospital visits
• VISIT_DETAIL -
• CARE_SITE -
• OBSERVATION - For recording misc identifiers (nhs number, name, etc)

Excluded tables:

• PROVIDER - Records healthcare providers (physicians, nurses, midwives, etc.). Please, DO NOT include provider ids in the linked tables Person, Visit Occurrence and Observation. We will only plan to add this data if it is required by a project.