ID

35294

Beskrivning

OMOP Common Data Model (CDM) Note The NOTE table captures unstructured information that was recorded by a provider about a patient in free text notes on a given date. OMOP Common Data Model Version 6.0 Specifications 11October2018. The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medical products. © 2014 Observational Health Data Sciences and Informatics This work is based on work by the Observational Medical Outcomes Partnership (OMOP) and used under license from the FNIH at http://omop.fnih.org/publiclicense. Version updated on 26.02.2019, from https://github.com/OHDSI/CommonDataModel/wiki/NOTE The NOTE table contains free text (in ASCII, or preferably in UTF8 format) taken by a healthcare Provider. The Visit during which the note was written is recorded through a reference to the VISIT_OCCURRENCE table. This information is not always available. The Provider making the note is recorded through a reference to the PROVIDER table. This information is not always available. NOTE_CLASS_CONCEPT_ID is a foreign key to the CONCEPT table to describe a standardized combination of five LOINC axes (role, domain, setting, type of service, and document kind). For more information, see https://github.com/OHDSI/CommonDataModel/wiki/NOTE

Länk

http://omop.fnih.org/publiclicense

Nyckelord

Versioner (3)
  1. 2017-01-04 2017-01-04 -
  2. 2019-02-12 2019-02-12 -
  3. 2019-02-26 2019-02-26 -
Rättsinnehavare

Observational Medical Outcomes Partnership (OMOP)

Uppladdad den

26 februari 2019

DOI

För en begäran logga in.

Licens

Creative Commons BY-NC 3.0
Modellkommentarer :

Här kan du kommentera modellen. Med hjälp av pratbubblor i Item-grupperna och Item kan du lägga in specifika kommentarer.

Tillbaka till modellkommentarer
Itemgroup-kommentar för :

Item-kommentar för :

Du måste vara inloggad för att kunna ladda ner formulär. Var vänlig logga in eller registrera dig utan kostnad.

OMOP Common Data Model (CDM) Note

Engelsk

OMOP Common Data Model (CDM) Note

1 Formulär  
Note
Beskrivning

Note

Alias
UMLS CUI-1
C1317574
UMLS CUI-2
C0947611
Note ID
Beskrivning

A unique identifier for each note.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C1300638
Person ID
Beskrivning

A foreign key identifier to the person about whom the note was recorded. The demographic details of that person are stored in the person table.

Datatyp

integer

Alias
UMLS CUI [1,1]
C0027361
UMLS CUI [1,2]
C1300638
Note event ID
Beskrivning

A foreign key identifier to the event (e.g. Measurement, Procedure, Visit, Drug Exposure, etc) record during which the note was recorded.

Datatyp

integer

Alias
UMLS CUI [1,1]
C0441471
UMLS CUI [1,2]
C1317574
UMLS CUI [1,3]
C1300638
Note event field concept ID
Beskrivning

A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the field to which the note_event_id is referring.

Datatyp

integer

Alias
UMLS CUI [1,1]
C0441471
UMLS CUI [1,2]
C1521738
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Note date
Beskrivning

The date the note was recorded.

Datatyp

date

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C0011008
Note datetime
Beskrivning

The date and time the note was recorded.

Datatyp

datetime

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C0011008
UMLS CUI [2,1]
C1317574
UMLS CUI [2,2]
C0040223
Note type concept ID
Beskrivning

A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the type, origin or provenance of the Note. These belong to the 'Note Type' vocabulary.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Note class concept ID
Beskrivning

A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the HL7 LOINC Document Type Vocabulary classification of the note. NOTE_CLASS_CONCEPT_ID is a foreign key to the CONCEPT table to describe a standardized combination of five LOINC axes (role, domain, setting, type of service, and document kind). See below for description.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C0008902
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Note title
Beskrivning

The title of the Note as it appears in the source. (Type varchar(250))

Datatyp

text

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C3888414
Note text
Beskrivning

The content of the Note. (Type varchar(MAX))

Datatyp

text

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C1527021
Encoding concept ID
Beskrivning

A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the note character encoding type.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C0009219
UMLS CUI [1,3]
C0332307
Language concept ID
Beskrivning

A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the language of the note

Datatyp

integer

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C0023008
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Provider ID
Beskrivning

A foreign key to the Provider in the PROVIDER table who took the Note.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1138603
UMLS CUI [1,2]
C1300638
Visit occurrence ID
Beskrivning

A foreign key to the Visit in the VISIT_OCCURRENCE table when the Note was taken.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Visit detail ID
Beskrivning

A foreign key to the Visit in the VISIT_DETAIL table when the Note was taken.

Datatyp

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C1522508
UMLS CUI [1,3]
C1300638
Note source value
Beskrivning

The source value associated with the origin of the note. (Type varchar(50))

Datatyp

text

Alias
UMLS CUI [1,1]
C1317574
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C1522609
Tillbaka till toppen

Similar models

OMOP Common Data Model (CDM) Note

1 Formulär
Name
Typ
Description | Question | Decode (Coded Value)
Datatyp
Alias
Item Group
Note
C1317574 (UMLS CUI-1)
C0947611 (UMLS CUI-2)
Note ID
Item
Note ID
integer
C1317574 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Person ID
Item
Person ID
integer
C0027361 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Note event ID
Item
Note event ID
integer
C0441471 (UMLS CUI [1,1])
C1317574 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Note event field concept ID
Item
Note event field concept ID
integer
C0441471 (UMLS CUI [1,1])
C1521738 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Note date
Item
Note date
date
C1317574 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
Note datetime
Item
Note datetime
datetime
C1317574 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
C1317574 (UMLS CUI [2,1])
C0040223 (UMLS CUI [2,2])
Note type concept ID
Item
Note type concept ID
integer
C1317574 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Note class concept ID
Item
Note class concept ID
integer
C1317574 (UMLS CUI [1,1])
C0008902 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Note title
Item
Note title
text
C1317574 (UMLS CUI [1,1])
C3888414 (UMLS CUI [1,2])
Note text
Item
Note text
text
C1317574 (UMLS CUI [1,1])
C1527021 (UMLS CUI [1,2])
Encoding concept ID
Item
Encoding concept ID
integer
C1317574 (UMLS CUI [1,1])
C0009219 (UMLS CUI [1,2])
C0332307 (UMLS CUI [1,3])
Language concept ID
Item
Language concept ID
integer
C1317574 (UMLS CUI [1,1])
C0023008 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Provider ID
Item
Provider ID
integer
C1138603 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Visit occurrence ID
Item
Visit occurrence ID
integer
C1512346 (UMLS CUI [1,1])
C2745955 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Visit detail ID
Item
Visit detail ID
integer
C1512346 (UMLS CUI [1,1])
C1522508 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Note source value
Item
Note source value
text
C1317574 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C1522609 (UMLS CUI [1,3])
Tillbaka till toppen 

Kontakt

Använd detta formulär för feedback, frågor och förslag på förbättringar.

Fält markerade med * är obligatoriska.

Hjälp

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial