VisitDetail
- nhs_number
- 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
- RecordConnectionIdentifier
- admitted_from_concept_id
- admitted_from_source_value
- discharged_to_source_value
- discharged_to_concept_id
SusOPVisitDetail
Assumptions
Emergencycovers a visit to A&E within the given Hospital Provider, and hence covers Admission Code 21 and 24 onlyLocation ClassID 24 is a Consultant Clinic within the Health Care Provider.Patient ClassificationID 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 anInpatientvisit.- No calculations to be made between Start and end visit date to try to calculate 24 hours, but instead the
Patient Classificationwill be sufficient
Comment or raise an issue for this mapping.
SusCCMDSVisitDetail
Comment or raise an issue for this mapping.
SusAPCVisitDetail
Assumptions
Emergencycovers a visit to A&E within the given Hospital Provider, and hence covers Admission Code 21 and 24 onlyLocation ClassID 24 is a Consultant Clinic within the Health Care Provider.Patient ClassificationID 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 anInpatientvisit.- No calculations to be made between Start and end visit date to try to calculate 24 hours, but instead the
Patient Classificationwill be sufficient
Comment or raise an issue for this mapping.
SusAEVisitDetail
Assumptions
Emergencycovers a visit to A&E within the given Hospital Provider, and hence covers Admission Code 21 and 24 only
Comment or raise an issue for this mapping.
OxfordGPVisitDetails
