Screening (enrollment date, informed consent date)

Enrollment & Informed Consent - Variable Definition Table:

Field Name

Description

Field Values
Enrollment date Date the participant enrolled format: YYYY-MM
Informed consent date Informed consent date format: YYYY-MM


Tables that Reference these Variables:

  • Enrollment


Data Type Information:

Field Name

Type

Mode
enrollment_date STRING NULLABLE
informed_consent_date STRING NULLABLE


Curation Notations:

Query Definition
Enrollment.Enrollment_months_after_baseline is not null OR Enrollment.informed_consent_months_after_baseline is not null

Clinical Data Forms Queried (available as a BigQuery Table and csv File)
Enrollment

Criteria
enrollment_months_after_baseline is not null
informed_consent_months_after_baseline is not null
OR

Query
SELECT left(participant_id, 2) Cohort, count(distinct participant_id) Count from `amp-pd-research.2021_v2_5release_0510.Enrollment` WHERE enrollment_months_after_baseline is not null OR informed_consent_months_after_baseline is not null GROUP BY Cohort ORDER BY Cohort