| 1 | package Convert::Pheno::OMOP::Definitions; | ||
| 2 | |||
| 3 | 140 | ▶ | use strict; |
|
Subroutine
BEGIN: called CC=1 SCAR=0.0
| |||
| 4 | 140 | ▶ | use warnings; |
|
Subroutine
BEGIN: called CC=1 SCAR=0.0
| |||
| 5 | 140 | ▶ | use Exporter 'import'; |
|
Subroutine
BEGIN: called CC=1 SCAR=0.0
| |||
| 6 | 140 | our @EXPORT = | |
| 7 | qw($omop_version $omop_main_table @omop_array_tables @omop_essential_tables @omop_supported_tables @stream_ram_memory_tables $omop_headers); | ||
| 8 | |||
| 9 | # NB: Direct export w/o encapsulation in subroutine | ||
| 10 | |||
| 11 | 140 | our $omop_version = 'v5.4'; | |
| 12 | 140 | our $omop_main_table = { | |
| 13 | 'v5.4' => [ | ||
| 14 | qw( | ||
| 15 | PERSON | ||
| 16 | OBSERVATION_PERIOD | ||
| 17 | VISIT_OCCURRENCE | ||
| 18 | VISIT_DETAIL | ||
| 19 | CONDITION_OCCURRENCE | ||
| 20 | DRUG_EXPOSURE | ||
| 21 | PROCEDURE_OCCURRENCE | ||
| 22 | DEVICE_EXPOSURE | ||
| 23 | MEASUREMENT | ||
| 24 | OBSERVATION | ||
| 25 | NOTE | ||
| 26 | NOTE_NLP | ||
| 27 | SPECIMEN | ||
| 28 | FACT_RELATIONSHIP | ||
| 29 | SURVEY_CONDUCT | ||
| 30 | ) | ||
| 31 | ], | ||
| 32 | 'v6' => [ | ||
| 33 | qw( | ||
| 34 | PERSON | ||
| 35 | OBSERVATION_PERIOD | ||
| 36 | VISIT_OCCURRENCE | ||
| 37 | VISIT_DETAIL | ||
| 38 | CONDITION_OCCURRENCE | ||
| 39 | DRUG_EXPOSURE | ||
| 40 | PROCEDURE_OCCURRENCE | ||
| 41 | DEVICE_EXPOSURE | ||
| 42 | MEASUREMENT | ||
| 43 | OBSERVATION | ||
| 44 | DEATH | ||
| 45 | NOTE | ||
| 46 | NOTE_NLP | ||
| 47 | SPECIMEN | ||
| 48 | FACT_RELATIONSHIP | ||
| 49 | ) | ||
| 50 | ] | ||
| 51 | }; | ||
| 52 | |||
| 53 | 140 | our @omop_array_tables = qw( | |
| 54 | MEASUREMENT | ||
| 55 | OBSERVATION | ||
| 56 | CONDITION_OCCURRENCE | ||
| 57 | PROCEDURE_OCCURRENCE | ||
| 58 | DRUG_EXPOSURE | ||
| 59 | SPECIMEN | ||
| 60 | VISIT_OCCURRENCE | ||
| 61 | ); | ||
| 62 | |||
| 63 | 140 | our @omop_essential_tables = qw( | |
| 64 | CONCEPT | ||
| 65 | CONDITION_OCCURRENCE | ||
| 66 | PERSON | ||
| 67 | PROCEDURE_OCCURRENCE | ||
| 68 | MEASUREMENT | ||
| 69 | OBSERVATION | ||
| 70 | DRUG_EXPOSURE | ||
| 71 | VISIT_OCCURRENCE | ||
| 72 | ); | ||
| 73 | |||
| 74 | 140 | our @omop_supported_tables = ( | |
| 75 | @omop_essential_tables, | ||
| 76 | qw(SPECIMEN) | ||
| 77 | ); | ||
| 78 | |||
| 79 | 140 | our $omop_headers = { | |
| 80 | "CONCEPT" => [ | ||
| 81 | 'concept_id', | ||
| 82 | 'concept_name', | ||
| 83 | 'domain_id', | ||
| 84 | 'vocabulary_id', | ||
| 85 | 'concept_class_id', | ||
| 86 | 'standard_concept', | ||
| 87 | 'concept_code', | ||
| 88 | 'valid_start_date', | ||
| 89 | 'valid_end_date', | ||
| 90 | 'invalid_reason', | ||
| 91 | ], | ||
| 92 | "CONDITION_OCCURRENCE" => [ | ||
| 93 | 'condition_occurrence_id', | ||
| 94 | 'person_id', | ||
| 95 | 'condition_concept_id', | ||
| 96 | 'condition_start_date', | ||
| 97 | 'condition_start_datetime', | ||
| 98 | 'condition_end_date', | ||
| 99 | 'condition_end_datetime', | ||
| 100 | 'condition_type_concept_id', | ||
| 101 | 'condition_status_concept_id', | ||
| 102 | 'stop_reason', | ||
| 103 | 'provider_id', | ||
| 104 | 'visit_occurrence_id', | ||
| 105 | 'visit_detail_id', | ||
| 106 | 'condition_source_value', | ||
| 107 | 'condition_source_concept_id', | ||
| 108 | 'condition_status_source_value', | ||
| 109 | ], | ||
| 110 | "DRUG_EXPOSURE" => [ | ||
| 111 | 'drug_exposure_id', | ||
| 112 | 'person_id', | ||
| 113 | 'drug_concept_id', | ||
| 114 | 'drug_exposure_start_date', | ||
| 115 | 'drug_exposure_start_datetime', | ||
| 116 | 'drug_exposure_end_date', | ||
| 117 | 'drug_exposure_end_datetime', | ||
| 118 | 'verbatim_end_date', | ||
| 119 | 'drug_type_concept_id', | ||
| 120 | 'stop_reason', | ||
| 121 | 'refills', | ||
| 122 | 'quantity', | ||
| 123 | 'days_supply', | ||
| 124 | 'sig', | ||
| 125 | 'route_concept_id', | ||
| 126 | 'lot_number', | ||
| 127 | 'provider_id', | ||
| 128 | 'visit_occurrence_id', | ||
| 129 | 'visit_detail_id', | ||
| 130 | 'drug_source_value', | ||
| 131 | 'drug_source_concept_id', | ||
| 132 | 'route_source_value', | ||
| 133 | 'dose_unit_source_value', | ||
| 134 | ], | ||
| 135 | "MEASUREMENT" => [ | ||
| 136 | 'measurement_id', | ||
| 137 | 'person_id', | ||
| 138 | 'measurement_concept_id', | ||
| 139 | 'measurement_date', | ||
| 140 | 'measurement_datetime', | ||
| 141 | 'measurement_time', | ||
| 142 | 'measurement_type_concept_id', | ||
| 143 | 'operator_concept_id', | ||
| 144 | 'value_as_number', | ||
| 145 | 'value_as_concept_id', | ||
| 146 | 'unit_concept_id', | ||
| 147 | 'range_low', | ||
| 148 | 'range_high', | ||
| 149 | 'provider_id', | ||
| 150 | 'visit_occurrence_id', | ||
| 151 | 'visit_detail_id', | ||
| 152 | 'measurement_source_value', | ||
| 153 | 'measurement_source_concept_id', | ||
| 154 | 'unit_source_value', | ||
| 155 | 'unit_source_concept_id', | ||
| 156 | 'value_source_value', | ||
| 157 | 'measurement_event_id', | ||
| 158 | 'meas_event_field_concept_id', | ||
| 159 | ], | ||
| 160 | "OBSERVATION" => [ | ||
| 161 | 'observation_id', | ||
| 162 | 'person_id', | ||
| 163 | 'observation_concept_id', | ||
| 164 | 'observation_date', | ||
| 165 | 'observation_datetime', | ||
| 166 | 'observation_type_concept_id', | ||
| 167 | 'value_as_number', | ||
| 168 | 'value_as_string', | ||
| 169 | 'value_as_concept_id', | ||
| 170 | 'qualifier_concept_id', | ||
| 171 | 'unit_concept_id', | ||
| 172 | 'provider_id', | ||
| 173 | 'visit_occurrence_id', | ||
| 174 | 'visit_detail_id', | ||
| 175 | 'observation_source_value', | ||
| 176 | 'observation_source_concept_id', | ||
| 177 | 'unit_source_value', | ||
| 178 | 'qualifier_source_value', | ||
| 179 | 'value_source_value', | ||
| 180 | 'observation_event_id', | ||
| 181 | 'obs_event_field_concept_id', | ||
| 182 | ], | ||
| 183 | "PERSON" => [ | ||
| 184 | 'person_id', | ||
| 185 | 'gender_concept_id', | ||
| 186 | 'year_of_birth', | ||
| 187 | 'month_of_birth', | ||
| 188 | 'day_of_birth', | ||
| 189 | 'birth_datetime', | ||
| 190 | 'race_concept_id', | ||
| 191 | 'ethnicity_concept_id', | ||
| 192 | 'location_id', | ||
| 193 | 'provider_id', | ||
| 194 | 'care_site_id', | ||
| 195 | 'person_source_value', | ||
| 196 | 'gender_source_value', | ||
| 197 | 'gender_source_concept_id', | ||
| 198 | 'race_source_value', | ||
| 199 | 'race_source_concept_id', | ||
| 200 | 'ethnicity_source_value', | ||
| 201 | 'ethnicity_source_concept_id', | ||
| 202 | ], | ||
| 203 | "PROCEDURE_OCCURRENCE" => [ | ||
| 204 | 'procedure_occurrence_id', | ||
| 205 | 'person_id', | ||
| 206 | 'procedure_concept_id', | ||
| 207 | 'procedure_date', | ||
| 208 | 'procedure_datetime', | ||
| 209 | 'procedure_end_date', | ||
| 210 | 'procedure_end_datetime', | ||
| 211 | 'procedure_type_concept_id', | ||
| 212 | 'modifier_concept_id', | ||
| 213 | 'quantity', | ||
| 214 | 'provider_id', | ||
| 215 | 'visit_occurrence_id', | ||
| 216 | 'visit_detail_id', | ||
| 217 | 'procedure_source_value', | ||
| 218 | 'procedure_source_concept_id', | ||
| 219 | 'modifier_source_value', | ||
| 220 | ], | ||
| 221 | "SPECIMEN" => [ | ||
| 222 | 'specimen_id', | ||
| 223 | 'person_id', | ||
| 224 | 'specimen_concept_id', | ||
| 225 | 'specimen_type_concept_id', | ||
| 226 | 'specimen_date', | ||
| 227 | 'specimen_datetime', | ||
| 228 | 'quantity', | ||
| 229 | 'unit_concept_id', | ||
| 230 | 'anatomic_site_concept_id', | ||
| 231 | 'disease_status_concept_id', | ||
| 232 | 'specimen_source_id', | ||
| 233 | 'specimen_source_value', | ||
| 234 | 'unit_source_value', | ||
| 235 | 'anatomic_site_source_value', | ||
| 236 | 'disease_status_source_value', | ||
| 237 | ], | ||
| 238 | "VISIT_OCCURRENCE" => [ | ||
| 239 | 'visit_occurrence_id', | ||
| 240 | 'person_id', | ||
| 241 | 'visit_concept_id', | ||
| 242 | 'visit_start_date', | ||
| 243 | 'visit_start_datetime', | ||
| 244 | 'visit_end_date', | ||
| 245 | 'visit_end_datetime', | ||
| 246 | 'visit_type_concept_id', | ||
| 247 | 'provider_id', | ||
| 248 | 'care_site_idvisit_source_value', | ||
| 249 | 'visit_source_concept_id', | ||
| 250 | 'admitted_from_concept_id', | ||
| 251 | 'admitted_from_source_value', | ||
| 252 | 'discharged_to_concept_id', | ||
| 253 | 'discharged_to_source_value', | ||
| 254 | 'preceding_visit_occurrence_id', | ||
| 255 | ], | ||
| 256 | }; | ||
| 257 | |||
| 258 | 140 | our @stream_ram_memory_tables = qw/CONCEPT PERSON VISIT_OCCURRENCE/; | |