Title: | OMOP Note |
Access field: | 20142 (Present in OMOP dataset) |
Table name | omop_note | Table group | OMOP | Debut | Feb 2023 | ||
Row count | 17,000+ | Parent table | n/a | Version | Feb 2023 | ||
Size | 2MB | Stability | Complete | Cost Tier | d2 o2 s2 |
Title: | OMOP Note |
Access field: | 20142 (Present in OMOP dataset) |
Table name | omop_note | Table group | OMOP | Debut | Feb 2023 | ||
Row count | 17,000+ | Parent table | n/a | Version | Feb 2023 | ||
Size | 2MB | Stability | Complete | Cost Tier | d2 o2 s2 |
WARNING: the interactive features of this website use CSS3, which your browser does not support. To use the full features of this website, please update your browser.
# | Column | Type | Notes |
---|---|---|---|
1 | eid | integer | A foreign key identifier to the Person about whom the Note was recorded. |
2 | encoding_concept_id | integer | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the note character encoding type. |
3 | language_concept_id | integer | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the language of the note. |
4 | note_class_concept_id | integer | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the HL7 LOINC Document Type Vocabulary classification of the note. |
5 | note_date | date | The date the note was recorded. |
6 | note_datetime | timestamp | The date and time the note was recorded. |
7 | note_id | integer | A unique identifier for each note. |
8 | note_source_value | integer | |
9 | note_text | string | The content of the Note. |
10 | note_title | string | The title of the Note as it appears in the source. |
11 | note_type_concept_id | integer | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the type, origin or provenance of the Note. |
12 | provider_id | integer | A foreign key to the Provider in the PROVIDER table who took the Note. |
13 | visit_detail_id | integer | |
14 | visit_occurrence_id | integer | Foreign key to the Visit in the VISIT_OCCURRENCE table when the Note was taken. |
Table ID | Table | Title |
---|---|---|
924 | omop_condition_era | OMOP Condition Era |
925 | omop_condition_occurrence | OMOP Condition Occurrence |
926 | omop_death | OMOP Death |
927 | omop_device_exposure | OMOP Device Exposure |
928 | omop_dose_era | OMOP Dose Era |
929 | omop_drug_era | OMOP Drug Era |
930 | omop_drug_exposure | OMOP Drug Exposure |
931 | omop_measurement | OMOP Measurement |
933 | omop_observation | OMOP Observation Period |
934 | omop_observation_period | OMOP Observation |
935 | omop_person | OMOP Person |
936 | omop_procedure_occurrence | OMOP Procedure Occurrence |
937 | omop_specimen | OMOP Specimen |
938 | omop_visit_detail | OMOP Visit Detail |
939 | omop_visit_occurrence | OMOP Visit Occurrence |
Enabling scientific discoveries that improve human health