< Back To Home
/
Diagnosis and Change in Diagnosis

Diagnosis and Change in Diagnosis

Diagnosis and Change in Diagnosis - Variable Definition Table:

Field Name	Description	Values
diagnosis	The diagnosis is an opportunity for the site investigator to give their opinion on a participant's most likely clinical diagnosis, regardless of cohort. The diagnosis may change over time because the site investigator may update the diagnosis at every longitudinal visit based on their opinion.	No PD Nor Other Idiopathic PD Parkinson's Disease Prodromal non-motor PD Prodromal motor PD	No PD no Other Multiple System Atrophy Essential Tremor Progressive Other Neurological Parkinsonism Demential with Lewy Corticobasal
initial_diagnosis	Initial diagnosis
most_recent_diagnosis	Most recent diagnosis
change_in_diagnosis	Change in diagnosis indicator	Yes No Null
change_in_diagnosis_date	Change in diagnosis date	YYYY-MM format
date_of_pd_diagnosis	Date of Parkinson's disease diagnosis	YYYY-MM format
age_at_diagnosis	Age at Parkinson's disease diagnosis	###

Tables that Reference this Variable:

PD Medical History

Data Type Information:

Field Name	Type	Mode
diagnosis	STRING	NULLABLE
initial_diagnosis	STRING	NULLABLE
most_recent_diagnosis	STRING	NULLABLE
change_in_diagnosis	STRING	NULLABLE
change_in_diagnosis_date	STRING	NULLABLE
date_of_pd_diagnosis	STRING	NULLABLE
age_at_diagnosis	INTEGER	NULLABLE

Curation Notations:

Appropriate Diagnosis (APPRDX) in PPMI and BioFIND were used as Study Arm and Most Likely Primary Diagnosis (PRIMDIAG) was used as Diagnosis. In PDBP Case/Control were used to identify three Study Arm values.
Diagnosis in PDBP were cleaned and standardized as suggested by CDH group.
Blank diagnosis values were filled with the value from the previous visit based on the participant_id. When a change in diagnosis occurs between visits (PDBP), the new diagnosis was associated with whichever visit is closest to the change date. The closest visit may be before the date of change logged in the system. These updates were completed manually.

Query Definition

PD_Medical_History.diagnosis is not null OR PD_Medical_History.change_in_diagnosis = "Yes"

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

PD_Medical_History

Criteria

diagnosis is not null

change_in_diagnosis = "Yes"

Query

SELECT left(participant_id, 2) Cohort, count(distinct participant_id) Count from `amp-pd-research.2021_v2_5release_0510.PD_Medical_History` WHERE diagnosis is not null OR change_in_diagnosis = "Yes" GROUP BY Cohort ORDER BY Cohort

Diagnosis and Change in Diagnosis