Skip to main content
. 2017 Dec 14;8(4):1012–1021. doi: 10.4338/ACI-2017-03-RA-0042

Table 1. Domain ontology with constraints.

DomainConcept Type DomainConstraint
Patient
 Birth_date Date Birth_date <= today
 Death_date Date If death_date is not null then death_date ≥ birth_date
Hospital admission
 Admission_date Date Discharge_date − admission_date < 1,000 d
 Admission_type Code
 Discharge_date Date Admission_date ≤ discharge_date
Procedure
 Procedure_concept_code Code
 Procedure_date Date Procedure_date ≥ admission_date
Medication
 Medication_concept_code Code
 Medication_end_date Date Medication_start_date < medication_end_date
 Medication_start_date Date Medication_start_date ≥ birth_date
Catheter intervention
 Catheter_duration Numeric Catheter_duration ≥ 0 d
Catheter_duration < 1,000 d
 Catheter_insertion_date Date If catheter_insertion_date is not null then catheter_inserted_by is not null
If catheter_insertion_date is not null and catheter_removal_date is null then catheter_rationale_for_continued_use is not null
 Catheter_removal_date Date If catheter_removal_date is not null then catheter_insertion_date is not null
 Catheter_rationale_for_continued_use String If catheter_rationale_for_continued_use is not null then catheter_insertion_date is not null
 Catheter_inserted_by String If catheter_inserted_by is not null then catheter_insertion_date is not null