VisitOccurrence

• NhsNumber
• HospitalProviderSpellNumber
• visit_start_date
• visit_start_datetime
• visit_end_date
• visit_end_datetime
• visit_concept_id
• visit_type_concept_id
• admitted_from_concept_id
• admitted_from_source_value
• discharged_to_concept_id
• discharged_to_source_value
• RecordConnectionIdentifier

CdsVisitOccurrenceWithSpell

Assumptions

• Emergency covers a visit to A&E within the given Hospital Provider, and hence covers Admission Code 21 and 24 only
• Location Class ID 24 is a Consultant Clinic within the Health Care Provider.
• Patient Classification ID 1 is the only entry that covers 24 hours or more with the use of a bed, and whilst others may be a day/night only, they will be discounted because they are less than 24 hours. Also, maternity is also not taken as an Inpatient visit.
• No calculations to be made between Start and end visit date to try to calculate 24 hours, but instead the Patient Classification will be sufficient

Comment or raise an issue for this mapping.

CdsVisitOccurrenceWithoutSpell

Assumptions

• Emergency covers a visit to A&E within the given Hospital Provider, and hence covers Admission Code 21 and 24 only
• Location Class ID 24 is a Consultant Clinic within the Health Care Provider.
• Patient Classification ID 1 is the only entry that covers 24 hours or more with the use of a bed, and whilst others may be a day/night only, they will be discounted because they are less than 24 hours. Also, maternity is also not taken as an Inpatient visit.
• No calculations to be made between Start and end visit date to try to calculate 24 hours, but instead the Patient Classification will be sufficient

Comment or raise an issue for this mapping.