Versions Compared

Old Version 8

changes.mady.by.user John Schneider

Saved on

compared with

New Version Current

changes.mady.by.user Erik Nielsen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

Introduction

Excerpt

The eHealth Infrastructure performs the import of organizations information from Sundhedsvæsnets Organisationsregister (SOR) and KOMBIT Fælleskommunalt (FK) Organisation (formerly Støttesystemet Organisation (STS-ORG)) to the eHealth Infrastructure on a daily basis.

During the import new or updated information in SOR and FK Organisation is updated in the eHealth Infrastructure.

...

  1. The customers provide mapping as MS Excel files to the Systematic AO team, which then do trigger triggers the relationship being created.
    The customer provides organisation relationship file(s) containing mappings between KOMBIT STS Organization identifiers and SOR identifiers. This input is provided to an operation in the eHealth system by SRE. The operation will then process the file line-by-line and establish the relevant related-to relationships in the FHIR Organization resources.

  2. FUT Infrastructure automatically creates the relationship during import from FK Organisation if the SOR code is available in FK Organisation (will be in production Fall 2023).
    The Municipalities FK Organisation administrator registers the SOR kode in the FK Organisation system (as address of type SOR ID), and the FUT infrastructure will automatically create the relationship during import.

Table of Contents

...

eHealth Infrastructure imports from Sundhedsvæsnets Organisationsregister (SOR)

The eHealth Infrastructure import imports organization information from Sundhedsvæsnets Organisationsregister (SOR) every night approximately 1 hour after SOR publishes the daily data file.

See Automated Processing for when the import is performed.

The SOR data file contains all organizations in SOR. The data file is published at http://filer.nsi.dk/sor/data/sor/sorxml/v_2_0_0/Sor.zip and is used in all FUT environments (exttest, test002 (education), pre-prod, production).

Info

The import exclude excludes the organization tree below 'Sundhedsdatastyrelsen' (SOR Identifier 634491000016008), and all children found below the organization.

...

The import respects the address inheritance rules defined by SOR by copying the relevant addresses from parents if not available for the current organization.
The import does not copy other attributes and values from the parent, and the current organizations are imported as-is.

Data mapping from SOR data to FHIR Organization of profile ehealth-organization:

...

The following table explains how each of the attributes on the FHIR resource is mapped from the SOR data model.

ehealth-organization element

Source from SOR

Description

id

N/A

Generated by FHIR server

meta.*

N/A

Generated by FHIR server

implicitRules

N/A

text

N/A

contained

N/A

extension

N/A

ehealth-organization-relatedTo

N/A

modifierExtension

N/A

identifier[0].use

Always set to official

identifier[0].type

N/A

identifier[0].system

always set to 'urn:oid:1.2.208.176.1.1'

identifier[0].code

SorIdentifier

The SOR identifier is stored in eHealth Infrastructure

identifier[0].period.start

SorStatus.FirstFromDate

identifier[0].period.end

SorStatus.ToDate

identifier[0].assigner

N/A

active

Computed based on SorStatus.ToDate and SorStatus.FirstFromDate

Set to true when:

sor1:ToDate is not set or is in the future and sor1:FirstFromDate is not a future date.

Set to false when

sor1:ToDate is in the past or sor1:FirstFromDate is a future date.

We will be using FirstFromDate as this is the flag used in SOR to set organizations active - FromDate is set when other data on the organization changes.

type

EntityTypeIdentifier

name

EntityName

alias

Concatenation of entityName from the top of the tree down to and including the current entity.

Example: For SorIdentifier=914571000016002 with the name "KOL Klinik" the constructed alias will be:

"Region Midtjylland, Aarhus Universitetshospital, Lungesygdomme, Lungesygdomme Klinik, KOL Klinik"

cvrNumber

CVRNumberIdentifier

If the SOR organization has a CVR number

...

, it is stored

...

.

Only if available on the current SOR entity. (no inheritance)

Source

Always set to SOR.

See Organization Source - eHealth Infrastructure v3.0.0 (sundhed.dk)

partOf

Calculated from ParentSorIdentifier

Relationships defining the organization trees are reflected in the Organization.partOf element.

FHIR id for the parent organization according to the SOR hierarchy.

telecom[n].value

  • VirtualAddressInformation.EmailAddressIdentifier

  • VirtualAddressInformation.Website

  • VirtualAddressInformation.TelephoneNumberIdentifier

  • VirtualAddressInformation.FaxNumberIdentifier

telecom[n].system

Code calculated from

  • VirtualAddressInformation.EmailAddressIdentifier

  • VirtualAddressInformation.Website

  • VirtualAddressInformation.TelephoneNumberIdentifier

  • VirtualAddressInformation.FaxNumberIdentifier

Stored as ContactPoints

See https://hl7.org/fhir/R4/valueset-contact-point-system.html

If not present on the current element the VirtualAddressInformation is

...

inherited from the SOR parent.

address[n]

Two addresses will be stored in FHIR.

PostalAddressInformation

And either an

VisitingAddressInformation or ActivityAddressInformation

PostalAddressInformation is mapped to an address using type = 'postal'.

Then a prioritized select of VisitingAddressInformation, ActivityAddressInformation is stored with type = 'physical'

http://filer.sst.dk/sor/docs/sorxml/v_2_0_0/SorXmlDocumentationV2.html describes the inheritance of addresses in the SOR structure (translated to English):

  • If "HealthInstitution" doesn't have a "PostalAddressInformation" the address is inherited from the parent.

  • If "HealthInstitution" doesn't have a "VisitingAddresseInformation" the unit's "PostalAddressInformation" is used.

  • If "OrganizationalUnit" doesn't have a "PostalAddressInformation" the address is inherited from the parent (either a HI or OU).

  • If "OrganizationalUnit" doesn't have a "VisitingAddressInformation" the unit's "PostalAddressInformation" is used.

  • If "OrganizationalUnit" doesn't have an "AcvitivityAddressInformation" the unit's "VisitingAddressInformation" is used.

After applying the inheritance logic the values are copied to the FHIR model. Ie. addresses are not left blank in the FHIR model.

address[0].type

PostalAddressInformation is mapped to an FHIR address using type = 'postal'.

address[0].text

PostalAddressInformation.AdditionalAddressInformationText

address[1].type

Either a VisitingAddressInformation or ActivityAddressInformation stored with type = 'physical'

contact

N/A

Not created during import.

municipalityCode

PostalAddressInformation.MunicipalityCode

regionCode

PostalAddressInformation.RegionCode

providerIdentifier

ProviderIdentifier

Translates to the Danish 'Ydernummer'

specialty[n].specialty

PrioritizedEntitySpeciality.SpecialityIdentifier

specialty[n].primaryIndicator

PrioritizedEntitySpeciality.SpecialityPriorityIdentifier

The .primaryIndicator field is a Boolean. It is set true if the SpecialityPriorityIdentifier has the identifier 51000095001, otherwise it is set to false.

eHealth Infrastructure imports from KOMBIT Fælleskommunalt (FK) Organisation

The eHealth Infrastructure import imports organization information from the FK Organisation every night around midnightMidnight. Only

Info

For the import to be performed a Service Agreement in KOMBIT Serviceplatform must be established per municipality.

The import performs the following:

  • Process every municipality that has agreed to a Service Agreement (could be all 98 municipalities given they have a Service Agreement.Import and update information from each municipality individually)

    • For OrganisationEnhed to be imported

    they

    • either the OrganisationEnhed itself or one of its children (transitively) must have

    the

    • KLE code ‘29.70.10 Telesundhed' or '29.70.20 Telemedicin' assigned as Opgaver as either udførende or ansvarlig.

  • Import and update information from each municipality individually

eHealth Environment

type

Service Agreements in place

KOMBIT Environment imported from

FK Organisation Service

Production

For all municipalities

PROD

https://prod.serviceplatformen.dk/service/Organisation

Non-production (e.g. EXTTEST)

For fewer municipalities (at the time of writing)

TEST

https://exttest.serviceplatformen.dk/service/Organisation

Organization discovery

For each municipality, the synchronization import starts by searching

  1. Search for all OrganisationEnhed having the KLE code

...

  1. ‘29.70.10

...

  1. Telesundhed' or

...

  1. '29.70.20

...

  1. Telemedicin' assigned as Opgaver as either udførende or ansvarlig.

  2. For all found OrganisationEnhed their parent organizational tree is found using the RelationListe.Overordnet attributes.

  3. For OrganisationEnhed not having a RelationListe.Overordnet the RelationListe.Tilhoerer attribute will be used to retrieve the Organisation.

  4. Then the Virksomhed is referenced by the Organisation's RelationList.Virksomhed attribute will be retrieved.

  5. Lastly, the referenced addresses will be retrieved from the Adresser service and Danish Adresse Register (DAR).

  6. The found

...

  1. OrganisationEnhed resources are transformed into eHealth Organization resources and imported.

Info

Prior to FUT-I Release 2024.3, the FK Organisation object type Organisation was transformed and maintained as the top-level FHIR Organization in a municipal organization tree. With FUT-I Release 2024.3 these have been inactived (FHIR Organization.active = false).

Data mapping overview

Data mapping from FK Organisation objects to FHIR Organization of profile https://ehealth.sundhed.dk/fhir/StructureDefinition-ehealth-organization.html :

The

...

following table explains how each of the attributes on the FHIR resource is mapped from the FK Organisation data model

ehealth-organization element

FK Organisation Source

Comment

id

Generated by FHIR server

meta.*

Generated by FHIR server

implicitRules

N/A

language

N/A

text

N/A

contained

N/A

extension

N/A

relatedTo

Adresse resources with Rolle 'SOR-ID'

A relation to corresponding FHIR Organization with the given SOR Id is established.

Adresse resources with Rolle 'SOR-ID' a relationship to the related SOR-origin FHIR Organization is reflected in the Organization.relatedTo element.

modifierExtension

N/A

identifier[0].use

Always set to official

identifier[0].type

Not used

identifier[0].system

For FK Organisation always https://www.kombit.dk/sts/organisation

...

The OrganisationEnhed identifier is stored as an Organization.identifier with system 'https://www.kombit.dk/sts/organisation'.

...

The CVR Number defined on the Virksomhed is copied to all children in the organizational tree.

...

identifier[0].value

OrganisationEnhed
tns:ListResponse/orgenhed:ListOutput/orgenhed:FiltreretOejebliksbillede/orgenhed:ObjektType/sd:UUIDIdentifikator

identifier[0].period.start

OrganisationEnhed
tns:ListResponse/orgenhed:ListOutput/orgenhed:FiltreretOejebliksbillede/orgenhed:Registrering/orgenhed:TilstandListe/orgfaelles:Gyldighed/sd:Virkning/sd:FraTidspunkt

identifier[0].period.end

If OrganisationEnhed
tns:ListResponse/orgenhed:ListOutput/orgenhed:FiltreretOejebliksbillede/orgenhed:Registrering/orgenhed:TilstandListe/orgfaelles:Gyldighed/sd:Virkning/sd:TilTidspunkt

identifier[0].assigner

Not used

type

OrganisationEnhed 

See https://ehealth.sundhed.dk/fhir/CodeSystem-ehealth-oio-organization-type.html

active

OrganisationEnhed
tns:ListResponse/orgenhed:ListOutput/orgenhed:FiltreretOejebliksbillede/orgenhed:Registrering/orgenhed:TilstandListe/orgfaelles:Gyldighed/orgfaelles:GyldighedStatusKode

Has to be Aktiv for active to be true.

If value is “Inaktiv”, then active is set to false.

name

OrganisationEnhed
tns:ListResponse/orgenhed:ListOutput/orgenhed:FiltreretOejebliksbillede/orgenhed:Registrering/orgenhed:AttributListe/orgenhed:Egenskab/sd:EnhedNavn

alias

Concatenation of 'name' from the top of the tree down to and including the current entity.

partOf

OrganisationEnhed.Overordnet
Target:  tns:ListResponse/orgenhed:ListOutput/orgenhed:FiltreretOejebliksbillede/orgenhed:Registrering/orgenhed:RelationListe/sd:Overordnet/sd:ReferenceID/sd:UUIDIdentifikator (translated to a FHIR Organization reference)

.. or if Overordnet is not set:

OrganisationEnhed.Tilhoerer
Target: tns:ListResponse/orgenhed:ListOutput/orgenhed:FiltreretOejebliksbillede/orgenhed:Registrering/orgenhed:RelationListe/sd:Tilhoerer/sd:ReferenceID/sd:UUIDIdentifikator (translated to a FHIR Organization reference)

Relationships defined in the organization trees from FK Organisation are reflected in the Organization.partOf element.

...

Root OrganisationEnhed will have no partOf.

FHIR id for the parent organization according to the OIO hierarchy.

address[0]

The first found entry in ../x:Registrering/x:RelationListe/x:Adresser with the Rolle = 'Postadresse' is mapped to a FHIR Address.

Address: Adresse resources with Rolle '

...

Postadresse' are stored as Organization.address.

address[0].use

Always "work"

In case of a STS ORG Adresse

address[0].type

Always "postal"

In case of a STS ORG Adresse

address[0].text

From Adresse service

../x:Registrering/x:AttributListe/x:Egenskab/x:AdresseTekst

In case of a STS ORG Adresse

address[0].period.start

From Organisation|OrganisationEnhed service

../x:Registrering/x:RelationList/x:Adresser/x:Virkning/x:FraTidspunkt/x:TidsstempelDatoTid

In case of a STS ORG Adresse

address[0].period.end

From Organisation|OrganisationEnhed service

../x:Registrering/x:RelationList/x:Adresser/x:Virkning/x:TilTidspunkt/x:TidsstempelDatoTid

In case of a STS ORG Adresse

address[0].use

Always "work"

In case of a DAR address

address[0].type

Always "postal"

In case of a DAR address

address[0].line

adresse.adgangsadresse.vejstykke.navn adresse.adgangsadresse.husnr[, adresse.etage adresse.dør]

In case of a DAR address

address[0].city

adresse.adgangsadresse.postnummer.navn

In case of a DAR address

address[0].postalCode

adresse.adgangsadresse.postnummer.nr

In case of a DAR address

address[0].country

Always "DK"

In case of a DAR address

address[0].regionCode

adresse.adgangsadresse.region.kode

In case of a DAR address

address[0].municipalityCode

adresse.adgangsadresse.kommune.kode

In case of a DAR address

telecom[0]

The first found entries in ../x:Registrering/x:RelationListe/x:Adresser for each of the 'Telefon' and 'Email' roles is mapped to a FHIR telecom.

Telecom: Adresse resources with Rolle 'Email' or 'Telefon' are stored as ContactPoints under the organization.telecom element.

telecom[0].use

Always "work"

telecom[0].system

"phone" or "email" depending on the Rolle

telecom[0].value

From Adresse service

../x:Registrering/x:AttributListe/x:Egenskab/x:AdresseTekst

telecom[0].period.start

From Organisation|OrganisationEnhed service

..

...

Address: Adresse resources with Rolle 'Postadresse' are stored as Organization.address.

...

/x:Registrering/x:RelationList/x:Adresser/x:Virkning/x:FraTidspunkt/x:TidsstempelDatoTid

telecom[0].period.end

From Organisation|OrganisationEnhed service

../x:Registrering/x:RelationList/x:Adresser/x:Virkning/x:FraTidspunkt/x:TidsstempelDatoTid

contact

Not set by import

source

STS-ORG for an organisation imported from STS-ORG

cvrNumber

tns:ListResponse/virksomhed:ListOutput/virksomhed:FiltreretOejebliksbillede/virksomhed:Registrering/virksomhed:AttributListe/virksomhed:Egenskab/stsBrugervendtNoegleTekst.
 

The CVR Number defined on the Virksomhed is copied to all children in the organizational tree.

This CVR number is taken from the Organisation-associated Virksomheds object and applied to all OrganisationEnhed in the tree.

The top-level Organisation in a hierarchy is accessed with the "tilhører" relation in an OrganisationEnhed

regionCode

Not available in FK Org.

This information does not exist for address in OIO Organisation (Adresse).

RegionCode for addresses is read from DAR:  adresse.adgangsadresse.region.kode

municipalityCode

Not available in FK Org.

This information does not exist for address in OIO Organisation (Adresse).

Municipality code for addresses is read from DAR: adresse.adgangsadresse.kommune.kode

providerIdentifier

Not available in FK Org.

specialty

Not available in FK Org.

Note

In case the resolution of the Address and telecom fails, it is logged and processing continues. This leaves the Address and telecom unchanged.

...

Establish the relationship between the FHIR Organization and the SOR-imported counterpart

A relationship between the municipal FHIR Organization and the SOR-imported counterpart must be established.

This relationship can be established in two ways: 1)

  1. The customers provide mapping as MS Excel files to the Systematic AO team, which then

...

  1. triggers the relationship being created or

...

  2. FUT Infrastructure automatically creates the relationship during import from FK Organisation if the SOR code is available in FK Organisation.

FUT Infrastructure automatically

...

establish the relationship during import from FK Organisation

If the SOR code is available in the FK Organisation, the Municipalities FK Organisation administrator registers the SOR kode in the FK Organisation system (as address of type SOR ID), and the FUT infrastructure will automatically create the relationship during import.

The

...

Systematics AO team establishes the relationship from MS Excel files

...

provided by the customer

The customer provides organisation relationship file(s) containing mappings between KOMBIT STS Organization identifiers and SOR identifiers. The Systematic operation team will make the eHealth then process the file line-by-line and establish the relevant related-to relationships in the FHIR Organization resources.

...