Lab Results CSV format import/update files

 

Release June 2021:

New Target Compounds and Endogenous Reference Compounds are available in IRMS details tab for the Sample Received after 01 May 2021:

Target Compounds with Specific Code between brackets: 

  • 6a-OH-AD(6a-OH-AD)
  • Prednisone (PS)
  • Prednisolone (PSL)
  • Epiandrosterone (EpiA)

Endogenous Reference Compound with Specific Code between brackets: 

  • Pregnanetriol (PT)

CF_unit[index] is removed from Presence of confounding factors.

ERC2 is added(Optional).

Release 04 May 2021: 

For samples that triggered an Atypical Passport Finding Confirmation request (ATPF-CPR) notification, it is mandatory to indicate whether the Testing Authority (TA) has approved the confirmation procedure or not when:

  • at least one Confounding Factor is detected,
  • or the Test Result is an “AAF” (for other Prohibited Substance(s) or Method(s)).

For confirmations requests that are not approved by the TA one of the following reasons must be provided:

    • See APMU Report (a text box is available to specify details)
    • TUE
    • Multiple AAFs
    • Previous samples with EtG and negative IRMS results.

Release 13 April 2021:

New mandatory Confounding Factors added to the system with Specific Code between brackets: 

  • Ethyl Glucuronide(ethylglucuronide_est)
  • carboxy-finasteride(carboxyfinasteride)
  • 4-hydroxy-dutasteride(4-hydroxy-dutasteride)
  • 6-hydroxy-dutasteride(6-hydroxy-dutasteride)
  • Ketoconazole(ketoconazole_est)
  • Fluconazole(fluconazole)
  • Miconazole(miconazole)
  • Anti-estrogenic substances(anti_estrogens_sub)
  • Other (other)

 

For the latest files see the attached file. 

Mandatory Fields
Field Column header Description
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.

Exemple:
"1479265"

Sample Type sample_type

This specifies the type of sample analyzed.

Exemple:
"URINE"
"BLOOD"

Date Received by Lab date_received

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

Exemple:
"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.

Exemple:
"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)

Exemple:
"ITTF"

Test Type test_type

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

Exemple:
"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.
Exemple:"SK","AQ"

Sport discipline discipline_code

This sport discipline's specific code. For the codes see the download centre on our website.
Exemple:"SK","AQ"

Test result test_result

Negative, NotAnalyzed, ATF, AAF
Exemple:
"Negative" ,"NotAnalyzed" ,"AAF" , "ATF"

Specific Gravity specific_gravity

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]

Exemple:
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.

Exemple:
1.025

Validity valid

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.

Exemple:
 
"Yes" or "No"

Steroid profile variables (Code) 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 (Value) 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.

Exemple:
"12"

Confirmed specific gravity confirmed_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.

Exemple:
"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.

Exemple:
"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.
Exemple:
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

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 between 1 Jan 2016 and 1 April 2021.

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

The selection options are boolean values (true/false)

ATPF-CPR confirmation request status

confirmation_request_status

See_APMU_report

TUE

Multiple_AAFs

Previous_samples_with_EtG_and_negative_IRMS_results

APMU_Report_txt

This fields become effective as per 4 May 2021 and apply to urine samples with date received after 1st April 2021.

The confirmation request status is mandatory for a Atypical Passport Finding under certain conditions.

Confirmation_Request status: 
TRUE: “Approved by TA”
FALSE: “Not Approved by TA”

The selection options are boolean values (true/false).
Exemple:
confirmation_request_status =FALSE
See_APMU_report=TRUE
APMU_Report_txt=text ABC

Presence of confounding factors

CF_code[index]

CF_presence[index]

CF_conc[index]

CF_unit[index]

 

For Confounding factors:

  • ethylglucuronide_est
  • carboxyfinasteride
  • 4-hydroxy-dutasteride 
  • 6-hydroxy-dutasteride
  • ketoconazole_est 
  • fluconazole
  • miconazole

"CF_conc” is mandatory when “CF_presence” is True.
“Unit” is not required.

Exemple:
CF_code[1]=ethylglucuronide_est
CF_presence[1]=True
CF_conc[1]=7

Confirmation of the presence of confounding factors

CF_presence_confirmed[index]

CF_conc_confirmed[index]

For Confounding factors:

  • ethylglucuronide_est
  • carboxyfinasteride
  • 4-hydroxy-dutasteride 
  • 6-hydroxy-dutasteride
  • ketoconazole_est 
  • fluconazole
  • miconazole

“CF_conc_confirmed” is mandatory when “CF_presence_confirmed” is True.

Exemple:
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).

When Date_ Received is equal to or greater then 01-May-2021 then the new Target Compounds are available with Specific code between brackets : 

  • 6a-OH-AD (6a-OH-AD)
  • Prednisone (PS)
  • Prednisolone (PSL)
  • Epiandrosterone (EpiA)

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.
Exemple:
TC_variable_code[1]=boldenone

Endogenous Reference Compounds

ERC_variable_code

ERC_variable_d_value

ERC_variable_u_value

ERC2_variable_code

ERC2_variable_d_value

ERC2_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)

A new Endogenous Reference Compounds with Specific Code between brackets is available when Date_ Received is equal or greater than 01-May-2021 :Pregnanetriol (PT)

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.

ERC2_variable_code is optional. 

Exemple:
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).
Exemple:
irms_conclusion = AAF
irms_conclusion = ATF_technical

Optional Fields
Field Column header Description
Results Management Authority

rma

This field contains the short-name identifier of the Results Management Authority, which will follow up on the result with the Results Management.

This is an optional field for samples reported after January 1st 2015. (ADAMS Release 4.0)

Exemple:
"ITTF"

Sample A or B sampleAB

Allowable values: A, B, B1, B2 . If left blank, then sample A will be assumed.

It is possible to specify the values "B1" and "B2" for samples reported after January 1st 2015. (ADAMS Release 4.0)

Exemple:
"A", "B" , "B1", "B2"," " 

Test Result reason test_result_reason

The reason substantiating the result selected. (This text will be added to the activity generated at creation)

Exemple:
"text"

Analysis Details / Explanation analysis_details

This field is used to provide any relevant information concerning the analyses performed by the laboratory or specific observations made.

Exemple:
"The samples were analyzed for anabolic and masking agents, diuretics, and hCG using methods 1001, 2001, and 6001."

Lab Internal Reference Number lin

This field is used to record the internal sample code assigned to the sample upon receipt by the laboratory.

Exemple:
"A127692"
"A127693"

Mission Order Number mo_number

This field is used to record the mission order/ sample collection order number (if available).

Exemple:
"M-127698"

Date of Analysis Report analysis_report_date

This field contains the date that the sample analysis results were reported to the TA. (yyyy-MM-dd)

Exemple:
"2006-04-13"

Country (of Sample Collection) country

This field contains the country code of where the sample was collected. It can be provided in either 2-character ISO format or 3-character Olympic format. For the codes see the download centre on our website.

Exemple:
"EE" or "EST"
"US" or "USA"

Region (of Sample Collection) region

This field contains an ISO code identifying the region within the country of sample collection. For the codes see the download centre on our website.

Exemple:
"CA-AB"
"US-KY"

City (of Sample Collection) city

This field contains the city where the sample was collected.

Exemple:
"Montreal"
"Warsaw"

Athlete Gender gender

This field specifies the gender of the athlete who provided the sample. Empty means 'X'

Exemple:
"M" , "F","X"

Screen T/E Ratio te_ratio

This field specifies the T/E ratio analyzed in the sample. Decimal value with max. 2 digits after the decimal point. Any extra digits will be discarded when saving the results (do not include any other modifier such as ":1").

Only for the import of results received before January 1st 2014.

Exemple:
"2.4"
"4.62"

pH ph

This field specifies the pH analyzed in the sample. Decimal value with max. 2 digits after the decimal point. Any extra digits will be discarded when saving the results.

Exemple:
"5" ,"2.4"

Special type of analysis analysis_attribute

Default is blank. Multiple types are allowed but need to be separated by a '|'.

For Urine:
ESAs (incl. recombinant EPOs and analogues) [internal code EPO]; GC/C/IRMS [code IRMS] ; Insulins [code Insulin] ; GHRF (GHRH/GHS/GHRP) [code GH] see below; GnRH [code GnRH ] ; IGF-1 analogues (code IGF1]; Other (code Other]

As of January 2016 the name will change for GHRF (GHRH/GHS/GHRP) [ code GH ] into GHRF (GHS/GHRP) [ internal code remains GH ] ; also we will add a new attribute GHRF (GHRH) [ internal code GHRH ]

For Blood:
GH Isoforms [code hGH] ; GH Biomarkers [code hGH Markers] ; Blood Transfusions [code Transfusion] ; HBOCS [code HBOCS] ; ESAs (incl. recombinant EPOs and analogues) [code EPOb]; IGF-1 analogues [IGF1b] ; Insulins [code Insulinsb] ; Other [code Other]

Exemple:
"EPO","IRMS", "Other" ,"EPO|IRMS",

as of Jan 2016: GHRH

"hGH|Other", "hGH Markers"

"hGH|EPOb|hGH Markers"

Send notification of results to send_result_to

This field specifies the short name of the organization(s) to be notified of the result. For the codes see the download centre on our website.

Exemple:
"UCI"
"CCES"

Name of the competition competition_name

In case the test_type is 'IC' (in-competition): free text

Exemple:
"2011 Worldcup"

LH-Analysis

lh_analysis

lh_concentration

lh_lod

or Urine samples A, B, B1, B2 it is optional to provide the LH-Analysis details:

lh_analysis : value can be either Negative, PAAF, ATF or blank. Blank value implies that No LH-Analysis was performed.
lh_concentration: a numeric value - positive integer or a decimal with 1 digit after decimal point, e.g. 3 or 2.7
lh_lod: a numeric value - positive integer or a decimal with 1 digit after decimal point, e.g. 3 or 2.7

Exemple:
"Negative" "PAAF" "ATF" " "

"0.2" "1.9"

"2" "0" "8"

Prohibited substance

prohibited_substance[index]

The specific substance code has to be used. For the codes see the download centre on our website. The index is a number ranging from 1 to 10. A maximum number of 10 prohibited substance columns (and associated prohibited substance value and prohibited substance unit columns) may be included in a file. If a metabolite is included in the file the substance becomes mandatory.

Exemple:
"danazol"

Prohibited substance value

prohibited_substance_value[index]

The decimal value of the prohibited substance [index]

Exemple:
"2.3"

Prohibited substance unit

prohibited_substance_unit[index]

The specific code of the unit of measure for analysis related to the prohibited substance[index]

Exemple:
"IU/L"

Prohibited substance details

prohibited_substance_details[index]

Free text for the details concerning finding.

Exemple:
"free text"

Metabolite-only indicator

prohibited_substance_metabolite_only[index]

Indicator that signifies whether metabolite(s) only were detected. Default is 'N'. If 'Y' then the substance becomes mandatory.

Exemple:
"Y", "N"

Metabolite

prohibited_substance_metabolite[index]

Free text for the metabolite. The index is a number ranging from 1 to 10. A maximum number of 10 metabolite columns (and associated metabolite value and metabolite unit columns) may be included in a file.

Exemple:
"text"

Prohibited substance value

prohibited_substance_metabolite_value[index]

 

The decimal value of the metabolite [index]

Exemple:

"4.15"

Prohibited substance unit

prohibited_substance_metabolite_unit[index]

The specific code of the unit of measure for analysis related to the metabolite[index].

Exemple:
"IU/L"

Prohibited substance details

prohibited_substance_details[index]

Free text for the details concerning finding.

Exemple:
"free text"

Metabolite-only indicator

prohibited_substance_metabolite_only[index]

Indicator that signifies whether metabolite(s) only were detected. Default is 'N'. If 'Y' then the substance becomes mandatory.

Exemple:
"Y"
"N"

Metabolite

prohibited_substance_metabolite[index]

Free text for the metabolite. The index is a number ranging from 1 to 10. A maximum number of 10 metabolite columns (and associated metabolite value and metabolite unit columns) may be included in a file.

Exemple:
"text"

Prohibited substance value

prohibited_substance_metabolite_value[index]

The decimal value of the metabolite [index]

Exemple:
"4.15"

Prohibited substance unit

prohibited_substance_metabolite_unit[index]

The specific code of the unit of measure for analysis related to the metabolite[index]

Exemple:
"IU/L"

Confirmed value of the steroid profile variable with the same index

steroid_profile_variable_confirmed[index]

Confirmed valued for steroid profile variable

Uncertainty of the steroid profile variable with the same index

steroid_profile_variable_uc[index]

If steroid_profile_variable_confirmed value is added then this value should be added.

If steroid_profile_variable_confirmed[index] is -1 or -2 then steroid_profile_variable_uc[index] must be empty.  

Threshold substance – mean value

prohibited_substance_mean[index]

Decimal value of the Mean when a special threshold substance is concerned (max. 5 digits apart from the decimal point)

Exemple:
"2.1234"

Threshold substance – mean unit

prohibited_substance_mean_unit[index]

Specific code of the unit of measure

Exemple:
"IU/L"

Threshold substance – uncertainty

prohibited_substance_uncertainty[index]

Decimal value of the Uncertainty when a special threshold substance is concerned (max. 5 digits apart from the decimal point)

Exemple:
"3.1234"

Threshold substance – uncertainty unit

prohibited_substance_uncertainty_unit[index]

Specific code of the unit of measure

Exemple:
"IU/L"

Indicator Monitoring

monitoring

To indicate whether the sample was analysed for the Monitoring program or not. Possible values : 'y', 'n', or empty. Default is No.

It is possible to indicate ‘y’(es) for monitoring while leaving the monitored_ substance data blank. If you however provide values for monitored_substance, then the ‘y’ should be on for ‘monitoring’ (‘n’ and empty are then not allowed).

Exemple:
"y", "n", ""

Comments Monitored

comments_monitored

Comments to the monitored sample (per sample and not per substance)

Exemple:
"comments"

Monitored substance

monitored_substance[index]

The specific substance code has to be used. For the codes see the download centre on our website. The index is a number ranging from 1 to 15.

Exemple:
"caffeine"

Monitored substance value

monitored_substance_value[index]

The decimal value of the monitored substance [index]

Exemple:
"2.3"

Monitored substance unit

monitored_substance_unit[index]

The specific code of the unit of measure for analysis related to the monitored substance[index]

Exemple:
"IU/L"

Test method code

test_method_code[index]

This code has to be a valid code as has been pre-defined by the Lab-administrator. The index is a number ranging from 1 to 15.

Exemple:
"ISO906"

Test method comments

methods_comments

A free text field to detail the test method codes utilized in the analysis and which will appear on the ADAMS test report. Exemple:
"We used various methods for analysing this sample: N2, N78, ISO9067."

 

Template: 

Was this article helpful?
1 out of 1 found this helpful