Tau

Tau - Variable Definition Table:

Field Name

Description

Field Values

Variable Summary
Test Name Name of the biospecimen test
Tau
 		 Analysis of Abeta, Tau, p-Tau in Cerebrospinal Fluid


Tables that Reference this Variable:

  • Biospecimen analysis_CSF_abeta_tau_ptau


Data Type Information:

Field Name

Type

Mode
test_name ENUMERATION REQUIRED


Curation Notations:

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.

Query Definition
Biospecimen_analyses_CSF_abeta_tau_ptau.test_name = 'Tau'

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

Criteria
test_name = 'Tau'

Query
SELECT left(participant_id, 2) Cohort, count(distinct participant_id) Count from `amp-pd-research.2021_v2_5release_0510.Biospecimen_analyses_CSF_abeta_tau_ptau` WHERE test_name = 'Tau' GROUP BY Cohort ORDER BY Cohort