search

hitontology / ontology

The Health IT Ontology.
https://hitontology.eu/
Creative Commons Zero v1.0 Universal
3 stars 2 forks source link

Delete Dickinson catalogue? #45

Closed KonradHoeffner closed 3 years ago

KonradHoeffner commented 3 years ago

Is https://hitontology.eu/ontology/Dickinson just a subset of https://hitontology.eu/ontology/EhrSfmFeatureCatalogue? Can we delete the Dickinson feature catalogue?

@vdornauer: Decide @KonradHoeffner: Implement

KonradHoeffner commented 3 years ago

Check how many references there are, if they can all be moved then move them and delete dickinson.

KonradHoeffner commented 3 years ago

Care: There may be many related entries in the database.

KonradHoeffner commented 3 years ago 
SELECT citation_suffix, classified_suffix
FROM citation_has_classified
JOIN classified
ON citation_has_classified.classified_suffix = classified.suffix
WHERE classified.catalogue_suffix = 'Dickinson'
KonradHoeffner commented 3 years ago

193 rows

citation_suffix classified_suffix
CIS1FeatSupportOfMedicationOrderingAndMedicationDocumentation ManageMedicationOrders
CIS1FeatSupportOfMedicationOrderingAndMedicationDocumentation ManageOrders
CIS1FeatSupportToManagevariousClinicalAndDiagnosticResults ManageResultsOfDiagnosticTests
CIS1FeatSupportOfWardOrganization ManageHealthcareResourceAvailabilityInformation
OpenMRSFeatCohortQuery MeasurementAnalysisResearchAndReports
OpenMRSFeatBuildReports ManageCareCoordinationAndReporting
OpenEMRFeatSOAP SupportClinicalDocumentation
OpenEMRFeatReferrals ManageOrdersForReferral
OpenDentalFeatTrackReferredTreatments ManageOrdersForReferral
nursingAnamnesis ManageClinicalHistory
predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm ManageOrders
toolsForQualityControl ManageResults
requestFormAssignedATimeslotRoomAndStaff SupportCareCoordinationAndReporting
nursingCarePlanningSupportedByPre-definedNursingCareStandards SupportForContextSensitiveCarePlansGuidelinesProtocols
safetyAlertsInRealTime SupportForMedicationInteractionAndAllergyChecking
predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm SupportOrders
real-timeVoiceCommunication SupportRemoteHealthcareServices
medication-specificOrderSet UseOrderSets
unit-specificOderSet UseOrderSets
planningView ManageCareCoordinationAndReporting
planningView ManageClinicalWorkflowTasking
requestFormAssignedATimeslotRoomAndStaff ManageClinicalWorkflowTasking
scheduling ManageClinicalWorkflowTasking
electronicMedicationAdministrationTool ManageMedicationAdministration
standardizedPrescriptionsAndMedicationProtocols ManageMedicationOrders
unit-specificOderSet ManageMedicationOrders
planningView ManageNonMedicationPatientCareOrders
requestFormAssignedATimeslotRoomAndStaff ManageNonMedicationPatientCareOrders
predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick ManageOrderSetTemplates
medication-specificOrderSet ManageOrders
patientRegistration ManageOrders
prescribeLonghand ManageOrders
computerizedOrderEntry MedicationOrderEfficiencies
medication-specificOrderSet MedicationOrderEfficiencies
predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick MedicationOrderEfficiencies
emailNotificationOfNewResults SupportForCommunicationBetweenOrganizations
medicationControlBasedOnNationalDrugDatabase SupportForMedicationInteractionAndAllergyChecking
medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown SupportForMedicationOrderingEfficiencies
unit-specificOderSet SupportForMedicationOrderingEfficiencies
predefinedOrderSentencesSearchableByCategoryQuickLists UseOrderSets
pointAndClickDataEntry ManageClinicalDocumentation
remindingAndDocumentationOfNursingTasks ManageClinicalHistory
supportingAllPhasesOfTheNursingProcess ManageClinicalWorkflowTasking
dataStorageRepository ManageHealthcareResourceAvailabilityInformation
predefinedOrderSentencesSearchableByCategoryQuickLists ManageOrders
readBarCodeLabel ManageOrders
allowingToReuseEarlierAnamnesticData ManagePatientHistory
capturingDataForAllPatientVisits ManagePatientHistory
warningsForDelayedReportingOfResults ManageResults
electronicMedicationAdministrationTool MedicationOrderEfficiencies
predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick SupportOrders
predefinedOrderSentencesSearchableByCategoryQuickLists SupportOrders
unit-specificOderSet SupportOrders
interactiveConsultationBetweenTwoOrMoreCenters SupportRemoteHealthcareServices
useOfClinicalPathways SupportforStandardCarePlansGuidelinesProtocols
predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm UseOrderSets
auditTrail Audit
creationOfDataRelationToTriage ManageCareCoordinationAndReporting
remindingAndDocumentationOfNursingTasks ManageClinicalWorkflowTasking
creationOfDataRelationToTriage ManageHealthcareResourceScheduling
planningView ManageOrders
patientRegistration ManageOrdersForDiagnositcScreeningTests
graphicalUserInterfaceToDocumentCare ManagePatientHistory
nursingAnamnesis ManageProblemList
forwardIntoArchive ManageResultsOfDiagnosticTests
possibilityToContinuePrescribingWhileSafetyAlert MedicationAlertOverrides
standardizedPrescriptionsAndMedicationProtocols MedicationOrderEfficiencies
automaticCreationOfANursingTransferReport ProduceASummaryRecordOfCare
dischargeSummaries ProduceASummaryRecordOfCare
mandatoryReporting SupportCareCoordinationAndReporting
supportNursingCarePlanningForCertainPatientCases SupportForPatientContextDrivenAssessments
mandatoryReporting ManageCareCoordinationAndReporting
capturingDataForAllPatientVisits ManageClinicalDocumentation
capturingDataForAllPatientVisits ManageClinicalHistory
computerizedOrderEntry ManageOrders
medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown ManageOrders
consolidatedListOfResultsForJurisdiction ManageResults
reportsOnTestsPerformed ManageResultsOfDiagnosticTests
safetyAlertsInRealTime MedicationAndAllergyInteractionChecking
creationOfDataRelationToTriage SupportCareCoordinationAndReporting
patientRegistration SupportForCommunicationBetweenOrganizations
predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick SupportForMedicationOrderingEfficiencies
supportNursingCarePlanningForCertainPatientCases SupportForStandardAssessments
safetyAlertsInCaseOfOverdosing SupportOfPatientSpecificDosingAndWarnings
supportNursingCarePlanningForCertainPatientCases SupportforStandardCarePlansGuidelinesProtocols
requestFormAssignedATimeslotRoomAndStaff ManageCareCoordinationAndReporting
patientManagementPlans ManageClinicalDocumentation
dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection ManageOrderSetTemplates
predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm ManageOrderSetTemplates
creationOfNursingCarePlans ManageOrders
electronicMedicationAdministrationTool ManageOrders
electronicSignature ManageRecordEntryAmendedCorrectedAndAugmentedState
forwardIntoArchive ManageResults
real-timeVoiceCommunication SupportForCommunicationBetweenOrganizations
nursingCarePlanningSupportedByPre-definedNursingCareStandards SupportForPatientContextDrivenAssessments
computerizedOrderEntry SupportOrders
predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick UseOrderSets
dataStorageRepository ManageClinicalDocumentation
medication-specificOrderSet ManageMedicationOrders
medication-specificOrderSet ManageOrderSetTemplates
predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick ManageOrders
automaticForwardedProcessedImages ManageOrdersForDiagnositcScreeningTests
readBarCodeLabel ManageOrdersForDiagnositcScreeningTests
anamnesisSupportedByOfferingFlexibleFormsForDataEntry ManageProblemList
visualizationOfSynchronizedDICOMImages ManageResults
visualizationOfSynchronizedDICOMImages ManageResultsOfDiagnosticTests
safetyAlertsInCaseOfDrug-drugInteractions MedicationAndAllergyInteractionChecking
automaticDataCollection MedicationOrderEfficiencies
safetyAlertsForAcceptedMedicationAreSeenByPharmacistsWhoCanContactPhysiciansOrNurses SupportForCommunicationBetweenOrganizations
safetyAlertsInCaseOfAllergies SupportForMedicationInteractionAndAllergyChecking
computerizedOrderEntry SupportForMedicationOrderingEfficiencies
triggeringTheCDSSToQueryTheTidalVolume SupportForMedicationOrderingEfficiencies
nursingCarePlanningSupportedByPre-definedNursingCareStandards SupportForStandardAssessments
creationOfNursingCarePlans SupportOrders
dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection SupportOrders
standardizedPrescriptionsAndMedicationProtocols SupportOrders
creationOfDataRelationToTriage SupportTriageCategorization
scheduling ManageAdministrativeTransactionProcessing
anamnesisSupportedByOfferingFlexibleFormsForDataEntry ManageClinicalHistory
medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown ManageHealthcareResourceAvailabilityInformation
predefinedOrderSentencesSearchableByCategoryQuickLists ManageOrderSetTemplates
requestFormAssignedATimeslotRoomAndStaff ManageOrders
medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown ManageResourceAvailability
automaticTransferOfLaboratoryData ManageResults
reportsOnTestsPerformed ManageResults
automaticForwardedProcessedImages ManageResultsOfDiagnosticTests
interactiveConsultationBetweenTwoOrMoreCenters ManageResultsOfDiagnosticTests
patientPageContainingDetailsOfAnySingleSample ManageResultsOfDiagnosticTests
patientPageContainingTheHistoryOfAllTestsPerformed ManageResultsOfDiagnosticTests
useOfInteractivePointersAndSpecificCalculationTools ManageResultsOfDiagnosticTests
unit-specificOderSet MedicationOrderEfficiencies
planningView SupportCareCoordinationAndReporting
interactiveConsultationBetweenTwoOrMoreCenters SupportForCommunicationBetweenOrganizations
electronicMedicationAdministrationTool SupportForMedicationOrderingEfficiencies
predefinedOrderSentencesSearchableByCategoryQuickLists SupportForMedicationOrderingEfficiencies
adaptionOfNursingCarePlansDuringCarePlanning SupportOrders
medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown SupportOrders
dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection UseOrderSets
medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown ManageMedicationOrders
dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection ManageOrders
warningsForDelayedReportingOfResults ManageResultsOfDiagnosticTests
safetyAlertsForAcceptedMedicationAreSeenByPharmacistsWhoCanContactPhysiciansOrNurses MedicationAlertOverrides
safetyAlertsInCaseOfAllergies MedicationAndAllergyInteractionChecking
dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection MedicationOrderEfficiencies
writingOfNursingLetters ProduceASummaryRecordOfCare
clinicalDocumentation ManageClinicalDocumentation
nursingDocumentationForms ManageClinicalDocumentation
standardizedPrescriptionsAndMedicationProtocols ManageOrders
unit-specificOderSet ManageOrders
wardManagement ManageResourceAvailability
interactiveConsultationBetweenTwoOrMoreCenters ManageResults
completeTestResults ManageResultsOfDiagnosticTests
medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown MedicationOrderEfficiencies
predefinedOrderSentencesSearchableByCategoryQuickLists MedicationOrderEfficiencies
predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm MedicationOrderEfficiencies
userDirectoryToControlAnyAccess RegistryAndDirectoryServices
nursingDiagnosisBasedOnTheNANDATaxonomy StandardTerminologyAndTerminologyServices
supportNursingCarePlanningForCertainPatientCases SupportForContextSensitiveCarePlansGuidelinesProtocols
dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection SupportForMedicationOrderingEfficiencies
standardizedPrescriptionsAndMedicationProtocols SupportForMedicationOrderingEfficiencies
safetyAlertsInRealTime SupportOfPatientSpecificDosingAndWarnings
medication-specificOrderSet SupportOrders
comprisingASetOfNursingCareStandards SupportforStandardCarePlansGuidelinesProtocols
standardizedPrescriptionsAndMedicationProtocols UseOrderSets
anamnesisSupportedByOfferingFlexibleFormsForDataEntry ManageClinicalDocumentation
graphicalUserInterfaceToDocumentCare ManageClinicalDocumentation
nursingAnamnesis ManageClinicalDocumentation
creationOfNursingCarePlans ManageClinicalWorkflowTasking
electronicMedicationAdministrationTool ManageMedicationImmunizationAndTreatmentAdministration
standardizedPrescriptionsAndMedicationProtocols ManageOrderSetTemplates
unit-specificOderSet ManageOrderSetTemplates
adaptionOfNursingCarePlansDuringCarePlanning ManageOrders
automaticForwardedProcessedImages ManageOrders
unit-specificOderSet ManageOrdersForDiagnositcScreeningTests
automaticForwardedProcessedImages ManageResults
completeTestResults ManageResults
patientPageContainingDetailsOfAnySingleSample ManageResults
patientPageContainingTheHistoryOfAllTestsPerformed ManageResults
useOfInteractivePointersAndSpecificCalculationTools ManageResults
automaticTransferOfLaboratoryData ManageResultsOfDiagnosticTests
consolidatedListOfResultsForJurisdiction ManageResultsOfDiagnosticTests
medicationControlBasedOnNationalDrugDatabase MedicationAndAllergyInteractionChecking
safetyAlertsInCaseOfDrug-drugInteractions SupportForMedicationInteractionAndAllergyChecking
automaticDataCollection SupportForMedicationOrderingEfficiencies
medication-specificOrderSet SupportForMedicationOrderingEfficiencies
predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm SupportForMedicationOrderingEfficiencies
medicationControlBasedOnNationalDrugDatabase SupportOfPatientSpecificDosingAndWarnings
offlineMode SupportRemoteHealthcareServices
nursingCarePlanningSupportedByPre-definedNursingCareStandards SupportforStandardCarePlansGuidelinesProtocols
AgfaRisElefanteFeatureSpeechRecognition ManageResults
AgfaRisElefanteFeatureSpeechRecognition SupportOrdersForDiagnosticScreeningTests
AgfaRisElefanteFeatureSpeechRecognition ManageResultsOfDiagnosticTests
AgfaRisElefanteFeatureSpeechRecognition SupportOrders
KonradHoeffner commented 3 years ago

With 193 citations, we really need to map the 49 classifieds of Dickinson. Let's try LIMES?

KonradHoeffner commented 3 years ago

LIMES 1.7.4 snapshot configuration file:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE LIMES SYSTEM "limes.dtd">
<LIMES>
    <PREFIX>
        <NAMESPACE>http://hitontology.eu/ontology/</NAMESPACE>
        <LABEL>hito</LABEL>
    </PREFIX>
    <PREFIX>
        <NAMESPACE>http://www.w3.org/1999/02/22-rdf-syntax-ns#</NAMESPACE>
        <LABEL>rdf</LABEL>
    </PREFIX>
    <PREFIX>
        <NAMESPACE>http://www.w3.org/2000/01/rdf-schema#</NAMESPACE>
        <LABEL>rdfs</LABEL>
    </PREFIX>
    <PREFIX>
        <NAMESPACE>http://www.w3.org/2002/07/owl#</NAMESPACE>
        <LABEL>owl</LABEL>
    </PREFIX>
    <PREFIX>
        <NAMESPACE>http://www.w3.org/2004/02/skos/core#</NAMESPACE>
        <LABEL>skos</LABEL>
    </PREFIX>

    <SOURCE>
        <ID>dickinson</ID>
        <ENDPOINT>../dickinson.ttl</ENDPOINT>
        <VAR>?di</VAR>
        <PAGESIZE>-1</PAGESIZE>
        <RESTRICTION>?di a hito:FeatureClassified; hito:featureCatalogue hito:Dickinson.</RESTRICTION>
        <PROPERTY>rdfs:label AS nolang->lowercase->regularalphabet RENAME label</PROPERTY>
        <TYPE>TURTLE</TYPE>
    </SOURCE>

    <TARGET>
        <ID></ID>
        <ENDPOINT>../hl7ehrsfm.ttl</ENDPOINT>
        <VAR>?ehr</VAR>
        <PAGESIZE>-1</PAGESIZE>
        <RESTRICTION>?ehr a hito:FeatureClassified; hito:featureCatalogue hito:EhrSfmFeatureCatalogue.</RESTRICTION>
        <PROPERTY>rdfs:label AS nolang->lowercase->regularalphabet RENAME label</PROPERTY>
        <TYPE>TURTLE</TYPE>
    </TARGET>

<METRIC>trigrams(di.label,ehr.label)</METRIC>

    <ACCEPTANCE>
        <THRESHOLD>0.7</THRESHOLD>
        <FILE>di-ehr-close.ttl</FILE>
        <RELATION>skos:closeMatch</RELATION>
    </ACCEPTANCE>

    <REVIEW>
        <THRESHOLD>0.2</THRESHOLD>
        <FILE>di-ehr-far.ttl</FILE>
        <RELATION>hito:farMatch</RELATION>
    </REVIEW>

    <EXECUTION>
        <REWRITER>default</REWRITER>
        <PLANNER>default</PLANNER>
        <ENGINE>default</ENGINE>
    </EXECUTION>

    <OUTPUT>CSV</OUTPUT>
</LIMES>
KonradHoeffner commented 3 years ago

Ergebnis in https://docs.google.com/spreadsheets/d/10atqHvwmf3EjxdM50IvHoUI856L3dzLCN-rhfw9Pm2I @MichelleBindel : Bitte existierende Mappings checken und neue manuell hinzufügen.

KonradHoeffner commented 3 years ago

Die Dickinson-Classifieds mit fehlenden Mappings sind:

Ich habe es heute versucht, selbst passenden Mapping-Kandidaten zu finden, da ich dachte, dass es ein Problem mit der Mapping-Konfiguration ist und die Labels einfach zu weit auseinander stehen aber tatsächlich finde ich überhaupt keine passenden Einträge dafür, ich glaube die existieren gar nicht im EHR-SFM. Vielleicht sind das Oberbegriffe, die im offiziellen EHR SFM nicht vorkommen?

Es wäre auf jeden Fall gut, das möglichst schnell zu mappen, da es dann vor dem Import aus der Datenbank erfolgen kann, ansonsten müssten wir das ja dann wieder neu anpassen.

VerenaDornauer commented 3 years ago
KonradHoeffner commented 3 years ago

Danke für die schnelle Antwort! Aber bist du sicher, dass man das 1:1 so mappen kann? Ich habe nämlich in dem Dickinson Dokument mal die Identifier herausgesucht und die gehören alle zu CP.4.x, was bei uns nicht im HL7 EHR SFM vorkommt:

Dickinson URI ID
ManageMedicationImmunizationAndTreatmentAdministration CP.6
ManageMedicationOrders CP.4.2
ManageNonMedicationPatientCareOrders CP.4.3
ManageOrdersForDiagnositcScreeningTests CP.4.4
ManageOrdersForReferral CP.4.6
MedicationAlertOverrides CP.4.2.4
MedicationAndAllergyInteractionChecking CP4.2.1
MedicationOrderEfficiencies CP.4.2.3
UseOrderSets CP.4.1

CPS gibt es im Dickinson auch nochmal separat. Wäre es auch möglich, diese Einträge dem EHR SFM (Zieldatensatz) hinzuzufügen oder soll ich trotzdem das Mapping von dir so für die Umbenennung benutzen?

VerenaDornauer commented 3 years ago

Moment ich bin dem Problem auf den Grund gegangen, in der Excel Tabelle, die ich dir für das EHR FM Model schickte war bei mir nicht alles aufgeklappt, deshalb fand ich sie bei mir auch nicht vorhin im Excel. Wenn du das auch nicht aufgeklappt hast vor dem Importieren als Feature Catalog in die Ontologie damals, dann ist klar, warum es fehlt im EHR FM.

Bitte sieh dir das Excel nochmal an, das ich dir initial schickte, und klappe alles auf - links über die Hierarchieebene. Einfach auf die "5" klicken, dann ist alles offen.

Dann kommen sie auch in unserem vor. Ggfs. EHR Functional Model vervollständigen wäre das zielführendste, denn dann ist alles da. Aber nicht händisch einspielen, sondern einfach Excel ganz aufklappen und fehlende Einträge in den EHR FM Feature Catalogue hinzufügen.

Ansonsten wegen Mappen Manage inkludiert auch Support, Support zeigt eher die Systemseite. Sozusagen die Mittel um zu Managen. Dennoch wäre das Vorgehen wie oben beschrieben sinnvoller, dann bleiben wir stringent und haben auch einen kompletten EHR FM Feature Catalogue! Danke!

KonradHoeffner commented 3 years ago

Ah, alles klar. Ich habe die Excel-Tabelle gar nicht geöffnet sondern in CSV konvertiert, vielleicht übernimmt er das dann nicht, ich sehe mir das gleich an und füge das hinzu. Oder vielleicht habe ich es direkt von LibreOffice kopiert und in das Google Sheet eingefügt. Beim Konvertieren sind die mit dabei also war es wohl copy&paste. Ich wusste gar nicht, dass man überhaupt Sachen zuklappen kann.

KonradHoeffner commented 3 years ago

OK, im LibreOffice lassen sich die versteckten Zeilen über STRG+A gefolgt von Format -> Rows -> Show anzeigen.

KonradHoeffner commented 3 years ago

Ich bin jetzt die ganze ursprüngliche Tabelle nochmal durchgegangen, um zu gucken, ob da noch mehr fehlt, aber es war glücklicherweise nur der Teil in den Zeilen 26-35 mit CP.4.1-CP.4.6. Damit konvertiere ich es jetzt neu und füge es zur Ontologie und Datenbank hinzu.

KonradHoeffner commented 3 years ago

CP.6 war auch noch nicht drin, da hatte ich ausversehen zweimal CPS.6 drin. Jetzt müsste es erstmal komplett sein.

KonradHoeffner commented 3 years ago

Prüfen, ob dickinson im Repository schon zitiert wird:

SELECT *
{
 ?classified a hito:FeatureClassified;
    hito:featureCatalogue hito:Dickinson.
 ?citation hito:featureClassified ?classified.
}
classified citation
Audit auditTrail
ManageAdministrativeTransactionProcessing admissionOverview
ManageAdministrativeTransactionProcessing agreementManagement
ManageAdministrativeTransactionProcessing dataReuseAndDataTransferForAccountingPurposesToTheAdministrationSubsystem
ManageAdministrativeTransactionProcessing exportFunctionToTheBillingSystem
ManageAdministrativeTransactionProcessing in-patientAdmissionsAndDischarges
ManageAdministrativeTransactionProcessing invoicingAndRegistrationOverview
ManageAdministrativeTransactionProcessing outpatientAppointements
ManageAdministrativeTransactionProcessing patientAdministration
ManageAdministrativeTransactionProcessing registrationOfInpatients
ManageAdministrativeTransactionProcessing scheduling
ManageCareCoordinationAndReporting creationOfDataRelationToTriage
ManageCareCoordinationAndReporting followingOfThePerioerpativeProcess
ManageCareCoordinationAndReporting informationAboutTheOperationActivity
ManageCareCoordinationAndReporting mandatoryReporting
ManageCareCoordinationAndReporting operationTheaterActivities
ManageCareCoordinationAndReporting planningSchedulingAndAnalysisOfOperations
ManageCareCoordinationAndReporting planningView
ManageCareCoordinationAndReporting requestFormAssignedATimeslotRoomAndStaff
ManageCareCoordinationAndReporting viewOfTheStatusOfPatientsInOperation
ManageClinicalDocumentation anamnesisSupportedByOfferingFlexibleFormsForDataEntry
ManageClinicalDocumentation capturingDataForAllPatientVisits
ManageClinicalDocumentation clinicalDocumentation
ManageClinicalDocumentation creationAndStorageOfNursingDiagnosesAndNursingOutcomes
ManageClinicalDocumentation dataStorageRepository
ManageClinicalDocumentation graphicalUserInterfaceToDocumentCare
ManageClinicalDocumentation integrationOfPatientSpecificData
ManageClinicalDocumentation nursingAnamnesis
ManageClinicalDocumentation nursingDocumentationForms
ManageClinicalDocumentation nursingEvaluation
ManageClinicalDocumentation patientManagementPlans
ManageClinicalDocumentation pointAndClickDataEntry
ManageClinicalDocumentation real-timeDataEntering
ManageClinicalHistory anamnesisSupportedByOfferingFlexibleFormsForDataEntry
ManageClinicalHistory capturingDataForAllPatientVisits
ManageClinicalHistory nursingAnamnesis
ManageClinicalHistory remindingAndDocumentationOfNursingTasks
ManageClinicalWorkflowTasking admissionOverview
ManageClinicalWorkflowTasking creationOfNursingCarePlans
ManageClinicalWorkflowTasking electronicPatientWorklist
ManageClinicalWorkflowTasking followingOfThePerioerpativeProcess
ManageClinicalWorkflowTasking informationAboutTheOperationActivity
ManageClinicalWorkflowTasking operatingRoomManagement
ManageClinicalWorkflowTasking operationTheaterActivities
ManageClinicalWorkflowTasking plannedActivities
ManageClinicalWorkflowTasking planningView
ManageClinicalWorkflowTasking remindingAndDocumentationOfNursingTasks
ManageClinicalWorkflowTasking requestFormAssignedATimeslotRoomAndStaff
ManageClinicalWorkflowTasking schedulingAndResourceAllocation
ManageClinicalWorkflowTasking supportingAllPhasesOfTheNursingProcess
ManageClinicalWorkflowTasking surgeryManagement
ManageClinicalWorkflowTasking viewOfTheStatusOfPatientsInOperation
ManageClinicalWorkflowTasking waitingListForTheFinalOperationSchedule
ManageClinicalWorkflowTasking scheduling
ManageCommunication plannedActivities
ManageCommunication simplifiedLanguage
ManageHealthcareResourceAvailabilityInformation dataStorageRepository
ManageHealthcareResourceAvailabilityInformation medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown
ManageHealthcareResourceScheduling creationOfDataRelationToTriage
ManageMedicationAdministration electronicMedicationAdministrationTool
ManageMedicationAdministration nurseAlteringIfPatientsMedicationIsOverdue
ManageMedicationAdministration scanBarCodesOnThePatientsWristband
ManageMedicationAdministration someWarningsCanNotBeOverridden
ManageMedicationImmunizationAndTreatmentAdministration electronicMedicationAdministrationTool
ManageMedicationImmunizationAndTreatmentAdministration nurseAlteringIfPatientsMedicationIsOverdue
ManageMedicationImmunizationAndTreatmentAdministration someWarningsCanNotBeOverridden
ManageMedicationOrders medication-specificOrderSet
ManageMedicationOrders medicationOrdersAppearOnThePatientsElectronicRecordOnceThePharmacistHasApprovedThem
ManageMedicationOrders medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown
ManageMedicationOrders nurseAlteringIfPatientsMedicationIsOverdue
ManageMedicationOrders standardizedPrescriptionsAndMedicationProtocols
ManageMedicationOrders unit-specificOderSet
ManageNonMedicationPatientCareOrders planningSchedulingAndAnalysisOfOperations
ManageNonMedicationPatientCareOrders planningView
ManageNonMedicationPatientCareOrders requestFormAssignedATimeslotRoomAndStaff
ManageNonMedicationPatientCareOrders retrievalOfAdministrativeData
ManageNonMedicationPatientCareOrders surgeryRequest
ManageOrderSetTemplates dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection
ManageOrderSetTemplates medication-specificOrderSet
ManageOrderSetTemplates predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick
ManageOrderSetTemplates predefinedOrderSentencesSearchableByCategoryQuickLists
ManageOrderSetTemplates predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm
ManageOrderSetTemplates standardizedPrescriptionsAndMedicationProtocols
ManageOrderSetTemplates unit-specificOderSet
ManageOrders adaptionOfNursingCarePlansDuringCarePlanning
ManageOrders alteringPrescribingHabitsByAlternativeDrugs
ManageOrders automaticAndPaperlessOperations
ManageOrders automaticForwardedProcessedImages
ManageOrders bedsideCPOEForOrdersBetweenPhysiciansAndNurses
ManageOrders bookingForm
ManageOrders bookingOfExaminations
ManageOrders computerizedOrderEntry
ManageOrders creationOfNursingCarePlans
ManageOrders dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection
ManageOrders electronicMedicationAdministrationTool
ManageOrders emergencyTesting
ManageOrders interfacedToTheRIS
ManageOrders medication-specificOrderSet
ManageOrders medicationOrdersAppearOnThePatientsElectronicRecordOnceThePharmacistHasApprovedThem
ManageOrders medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown
ManageOrders patientRegistration
ManageOrders planningSchedulingAndAnalysisOfOperations
ManageOrders planningView
ManageOrders predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick
ManageOrders predefinedOrderSentencesSearchableByCategoryQuickLists
ManageOrders predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm
ManageOrders prescribeLonghand
ManageOrders readBarCodeLabel
ManageOrders requestFormAssignedATimeslotRoomAndStaff
ManageOrders retrievalOfAdministrativeData
ManageOrders retrievalOfPatientRegisters
ManageOrders standardizedPrescriptionsAndMedicationProtocols
ManageOrders surgeryRequest
ManageOrders unit-specificOderSet
ManageOrdersForDiagnositcScreeningTests automaticAndPaperlessOperations
ManageOrdersForDiagnositcScreeningTests automaticForwardedProcessedImages
ManageOrdersForDiagnositcScreeningTests bookingOfExaminations
ManageOrdersForDiagnositcScreeningTests emergencyTesting
ManageOrdersForDiagnositcScreeningTests interfacedToTheRIS
ManageOrdersForDiagnositcScreeningTests patientRegistration
ManageOrdersForDiagnositcScreeningTests readBarCodeLabel
ManageOrdersForDiagnositcScreeningTests unit-specificOderSet
ManageOrdersForReferral consultationReferrals
ManagePatientHistory allowingToReuseEarlierAnamnesticData
ManagePatientHistory capturingDataForAllPatientVisits
ManagePatientHistory graphicalUserInterfaceToDocumentCare
ManageProblemList anamnesisSupportedByOfferingFlexibleFormsForDataEntry
ManageProblemList nursingAnamnesis
ManageProblemList nursingEvaluation
ManageRecordEntryAmendedCorrectedAndAugmentedState electronicSignature
ManageResourceAvailability bedManagement
ManageResourceAvailability medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown
ManageResourceAvailability schedulingAndResourceAllocation
ManageResourceAvailability wardManagement
ManageResults PACSInterface
ManageResults automaticAlignmentOfBaselineAndFollow-upCTA
ManageResults automaticAndPaperlessOperations
ManageResults automaticForwardedProcessedImages
ManageResults automaticSegmentationOfBaselineCTA
ManageResults automaticTransferOfLaboratoryData
ManageResults completeTestResults
ManageResults consolidatedListOfResultsForJurisdiction
ManageResults emergencyTesting
ManageResults forwardIntoArchive
ManageResults importInterfacesForLaboratoryMicrobiologyRadiologyReports
ManageResults interactiveConsultationBetweenTwoOrMoreCenters
ManageResults interfacedToTheRIS
ManageResults listToTrackTheStatusOfPendingSamples
ManageResults onlineDataAcquisitionOfCitalSignsFromVentilators
ManageResults onlineDataAcquisitionOfVitalSignsFromMonitoringDevices
ManageResults onlineDataAcquisitionOfVitalSignsFromOtherMedicalDevices
ManageResults patientPageContainingDetailsOfAnySingleSample
ManageResults patientPageContainingTheHistoryOfAllTestsPerformed
ManageResults reportsOnTestsPerformed
ManageResults semi-automaticAssessmentOfThoracicAortaDiameters
ManageResults speechRecognition
ManageResults supportForDigitalPhotography
ManageResults toolsForQualityControl
ManageResults useOfInteractivePointersAndSpecificCalculationTools
ManageResults visualizationOfDiameterProgression
ManageResults visualizationOfSynchronizedDICOMImages
ManageResults warningsForDelayedReportingOfResults
ManageResults pre-processing
ManageResultsOfDiagnosticTests automaticAlignmentOfBaselineAndFollow-upCTA
ManageResultsOfDiagnosticTests automaticAndPaperlessOperations
ManageResultsOfDiagnosticTests automaticForwardedProcessedImages
ManageResultsOfDiagnosticTests automaticSegmentationOfBaselineCTA
ManageResultsOfDiagnosticTests automaticTransferOfLaboratoryData
ManageResultsOfDiagnosticTests completeTestResults
ManageResultsOfDiagnosticTests consolidatedListOfResultsForJurisdiction
ManageResultsOfDiagnosticTests emergencyTesting
ManageResultsOfDiagnosticTests forwardIntoArchive
ManageResultsOfDiagnosticTests importInterfacesForLaboratoryMicrobiologyRadiologyReports
ManageResultsOfDiagnosticTests interactiveConsultationBetweenTwoOrMoreCenters
ManageResultsOfDiagnosticTests interfacedToTheRIS
ManageResultsOfDiagnosticTests listToTrackTheStatusOfPendingSamples
ManageResultsOfDiagnosticTests patientPageContainingDetailsOfAnySingleSample
ManageResultsOfDiagnosticTests patientPageContainingTheHistoryOfAllTestsPerformed
ManageResultsOfDiagnosticTests reportsOnTestsPerformed
ManageResultsOfDiagnosticTests semi-automaticAssessmentOfThoracicAortaDiameters
ManageResultsOfDiagnosticTests speechRecognition
ManageResultsOfDiagnosticTests supportForDigitalPhotography
ManageResultsOfDiagnosticTests useOfInteractivePointersAndSpecificCalculationTools
ManageResultsOfDiagnosticTests visualizationOfDiameterProgression
ManageResultsOfDiagnosticTests visualizationOfSynchronizedDICOMImages
ManageResultsOfDiagnosticTests warningsForDelayedReportingOfResults
ManageResultsOfDiagnosticTests pre-processing
MedicationAlertOverrides possibilityToContinuePrescribingWhileSafetyAlert
MedicationAlertOverrides safetyAlertsForAcceptedMedicationAreSeenByPharmacistsWhoCanContactPhysiciansOrNurses
MedicationAlertOverrides someWarningsCanNotBeOverridden
MedicationAndAllergyInteractionChecking displayOfWarningsWhenAppropiate
MedicationAndAllergyInteractionChecking medicationControlBasedOnNationalDrugDatabase
MedicationAndAllergyInteractionChecking medicationOrdersAppearOnThePatientsElectronicRecordOnceThePharmacistHasApprovedThem
MedicationAndAllergyInteractionChecking safetyAlertsInCaseOfAllergies
MedicationAndAllergyInteractionChecking safetyAlertsInCaseOfDrug-drugInteractions
MedicationAndAllergyInteractionChecking safetyAlertsInRealTime
MedicationOrderEfficiencies alteringPrescribingHabitsByAlternativeDrugs
MedicationOrderEfficiencies automaticDataCollection
MedicationOrderEfficiencies computerizedOrderEntry
MedicationOrderEfficiencies displayOfWarningsWhenAppropiate
MedicationOrderEfficiencies dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection
MedicationOrderEfficiencies drugDictionary
MedicationOrderEfficiencies electronicMedicationAdministrationTool
MedicationOrderEfficiencies medication-specificOrderSet
MedicationOrderEfficiencies medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown
MedicationOrderEfficiencies predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick
MedicationOrderEfficiencies predefinedOrderSentencesSearchableByCategoryQuickLists
MedicationOrderEfficiencies predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm
MedicationOrderEfficiencies standardizedPrescriptionsAndMedicationProtocols
MedicationOrderEfficiencies unit-specificOderSet
ProduceASummaryRecordOfCare automaticCreationOfANursingTransferReport
ProduceASummaryRecordOfCare dischargeSummaries
ProduceASummaryRecordOfCare writingOfNursingLetters
RegistryAndDirectoryServices userDirectoryToControlAnyAccess
StandardTerminologyAndTerminologyServices ICNPAsClassificationSystem
StandardTerminologyAndTerminologyServices automatedCodingSemi-automatedCodingOfDiagnosesAndProceduresFromPreviouslyDocumentedClinicalDataAccorddingToGermanDRG
StandardTerminologyAndTerminologyServices nursingDiagnosisBasedOnTheNANDATaxonomy
StandardTerminologyAndTerminologyServices retrievalOfTheNationalCodingSystemForDiagnosisAndMedicalProcedures
SupportCareCoordinationAndReporting creationOfDataRelationToTriage
SupportCareCoordinationAndReporting followingOfThePerioerpativeProcess
SupportCareCoordinationAndReporting informationAboutTheOperationActivity
SupportCareCoordinationAndReporting mandatoryReporting
SupportCareCoordinationAndReporting operationTheaterActivities
SupportCareCoordinationAndReporting planningSchedulingAndAnalysisOfOperations
SupportCareCoordinationAndReporting planningView
SupportCareCoordinationAndReporting requestFormAssignedATimeslotRoomAndStaff
SupportCareCoordinationAndReporting viewOfTheStatusOfPatientsInOperation
SupportForCommunicationBetweenOrganizations dataReuseAndDataTransferForAccountingPurposesToTheAdministrationSubsystem
SupportForCommunicationBetweenOrganizations emailNotificationOfNewResults
SupportForCommunicationBetweenOrganizations interactiveConsultationBetweenTwoOrMoreCenters
SupportForCommunicationBetweenOrganizations listToTrackTheStatusOfPendingSamples
SupportForCommunicationBetweenOrganizations outpatientAppointements
SupportForCommunicationBetweenOrganizations patientRegistration
SupportForCommunicationBetweenOrganizations real-timeVoiceCommunication
SupportForCommunicationBetweenOrganizations safetyAlertsForAcceptedMedicationAreSeenByPharmacistsWhoCanContactPhysiciansOrNurses
SupportForContextSensitiveCarePlansGuidelinesProtocols nursingCarePlanningSupportedByPre-definedNursingCareStandards
SupportForContextSensitiveCarePlansGuidelinesProtocols supportNursingCarePlanningForCertainPatientCases
SupportForMedicationInteractionAndAllergyChecking medicationControlBasedOnNationalDrugDatabase
SupportForMedicationInteractionAndAllergyChecking safetyAlertsInCaseOfAllergies
SupportForMedicationInteractionAndAllergyChecking safetyAlertsInCaseOfDrug-drugInteractions
SupportForMedicationInteractionAndAllergyChecking safetyAlertsInRealTime
SupportForMedicationOrderingEfficiencies automatedCalculationOfVentilationTimes
SupportForMedicationOrderingEfficiencies automaticDataCollection
SupportForMedicationOrderingEfficiencies bedsideCPOEForOrdersBetweenPhysiciansAndNurses
SupportForMedicationOrderingEfficiencies computerizedOrderEntry
SupportForMedicationOrderingEfficiencies dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection
SupportForMedicationOrderingEfficiencies electronicMedicationAdministrationTool
SupportForMedicationOrderingEfficiencies facilitatingCalculationsOfDrugDosesAndFluidBalances
SupportForMedicationOrderingEfficiencies medication-specificOrderSet
SupportForMedicationOrderingEfficiencies medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown
SupportForMedicationOrderingEfficiencies predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick
SupportForMedicationOrderingEfficiencies predefinedOrderSentencesSearchableByCategoryQuickLists
SupportForMedicationOrderingEfficiencies predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm
SupportForMedicationOrderingEfficiencies standardizedPrescriptionsAndMedicationProtocols
SupportForMedicationOrderingEfficiencies triggeringTheCDSSToQueryTheTidalVolume
SupportForMedicationOrderingEfficiencies unit-specificOderSet
SupportForMedicationRecommendations automatedCalculationOfVentilationTimes
SupportForMedicationRecommendations drugDictionary
SupportForPatientContextDrivenAssessments informationSourroundingPatientAgeAndGestationalAgeToGuideTowardAvailableOptions
SupportForPatientContextDrivenAssessments nursingCarePlanningSupportedByPre-definedNursingCareStandards
SupportForPatientContextDrivenAssessments reviewScreeningAndTestingOptions
SupportForPatientContextDrivenAssessments simplifiedLanguage
SupportForPatientContextDrivenAssessments supportNursingCarePlanningForCertainPatientCases
SupportForPatientContextDrivenAssessments translatedIntoSpanish
SupportForStandardAssessments nursingCarePlanningSupportedByPre-definedNursingCareStandards
SupportForStandardAssessments supportNursingCarePlanningForCertainPatientCases
SupportOfPatientSpecificDosingAndWarnings decisionsSupportFunctions
SupportOfPatientSpecificDosingAndWarnings displayOfWarningsWhenAppropiate
SupportOfPatientSpecificDosingAndWarnings drugDictionary
SupportOfPatientSpecificDosingAndWarnings facilitatingCalculationsOfDrugDosesAndFluidBalances
SupportOfPatientSpecificDosingAndWarnings medicationControlBasedOnNationalDrugDatabase
SupportOfPatientSpecificDosingAndWarnings recommendationPop-upWindow
SupportOfPatientSpecificDosingAndWarnings safetyAlertsInCaseOfOverdosing
SupportOfPatientSpecificDosingAndWarnings safetyAlertsInRealTime
SupportOfPatientSpecificDosingAndWarnings someWarningsCanNotBeOverridden
SupportOrders adaptionOfNursingCarePlansDuringCarePlanning
SupportOrders automatedCalculationOfVentilationTimes
SupportOrders automaticAndPaperlessOperations
SupportOrders bedsideCPOEForOrdersBetweenPhysiciansAndNurses
SupportOrders bookingForm
SupportOrders bookingOfExaminations
SupportOrders computerizedOrderEntry
SupportOrders creationOfNursingCarePlans
SupportOrders decisionsSupportFunctions
SupportOrders dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection
SupportOrders facilitatingCalculationsOfDrugDosesAndFluidBalances
SupportOrders medication-specificOrderSet
SupportOrders medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown
SupportOrders predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick
SupportOrders predefinedOrderSentencesSearchableByCategoryQuickLists
SupportOrders predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm
SupportOrders speechRecognition
SupportOrders standardizedPrescriptionsAndMedicationProtocols
SupportOrders unit-specificOderSet
SupportOrdersForDiagnosticScreeningTests automaticAndPaperlessOperations
SupportOrdersForDiagnosticScreeningTests bookingOfExaminations
SupportOrdersForDiagnosticScreeningTests reviewScreeningAndTestingOptions
SupportOrdersForDiagnosticScreeningTests speechRecognition
SupportRemoteHealthcareServices interactiveConsultationBetweenTwoOrMoreCenters
SupportRemoteHealthcareServices offlineMode
SupportRemoteHealthcareServices real-timeVoiceCommunication
SupportRemoteHealthcareServices tabletBasedApplication
SupportRemoteHealthcareServices app
SupportTriageCategorization creationOfDataRelationToTriage
SupportforStandardCarePlansGuidelinesProtocols comprisingASetOfNursingCareStandards
SupportforStandardCarePlansGuidelinesProtocols nursingCarePlanningSupportedByPre-definedNursingCareStandards
SupportforStandardCarePlansGuidelinesProtocols supportNursingCarePlanningForCertainPatientCases
SupportforStandardCarePlansGuidelinesProtocols useOfClinicalPathways
UseOrderSets dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection
UseOrderSets medication-specificOrderSet
UseOrderSets predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick
UseOrderSets predefinedOrderSentencesSearchableByCategoryQuickLists
UseOrderSets predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm
UseOrderSets standardizedPrescriptionsAndMedicationProtocols
UseOrderSets unit-specificOderSet
KonradHoeffner commented 3 years ago

Fertige Map

Audit   EhrSfmAudit
ManageAdministrativeTransactionProcessing   EhrSfmManageAdministrativeTransactionProcessing
ManageCareCoordinationAndReporting  EhrSfmManageCareCoordinationReporting
ManageClinicalDocumentation EhrSfmManageClinicalDocumentation
ManageClinicalHistory   EhrSfmManageClinicalHistory
ManageClinicalWorkflowTasking   EhrSfmManageClinicalWorkflowTasking
ManageCommunication EhrSfmManageCommunication
ManageHealthcareResourceAvailabilityInformation EhrSfmManageHealthcareResourceAvailabilityInformation
ManageHealthcareResourceScheduling  EhrSfmManageHealthcareResourceScheduling
ManageMedicationAdministration  EhrSfmManageMedicationAdministration
ManageOrders    EhrSfmManageOrders
ManageOrderSetTemplates EhrSfmManageOrderSetTemplates
ManagePatientHistory    EhrSfmManagePatientHistory
ManageProblemList   EhrSfmManageProblemList
ManageRecordEntryAmendedCorrectedAndAugmentedState  EhrSfmManageRecordEntryAmendedCorrectedAndAugementedState
ManageResourceAvailability  EhrSfmManageResourceAvailability
ManageResults   EhrSfmManageResults
ManageResultsOfDiagnosticTests  EhrSfmManageResultsOfDiagnosticTests
MeasurementAnalysisResearchAndReports   EhrSfmMeasurementAnalysisResearchAndReports
ProduceASummaryRecordOfCare EhrSfmProduceASummaryRecordOfCare
RegistryAndDirectoryServices    EhrSfmRegistryAndDirectoryServices
StandardTerminologyAndTerminologyServices   EhrSfmStandardTerminologyAndTerminologyServices
SupportCareCoordinationAndReporting EhrSfmSupportCareCoordinationReporting
SupportClinicalDocumentation    EhrSfmSupportClinicalDocumentation
SupportForCommunicationBetweenOrganizations EhrSfmSupportForCommunicationsBetweenOrganizations
SupportForContextSensitiveCarePlansGuidelinesProtocols  EhrSfmSupportForContextSensitiveCarePlansGuidelinesProtocols
SupportForMedicationAdministration  EhrSfmSupportForMedicationAdministration
SupportForMedicationInteractionAndAllergyChecking   EhrSfmSupportForMedicationInteractionAndAllergyChecking
SupportForMedicationOrderingEfficiencies    EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationRecommendations EhrSfmSupportForMedicationRecommendations
SupportForPatientContextDrivenAssessments   EhrSfmSupportForPatientContextdrivenAssessments
SupportForStandardAssessments   EhrSfmSupportForStandardAssessments
SupportforStandardCarePlansGuidelinesProtocols  EhrSfmSupportForStandardCarePlansGuidelinesProtocols
SupportOfPatientSpecificDosingAndWarnings   EhrSfmSupportOfPatientSpecificDosingAndWarnings
SupportOrders   EhrSfmSupportOrders
SupportOrdersForDiagnosticScreeningTests    EhrSfmSupportOrdersForDiagnosticscreeningTests
SupportRemoteHealthcareServices EhrSfmSupportRemoteHealthcareServices
SupportTriageCategorization EhrSfmSupportTriageCategorization
ManageMedicationImmunizationAndTreatmentAdministration  EhrSfmManageMedicationImmunizationAndTreatmentAdministration
ManageMedicationOrders  EhrSfmManageMedicationOrders
ManageNonMedicationPatientCareOrders    EhrSfmManageNonmedicationPatientCareOrders
ManageOrdersForDiagnositcScreeningTests EhrSfmManageOrdersForDiagnosticscreeningTests
ManageOrdersForReferral EhrSfmManageOrdersForReferral
MedicationAlertOverrides    EhrSfmMedicationAlertOverrides
MedicationAndAllergyInteractionChecking EhrSfmMedicationInteractionAndAllergyChecking
MedicationOrderEfficiencies EhrSfmMedicationOrderEfficiencies
UseOrderSets    EhrSfmUseOrderSets
KonradHoeffner commented 3 years ago

Alle Vorkommen aus Zeile 1 müssen durch den Wert aus Zeile 2 ersetzt werden (außer im dickinson selbst).

awk -F$'\t' '{ sed -i "s|$1|$2|" "*.ttl"}' dickinsonmap

Siehe https://stackoverflow.com/questions/40205472/loop-through-all-columns-in-bash Sollte alles ersetzen, auch die Stellen die wir nicht ersetzen wollen, aber dafür gibt es ja Git. Irgendwas funktioniert da aber noch nicht, investigate. Leider kenne ich mich mit AWK gar nicht aus, daher werde ich wohl eine andere Lösung suchen.

KonradHoeffner commented 3 years ago

Dieses bash-script (im limes-Ordner) scheint zu funktionieren:

#!/bin/bash

SCRIPTPATH=$(dirname "$0")

while IFS= read -r line; do
  # Split line into fields and read into array.
  IFS=$'\t' read -ra fields <<<"$line"
  sed -i "s|${fields[0]}|${fields[1]}|" $SCRIPTPATH/../individual.ttl
done < $SCRIPTPATH/dickinsonmap

Es gibt nun keine Zitate mehr von Dickinson. Es wurde tatsächlich nur in individual.ttl benutzt, damit ist der Teil erledigt.

KonradHoeffner commented 3 years ago

Jetzt fehlt nur noch das Ersetzen in der Datenbank. Dafür muss aus der Map ein SQL-Script erzeugt werden, welches alle Vorkommen ersetzt.

KonradHoeffner commented 3 years ago 
sort dickinsoncitations -k 2 -o dickinsoncitations
join mapdickinson.sql ../../ontology/limes/dickinsonmap -1 2

Result

Dickinson Classified Citation EHR SFM Classified
Audit auditTrail EhrSfmAudit
ManageAdministrativeTransactionProcessing scheduling EhrSfmManageAdministrativeTransactionProcessing
ManageCareCoordinationAndReporting creationOfDataRelationToTriage EhrSfmManageCareCoordinationReporting
ManageCareCoordinationAndReporting mandatoryReporting EhrSfmManageCareCoordinationReporting
ManageCareCoordinationAndReporting OpenMRSFeatBuildReports EhrSfmManageCareCoordinationReporting
ManageCareCoordinationAndReporting planningView EhrSfmManageCareCoordinationReporting
ManageCareCoordinationAndReporting requestFormAssignedATimeslotRoomAndStaff EhrSfmManageCareCoordinationReporting
ManageClinicalDocumentation anamnesisSupportedByOfferingFlexibleFormsForDataEntry EhrSfmManageClinicalDocumentation
ManageClinicalDocumentation capturingDataForAllPatientVisits EhrSfmManageClinicalDocumentation
ManageClinicalDocumentation clinicalDocumentation EhrSfmManageClinicalDocumentation
ManageClinicalDocumentation dataStorageRepository EhrSfmManageClinicalDocumentation
ManageClinicalDocumentation graphicalUserInterfaceToDocumentCare EhrSfmManageClinicalDocumentation
ManageClinicalDocumentation nursingAnamnesis EhrSfmManageClinicalDocumentation
ManageClinicalDocumentation nursingDocumentationForms EhrSfmManageClinicalDocumentation
ManageClinicalDocumentation patientManagementPlans EhrSfmManageClinicalDocumentation
ManageClinicalDocumentation pointAndClickDataEntry EhrSfmManageClinicalDocumentation
ManageClinicalHistory anamnesisSupportedByOfferingFlexibleFormsForDataEntry EhrSfmManageClinicalHistory
ManageClinicalHistory capturingDataForAllPatientVisits EhrSfmManageClinicalHistory
ManageClinicalHistory nursingAnamnesis EhrSfmManageClinicalHistory
ManageClinicalHistory remindingAndDocumentationOfNursingTasks EhrSfmManageClinicalHistory
ManageClinicalWorkflowTasking creationOfNursingCarePlans EhrSfmManageClinicalWorkflowTasking
ManageClinicalWorkflowTasking planningView EhrSfmManageClinicalWorkflowTasking
ManageClinicalWorkflowTasking remindingAndDocumentationOfNursingTasks EhrSfmManageClinicalWorkflowTasking
ManageClinicalWorkflowTasking requestFormAssignedATimeslotRoomAndStaff EhrSfmManageClinicalWorkflowTasking
ManageClinicalWorkflowTasking scheduling EhrSfmManageClinicalWorkflowTasking
ManageClinicalWorkflowTasking supportingAllPhasesOfTheNursingProcess EhrSfmManageClinicalWorkflowTasking
ManageHealthcareResourceAvailabilityInformation CIS1FeatSupportOfWardOrganization EhrSfmManageHealthcareResourceAvailabilityInformation
ManageHealthcareResourceAvailabilityInformation dataStorageRepository EhrSfmManageHealthcareResourceAvailabilityInformation
ManageHealthcareResourceAvailabilityInformation medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown EhrSfmManageHealthcareResourceAvailabilityInformation
ManageHealthcareResourceScheduling creationOfDataRelationToTriage EhrSfmManageHealthcareResourceScheduling
ManageMedicationAdministration electronicMedicationAdministrationTool EhrSfmManageMedicationAdministration
ManageMedicationImmunizationAndTreatmentAdministration electronicMedicationAdministrationTool EhrSfmManageMedicationImmunizationAndTreatmentAdministration
ManageMedicationOrders CIS1FeatSupportOfMedicationOrderingAndMedicationDocumentation EhrSfmManageMedicationOrders
ManageMedicationOrders medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown EhrSfmManageMedicationOrders
ManageMedicationOrders medication-specificOrderSet EhrSfmManageMedicationOrders
ManageMedicationOrders standardizedPrescriptionsAndMedicationProtocols EhrSfmManageMedicationOrders
ManageMedicationOrders unit-specificOderSet EhrSfmManageMedicationOrders
ManageNonMedicationPatientCareOrders planningView EhrSfmManageNonmedicationPatientCareOrders
ManageNonMedicationPatientCareOrders requestFormAssignedATimeslotRoomAndStaff EhrSfmManageNonmedicationPatientCareOrders
ManageOrders adaptionOfNursingCarePlansDuringCarePlanning EhrSfmManageOrders
ManageOrders automaticForwardedProcessedImages EhrSfmManageOrders
ManageOrders CIS1FeatSupportOfMedicationOrderingAndMedicationDocumentation EhrSfmManageOrders
ManageOrders computerizedOrderEntry EhrSfmManageOrders
ManageOrders creationOfNursingCarePlans EhrSfmManageOrders
ManageOrders dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection EhrSfmManageOrders
ManageOrders electronicMedicationAdministrationTool EhrSfmManageOrders
ManageOrders medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown EhrSfmManageOrders
ManageOrders medication-specificOrderSet EhrSfmManageOrders
ManageOrders patientRegistration EhrSfmManageOrders
ManageOrders planningView EhrSfmManageOrders
ManageOrders predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick EhrSfmManageOrders
ManageOrders predefinedOrderSentencesSearchableByCategoryQuickLists EhrSfmManageOrders
ManageOrders predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm EhrSfmManageOrders
ManageOrders prescribeLonghand EhrSfmManageOrders
ManageOrders readBarCodeLabel EhrSfmManageOrders
ManageOrders requestFormAssignedATimeslotRoomAndStaff EhrSfmManageOrders
ManageOrders standardizedPrescriptionsAndMedicationProtocols EhrSfmManageOrders
ManageOrders unit-specificOderSet EhrSfmManageOrders
ManageOrderSetTemplates dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection EhrSfmManageOrderSetTemplates
ManageOrderSetTemplates medication-specificOrderSet EhrSfmManageOrderSetTemplates
ManageOrderSetTemplates predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick EhrSfmManageOrderSetTemplates
ManageOrderSetTemplates predefinedOrderSentencesSearchableByCategoryQuickLists EhrSfmManageOrderSetTemplates
ManageOrderSetTemplates predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm EhrSfmManageOrderSetTemplates
ManageOrderSetTemplates standardizedPrescriptionsAndMedicationProtocols EhrSfmManageOrderSetTemplates
ManageOrderSetTemplates unit-specificOderSet EhrSfmManageOrderSetTemplates
ManageOrdersForDiagnositcScreeningTests automaticForwardedProcessedImages EhrSfmManageOrdersForDiagnosticscreeningTests
ManageOrdersForDiagnositcScreeningTests patientRegistration EhrSfmManageOrdersForDiagnosticscreeningTests
ManageOrdersForDiagnositcScreeningTests readBarCodeLabel EhrSfmManageOrdersForDiagnosticscreeningTests
ManageOrdersForDiagnositcScreeningTests unit-specificOderSet EhrSfmManageOrdersForDiagnosticscreeningTests
ManageOrdersForReferral OpenDentalFeatTrackReferredTreatments EhrSfmManageOrdersForReferral
ManageOrdersForReferral OpenEMRFeatReferrals EhrSfmManageOrdersForReferral
ManagePatientHistory allowingToReuseEarlierAnamnesticData EhrSfmManagePatientHistory
ManagePatientHistory capturingDataForAllPatientVisits EhrSfmManagePatientHistory
ManagePatientHistory graphicalUserInterfaceToDocumentCare EhrSfmManagePatientHistory
ManageProblemList anamnesisSupportedByOfferingFlexibleFormsForDataEntry EhrSfmManageProblemList
ManageProblemList nursingAnamnesis EhrSfmManageProblemList
ManageRecordEntryAmendedCorrectedAndAugmentedState electronicSignature EhrSfmManageRecordEntryAmendedCorrectedAndAugementedState
ManageResourceAvailability medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown EhrSfmManageResourceAvailability
ManageResourceAvailability wardManagement EhrSfmManageResourceAvailability
ManageResults AgfaRisElefanteFeatureSpeechRecognition EhrSfmManageResults
ManageResults automaticForwardedProcessedImages EhrSfmManageResults
ManageResults automaticTransferOfLaboratoryData EhrSfmManageResults
ManageResults completeTestResults EhrSfmManageResults
ManageResults consolidatedListOfResultsForJurisdiction EhrSfmManageResults
ManageResults forwardIntoArchive EhrSfmManageResults
ManageResults interactiveConsultationBetweenTwoOrMoreCenters EhrSfmManageResults
ManageResults patientPageContainingDetailsOfAnySingleSample EhrSfmManageResults
ManageResults patientPageContainingTheHistoryOfAllTestsPerformed EhrSfmManageResults
ManageResults reportsOnTestsPerformed EhrSfmManageResults
ManageResults toolsForQualityControl EhrSfmManageResults
ManageResults useOfInteractivePointersAndSpecificCalculationTools EhrSfmManageResults
ManageResults visualizationOfSynchronizedDICOMImages EhrSfmManageResults
ManageResults warningsForDelayedReportingOfResults EhrSfmManageResults
ManageResultsOfDiagnosticTests AgfaRisElefanteFeatureSpeechRecognition EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests automaticForwardedProcessedImages EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests automaticTransferOfLaboratoryData EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests CIS1FeatSupportToManagevariousClinicalAndDiagnosticResults EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests completeTestResults EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests consolidatedListOfResultsForJurisdiction EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests forwardIntoArchive EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests interactiveConsultationBetweenTwoOrMoreCenters EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests patientPageContainingDetailsOfAnySingleSample EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests patientPageContainingTheHistoryOfAllTestsPerformed EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests reportsOnTestsPerformed EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests useOfInteractivePointersAndSpecificCalculationTools EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests visualizationOfSynchronizedDICOMImages EhrSfmManageResultsOfDiagnosticTests
ManageResultsOfDiagnosticTests warningsForDelayedReportingOfResults EhrSfmManageResultsOfDiagnosticTests
MeasurementAnalysisResearchAndReports OpenMRSFeatCohortQuery EhrSfmMeasurementAnalysisResearchAndReports
MedicationAlertOverrides possibilityToContinuePrescribingWhileSafetyAlert EhrSfmMedicationAlertOverrides
MedicationAlertOverrides safetyAlertsForAcceptedMedicationAreSeenByPharmacistsWhoCanContactPhysiciansOrNurses EhrSfmMedicationAlertOverrides
MedicationAndAllergyInteractionChecking medicationControlBasedOnNationalDrugDatabase EhrSfmMedicationInteractionAndAllergyChecking
MedicationAndAllergyInteractionChecking safetyAlertsInCaseOfAllergies EhrSfmMedicationInteractionAndAllergyChecking
MedicationAndAllergyInteractionChecking safetyAlertsInCaseOfDrug-drugInteractions EhrSfmMedicationInteractionAndAllergyChecking
MedicationAndAllergyInteractionChecking safetyAlertsInRealTime EhrSfmMedicationInteractionAndAllergyChecking
MedicationOrderEfficiencies automaticDataCollection EhrSfmMedicationOrderEfficiencies
MedicationOrderEfficiencies computerizedOrderEntry EhrSfmMedicationOrderEfficiencies
MedicationOrderEfficiencies dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection EhrSfmMedicationOrderEfficiencies
MedicationOrderEfficiencies electronicMedicationAdministrationTool EhrSfmMedicationOrderEfficiencies
MedicationOrderEfficiencies medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown EhrSfmMedicationOrderEfficiencies
MedicationOrderEfficiencies medication-specificOrderSet EhrSfmMedicationOrderEfficiencies
MedicationOrderEfficiencies predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick EhrSfmMedicationOrderEfficiencies
MedicationOrderEfficiencies predefinedOrderSentencesSearchableByCategoryQuickLists EhrSfmMedicationOrderEfficiencies
MedicationOrderEfficiencies predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm EhrSfmMedicationOrderEfficiencies
MedicationOrderEfficiencies standardizedPrescriptionsAndMedicationProtocols EhrSfmMedicationOrderEfficiencies
MedicationOrderEfficiencies unit-specificOderSet EhrSfmMedicationOrderEfficiencies
ProduceASummaryRecordOfCare automaticCreationOfANursingTransferReport EhrSfmProduceASummaryRecordOfCare
ProduceASummaryRecordOfCare dischargeSummaries EhrSfmProduceASummaryRecordOfCare
ProduceASummaryRecordOfCare writingOfNursingLetters EhrSfmProduceASummaryRecordOfCare
RegistryAndDirectoryServices userDirectoryToControlAnyAccess EhrSfmRegistryAndDirectoryServices
StandardTerminologyAndTerminologyServices nursingDiagnosisBasedOnTheNANDATaxonomy EhrSfmStandardTerminologyAndTerminologyServices
SupportCareCoordinationAndReporting creationOfDataRelationToTriage EhrSfmSupportCareCoordinationReporting
SupportCareCoordinationAndReporting mandatoryReporting EhrSfmSupportCareCoordinationReporting
SupportCareCoordinationAndReporting planningView EhrSfmSupportCareCoordinationReporting
SupportCareCoordinationAndReporting requestFormAssignedATimeslotRoomAndStaff EhrSfmSupportCareCoordinationReporting
SupportClinicalDocumentation OpenEMRFeatSOAP EhrSfmSupportClinicalDocumentation
SupportForCommunicationBetweenOrganizations emailNotificationOfNewResults EhrSfmSupportForCommunicationsBetweenOrganizations
SupportForCommunicationBetweenOrganizations interactiveConsultationBetweenTwoOrMoreCenters EhrSfmSupportForCommunicationsBetweenOrganizations
SupportForCommunicationBetweenOrganizations patientRegistration EhrSfmSupportForCommunicationsBetweenOrganizations
SupportForCommunicationBetweenOrganizations real-timeVoiceCommunication EhrSfmSupportForCommunicationsBetweenOrganizations
SupportForCommunicationBetweenOrganizations safetyAlertsForAcceptedMedicationAreSeenByPharmacistsWhoCanContactPhysiciansOrNurses EhrSfmSupportForCommunicationsBetweenOrganizations
SupportForContextSensitiveCarePlansGuidelinesProtocols nursingCarePlanningSupportedByPre-definedNursingCareStandards EhrSfmSupportForContextSensitiveCarePlansGuidelinesProtocols
SupportForContextSensitiveCarePlansGuidelinesProtocols supportNursingCarePlanningForCertainPatientCases EhrSfmSupportForContextSensitiveCarePlansGuidelinesProtocols
SupportForMedicationInteractionAndAllergyChecking medicationControlBasedOnNationalDrugDatabase EhrSfmSupportForMedicationInteractionAndAllergyChecking
SupportForMedicationInteractionAndAllergyChecking safetyAlertsInCaseOfAllergies EhrSfmSupportForMedicationInteractionAndAllergyChecking
SupportForMedicationInteractionAndAllergyChecking safetyAlertsInCaseOfDrug-drugInteractions EhrSfmSupportForMedicationInteractionAndAllergyChecking
SupportForMedicationInteractionAndAllergyChecking safetyAlertsInRealTime EhrSfmSupportForMedicationInteractionAndAllergyChecking
SupportForMedicationOrderingEfficiencies automaticDataCollection EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationOrderingEfficiencies computerizedOrderEntry EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationOrderingEfficiencies dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationOrderingEfficiencies electronicMedicationAdministrationTool EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationOrderingEfficiencies medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationOrderingEfficiencies medication-specificOrderSet EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationOrderingEfficiencies predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationOrderingEfficiencies predefinedOrderSentencesSearchableByCategoryQuickLists EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationOrderingEfficiencies predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationOrderingEfficiencies standardizedPrescriptionsAndMedicationProtocols EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationOrderingEfficiencies triggeringTheCDSSToQueryTheTidalVolume EhrSfmSupportForMedicationOrderingEfficiencies
SupportForMedicationOrderingEfficiencies unit-specificOderSet EhrSfmSupportForMedicationOrderingEfficiencies
SupportForPatientContextDrivenAssessments nursingCarePlanningSupportedByPre-definedNursingCareStandards EhrSfmSupportForPatientContextdrivenAssessments
SupportForPatientContextDrivenAssessments supportNursingCarePlanningForCertainPatientCases EhrSfmSupportForPatientContextdrivenAssessments
SupportForStandardAssessments nursingCarePlanningSupportedByPre-definedNursingCareStandards EhrSfmSupportForStandardAssessments
SupportForStandardAssessments supportNursingCarePlanningForCertainPatientCases EhrSfmSupportForStandardAssessments
SupportforStandardCarePlansGuidelinesProtocols comprisingASetOfNursingCareStandards EhrSfmSupportForStandardCarePlansGuidelinesProtocols
SupportforStandardCarePlansGuidelinesProtocols nursingCarePlanningSupportedByPre-definedNursingCareStandards EhrSfmSupportForStandardCarePlansGuidelinesProtocols
SupportforStandardCarePlansGuidelinesProtocols supportNursingCarePlanningForCertainPatientCases EhrSfmSupportForStandardCarePlansGuidelinesProtocols
SupportforStandardCarePlansGuidelinesProtocols useOfClinicalPathways EhrSfmSupportForStandardCarePlansGuidelinesProtocols
SupportOfPatientSpecificDosingAndWarnings medicationControlBasedOnNationalDrugDatabase EhrSfmSupportOfPatientSpecificDosingAndWarnings
SupportOfPatientSpecificDosingAndWarnings safetyAlertsInCaseOfOverdosing EhrSfmSupportOfPatientSpecificDosingAndWarnings
SupportOfPatientSpecificDosingAndWarnings safetyAlertsInRealTime EhrSfmSupportOfPatientSpecificDosingAndWarnings
SupportOrders adaptionOfNursingCarePlansDuringCarePlanning EhrSfmSupportOrders
SupportOrders AgfaRisElefanteFeatureSpeechRecognition EhrSfmSupportOrders
SupportOrders computerizedOrderEntry EhrSfmSupportOrders
SupportOrders creationOfNursingCarePlans EhrSfmSupportOrders
SupportOrders dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection EhrSfmSupportOrders
SupportOrders medicationSelectionFromMenuInWichMedicationFromTheWardStockOrThePharmacyIsShown EhrSfmSupportOrders
SupportOrders medication-specificOrderSet EhrSfmSupportOrders
SupportOrders predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick EhrSfmSupportOrders
SupportOrders predefinedOrderSentencesSearchableByCategoryQuickLists EhrSfmSupportOrders
SupportOrders predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm EhrSfmSupportOrders
SupportOrders standardizedPrescriptionsAndMedicationProtocols EhrSfmSupportOrders
SupportOrders unit-specificOderSet EhrSfmSupportOrders
SupportOrdersForDiagnosticScreeningTests AgfaRisElefanteFeatureSpeechRecognition EhrSfmSupportOrdersForDiagnosticscreeningTests
SupportRemoteHealthcareServices interactiveConsultationBetweenTwoOrMoreCenters EhrSfmSupportRemoteHealthcareServices
SupportRemoteHealthcareServices offlineMode EhrSfmSupportRemoteHealthcareServices
SupportRemoteHealthcareServices real-timeVoiceCommunication EhrSfmSupportRemoteHealthcareServices
SupportTriageCategorization creationOfDataRelationToTriage EhrSfmSupportTriageCategorization
UseOrderSets dropdownMenuOfPredefinedOrderSentencesTriggeredOnDrugSelection EhrSfmUseOrderSets
UseOrderSets medication-specificOrderSet EhrSfmUseOrderSets
UseOrderSets predefinedOrderSentencesAllowForGroupOfRelatedOrdersToBeSelectedWithSingleClick EhrSfmUseOrderSets
UseOrderSets predefinedOrderSentencesSearchableByCategoryQuickLists EhrSfmUseOrderSets
UseOrderSets predefinedOrderSentencesWithDetailsOfDrugStrengthDoseAndForm EhrSfmUseOrderSets
UseOrderSets standardizedPrescriptionsAndMedicationProtocols EhrSfmUseOrderSets
UseOrderSets unit-specificOderSet EhrSfmUseOrderSets
KonradHoeffner commented 3 years ago

To pick one example, the SQL query would be:

UPDATE citation_has_classified SET classified_suffix='EhrSfmAudit' WHERE classified_suffix='Audit';
KonradHoeffner commented 3 years ago

This is probably really inefficient and I really need to learn AWK but to get this done quickly I transformed this to an SQL script using Atom multi cursor and sort -u:

UPDATE citation_has_classified SET classified_suffix='EhrSfmAudit' WHERE classified_suffix='Audit';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageAdministrativeTransactionProcessing' WHERE classified_suffix='ManageAdministrativeTransactionProcessing';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageCareCoordinationReporting' WHERE classified_suffix='ManageCareCoordinationAndReporting';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageClinicalDocumentation' WHERE classified_suffix='ManageClinicalDocumentation';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageClinicalHistory' WHERE classified_suffix='ManageClinicalHistory';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageClinicalWorkflowTasking' WHERE classified_suffix='ManageClinicalWorkflowTasking';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageHealthcareResourceAvailabilityInformation' WHERE classified_suffix='ManageHealthcareResourceAvailabilityInformation';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageHealthcareResourceScheduling' WHERE classified_suffix='ManageHealthcareResourceScheduling';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageMedicationAdministration' WHERE classified_suffix='ManageMedicationAdministration';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageMedicationImmunizationAndTreatmentAdministration' WHERE classified_suffix='ManageMedicationImmunizationAndTreatmentAdministration';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageMedicationOrders' WHERE classified_suffix='ManageMedicationOrders';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageNonmedicationPatientCareOrders' WHERE classified_suffix='ManageNonMedicationPatientCareOrders';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageOrderSetTemplates' WHERE classified_suffix='ManageOrderSetTemplates';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageOrdersForDiagnosticscreeningTests' WHERE classified_suffix='ManageOrdersForDiagnositcScreeningTests';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageOrdersForReferral' WHERE classified_suffix='ManageOrdersForReferral';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageOrders' WHERE classified_suffix='ManageOrders';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManagePatientHistory' WHERE classified_suffix='ManagePatientHistory';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageProblemList' WHERE classified_suffix='ManageProblemList';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageRecordEntryAmendedCorrectedAndAugementedState' WHERE classified_suffix='ManageRecordEntryAmendedCorrectedAndAugmentedState';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageResourceAvailability' WHERE classified_suffix='ManageResourceAvailability';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageResultsOfDiagnosticTests' WHERE classified_suffix='ManageResultsOfDiagnosticTests';
UPDATE citation_has_classified SET classified_suffix='EhrSfmManageResults' WHERE classified_suffix='ManageResults';
UPDATE citation_has_classified SET classified_suffix='EhrSfmMeasurementAnalysisResearchAndReports' WHERE classified_suffix='MeasurementAnalysisResearchAndReports';
UPDATE citation_has_classified SET classified_suffix='EhrSfmMedicationAlertOverrides' WHERE classified_suffix='MedicationAlertOverrides';
UPDATE citation_has_classified SET classified_suffix='EhrSfmMedicationInteractionAndAllergyChecking' WHERE classified_suffix='MedicationAndAllergyInteractionChecking';
UPDATE citation_has_classified SET classified_suffix='EhrSfmMedicationOrderEfficiencies' WHERE classified_suffix='MedicationOrderEfficiencies';
UPDATE citation_has_classified SET classified_suffix='EhrSfmProduceASummaryRecordOfCare' WHERE classified_suffix='ProduceASummaryRecordOfCare';
UPDATE citation_has_classified SET classified_suffix='EhrSfmRegistryAndDirectoryServices' WHERE classified_suffix='RegistryAndDirectoryServices';
UPDATE citation_has_classified SET classified_suffix='EhrSfmStandardTerminologyAndTerminologyServices' WHERE classified_suffix='StandardTerminologyAndTerminologyServices';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportCareCoordinationReporting' WHERE classified_suffix='SupportCareCoordinationAndReporting';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportClinicalDocumentation' WHERE classified_suffix='SupportClinicalDocumentation';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportForCommunicationsBetweenOrganizations' WHERE classified_suffix='SupportForCommunicationBetweenOrganizations';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportForContextSensitiveCarePlansGuidelinesProtocols' WHERE classified_suffix='SupportForContextSensitiveCarePlansGuidelinesProtocols';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportForMedicationInteractionAndAllergyChecking' WHERE classified_suffix='SupportForMedicationInteractionAndAllergyChecking';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportForMedicationOrderingEfficiencies' WHERE classified_suffix='SupportForMedicationOrderingEfficiencies';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportForPatientContextdrivenAssessments' WHERE classified_suffix='SupportForPatientContextDrivenAssessments';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportForStandardAssessments' WHERE classified_suffix='SupportForStandardAssessments';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportForStandardCarePlansGuidelinesProtocols' WHERE classified_suffix='SupportforStandardCarePlansGuidelinesProtocols';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportOfPatientSpecificDosingAndWarnings' WHERE classified_suffix='SupportOfPatientSpecificDosingAndWarnings';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportOrdersForDiagnosticscreeningTests' WHERE classified_suffix='SupportOrdersForDiagnosticScreeningTests';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportOrders' WHERE classified_suffix='SupportOrders';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportRemoteHealthcareServices' WHERE classified_suffix='SupportRemoteHealthcareServices';
UPDATE citation_has_classified SET classified_suffix='EhrSfmSupportTriageCategorization' WHERE classified_suffix='SupportTriageCategorization';
UPDATE citation_has_classified SET classified_suffix='EhrSfmUseOrderSets' WHERE classified_suffix='UseOrderSets';
KonradHoeffner commented 3 years ago 
ERROR:  duplicate key value violates unique constraint "citation_has_classified_pkey"
DETAIL:  Key (citation_suffix, classified_suffix)=(OpenMRSFeatBuildReports, EhrSfmManageCareCoordinationReporting) already exists.

ERROR:  duplicate key value violates unique constraint "citation_has_classified_pkey"
DETAIL:  Key (citation_suffix, classified_suffix)=(CIS1FeatSupportOfWardOrganization, EhrSfmManageHealthcareResourceAvailabilityInformation) already exists.

Deleted those.

ERROR:  insert or update on table "citation_has_classified" violates foreign key constraint "citation_has_classified_classified_suffix_fkey"
DETAIL:  Key (classified_suffix)=(EhrSfmManageMedicationImmunizationAndTreatmentAdministration) is not present in table "classified".
KonradHoeffner commented 3 years ago 
ERROR:  duplicate key value violates unique constraint "citation_has_classified_pkey"
DETAIL:  Key (citation_suffix, classified_suffix)=(OpenMRSFeatCohortQuery, EhrSfmMeasurementAnalysisResearchAndReports) already exists.

Deleted. Added. Done.

KonradHoeffner commented 3 years ago

mapdickinson.sql.txt