Survey Conduct

  1. StudyEvent: ODM
    1. Survey Conduct
Survey Conduct
Description

Survey Conduct

Alias
UMLS CUI-1
C0260857
Survey Conduct ID
Description

Unique identifier for each completed survey.

Data type

integer

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

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

Data type

integer

Alias
UMLS CUI [1]
C2348585
Survey concept ID
Description

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

Data type

integer

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

Date on which the survey was started.

Data type

date

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

Date and time the survey was started.

Data type

datetime

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

Date on which the survey was completed.

Data type

date

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

Date and time on which the survey was completed.

Data type

datetime

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

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

Data type

integer

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

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

Data type

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
Description

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

Data type

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
Description

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.

Data type

integer

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

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

Data type

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
Description

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

Data type

text

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

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

Data type

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
Description

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

Data type

text

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

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

Data type

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
Description

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

Data type

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
Description

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

Data type

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
Description

Unique identifier for each completed survey in source system.

Data type

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
Description

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

Data type

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
Description

Source value representing the validation status of the survey.

Data type

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
Description

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

Data type

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
Description

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

Data type

integer

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

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

Data type

integer

Alias
UMLS CUI [1,1]
C0521982
UMLS CUI [1,2]
C1512346
UMLS CUI [1,3]
C2745955
UMLS CUI [1,4]
C1300638

Similar models

Survey Conduct

  1. StudyEvent: ODM
    1. Survey Conduct
Name
Type
Description | Question | Decode (Coded Value)
Data type
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])