Data Management with FHIR
0.1.0 - ci-build

Data Management with FHIR - Local Development build (v0.1.0) built by the FHIR (HL7® FHIR® Standard) Build Tools. See the Directory of published versions

## Logical Model: Note OMOP Table

Official URL: https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPNote | Version: 0.1.0
Draft as of 2025-10-23 | Computable Name: OMOPNote

The NOTE table captures unstructured information that was recorded by a provider about a patient in free text (in ASCII, or preferably in UTF8 format) notes on a given date. The type of note_text is CLOB or varchar(MAX) depending on RDBMS.

Usages:

- Refer to this Logical Model: Note NLP OMOP Table

You can also check for usages in the FHIR IG Statistics

### Formal Views of Profile Content

Description of Profiles, Differentials, Snapshots and how the different presentations work.

- Key Elements Table
- Differential Table
- Snapshot Table
- Statistics/References
- All

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
OMOPNote |  | 0..* | Base | Note OMOP Table Instances of this logical model can be the target of a Reference
note_id |  | 1..1 | integer | Note Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
note_date |  | 1..1 | date | Note Date
note_datetime |  | 0..1 | dateTime | Note Datetime
note_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Type
note_class_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Class
note_title |  | 0..1 | string | Title
note_text |  | 1..1 | string | Text
encoding_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Encoding
language_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Language
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
visit_occurrence_id |  | 0..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurence
visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Visit Detail
note_source_value |  | 0..1 | string | Note Source Value
note_event_id |  | 0..1 | integer | Note Event
note_event_field_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Note Event Field
Documentation for this format

This structure is derived from Base

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
OMOPNote |  | 0..* | Base | Note OMOP Table Instances of this logical model can be the target of a Reference
note_id |  | 1..1 | integer | Note Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
note_date |  | 1..1 | date | Note Date
note_datetime |  | 0..1 | dateTime | Note Datetime
note_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Type
note_class_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Class
note_title |  | 0..1 | string | Title
note_text |  | 1..1 | string | Text
encoding_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Encoding
language_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Language
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
visit_occurrence_id |  | 0..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurence
visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Visit Detail
note_source_value |  | 0..1 | string | Note Source Value
note_event_id |  | 0..1 | integer | Note Event
note_event_field_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Note Event Field
Documentation for this format

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
OMOPNote |  | 0..* | Base | Note OMOP Table Instances of this logical model can be the target of a Reference
note_id |  | 1..1 | integer | Note Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
note_date |  | 1..1 | date | Note Date
note_datetime |  | 0..1 | dateTime | Note Datetime
note_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Type
note_class_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Class
note_title |  | 0..1 | string | Title
note_text |  | 1..1 | string | Text
encoding_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Encoding
language_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Language
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
visit_occurrence_id |  | 0..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurence
visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Visit Detail
note_source_value |  | 0..1 | string | Note Source Value
note_event_id |  | 0..1 | integer | Note Event
note_event_field_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Note Event Field
Documentation for this format

This structure is derived from Base

Résumé

Mandatory: 0 element(8 nested mandatory elements)

Structures

This structure refers to these other structures:

- Person OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPPerson)
- Concept OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPConcept)
- Provider OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPProvider)
- Visit Occurrence OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPVisitOccurrence)
- Visit Detail OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPVisitDetail)

Key Elements View

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
OMOPNote |  | 0..* | Base | Note OMOP Table Instances of this logical model can be the target of a Reference
note_id |  | 1..1 | integer | Note Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
note_date |  | 1..1 | date | Note Date
note_datetime |  | 0..1 | dateTime | Note Datetime
note_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Type
note_class_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Class
note_title |  | 0..1 | string | Title
note_text |  | 1..1 | string | Text
encoding_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Encoding
language_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Language
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
visit_occurrence_id |  | 0..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurence
visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Visit Detail
note_source_value |  | 0..1 | string | Note Source Value
note_event_id |  | 0..1 | integer | Note Event
note_event_field_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Note Event Field
Documentation for this format

Differential View

This structure is derived from Base

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
OMOPNote |  | 0..* | Base | Note OMOP Table Instances of this logical model can be the target of a Reference
note_id |  | 1..1 | integer | Note Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
note_date |  | 1..1 | date | Note Date
note_datetime |  | 0..1 | dateTime | Note Datetime
note_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Type
note_class_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Class
note_title |  | 0..1 | string | Title
note_text |  | 1..1 | string | Text
encoding_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Encoding
language_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Language
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
visit_occurrence_id |  | 0..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurence
visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Visit Detail
note_source_value |  | 0..1 | string | Note Source Value
note_event_id |  | 0..1 | integer | Note Event
note_event_field_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Note Event Field
Documentation for this format

Snapshot View

Nom | Drapeaux | Card. | Type | Description et contraintes Filter: Bindings Constraints Obligations
--- | --- | --- | --- | ---
OMOPNote |  | 0..* | Base | Note OMOP Table Instances of this logical model can be the target of a Reference
note_id |  | 1..1 | integer | Note Identifier
person_id |  | 1..1 | Reference(Person OMOP Table) | Person
note_date |  | 1..1 | date | Note Date
note_datetime |  | 0..1 | dateTime | Note Datetime
note_type_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Type
note_class_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Note Class
note_title |  | 0..1 | string | Title
note_text |  | 1..1 | string | Text
encoding_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Encoding
language_concept_id |  | 1..1 | Reference(Concept OMOP Table) | Language
provider_id |  | 0..1 | Reference(Provider OMOP Table) | Provider
visit_occurrence_id |  | 0..1 | Reference(Visit Occurrence OMOP Table) | Visit Occurence
visit_detail_id |  | 0..1 | Reference(Visit Detail OMOP Table) | Visit Detail
note_source_value |  | 0..1 | string | Note Source Value
note_event_id |  | 0..1 | integer | Note Event
note_event_field_concept_id |  | 0..1 | Reference(Concept OMOP Table) | Note Event Field
Documentation for this format

This structure is derived from Base

Résumé

Mandatory: 0 element(8 nested mandatory elements)

Structures

This structure refers to these other structures:

- Person OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPPerson)
- Concept OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPConcept)
- Provider OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPProvider)
- Visit Occurrence OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPVisitOccurrence)
- Visit Detail OMOP Table (https://interop.aphp.fr/ig/fhir/dm/StructureDefinition/OMOPVisitDetail)

Other representations of profile: CSV, Excel