KonradHoeffner commented 3 years ago

Choosing "Eintrag anzeigen" on any row of feature supports function results in an internal server error.

Example: https://hitontology.eu/database-frontend/featuresupportsfunctionview/show/%5B%22WhoDhiAssessCapacityOfHealthcareProvider%22%2C%20%22WhoDhiHealthcareProviderTraining%22%5D

KonradHoeffner commented 3 years ago

The whole feature supports function part must be redesigned.

There are actually different feature-supports-function relations:

hito:supportsFunction has domain hito:featureCitation and range hito:enterpriseFunctionCitation. That is the important one for the database frontend that needs to be editable there but that is missing until now.

hito:supportsFunctionClassified on the other hand has domain hito:featureClassified and range hito:enterpriseFunctionCitation. This is just the hierarchical relation like subFeatureOf but between feature and function.

KonradHoeffner commented 3 years ago

supportsFunction (between citations)

[x] define in hito.ttl in the ontology repository
[x] backup contents of feature_supports_function table
[x] delete old feature_supports_function table
[x] modify database schema of feature_supports_function table to reference citations instead of classifieds
[x] modify database schema trigger of feature_supports_function
[x] create new table in database
[x] modify download script in the database repository to download citations instead of classifieds
[x] execute the download script
[x] add the new values
[x] change the export script property to export feature_supports_function and add to citation.r2rml.ttl
[x] run export script
[x] compare export.nt with sparql result of diff.py
[x] adapt to database frontend locally
[x] push to server

KonradHoeffner commented 3 years ago

supportsFunctionClassified

[x] put old feature support function entries (between classifieds) in the classified_has_child table

They are already partly included as can be seen with the following new SQL view:

CREATE VIEW classified_has_child_type AS
SELECT
child.suffix as child_suffix,
child.type AS child_type,
parent.suffix as parent_suffix,
parent.type AS parent_type
FROM classified_has_child
JOIN classified_type child ON classified_has_child.child_suffix=child.suffix
JOIN classified_type parent ON classified_has_child.parent_suffix=parent.suffix

However the WHO DHI entries are not included. To that end, the download script was run again and the WHO DHI entries added to the database:

INSERT INTO classified_has_child VALUES...


INSERT INTO classified_has_child VALUES
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiCertifyBirthEvent'),
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiCertifyDeathEvent'),
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiNotifyBirthEvent'),
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiNotifyDeathEvent'),
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiRegisterBirthEvent'),
(E'WhoDhiCivilRegistrationAndVitalStatistic',E'WhoDhiRegisterDeathEvent'),
(E'WhoDhiClientHealthRecords',E'WhoDhiLongitudinalTrackingOfClientsHealthStatusAndServices'),
(E'WhoDhiClientHealthRecords',E'WhoDhiManageClientsStructuredClinicalRecords'),
(E'WhoDhiClientHealthRecords',E'WhoDhiManageClientsUnstructuredClinicalRecords'),
(E'WhoDhiClientHealthRecords',E'WhoDhiRoutineHealthIndicatorDataCollectionAndManagement'),
(E'WhoDhiClientIdentificationAndRegistration',E'WhoDhiEnrolClientForHealthServicesclinicalCarePlan'),
(E'WhoDhiClientIdentificationAndRegistration',E'WhoDhiVerifyClientUniqueIdentity'),
(E'WhoDhiEquipmentAndAssetManagement',E'WhoDhiMonitorStatusOfHealthEquipment'),
(E'WhoDhiEquipmentAndAssetManagement',E'WhoDhiTrackRegulationAndLicensingOfMedicalEquipment'),
(E'WhoDhiFacilityManagement',E'WhoDhiAssessHealthFacilities'),
(E'WhoDhiFacilityManagement',E'WhoDhiListHealthFacilitiesAndRelatedInformation'),
(E'WhoDhiHealthFinancing',E'WhoDhiManageBudgetAndExpenditures'),
(E'WhoDhiHealthFinancing',E'WhoDhiRegisterAndVerifyClientInsuranceMembership'),
(E'WhoDhiHealthFinancing',E'WhoDhiTrackAndManageInsuranceReimbursement'),
(E'WhoDhiHealthFinancing',E'WhoDhiTrackInsuranceBillingAndClaimsSubmission'),
(E'WhoDhiHealthFinancing',E'WhoDhiTransmitOrManageIncentivesToHealthcareProviders'),
(E'WhoDhiHealthFinancing',E'WhoDhiTransmitRoutinePayrollPaymentToHealthcareProviders'),
(E'WhoDhiHealthWorkerActivityPlanningAndScheduling',E'WhoDhiIdentifyClientsInNeedOfServices'),
(E'WhoDhiHealthWorkerActivityPlanningAndScheduling',E'WhoDhiScheduleHealthcareProvidersActivities'),
(E'WhoDhiHealthcareProviderCommunication',E'WhoDhiCommunicationAndPerformanceFeedbackToHealthcareProviders'),
(E'WhoDhiHealthcareProviderCommunication',E'WhoDhiCommunicationFromHealthcareProvidersToSupervisor'),
(E'WhoDhiHealthcareProviderCommunication',E'WhoDhiPeerGroupForHealthcareProviders'),
(E'WhoDhiHealthcareProviderCommunication',E'WhoDhiTransmitNonroutineHealthEventAlertsToHealthcareProviders'),
(E'WhoDhiHealthcareProviderCommunication',E'WhoDhiTransmitRoutineNewsAndWorkflowNotificationsToHealthcareProviders'),
(E'WhoDhiHealthcareProviderDecisionSupport',E'WhoDhiProvideChecklistAccordingToProtocol'),
(E'WhoDhiHealthcareProviderDecisionSupport',E'WhoDhiProvidePromptsAndAlertsBasedAccordingToProtocol'),
(E'WhoDhiHealthcareProviderDecisionSupport',E'WhoDhiScreenClientsByRiskOrOtherHealthStatus'),
(E'WhoDhiHealthcareProviderTraining',E'WhoDhiAssessCapacityOfHealthcareProvider'),
(E'WhoDhiHealthcareProviderTraining',E'WhoDhiProvideTrainingContentToHealthcareProviders'),
(E'WhoDhiHumanResourceManagement',E'WhoDhiListHealthWorkforceCadresAndRelatedIdentificationInformation'),
(E'WhoDhiHumanResourceManagement',E'WhoDhiManageCertificationregistrationOfHealthcareProviders'),
(E'WhoDhiHumanResourceManagement',E'WhoDhiMonitorPerformanceOfHealthcareProviders'),
(E'WhoDhiHumanResourceManagement',E'WhoDhiRecordTrainingCredentialsOfHealthcareProviders'),
(E'WhoDhiPrescriptionAndMedicationManagement',E'WhoDhiReportEffectsAdverseDrug'),
(E'WhoDhiPrescriptionAndMedicationManagement',E'WhoDhiTrackClientsMedicationConsumption'),
(E'WhoDhiPrescriptionAndMedicationManagement',E'WhoDhiTransmitOrTrackPrescriptionOrders'),
(E'WhoDhiPublicHealthEventNotification',E'WhoDhiNotificationOfPublicHealthEventsFromPointOfDiagnosis'),
(E'WhoDhiReferralCoordination',E'WhoDhiCoordinateEmergencyResponseAndTransport'),
(E'WhoDhiReferralCoordination',E'WhoDhiManageReferralsBetweenHealthAndOtherSectors'),
(E'WhoDhiReferralCoordination',E'WhoDhiManageReferralsBetweenPointsOfServiceWithinHealthSector'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiManageInventoryAndDistributionOfHealthCommoditiesStockLevelsOf'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiManageOfCommodities'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiMonitorColdchainSensitiveCommoditiesLicensedDrugs'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiNotifyHealthCommodities'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiRegisterAndHealthCommoditiesProcurement'),
(E'WhoDhiSupplyChainManagement',E'WhoDhiReportCounterfeitOrSubstandardDrugsByClients'),
(E'WhoDhiTelemedicine',E'WhoDhiConsultationsBetweenRemoteClientAndHealthcareProvider'),
(E'WhoDhiTelemedicine',E'WhoDhiConsultationsForCaseManagementBetweenHealthcareProviders'),
(E'WhoDhiTelemedicine',E'WhoDhiRemoteMonitoringOfClientHealthOrDiagnosticDataByProvider'),
(E'WhoDhiTelemedicine',E'WhoDhiTransmissionOfMedicalDataToHealthcareProvider'),
(E'WhoDhiLaboratoryAndDiagnosticsImagingManagement',E'WhoDhiCaptureFromDigitalDevices'),
(E'WhoDhiLaboratoryAndDiagnosticsImagingManagement',E'WhoDhiTrackBiologicalSpecimens'),
(E'WhoDhiLaboratoryAndDiagnosticsImagingManagement',E'WhoDhiTransmitDiagnosticOrdersDiagnosticResults'),
(E'WhoDhiLaboratoryAndDiagnosticsImagingManagement',E'WhoDhiTransmitToHealthcareProviderAndTrack'),
(E'WhoDhiCitizenBasedReporting',E'WhoDhiReportingOfHealthSystemFeedbackByClients'),
(E'WhoDhiCitizenBasedReporting',E'WhoDhiReportingOfPublicHealthEventsByClient'),
(E'WhoDhiClientFinancialTransactions',E'WhoDhiTransmitOrManageIncentivesToClientsForHealthServices'),
(E'WhoDhiClientFinancialTransactions',E'WhoDhiTransmitOrManageOutOfPocketPaymentsByClient'),
(E'WhoDhiClientFinancialTransactions',E'WhoDhiTransmitOrManageVouchersToClientForHealthServices'),
(E'WhoDhiClientToClientCommunication',E'WhoDhiPeerGroupForClients'),
(E'WhoDhiDataCoding',E'WhoDhiClassifyDiseaseCodesOrCauseOfMortality'),
(E'WhoDhiDataCoding',E'WhoDhiMergeDeduplicateAndCurateCodedDatasetsOrTerminologies'),
(E'WhoDhiDataCoding',E'WhoDhiParseUnstructuredDataIntoStructuredData'),
(E'WhoDhiDataCollectionManagementAndUse',E'WhoDhiAutomatedAnalysisOfDataToGenerateNewInformationOrPredictionsOnFutureEvents'),
(E'WhoDhiDataCollectionManagementAndUse',E'WhoDhiDataStorageAndAggregation'),
(E'WhoDhiDataCollectionManagementAndUse',E'WhoDhiDataSynthesisAndVisualization'),
(E'WhoDhiDataCollectionManagementAndUse',E'WhoDhiNonRoutineDataCollectionAndManagement'),
(E'WhoDhiDataExchangeAndInteroperability',E'WhoDhiDataExchangeAcrossSystems'),
(E'WhoDhiLocationMapping',E'WhoDhiMapLocationOfClientsAndHouseholds'),
(E'WhoDhiLocationMapping',E'WhoDhiMapLocationOfHealthEvents'),
(E'WhoDhiLocationMapping',E'WhoDhiMapLocationOfHealthFacilitiesstructures'),
(E'WhoDhiLocationMapping',E'WhoDhiMapLocationOfHealthcareProviders'),
(E'WhoDhiOndemandInformationServicesToClients',E'WhoDhiClientLookupOfHealthInformation'),
(E'WhoDhiPersonalHealthTracking',E'WhoDhiAccessByClientToOwnMedicalRecords'),
(E'WhoDhiPersonalHealthTracking',E'WhoDhiActiveDataCapturedocumentationByClient'),
(E'WhoDhiPersonalHealthTracking',E'WhoDhiSelfMonitoringOfHealthOrDiagnosticDataByClient'),
(E'WhoDhiTargetedClientCommunication',E'WhoDhiTransmitDiagnosticsResultOrAvailabilityOfResultToClients'),
(E'WhoDhiTargetedClientCommunication',E'WhoDhiTransmitHealthEventAlertsToSpecificPopulationGroups'),
(E'WhoDhiTargetedClientCommunication',E'WhoDhiTransmitTargetedAlertsAndRemindersToClients'),
(E'WhoDhiTargetedClientCommunication',E'WhoDhiTransmitTargetedHealthInformationToClientBasedOnHealthStatusOrDemographics'),
(E'WhoDhiUntargetedClientCommunication',E'WhoDhiTransmitUntargetedHealthEventAlertsToUndefinedGroup'),
(E'WhoDhiUntargetedClientCommunication',E'WhoDhiTransmitUntargetedHealthInformationToAnUndefinedPopulation')
ON CONFLICT DO NOTHING;

KonradHoeffner commented 3 years ago

feature_supports_function table backup

feature_suffix	function_suffix	source
WhoDhiAssessCapacityOfHealthcareProvider	WhoDhiHealthcareProviderTraining	NULL
WhoDhiAssessHealthFacilities	WhoDhiFacilityManagement	NULL
WhoDhiCaptureFromDigitalDevices	WhoDhiLaboratoryAndDiagnosticsImagingManagement	NULL
WhoDhiCertifyBirthEvent	WhoDhiCivilRegistrationAndVitalStatistic	NULL
WhoDhiCertifyDeathEvent	WhoDhiCivilRegistrationAndVitalStatistic	NULL
WhoDhiCommunicationAndPerformanceFeedbackToHealthcareProviders	WhoDhiHealthcareProviderCommunication	NULL
WhoDhiCommunicationFromHealthcareProvidersToSupervisor	WhoDhiHealthcareProviderCommunication	NULL
WhoDhiConsultationsBetweenRemoteClientAndHealthcareProvider	WhoDhiTelemedicine	NULL
WhoDhiConsultationsForCaseManagementBetweenHealthcareProviders	WhoDhiTelemedicine	NULL
WhoDhiCoordinateEmergencyResponseAndTransport	WhoDhiReferralCoordination	NULL
WhoDhiEnrolClientForHealthServicesclinicalCarePlan	WhoDhiClientIdentificationAndRegistration	NULL
WhoDhiIdentifyClientsInNeedOfServices	WhoDhiHealthWorkerActivityPlanningAndScheduling	NULL
WhoDhiListHealthFacilitiesAndRelatedInformation	WhoDhiFacilityManagement	NULL
WhoDhiListHealthWorkforceCadresAndRelatedIdentificationInformation	WhoDhiHumanResourceManagement	NULL
WhoDhiLongitudinalTrackingOfClientsHealthStatusAndServices	WhoDhiClientHealthRecords	NULL
WhoDhiManageBudgetAndExpenditures	WhoDhiHealthFinancing	NULL
WhoDhiManageCertificationregistrationOfHealthcareProviders	WhoDhiHumanResourceManagement	NULL
WhoDhiManageClientsStructuredClinicalRecords	WhoDhiClientHealthRecords	NULL
WhoDhiManageClientsUnstructuredClinicalRecords	WhoDhiClientHealthRecords	NULL
WhoDhiManageInventoryAndDistributionOfHealthCommoditiesStockLevelsOf	WhoDhiSupplyChainManagement	NULL
WhoDhiManageOfCommodities	WhoDhiSupplyChainManagement	NULL
WhoDhiManageReferralsBetweenHealthAndOtherSectors	WhoDhiReferralCoordination	NULL
WhoDhiManageReferralsBetweenPointsOfServiceWithinHealthSector	WhoDhiReferralCoordination	NULL
WhoDhiMonitorColdchainSensitiveCommoditiesLicensedDrugs	WhoDhiSupplyChainManagement	NULL
WhoDhiMonitorPerformanceOfHealthcareProviders	WhoDhiHumanResourceManagement	NULL
WhoDhiMonitorStatusOfHealthEquipment	WhoDhiEquipmentAndAssetManagement	NULL
WhoDhiNotificationOfPublicHealthEventsFromPointOfDiagnosis	WhoDhiPublicHealthEventNotification	NULL
WhoDhiNotifyBirthEvent	WhoDhiCivilRegistrationAndVitalStatistic	NULL
WhoDhiNotifyDeathEvent	WhoDhiCivilRegistrationAndVitalStatistic	NULL
WhoDhiNotifyHealthCommodities	WhoDhiSupplyChainManagement	NULL
WhoDhiPeerGroupForHealthcareProviders	WhoDhiHealthcareProviderCommunication	NULL
WhoDhiProvideChecklistAccordingToProtocol	WhoDhiHealthcareProviderDecisionSupport	NULL
WhoDhiProvidePromptsAndAlertsBasedAccordingToProtocol	WhoDhiHealthcareProviderDecisionSupport	NULL
WhoDhiProvideTrainingContentToHealthcareProviders	WhoDhiHealthcareProviderTraining	NULL
WhoDhiRecordTrainingCredentialsOfHealthcareProviders	WhoDhiHumanResourceManagement	NULL
WhoDhiRegisterAndHealthCommoditiesProcurement	WhoDhiSupplyChainManagement	NULL
WhoDhiRegisterAndVerifyClientInsuranceMembership	WhoDhiHealthFinancing	NULL
WhoDhiRegisterBirthEvent	WhoDhiCivilRegistrationAndVitalStatistic	NULL
WhoDhiRegisterDeathEvent	WhoDhiCivilRegistrationAndVitalStatistic	NULL
WhoDhiRemoteMonitoringOfClientHealthOrDiagnosticDataByProvider	WhoDhiTelemedicine	NULL
WhoDhiReportCounterfeitOrSubstandardDrugsByClients	WhoDhiSupplyChainManagement	NULL
WhoDhiReportEffectsAdverseDrug	WhoDhiPrescriptionAndMedicationManagement	NULL
WhoDhiRoutineHealthIndicatorDataCollectionAndManagement	WhoDhiClientHealthRecords	NULL
WhoDhiScheduleHealthcareProvidersActivities	WhoDhiHealthWorkerActivityPlanningAndScheduling	NULL
WhoDhiScreenClientsByRiskOrOtherHealthStatus	WhoDhiHealthcareProviderDecisionSupport	NULL
WhoDhiTrackAndManageInsuranceReimbursement	WhoDhiHealthFinancing	NULL
WhoDhiTrackBiologicalSpecimens	WhoDhiLaboratoryAndDiagnosticsImagingManagement	NULL
WhoDhiTrackClientsMedicationConsumption	WhoDhiPrescriptionAndMedicationManagement	NULL
WhoDhiTrackInsuranceBillingAndClaimsSubmission	WhoDhiHealthFinancing	NULL
WhoDhiTrackRegulationAndLicensingOfMedicalEquipment	WhoDhiEquipmentAndAssetManagement	NULL
WhoDhiTransmissionOfMedicalDataToHealthcareProvider	WhoDhiTelemedicine	NULL
WhoDhiTransmitDiagnosticOrdersDiagnosticResults	WhoDhiLaboratoryAndDiagnosticsImagingManagement	NULL
WhoDhiTransmitNonroutineHealthEventAlertsToHealthcareProviders	WhoDhiHealthcareProviderCommunication	NULL
WhoDhiTransmitOrManageIncentivesToHealthcareProviders	WhoDhiHealthFinancing	NULL
WhoDhiTransmitOrTrackPrescriptionOrders	WhoDhiPrescriptionAndMedicationManagement	NULL
WhoDhiTransmitRoutineNewsAndWorkflowNotificationsToHealthcareProviders	WhoDhiHealthcareProviderCommunication	NULL
WhoDhiTransmitRoutinePayrollPaymentToHealthcareProviders	WhoDhiHealthFinancing	NULL
WhoDhiTransmitToHealthcareProviderAndTrack	WhoDhiLaboratoryAndDiagnosticsImagingManagement	NULL
WhoDhiVerifyClientUniqueIdentity	WhoDhiClientIdentificationAndRegistration	NULL

KonradHoeffner commented 3 years ago

initial new table values

INSERT INTO feature_supports_function(feature_suffix,function_suffix) VALUES

INSERT INTO feature_supports_function(feature_suffix,function_suffix) VALUES (E'BahmniFeatCaptureClinicalRecords',E'BahmniFuncClinicalServices'), (E'BahmniFeatCaptureDrugPrescriptions',E'BahmniFuncClinicalServices'), (E'BahmniFeatClinicalReporting',E'BahmniFuncReporting'), (E'BahmniFeatCreateDiseaseSpecificForms',E'BahmniFuncClinicalServices'), (E'BahmniFeatCreateGeneralForms',E'BahmniFuncClinicalServices'), (E'BahmniFeatDisplayLaboratoryWorkload',E'BahmniFuncLaboratory'), (E'BahmniFeatMaintainAccurateRecords',E'BahmniFuncBilling'), (E'BahmniFeatMaintainClinicalRecords',E'BahmniFuncClinicalServices'), (E'BahmniFeatManageAccurateRecords',E'BahmniFuncBilling'), (E'BahmniFeatManagePatientOrders',E'BahmniFuncLaboratory'), (E'BahmniFeatManagePatientsAdmissions',E'BahmniFuncInpatientManagement'), (E'BahmniFeatManageSamples',E'BahmniFuncLaboratory'), (E'BahmniFeatManageStock',E'BahmniFuncStockManagement'), (E'BahmniFeatManageTests',E'BahmniFuncLaboratory'), (E'BahmniFeatMonitorStockLevels',E'BahmniFuncStockManagement'), (E'BahmniFeatMoveStock',E'BahmniFuncStockManagement'), (E'BahmniFeatOrderInvestigation',E'BahmniFuncClinicalServices'), (E'BahmniFeatOrderLab',E'BahmniFuncClinicalServices'), (E'BahmniFeatOrderRadiology',E'BahmniFuncClinicalServices'), (E'BahmniFeatPerformBedAssignments',E'BahmniFuncInpatientManagement'), (E'BahmniFeatPerformOperationalReporting',E'BahmniFuncReporting'), (E'BahmniFeatPrintPatientId',E'BahmniFuncPatientRegistration'), (E'BahmniFeatPublicHealthReporting',E'BahmniFuncReporting'), (E'BahmniFeatReorderStock',E'BahmniFuncStockManagement'), (E'BahmniFeatSearchPatients',E'BahmniFuncPatientRegistration'), (E'BahmniFeatSendSamplesForReferrals',E'BahmniFuncInpatientManagement'), (E'BahmniFeatTrackStock',E'BahmniFuncStockManagement'), (E'BahmniFeatTrackWardOccupancy',E'BahmniFuncInpatientManagement'), (E'BahmniFeatUseDrugPrescriptionTemplates',E'BahmniFuncClinicalServices')ON CONFLICT DO NOTHING;

hitontology / database-frontend

Feature Supports Function #19

supportsFunction (between citations)

supportsFunctionClassified

feature_supports_function table backup

initial new table values