Vision GP Extract FHIR Mapping: Difference between revisions

From Voror_Wiki
Tags: Reverted Visual edit
Tags: Reverted Visual edit
Line 6: Line 6:
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#90A4AE" |Compass V2
!
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
Line 12: Line 11:
! scope="col" width="15%" |Table
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
!
|-
|-
|PID
|PID
Line 19: Line 17:
|patient
|patient
|id
|id
|
|+
|+
|-
|-
Line 26: Line 23:
|patient
|patient
|date_of_birth
|date_of_birth
|
|-
|-
| rowspan="3" |SEX
| rowspan="3" |SEX
Line 32: Line 28:
| rowspan="3" |patient
| rowspan="3" |patient
| rowspan="3" |gender_concept_id
| rowspan="3" |gender_concept_id
|
|-
|-
|
 
|-
|-
|
 
|-
|-
|POSTCODE
|POSTCODE
Line 42: Line 37:
|patient_address
|patient_address
|postcode
|postcode
|
|-
|-
| rowspan="7" |MARITAL_STATUS
| rowspan="7" |MARITAL_STATUS
Line 49: Line 43:
| rowspan="7" |core_concept_id
| rowspan="7" |core_concept_id
non_core_concept_id
non_core_concept_id
|
|-
|-
|
 
|-
|-
|
 
|-
|-
|
 
|-
|-
|
 
|-
|-
|
 
|-
|-
|
 
|-
|-
| rowspan="2" |GP_USUAL
| rowspan="2" |GP_USUAL
Line 68: Line 61:
| rowspan="2" | -
| rowspan="2" | -
| rowspan="2" | -
| rowspan="2" | -
|
|-
|-
|
 
|-
|-
| rowspan="6" |ACTIVE
| rowspan="6" |ACTIVE
Line 76: Line 68:
| rowspan="6" |episode_of_care
| rowspan="6" |episode_of_care
| rowspan="6" |registration_type_concept_id
| rowspan="6" |registration_type_concept_id
|
|-
|-
|
 
|-
|-
|
 
|-
|-
|
 
|-
|-
|
 
|-
|-
|
 
|-
|-
|REGISTERED_DATE
|REGISTERED_DATE
Line 95: Line 86:
|date_registered
|date_registered
start_date
start_date
|
|-
|-
|REMOVED_DATE
|REMOVED_DATE
Line 103: Line 93:
|date_registered_end
|date_registered_end
end_date
end_date
|
|-
|-
|DATE_OF_DEATH
|DATE_OF_DEATH
Line 109: Line 98:
|patient
|patient
|date_of_death
|date_of_death
|
|-
|-
|SURNAME
|SURNAME
Line 115: Line 103:
|patient
|patient
|last_name
|last_name
|
|-
|-
|FORENAME
|FORENAME
Line 121: Line 108:
|patient
|patient
|first_names
|first_names
|
|-
|-
|TITLE
|TITLE
Line 127: Line 113:
|patient
|patient
|title
|title
|
|-
|-
| rowspan="2" |NHS_NUMBER
| rowspan="2" |NHS_NUMBER
Line 133: Line 118:
| rowspan="2" |patient
| rowspan="2" |patient
| rowspan="2" |nhs_number
| rowspan="2" |nhs_number
|
|-
|-
|
 
|-
|-
|ADDRESS_1  
|ADDRESS_1  
Line 141: Line 125:
|patient_address
|patient_address
|address_line_1
|address_line_1
|
|-
|-
|ADDRESS_2
|ADDRESS_2
Line 147: Line 130:
|patient_address
|patient_address
|address_line_2
|address_line_2
|
|-
|-
|ADDRESS_3
|ADDRESS_3
Line 153: Line 135:
|patient_address
|patient_address
|address_line_3
|address_line_3
|
|-
|-
|ADDRESS_4
|ADDRESS_4
Line 159: Line 140:
|patient_address
|patient_address
|address_line_4
|address_line_4
|
|-
|-
|ADDRESS_5
|ADDRESS_5
Line 165: Line 145:
|patient_address
|patient_address
|city
|city
|
|-
|-
|PHONE_NUMBER
|PHONE_NUMBER
Line 171: Line 150:
|patient_contact
|patient_contact
|type_concept_id - value
|type_concept_id - value
|
|-
|-
|MOBILE_NUMBER
|MOBILE_NUMBER
Line 177: Line 155:
|patient_contact
|patient_contact
|type_concept_id - value
|type_concept_id - value
|
|-
|-
|EMAIL
|EMAIL
Line 183: Line 160:
|patient_contact
|patient_contact
|type_concept_id - value
|type_concept_id - value
|
|-
|-
|PRACT_NUMBER
|PRACT_NUMBER
Line 189: Line 165:
| -
| -
| -
| -
|
|-
|-
|SERVICE_ID
|SERVICE_ID
Line 195: Line 170:
|patient
|patient
|organization_id
|organization_id
|
|}
|}


Revision as of 11:52, 3 August 2023

To see the latest Compass V2 schema, please see Discovery Remote Subscriber Database Familiarisation#Data_Mapping

Patients

Publisher DDS Core Compass V2
Field Name FHIR Table Field
PID Patient::Id*

EpisodeOfCare::Id*

patient id
Collapse
DATE_OF_BIRTH Patient::BirthDate patient date_of_birth
SEX Patient::Gender patient gender_concept_id
POSTCODE Patient::Address::PostalCode patient_address postcode
MARITAL_STATUS Patient::Marital_Status::ValueCodeableconcept observation core_concept_id

non_core_concept_id

GP_USUAL EpisodeOfCare ::CareManager::Reference *

Patient::CareProvider::Reference *

- -
ACTIVE EpsisodeOfCare:: primarycare-patient-registration-type-extension::ValueCodeableConcept*** episode_of_care registration_type_concept_id
REGISTERED_DATE EpisodeOfCare ::Period::Start

Also used as part of the EpisodeOfCare Id

episode_of_care

registration_status_history

date_registered

start_date

REMOVED_DATE EpisodeOfCare ::Period::End episode_of_care

registration_status_history

date_registered_end

end_date

DATE_OF_DEATH Patient::Deceased patient date_of_death
SURNAME Patient::Name::Family patient last_name
FORENAME Patient::Name::Given patient first_names
TITLE Patient::Name::Prefix (use=official) patient title
NHS_NUMBER Patient::Identifier::Value (use=official, system=nhs-number) patient nhs_number
ADDRESS_1 Patient::Address::Line patient_address address_line_1
ADDRESS_2 Patient::Address::Line patient_address address_line_2
ADDRESS_3 Patient::Address::Line patient_address address_line_3
ADDRESS_4 Patient::Address::District patient_address address_line_4
ADDRESS_5 Patient::Address::City patient_address city
PHONE_NUMBER Patient::Telecom::Value (use=home, system=phone) patient_contact type_concept_id - value
MOBILE_NUMBER Patient::Telecom::Value (use=mobile, system=phone) patient_contact type_concept_id - value
EMAIL Patient::Telecom::Value (use=home, system=email) patient_contact type_concept_id - value
PRACT_NUMBER Patient::Identifier::Value (use=secondary, system=http://visionhealth.co.uk/identifier/patient-number) - -
SERVICE_ID EpisodeOfCare ::ManagingOrganization::Reference * patient organization_id

Encounters

Publisher DDS Core Compass V2
Field Name FHIR Table Field
Collapse

Journals

Publisher DDS Core Compass V2
Field Name FHIR Table Field
Collapse

Referrals

Publisher DDS Core Compass V2
Field Name FHIR Table Field
Collapse

Practice

Publisher DDS Core Compass V2
Field Name FHIR Table Field
Collapse

Staff

Publisher DDS Core Compass V2
Field Name FHIR Table Field
Collapse
Retrieved from ‘https://wiki.voror.co.uk/index.php?title=Vision_GP_Extract_FHIR_Mapping&oldid=6561’
Last modified
This page was last modified on 3 August 2023, at 11:52.