Visit_Name
Visit Name Variable Definition Table:
Field Name |
Description |
Field Values |
|
---|---|---|---|
Visit Name | Visit name: M - in months, SC - screening visit, LOG - records without visit; #2 or #3 define repeated records at the same visit or repeated visit |
M0 M12 M24 M36 M48 |
M60 M42 M0#2 SC M54 |
Tables that Reference this Variable:
|
|
|
Data Type Information:
Field Name |
Type |
Mode |
---|---|---|
Visit_Name | String | Required |
Curation Notations:
There are discrepancies across the cohorts in coding of baseline and screening visits. In some studies, screening takes place during the baseline visit, whereas in other studies screening takes place during a separate precursor visit.
- Baseline visits were labeled as M0 (month 0), with follow up visits as M1, M2, etc.
- Screening visits were labeled as SC.
- Visit 2 in BioFIND (week 2 visit) was labeled as M0_5.
- If repeated record at the same visit #2 or #3 were added to visit label (e.g. M12, M12#2, etc.)
PPMI visits RS1, U01, U02, PW, ST were re-labeled using following approach:
- RS1 – Re-screen visit was labeled SC#2
- PW – Premature Withdrawal visits were aligned with closest to scheduled visit month difference calculated between dates of Baseline (M0) and PW visit using INFODT (e.g. if participant has M6 and M9 scheduled visits, PW visit would be M6 if month difference is 7 months).
- U01, U02 – Unscheduled Visit 1 and 2 were aligned with closest to scheduled visit month difference calculated between dates of Baseline (M0) and unscheduled visit using INFODT. In “Biospecimen_analyses_CSF_abeta_tau_ptau.csv” and “DaTSCAN_SBR.csv” unscheduled visits are manually replaced (after transform1 automatic run) by “visit_name” from “PPMI Unexpected Visit Listings - DATSCAN and CSF data_May2019.xlsx” provided by Clinical Trials Statistical & Data Management Center, University of Iowa.
- ST visits – Symptomatic Therapy visits were re-labeled with the regular visit label (e.g. V01=M3, V02=M6, V03=M9, V04=M12, etc.) using “ST Replaces Visit (STRPLCVS)” from ST_CATALOG.csv. If an ST visit replaced V01 or V03, then per protocol the subject was supposed to skip V02 or V04, respectively. V01 and V03 in “STRPLCVS” were replaced by V02 and V04 only if V02 or V04 are missing, otherwise V01 and V03 were used (few cases where protocol was not followed).
- 8 participants do not have STRPLCVS in ST_CATALOG.csv. For these the date difference was calculated, and the closest visit was used to replace ST (e.g. if PP-3067 has date difference 22 months then ST is M24; if PP-3078 has date difference 19 months then ST is M18; if PP-3653 has date difference 19 months then ST is M18).
- The “LOG” visits were used to indicate that the time points are irrelevant for this particular data set (e.g. Smoking_and_alcohol_history.csv, Caffeine_history.csv, etc.), or for unscheduled/unknown visits where no date of visit is available.
Query Definition
Clinical Data Forms Queried (available as a BigQuery Table and csv File)
Criteria
Query
Demographics.visit_name is not null
Clinical Data Forms Queried (available as a BigQuery Table and csv File)
Demographics
Criteria
visit_name is not null
Query
SELECT left(participant_id, 2) Cohort, count(distinct participant_id) Count from `amp-pd-research.2021_v2_5release_0510.Demographics` WHERE visit_name is not null GROUP BY Cohort ORDER BY Cohort