ADO users can filter out specific samples on their SM dashboard to export a CSV file if they wish to perform further analysis on the raw sample data. The data you will export from your dashboard depends on the filters you choose.
Some common scenarios for exporting filtered data are:
-
All requested LTS samples, select the filter LTS requested = Yes and click "Export to CSV".
-
All stored LTS samples, select the filter LTS stored = Yes and click "Export to CSV".
-
All requested QTA samples, select the filter QTA requested = Yes and click "Export to CSV".
-
All completed QTA samples, select the filter QTA completed = Yes and click "Export to CSV".
If you wish to to export data for all samples in your dashboard, leave all the filters blank and click "Export to CSV".
Depending on the filtered data you choose to export, the file will generate fields such as:
-
LTS/QTA: Yes/No
- Location: name of the location where the sample is stored (LTS only)
-
Stored until: date of destruction (LTS only)
-
Reason: reason provided by the Testing Authority for storing the sample (LTS only)
-
Confirmed by lab: Yes/No
-
ADAMS ID of the athlete
-
Sport nationality of the athlete
-
Test Type: In Competition or Out of Competition
-
Sample Collection Date
-
Sample Type: Urine, Blood, DBS, Blood Passport
-
Analyzing lab
-
Date of Analysis
-
Date result reported
-
Test Result
-
Analysis Attributes
-
Sport - Discipline
-
Sample Code
-
Testing Authority (TA)
-
Sample Collection Authority (SCA)
-
Results Management Authority (RMA)