Unstructured secondary care data FHIR mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
No edit summary
No edit summary
Line 59: Line 59:
! scope="col" width="13%" |File field Name
! scope="col" width="13%" |File field Name
! scope="col" width="13%" |Field  
! scope="col" width="13%" |Field  
! scope="col" width="13%" |Data/Coding Type
! scope="col" width="20%" |FHIR
! scope="col" width="13%" |Table
! scope="col" width="13%" |Field
|-
| rowspan="12" |ORGREF
LOREF
organisation
encounter_location
|ID
FACILITY_SOURCE_ID
|LocationGuid
|Unique  ID
|Location::Id*
|location
|id
|-
|NURSE_UNIT_LOC_CD
AMBULATORY_LOC_CD
SURGERY_LOC_CD
BUILDING_LOC_CD
FACILITY_LOC_CD
FACILITY
|LocationName
|Location name
|Location::Name
|location
|name
|-
|END_EFFECTIVE_DT_TM
|CloseDate
|Close Date
|Location::primarycare-activeperiod-extension::ValuePeriod::End
| -
| -
|-
|FAX_NBR_TXT
|FaxNumber
|Fax number
|Location::contactPoint::fax  (use=work, system=fax)
| -
| -
|-
|EMAIL_TXT
|EmailAddress
|Email adress
|Location::contactPoint::email  (use=work, system=email)
| -
| -
|-
|PHONE_NBR_TXT
|PhoneNumber
|Phone number
|Location::contactPoint::phone  (use=work, system=phone)
| -
| -
|-
|ADDR_LINE1_TXT
|HouseNameFlatNumber
|Address  name/flat number
|Location::Address::Line
| -
| -
|-
|ADDR_LINE2_TXT
|NumberAndStreet
|Address street
|Location::Address::Line
| -
| -
|-
|ADDR_LINE3_TXT
|Village
|Address  village
|Location::Address::Line
| -
| -
|-
|ADDR_LINE4_TXT
CITY_TXT
|Town
|Address town
|Location::Address::City
| -
| -
|-
|COUNTY_CD
|County
|Address county
|Location::Address::District
| -
| -
|-
|POSTCODE_TXT
|Postcode
|Postcode
|Location::Address::PostalCode
|location
|Postcode
|}
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="5" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
!Organisation Data Files<span style="color:red;"> *</span>
! scope="col" width="13%" |File field Name
! scope="col" width="13%" |Field
! scope="col" width="13%" |Data/Coding Type
! scope="col" width="20%" |FHIR
! scope="col" width="13%" |Table
! scope="col" width="13%" |Field
|-
| rowspan="4" |
|
|
|
|
|
|
|-
|
|
|
|
|
|
|-
|
|
|
|
|
|
|-
|
|
|
|
|
|
|}
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="5" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
!Organisation Data Files<span style="color:red;"> *</span>
! scope="col" width="13%" |File field Name
! scope="col" width="13%" |Field
! scope="col" width="13%" |Data/Coding Type
! scope="col" width="13%" |Data/Coding Type
! scope="col" width="20%" |FHIR
! scope="col" width="20%" |FHIR
Line 95: Line 249:




<span style="color:red;"> &ast;</span> Example organisation data files only. File names can differ across different systems.
<span style="color:red;">&ast;</span> Example organisation data files only. File names can differ across different systems.

Revision as of 12:44, 14 November 2023

Organisation

Organisation

Publisher DDS Core Compass V2
Organisation Data Files * File field Name Field Data/Coding Type FHIR Table Field
ORGREF

LOREF

organisation

encounter_location

ORG_ID OrganisationGuid Unique ID Organization::Id* organization id
ORG_NAME_TXT OrganisationName Name of organisation Organization::name organization Name
NHS_ORG_ALIAS ODSCode ODS code Organization::Identifier::Value (use=official, system=ods-organization-code) organization ods_code
PARENT_NHS_ORG_ALIAS ParentOrganisationGuid Links to Organisation - Organisation - OrganisationGuid Organization::PartOf::Reference * organization parent_organization_id

Location

Publisher DDS Core Compass V2
Organisation Data Files * File field Name Field Data/Coding Type FHIR Table Field
ORGREF

LOREF

organisation

encounter_location

ID

FACILITY_SOURCE_ID

LocationGuid Unique ID Location::Id* location id
NURSE_UNIT_LOC_CD

AMBULATORY_LOC_CD SURGERY_LOC_CD BUILDING_LOC_CD FACILITY_LOC_CD FACILITY

LocationName Location name Location::Name location name
END_EFFECTIVE_DT_TM CloseDate Close Date Location::primarycare-activeperiod-extension::ValuePeriod::End - -
FAX_NBR_TXT FaxNumber Fax number Location::contactPoint::fax (use=work, system=fax) - -
EMAIL_TXT EmailAddress Email adress Location::contactPoint::email (use=work, system=email) - -
PHONE_NBR_TXT PhoneNumber Phone number Location::contactPoint::phone  (use=work, system=phone) - -
ADDR_LINE1_TXT HouseNameFlatNumber Address name/flat number Location::Address::Line - -
ADDR_LINE2_TXT NumberAndStreet Address street Location::Address::Line - -
ADDR_LINE3_TXT Village Address village Location::Address::Line - -
ADDR_LINE4_TXT

CITY_TXT

Town Address town Location::Address::City - -
COUNTY_CD County Address county Location::Address::District - -
POSTCODE_TXT Postcode Postcode Location::Address::PostalCode location Postcode
Publisher DDS Core Compass V2
Organisation Data Files * File field Name Field Data/Coding Type FHIR Table Field
Publisher DDS Core Compass V2
Organisation Data Files * File field Name Field Data/Coding Type FHIR Table Field


* Example organisation data files only. File names can differ across different systems.