ApplicationSystemCatalogue classifieds missing in database

[KonradHoeffner]

For example BbDecisionSupportSystem.

[KonradHoeffner]

The issue is caused by some properties missing the hito:catalogue superproperty.

Only the organizational unit, enterprise function, and feature catalogue properties have it.

Add to:

• [x] applicationSystemCatalogue
• [x] userGroupCatalogue

[KonradHoeffner]

• [x] add application system and user group classifieds to the database

[KonradHoeffner]

INSERT INTO classified(suffix,catalogue_suffix,n,label,comment,synonyms,dct_source,dce_sources) VALUES
(E'SnomedProfessionalNurseOccupation',E'SnomedUserGroupCatalogue',NULL,E'Professional nurse occupation',E'Professional nurse (occupation)','{}','{}','{}'),
(E'SnomedSurgeonOccupation',E'SnomedUserGroupCatalogue',NULL,E'Surgeon occupation',E'Surgeon (occupation)','{}','{}','{}'),
(E'SnomedPhysicianOccupation',E'SnomedUserGroupCatalogue',NULL,E'Physician occupation',E'Physician (occupation)','{}','{}','{}'),
(E'SnomedClericalOccupationOccupation',E'SnomedUserGroupCatalogue',NULL,E'Clerical occupation occupation',E'Clerical occupation (occupation)','{}','{}','{}'),
(E'SnomedResearcherOccupation',E'SnomedUserGroupCatalogue',NULL,E'Researcher occupation',E'Researcher (occupation)','{}','{}','{}'),
(E'SnomedMedicalTechnicianOccupation',E'SnomedUserGroupCatalogue',NULL,E'Medical technician occupation',E'Medical technician (occupation)','{}','{}','{}'),
(E'SnomedLaboratoryTechnicianOccupation',E'SnomedUserGroupCatalogue',NULL,E'Laboratory technician occupation',E'Laboratory technician (occupation)','{}','{}','{}'),
(E'SnomedRadiologistOccupation',E'SnomedUserGroupCatalogue',NULL,E'Radiologist occupation',E'Radiologist (occupation)','{}','{}','{}'),
(E'SnomedClerkOccupation',E'SnomedUserGroupCatalogue',NULL,E'Clerk occupation',E'Clerk (occupation)','{}','{}','{}'),
(E'SnomedAdministrativeHealthcareStaffOccupation',E'SnomedUserGroupCatalogue',NULL,E'Administrative healthcare staff occupation',E'Administrative healthcare staff (occupation)','{}','{}','{}'),
(E'SnomedWomanPerson',E'SnomedUserGroupCatalogue',NULL,E'Woman person',E'Woman (person)','{}','{}','{}'),
(E'SnomedPharmacistOccupation',E'SnomedUserGroupCatalogue',NULL,E'Pharmacist occupation',E'Pharmacist (occupation)','{}','{}','{}'),
(E'BbDocumentArchivingSystem',E'BbApplicationSystemCatalogue',NULL,E'Document Archiving System',NULL,'{}','{}','{"Table 6.13"}'),
(E'WhoDhiClinicalTerminologyAndClassifications',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Clinical terminology and classifications',NULL,'{}','{}','{}'),
(E'WhoDhiLogisticsManagementInformationSystemLmis',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Logistics management information system (LMIS)',NULL,'{}','{}','{}'),
(E'BbPatientDataManagementSystem',E'BbApplicationSystemCatalogue',NULL,E'Patient Data Management System',NULL,'{"PDMS"}','{}','{"Table 6.6"}'),
(E'BbOutpatientManagementSystem',E'BbApplicationSystemCatalogue',NULL,E'Outpatient Management System',NULL,'{}','{}','{"Table 6.4"}'),
(E'WhoDhiEmergencyResponseSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Emergency response system',NULL,'{}','{}','{}'),
(E'BbElectronicPatientRecordSystem',E'BbApplicationSystemCatalogue',NULL,E'Electronic Patient Record System',NULL,'{"CIS","EPR System"}','{}','{"Chapter 6.4.15"}'),
(E'BbDataWarehouseSystem',E'BbApplicationSystemCatalogue',NULL,E'Data Warehouse System',NULL,'{}','{}','{"Table 6.12"}'),
(E'BbPathologyInformationSystem',E'BbApplicationSystemCatalogue',NULL,E'Pathology information system',E'Has similar features as a laboratory information system, e. g. receiving orders, writing reports.','{}','{}','{"Table 6.14"}'),
(E'WhoDhiHumanResourceInformationSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Human resource information system',NULL,'{}','{}','{}'),
(E'BbPictureArchivingAndCommunicationSystem',E'BbApplicationSystemCatalogue',NULL,E'Picture Archiving and Communication System',NULL,'{"PACS"}','{}','{"Table 6.9"}'),
(E'WhoDhiResearchInformationSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Research information system',NULL,'{}','{}','{}'),
(E'WhoDhiKnowledgeManagementSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Knowledge management system',NULL,'{}','{}','{}'),
(E'WhoDhiCivilRegistrationAndVitalStatistics',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Civil registration and vital statistics',NULL,'{}','{}','{}'),
(E'WhoDhiClientCommunicationSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Client communication system',NULL,'{}','{}','{}'),
(E'BbEnterpriseResourcePlanningSystem',E'BbApplicationSystemCatalogue',NULL,E'Enterprise Resource Planning System',NULL,'{}','{}','{"Table 6.11"}'),
(E'WhoDhiTelemedicineCategory',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Telemedicine Category',NULL,'{}','{}','{}'),
(E'WhoDhiIdentificationRegistriesAndDirectories',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Identification registries and directories',NULL,'{}','{}','{}'),
(E'BbLaboratoryInformationSystem',E'BbApplicationSystemCatalogue',NULL,E'Laboratory Information System',NULL,'{"LIS"}','{}','{"Table 6.10"}'),
(E'WhoDhiGeographicInformationSystemGis',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Geographic information system (GIS)',NULL,'{}','{}','{}'),
(E'WhoDhiCensusPopulationInformationDataWarehouse',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Census, population information & data warehouse',NULL,'{}','{}','{}'),
(E'BbClinicalInformationSystem',E'BbApplicationSystemCatalogue',NULL,E'Clinical Information System',NULL,'{"CIS","EPR System"}','{}','{"Chapter 6.4.15"}'),
(E'WhoDhiLaboratoryAndDiagnosticsInformationSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Laboratory and diagnostics information system',NULL,'{}','{}','{}'),
(E'BbDecisionSupportSystem',E'BbApplicationSystemCatalogue',NULL,E'Decision support system',E'A knowledge-based system which assists a doctor in finding the right diagnosis or treatment for a specific patient.','{}','{}','{"Table 6.14"}'),
(E'WhoDhiFacilityManagementInformationSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Facility management information system',NULL,'{}','{}','{}'),
(E'BbDialysisInformationSystem',E'BbApplicationSystemCatalogue',NULL,E'Dialysis information system',E'Provides many features of a clinical information system while tailoring the special needs of a dialysis department, has interfaces to hemodialysis machines.','{}','{}','{"Table 6.14"}'),
(E'WhoDhiCommunitybasedInformationSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Community-based information system',NULL,'{}','{}','{}'),
(E'WhoDhiHealthFinanceAndInsuranceInformationSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Health finance and insurance information system',NULL,'{}','{}','{}'),
(E'WhoDhiDataInterchangeInteroperabilityAndAccessibility',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Data interchange interoperability and accessibility',NULL,'{}','{}','{}'),
(E'WhoDhiHealthManagementInformationSystemHmis',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Health management information system (HMIS)',NULL,'{}','{}','{}'),
(E'WhoDhiSharedHealthRecordAndHealthInformationRespositories',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Shared Health Record and health information respositories',NULL,'{}','{}','{}'),
(E'BbTeleradiologySystem',E'BbApplicationSystemCatalogue',NULL,E'Teleradiology system',E'Enables evaluations of radiological images from (external) radiologists\' remote workplaces and may be closely connected to RIS and PACS.','{}','{}','{"Table 6.14"}'),
(E'WhoDhiElectronicMedicalRecord',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Electronic medical record',NULL,'{}','{}','{}'),
(E'BbDigitalDictationSystem',E'BbApplicationSystemCatalogue',NULL,E'Digital dictation system',E'Offers features for digital voice recording and speech recognition, is often integrated into medical information systems and supports report, finding and letter writing.','{}','{}','{"Table 6.14"}'),
(E'BbCardiovascularInformationSystem',E'BbApplicationSystemCatalogue',NULL,E'Cardiovascular information system',E'Provides many features of a clinical information system and a radiology information system while tailoring the special needs of a cardiology department.','{"CVIS"}','{}','{"Table 6.14"}'),
(E'BbMedicalDocumentationSystem',E'BbApplicationSystemCatalogue',NULL,E'Medical Documentation System',NULL,'{}','{}','{"Table 6.2"}'),
(E'BbBloodBankManagementSystem',E'BbApplicationSystemCatalogue',NULL,E'Blood bank management system',E'Supports blood donor services, blood analyses, administration of blood bottles.','{}','{}','{"Table 6.14"}'),
(E'BbOperationManagementSystem',E'BbApplicationSystemCatalogue',NULL,E'Operation Management System',NULL,'{}','{}','{"Table 6.7"}'),
(E'BbPharmacyInformationSystem',E'BbApplicationSystemCatalogue',NULL,E'Pharmacy information system',E'Supports the workflow in the pharmacy department: receiving drug orders, managing the drug stock, distributing drugs throughout the hospital.','{}','{}','{"Table 6.14"}'),
(E'WhoDhiPharmacyInformationSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Pharmacy information system',NULL,'{}','{}','{}'),
(E'BbRadiologyInformationSystem',E'BbApplicationSystemCatalogue',NULL,E'Radiology Information System',NULL,'{"RIS"}','{}','{"Table 6.8"}'),
(E'BbProviderOrPhysicianOrderEntrySystem',E'BbApplicationSystemCatalogue',NULL,E'Provider or Physician Order Entry System',NULL,'{"POE"}','{}','{"Table 6.5"}'),
(E'BbPatientAdministrationSystem',E'BbApplicationSystemCatalogue',NULL,E'Patient Administration System',NULL,'{}','{}','{"Table 6.1"}'),
(E'WhoDhiPublicHealthAndDiseaseSurveillanceSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Public health and disease surveillance system',NULL,'{}','{}','{}'),
(E'BbNursingManagementAndDocumentationSystem',E'BbApplicationSystemCatalogue',NULL,E'Nursing Management and Documentation System',NULL,'{}','{}','{"Table 6.3"}'),
(E'BbOrthopedicsInformationSystem',E'BbApplicationSystemCatalogue',NULL,E'Orthopedics information system',E'Provides many features of a clinical information system while tailoring the special needs of an orthopedics department, can include a computer-aided design (CAD) system for transplant planning.','{}','{}','{"Table 6.14"}'),
(E'WhoDhiEnvironmentalMonitoringSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Environmental monitoring system',NULL,'{}','{}','{}'),
(E'BbOncologyInformationSystem',E'BbApplicationSystemCatalogue',NULL,E'Oncology information system',E'Provides many features of a clinical information system while tailoring the special needs of an oncology department.','{}','{}','{"Table 6.14"}'),
(E'WhoDhiLearningAndTrainingSystem',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Learning and training system',NULL,'{}','{}','{}'),
(E'WhoDhiClientApplications',E'WhoDhiSystemCategoryApplicationSystemCatalogue',NULL,E'Client applications',NULL,'{}','{}','{}');

[KonradHoeffner]

Added all missing classifieds.