Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field

Column header

Description

Example(s)

Sample Code

sample_code

This is the identifying number on the sample collection kit. 

The sample code must be unique in combination with the sample type, the Lab name and the Date received by the Lab.

"1479265"

Sample Type

sample_type

This specifies the type of sample analyzed.

"URINE"
"BLOOD"

Date Received by Lab

date_received

This specifies the date that the sample was received by the laboratory (yyyy-MM-dd)

"2006-01-12"
"2006-11-28"

Sample Collection Authority

sca

Short name of the ADO organization in charge of the Sample Collection. For the codes see the download centre on our website.

"AIBA"

Testing Authority

ta

This field contains the short-name identifier of the Testing Agency, which is generally the laboratory's customer.  This is a mandatory field for samples reported after January 1st 2015. (ADAMS Release 4.0)

"ITTF"

Test Type

test_type

This field is used to indicate whether the sample was collected in- or out-of-competition

"IC"
"OOC"

Sport

sport_code

This field is used to report the sport of the athlete who contributed the sample.  The WADA sport identifier code must be used in this field, not the sport's name. For the codes see the download centre on our website.

"SK"
"AQ"

Sport discipline

discipline_code

This sport discipline's specific code. For the codes see the download centre on our website.

"SK"
"AQ"

Test result

test_result

Negative, NotAnalyzed, ATF, AAF

"Negative"
"NotAnalyzed" "AAF" , "ATF"

Specific Gravity

specific_gravity

decimal On the UI this corresponds with the field Sample Specific Gravity (Initial Testing Procedure).

value (eg. 1.025)  with 3 digits after comma

Min - Max: [1.001 - 1.050]

1.025
Sample Specific Gravity (Confirmation Procedure)sample_specific_gravity_CP

Introduced in ADAMS Release 7 May 2019

A value indicating the Sample Specific Gravity (Confirmation Procedure) for Urine sample.

value (eg. 1.025)  with 3 digits after comma

Min - Max: [1.001 - 1.050]

For samples with a date_received that is equal to or later than 1 March 2019 AND with a Test result = AAF/ATF, it is mandatory to provide a value for the Sample Specific Gravity (Confirmation Procedure). This is for Urine A/B/B1/B2 samples.

 1.025
Validityvalid

urine sample validity.

For samples with a date_received on or after 16 March 2016 the validity status is calculated automatically based on the provided microbial contamination markers (any values included in the column 'valid' will be disregarded). 

For samples with a date_received before 16 March 2016 the validity column remains mandatory

"Yes" or "No"

Steroid profile variables

Steroid_profile_variable_code[index]

Specific code of the steroid profile variable.This field is mandatory for results received after January 1st 2014

Current codes are: androsterone, epitestosterone, 5b-androstanediol, 5a-androstanediol, testosterone, etiocholanolone, T/E.

Steroid profile variables

Steroid_profile_variable_value[index]

Decimal value or integer as per ADM2 settings for each variable.  

For samples with a received date after 1 Jan 2016, a value of '-2' will be allowed for Epitestosterone.

"12"

Specific gravity

specific_gravity

This field specifies the specific gravity analyzed in the sample. Decimal value with max. 4 digits after the decimal point. Any extra digits will be discarded when saving the results. With the introduction of the Steroid Profile it becomes mandatory with range [1.001 - 1.050] set by Adm2.
This field is mandatory for results received after January 1st 2014

"1.003"
"1.050"

Date of Sample Collection

sample_collection_date

This field contains the sample collection date (yyyy-MM-dd) This field is mandatory for samples with a date received after 1 Jan 2016

"2006-01-28"

Microbial contamination parameters, and confirmation

ratio_5aand_a

ratio_5band_etio

ratio_freet_totalt

ratio_5aand_a_confirmed

ratio_5band_etio_confirmed



These fields become effective for Urine samples (type 'A') with a date received after 16 March 2016.

ratio_5aand_a  and ratio_5band_etio refer to 5aAND/A or 5βAND/Etio and are both mandatory for the screening procedure.

ratio_freet_totalt refers to "Free T/total T", which is not-mandatory.

All are decimal values

Similar for the confirmed values:

ratio_5aand_a_confirmed, ratio_5band_etio_confirmed (ratio_freet_totalt doesn't require confirmation)

For samples other than type 'A' the microbial contamination parameters details are optional.

ratio_5aand_a: "0.10234"

ratio_5band_etio: "010246"

ratio_freet_totalt: "0.0203"

ratio_5aand_a_confirmed: 0.10235

ratio_5band_etio_confirmed: 0.10234

 


Confirmed specific gravityconfirmed_specific_gravity

This field is mandatory for Urine samples with a date received after 1 Jan 2016

When the user is confirming the result, the Specific Gravity must be confirmed. This is mandatory.

"1.003"
Suspicious SP confirmation request status

confirmation_request_status

samplea_inadequate_volume

normal_athlete_profile

valid_teratio_firsttest

irms_method_unavailable

other_reason

These fields become effective as per 16 March 2016 and apply to Urine samples with a date received after 1 Jan 2016.

The confirmation request status is mandatory for a Suspicious Steroidal Passport under certain conditions.

The selection options are boolean values (true/false)

 
Presence of confounding factors

CF_code[index]

CF_presence[index]

CF_conc[index]

CF_unit[index]

These fields become effective as per 16 March 2016 and apply to Urine samples with a date received after 1 Jan 2016.

CF_code[index]: specific code of the Confounding Factor variable. Possible values: ‘ethylglucuronide’ for  ‘Ethyl Glucuronide’; ‘5areductase’ for ‘5a-reductase inhibitors’; ‘ketoconazole’ for ‘ketoconazole or similar’; ‘hCG’ for ‘Heterodimeric hCG’; ‘steroids’ for ‘Anabolic Steroids’; 'masking’ for ‘Masking Agents and diuretics’; 'aromatase' for 'aromatase inhibitors' and 'anti_estrogens' for 'anti-estrogens' . The index number ranges from 1 to 8.

If Lab results are entered after the start date of the TD2016EAAS & TD2016IRMS Reporting in Jan 2016 AND the sample_type = Urine in the file, then ALL CF_codes for index 1 to 6 should be present in the Import file.

CF_presence[index]: Boolean with values True (yes-confounding factor is present) or False (no - confounding factor is not present). Mandatory for all indices from 1 to 8.

CF_conc[index]: decimal value for the estimated concentration of the confounding factor. This is currently only applicable to Ethyl Glucuronide’ : it is an optional field, yet the Lab should enter a value if concentration is above 5 ug/mL.

CF_unit[index]: unit for the estimated concentration of the confounding factor. This is currently only applicable to Ethyl Glucuronide’ , and defaults to ug/mL (optional field).

CF_code[1]=ethylglucuronide

CF_presence[1]=True

CF_conc[1]=7

CF_unit[1]=ug/mL

Confirmation of the presence of confounding factors

CF_presence_confirmed[index]

CF_conc_confirmed[index]

 

These fields become effective as per 16 March 2016 and apply to Urine samples with a date received after 1 Jan 2016.

The CF_code[index] will be used.

CF_presence_confirmed[index]: Boolean with values True (yes- Confirmed confounding factor is present) or False (no- Confirmed confounding factor is not present). It is mandatory for all CFs where CF-presence (initial value) = ‘True’ – the file should then contain a CF_code_confirmed = CF_code  AND a CF_presence_confirmed

CF_conc_confirmed[index]: decimal value for the Confirmed estimated concentration of the confounding factor. This is currently only applicable to Ethyl Glucuronide’. It is mandatory if for any index (CF_code_confirmed[index] = ‘ethylglucuronide’ AND CF_presence_confirmed[index] = ‘True’).

CF_presence_confirmed[1]=True

CF_conc_confirmed[1]=7

 

IRMS Target Compounds

TC_variable_code[index]

TC_variable_d_value[index]

TC_variable_u_value[index]

These fields become effective as per 16 March 2016 and apply to Urine samples with a date received after 1 Jan 2016. 

TC_variable_code[index]: specific code of the IRMS Target_Compound variable. If Lab results are entered after the start date of the TD2016EAAS & TD2016IRMS Reporting in Jan 2016 AND the analysis_attribute = IRMS in the file, then at least one TC should be present in the Import file. Index should not have a limit.  Current possible values with the specific code between brackets: testosterone (T), epitestosterone (E), androsterone (A), etiocholanolone (Etio), "5α-androstane-3α,17β-diol" (5aAdiol), "5β-androstane-3α,17β-diol" (5bAdiol), 19-NA (19-NA),  formestane (formestane), boldenone (boldenone), boldenone metabolites (boldenonemet), other TC (other-TC).

TC_variable_d_value[index]: δ (0/00) decimal value or integer as per ADM2 settings for each variable. Mandatory if a TC_code is included for the same index.

TC_variable_u_value[index]: uc (0/00) decimal value or integer as per ADM2 settings for each variable. Mandatory if a TC_code is included for the same index.

TC_variable_code[1]=boldenone

Endogenous Reference Compounds

ERC_variable_code

ERC_variable_d_value

ERC_variable_u_value

These fields become effective as per 16 March 2016 and apply to Urine samples with a date received after 1 Jan 2016. 

ERC_variable_code: specific code of the Endogenous Reference Compound variable for IRMS. Can only be present if the analysis_attribute = IRMS; If nothing is entered, then the default is PD. Possible values: Pregnanediol (PD), 5α-androst-16-en-3α-ol (16-en), 11β-hydroxyandrosterone (11-OHA), 11-ketoetiocholanolone (11-O-Etio), Androsterone (Androsterone)

ERC_variable_d_value: δ(0/00) decimal value or integer as per ADM2 settings for the variable. Mandatory if the analysis_attribute = IRMS is included. If there is no ERC-code then it is assumed that it is for PD.

ERC_variable_u_value: uc (0/00) decimal value or integer as per ADM2 settings for the variable. Mandatory if the analysis_attribute = IRMS is included. If there is no ERC-code then it is assumed that it is for PD.

ERC_variable_code=16-en

Overall IRMS conclusion irms_conclusion This variable becomes effective as per release 4.7.0

The possible values:

  • Negative

  • AAF

  • ATF

  • ATF_technical

  • ATF_opinion

This field is mandatory if analysis_attribute = IRMS and the date_received is after 1 Jan 2016 (TDEAAS date) and creation_date is after 16 March 2016 (IRMS-details tab launch date).

 irms_conclusion = AAF

 irms_conclusion = ATF_technical

...