VisitDetail
- nhs_number
- RecordConnectionIdentifier
- HospitalProviderSpellNumber
- visit_detail_start_date
- visit_detail_start_datetime
- visit_detail_end_date
- visit_detail_end_datetime
- visit_detail_concept_id
- visit_detail_type_concept_id
- admitted_from_concept_id
- admitted_from_source_value
- discharged_to_concept_id
- discharged_to_source_value
CdsVisitDetail
Assumptions
Emergency
covers a visit to A&E within the given Hospital Provider, and hence covers Admission Code 21 and 24 onlyLocation 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 anInpatient
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