ID

35349

Beschreibung

OMOP Common Data Model (CDM) Survey Conduct The SURVEY_CONDUCT table is used to store an instance of a completed survey or questionnaire. It captures details of the individual questionnaire such as who completed it, when it was completed and to which patient treatment or visit it relates to (if any). Each SURVEY has a SURVEY_CONCEPT_ID, a concept in the CONCEPT table identifying the questionnaire e.g. EQ5D, VR12, SF12. Each questionnaire should exist in the CONCEPT table. Each SURVEY can be optionally related to a specific patient visit in order to link it both to the visit during which it was completed and any subsequent visit where treatment was assigned based on the patient's responses. 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. Version updated on 01.03.2019, from https://github.com/OHDSI/CommonDataModel/wiki/SURVEY_CONDUCT. Patient responses to survey questions are stored in the OBSERVATION table. Each record in the OBSERVATION table represents a single question/response pair and is linked to a specific SURVEY/questionnaire using OBSERVATION.DOMAIN_OCCURRENCE_ID and SURVEY.SURVEY_OCCURRENCE_ID. Each response record is the response to a specific question identified by the OBSERVATION_CONCEPT_ID. This concept ID is a unique question contained in the CONCEPT table. An individual survey question can have multiple responses to a question (e.g. which of these items relate to you, a, b, c ,…?). Each response is stored as a separate record in the OBSERVATION table. The name (question) is stored as OBSERVATION_CONCEPT_ID and the value (answer) is stored as OBSERVATION_AS_CONCEPT_ID where the answer is categorical and is defined as a concept in the concept table, OBSERVATION_AS_NUMBER where the answer is numeric, OBSERVATION_AS_STRING where the answer is a free text string or OBSERVATION_AS_DATETIME. The question / answer observation record is linked to the patient questionnaire used for collecting the data using two new fields in the OBSERVATION table; DOMAIN_ID and DOMAIN_OCCURRENCE_ID. DOMAIN_ID for any survey related observations contains the text ‘Survey’ and DOMAIN_OCCURRENCE_ID contains the SURVEY_OCCURRENCE_ID of the specific survey. This domain construct can be used for other observation groupings. The OBSERVATION table can also store survey scoring results. Many validated PRO questionnaires have scoring algorithms (many of which proprietary) that return an overall patient score based on the answers provided. Survey scores are identified by their OBSERVATION_CONCEPT_ID and are linked back to the scored survey using the same DOMAIN construct described. For more information, please see: https://github.com/OHDSI/CommonDataModel/wiki/SURVEY_CONDUCT

Link

https://github.com/OHDSI/CommonDataModel/wiki/SURVEY_CONDUCT

Stichworte

Versionen (1)
  1. 01.03.19 01.03.19 -
Rechteinhaber

Observational Medical Outcomes Partnership (OMOP)

Hochgeladen am

1. März 2019

DOI

Für eine Beantragung loggen Sie sich ein.

Lizenz

Creative Commons BY-NC 3.0
Modell Kommentare :

Hier können Sie das Modell kommentieren. Über die Sprechblasen an den Itemgruppen und Items können Sie diese spezifisch kommentieren.

Zurück zu Modell Kommentaren
Itemgroup Kommentare für :

Item Kommentare für :

Um Formulare herunterzuladen müssen Sie angemeldet sein. Bitte loggen Sie sich ein oder registrieren Sie sich kostenlos.

OMOP Common Data Model (CDM)

Englisch

Survey Conduct

1 Formulare  
  1. StudyEvent: ODM
    1. Survey Conduct
Survey Conduct
Beschreibung

Survey Conduct

Alias
UMLS CUI-1
C0260857
Survey Conduct ID
Beschreibung

Unique identifier for each completed survey.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C1300638
Person ID
Beschreibung

A foreign key identifier to the Person in the PERSON table about whom the survey was completed.

Datentyp

integer

Alias
UMLS CUI [1]
C2348585
Survey concept ID
Beschreibung

A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the name and identity of the survey.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Survey start date
Beschreibung

Date on which the survey was started.

Datentyp

date

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C0011008
Survey start datetime
Beschreibung

Date and time the survey was started.

Datentyp

datetime

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C0808070
UMLS CUI [1,3]
C1301880
Survey end date
Beschreibung

Date on which the survey was completed.

Datentyp

date

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C0806020
Survey end datetime
Beschreibung

Date and time on which the survey was completed.

Datentyp

datetime

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C0806020
UMLS CUI [1,3]
C1522314
Provider ID
Beschreibung

A foreign key to the provider in the provider table who was associated with the survey completion.

Datentyp

integer

Alias
UMLS CUI [1,1]
C1138603
UMLS CUI [1,2]
C1300638
Assisted concept ID
Beschreibung

A foreign key to the predefined Concept identifier in the Standardized Vocabularies indicating whether the survey was completed with assistance.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C1521721
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Respondent type concept ID
Beschreibung

A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the respondent type. Example: Research Associate, Patient.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0282122
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Timing concept ID
Beschreibung

A foreign key to the predefined Concept identifier in the Standardized Vocabularies that refers to a certain timing. Example: 3 month follow-up, 6 month follow-up.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0449243
UMLS CUI [1,2]
C0178566
UMLS CUI [1,3]
C1300638
Collection method concept ID
Beschreibung

A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the data collection method (e.g. Paper, Telephone, Electronic Questionnaire).

Datentyp

integer

Alias
UMLS CUI [1,1]
C0010995
UMLS CUI [1,2]
C0025663
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Assisted source value
Beschreibung

Source value representing whether patient required assistance to complete the survey. Example: “Completed without assistance”, ”Completed with assistance”. (Type varchar(50))

Datentyp

text

Alias
UMLS CUI [1,1]
C0034394
UMLS CUI [1,2]
C1115437
UMLS CUI [1,3]
C1521721
Respondent type source value
Beschreibung

Source code representing role of person who completed the survey. (Type varchar(100))

Datentyp

text

Alias
UMLS CUI [1,1]
C0282122
UMLS CUI [1,2]
C0332307
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C0805701
Timing source value
Beschreibung

Text string representing the timing of the survey. Example: Baseline, 6-month follow-up. (Type varchar(100))

Datentyp

text

Alias
UMLS CUI [1,1]
C0449243
UMLS CUI [1,2]
C0449416
UMLS CUI [1,3]
C0805701
Collection method source value
Beschreibung

The collection method as it appears in the source data. (Type varchar(100))

Datentyp

text

Alias
UMLS CUI [1,1]
C0010995
UMLS CUI [1,2]
C0025663
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C0805701
Survey source value
Beschreibung

The survey name/title as it appears in the source data. (Type varchar(100))

Datentyp

text

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C3888414
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C1522609
Survey source concept ID
Beschreibung

A foreign key to a predefined Concept that refers to the code for the survey name/title used in the source.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C3888414
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C0178566
UMLS CUI [1,5]
C1300638
Survey source identifier
Beschreibung

Unique identifier for each completed survey in source system.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C1115437
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C2349022
Validated survey concept ID
Beschreibung

A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the validation status of the survey.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C1519941
UMLS CUI [1,3]
C0178566
UMLS CUI [1,4]
C1300638
Validated survey source value
Beschreibung

Source value representing the validation status of the survey.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C1519941
UMLS CUI [1,3]
C0449416
UMLS CUI [1,4]
C1522609
Survey version number
Beschreibung

Version number of the questionnaire or survey used. (Type varchar(20))

Datentyp

text

Alias
UMLS CUI [1,1]
C0260857
UMLS CUI [1,2]
C0333052
UMLS CUI [1,3]
C0237753
UMLS CUI [2,1]
C0034394
UMLS CUI [2,2]
C0333052
UMLS CUI [2,3]
C0237753
Visit occurrence ID
Beschreibung

A foreign key to the VISIT_OCCURRENCE table during which the survey was completed

Datentyp

integer

Alias
UMLS CUI [1,1]
C1512346
UMLS CUI [1,2]
C2745955
UMLS CUI [1,3]
C1300638
Response visit occurrence ID
Beschreibung

A foreign key to the visit in the VISIT_OCCURRENCE table during which treatment was carried out that relates to this survey.

Datentyp

integer

Alias
UMLS CUI [1,1]
C0521982
UMLS CUI [1,2]
C1512346
UMLS CUI [1,3]
C2745955
UMLS CUI [1,4]
C1300638
Zum Seitenanfang zurückkehren

Ähnliche Modelle

Survey Conduct

1 Formulare
  1. StudyEvent: ODM
    1. Survey Conduct
Name
Typ
Description | Question | Decode (Coded Value)
Datentyp
Alias
Item Group
Survey Conduct
C0260857 (UMLS CUI-1)
Survey Conduct ID
Item
Survey Conduct ID
integer
C0260857 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Person ID
Item
Person ID
integer
C2348585 (UMLS CUI [1])
Survey concept ID
Item
Survey concept ID
integer
C0260857 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Survey start date
Item
Survey start date
date
C0260857 (UMLS CUI [1,1])
C0011008 (UMLS CUI [1,2])
Survey start datetime
Item
Survey start datetime
datetime
C0260857 (UMLS CUI [1,1])
C0808070 (UMLS CUI [1,2])
C1301880 (UMLS CUI [1,3])
Survey end date
Item
Survey end date
date
C0260857 (UMLS CUI [1,1])
C0806020 (UMLS CUI [1,2])
Survey end datetime
Item
Survey end datetime
datetime
C0260857 (UMLS CUI [1,1])
C0806020 (UMLS CUI [1,2])
C1522314 (UMLS CUI [1,3])
Provider ID
Item
Provider ID
integer
C1138603 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Assisted concept ID
Item
Assisted concept ID
integer
C0260857 (UMLS CUI [1,1])
C1521721 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Respondent type concept ID
Item
Respondent type concept ID
integer
C0282122 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Timing concept ID
Item
Timing concept ID
integer
C0449243 (UMLS CUI [1,1])
C0178566 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Collection method concept ID
Item
Collection method concept ID
integer
C0010995 (UMLS CUI [1,1])
C0025663 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Assisted source value
Item
Assisted source value
text
C0034394 (UMLS CUI [1,1])
C1115437 (UMLS CUI [1,2])
C1521721 (UMLS CUI [1,3])
Respondent type source value
Item
Respondent type source value
text
C0282122 (UMLS CUI [1,1])
C0332307 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C0805701 (UMLS CUI [1,4])
Timing source value
Item
Timing source value
text
C0449243 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
C0805701 (UMLS CUI [1,3])
Collection method source value
Item
Collection method source value
text
C0010995 (UMLS CUI [1,1])
C0025663 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C0805701 (UMLS CUI [1,4])
Survey source value
Item
Survey source value
text
C0260857 (UMLS CUI [1,1])
C3888414 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C1522609 (UMLS CUI [1,4])
Survey source concept ID
Item
Survey source concept ID
integer
C0260857 (UMLS CUI [1,1])
C3888414 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C0178566 (UMLS CUI [1,4])
C1300638 (UMLS CUI [1,5])
Survey source identifier
Item
Survey source identifier
integer
C0260857 (UMLS CUI [1,1])
C1115437 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C2349022 (UMLS CUI [1,4])
Validated survey concept ID
Item
Validated survey concept ID
integer
C0260857 (UMLS CUI [1,1])
C1519941 (UMLS CUI [1,2])
C0178566 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Validated survey source value
Item
Validated survey source value
integer
C0260857 (UMLS CUI [1,1])
C1519941 (UMLS CUI [1,2])
C0449416 (UMLS CUI [1,3])
C1522609 (UMLS CUI [1,4])
Survey version number
Item
Survey version number
text
C0260857 (UMLS CUI [1,1])
C0333052 (UMLS CUI [1,2])
C0237753 (UMLS CUI [1,3])
C0034394 (UMLS CUI [2,1])
C0333052 (UMLS CUI [2,2])
C0237753 (UMLS CUI [2,3])
Visit occurrence ID
Item
Visit occurrence ID
integer
C1512346 (UMLS CUI [1,1])
C2745955 (UMLS CUI [1,2])
C1300638 (UMLS CUI [1,3])
Response visit occurrence ID
Item
Response visit occurrence ID
integer
C0521982 (UMLS CUI [1,1])
C1512346 (UMLS CUI [1,2])
C2745955 (UMLS CUI [1,3])
C1300638 (UMLS CUI [1,4])
Zum Seitenanfang zurückkehren 

Kontakt

Benutzen Sie dieses Formular für Rückmeldungen, Fragen und Verbesserungsvorschläge.

Mit * gekennzeichnete Felder sind notwendig.

Hilfe

Benötigen Sie Hilfe bei der Suche? Um mehr Details zu erfahren und die Suche effektiver nutzen zu können schauen Sie sich doch das entsprechende Video auf unserer Tutorial Seite an.

Zum Video