Lab Results XML Format import /update

Follow

Release of June 2022

lh_concentration is optional,when date_received is equal or after 01 April 2021 and:

• SG is greater than 1.018;
  and
• LH-Analysis result is either “PAAF” or “ATF”.

Release of November 2021

See details on the following page:

Upcoming changes to CSV /XML import files for DBS

Release September 2021:

See Details in the following page:

What's new in Lab Results CSV/XML import files as of 28 September 2021?

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)

Endogenous Reference Compound 2 is added(Optional).

<unit> is removed from Presence of confounding factors.

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)

An ISO representation of the date that the data file was created by the laboratory (e.g. 2005-02-15). This date will be stored in ADAMS as the result posting date.

The name of the organization, department, or possibly individual that is the source of the data transmission. This field is optional, but if provided, it will be stored in the "Observations and Details" area of the result record.

An internal lab number to identify the batch of results contained within the transmission. This identifier will be stored with each result record in ADAMS.

An identification code indicating the Lab name that is to send the result records.

A code indicating whether the samples were collected in-competition ("IC") or out-of-competition ("OOC"). This tag is mandatory for the Import operation, whereas it is optional for the Update operation. If mentioned in the header, the suggested value will apply to all results in the body.

If desired, comments can be provided. This field is not mandatory.

The unique sample code (e.g. test kit identifier). This will be used to match the result record to the test record.

Mandatory

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

An internal number or code assigned to each sample by the lab. This field is not mandatory, but will be stored in ADAMS if provided.

A code used to identify the type of sample provided (e.g. Blood, Urine,Dried_blood_spot)..

Mandatory

No update allowed.

Code to indicate whether the result record relates to the analysis of the "A", the "B", "B1" or "B2" Sample. It is possible to specify the values "B1" and "B2" for samples reported after January 1st 2015. (ADAMS Release 4.0)

Mandatory

No update allowed. 

The sample collection date as recorded on the doping control form. (e.g. 2005-02-12)

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

There are business rules, such as

• date_received can not be earlier than sample_collection date.
• sample_collection must be in the past or today's date. 

Mandatory 

No update allowed

The date that the lab received the sample (e.g. 2005-02-12)

Manda

A code (M, F, or X) indicating the gender of the athlete as provided on the doping control form. This field is not mandatory.

The sport and discipline in which the athlete competes (e.g. AQ ). ADAMS will record the lab entry even though it may not exactly match the sport and discipline recorded on the sample collection order.

The name of the event (e.g. Men's 100m finals) in which the athlete was competing, as provided on the doping control form.

A code indicating the short name of the Sample Collection Authority.

A code indicating the country in which the sample was collected.

A code indicating the region in which the sample was collected.

The city where the sample was collected. This is not a mandatory field but may be used to verify a match if provided.

A code indicating the short name of the Testing Authority.This is a mandatory field for samples reported after January 1st 2015. (ADAMS Release 4.0)

A code indicating the short name of the Results Management Authority. This is an optional field for samples reported after January 1st 2015. (ADAMS Release 4.0)
Example:

<rma>

<shortName>CCES</shortName>

</rma>

Optional

If applicable, the name of a competition

urine sample validity - tag: valid with the values "true" or "false".

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 tag 'validity' will be disregarded). For samples with a date_received before 16 March 2016 the validity column remains mandatory

A number indicating the T/E ratio of the sample. For example, 2.6 would indicate a T/E ratio of 2.6:1. This field must only be used for samples received prior to January 1st 2014, it is not a mandatory field.

A value indicating the pH of the sample. This is not a mandatory field; if it is not provided, the implication will be that the pH of the sample is within acceptable limits.

A value indicating the Specific Gravity of the sample - on the UI this corresponds with the field Sample Specific Gravity (Initial Testing Procedure). This is a mandatory field for samples received after January 1st 2014.

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

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.

For Urine Samples with date_recieved equal to or after 01 April 2021, Sample Specific Gravity (Confirmation Procedure) is mandatory for  B and B2  samples. 

A code indicating the test result following the sample analysis ("Negative", AAF, ATF, "NotAnalyzed").

This is not a mandatory field.

Date of reporting the results. This is not a mandatory field.

A list of analysis types that were performed on the sample. E.g. "EPO", "GC/C/IRMS", "Transfusion", "HBOCS", "hGH", and "Other". Not mandatory.
For "GC/C/IRMS" a conclusion can be provided (consistent or not).This conclusion is no longer effective for samples with a date_received on or after 16 March 2016.

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]; 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]

The new value overwrites the old value, even if the old value has multiple attributes.

A free-text description (Analysis details/Explanation/ Opinion) of any relevant observations or analyses performed on the sample (e.g. sample tampering or received in poor condition, sample decomposition detected, unusual odor or color detected, etc.). This field is not mandatory. Please note that any departure from the International Standard for Laboratories must be reported to the Testing Authority outside of ADAMS, especially if the sample result is an adverse analytical finding.

Free text (in case of a partially submitted ATF, this text can also be updated when the record is 'locked')

A free-text description (Analysis details/Explanation/ Opinion) of any relevant observations or analyses performed on the sample.

Code: DBSDetails

A code indicating the short name of the organization the results have to be sent to. Multiple organizations are possible.

The new value overwrites the old value. Even if the old value has multiple organization names e.g. FINA|CCES and the new value is NADA, the entire FINA|CCES will be replaced by NADA

For Urine samples A, B, B1, B2 it is optional to provide a tag for:

lh_analysis : code can be either Negative, PAAF or ATF . If no tag is provided, it is assumed 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_adj_concentration: a numeric value - positive integer or a decimal with 1 digit after decimal point, mandatory only when sample received after 01-April-2021 and specific gravity is > 1.018
 and LH-Analysis is either PAAF or ATF. 
lh_lod: a numeric value - positive integer or a decimal with 1 digit after decimal point, e.g. 3 or 2.7

Applicable to Urine samples A, B, B1, B2.  The new value in the file overwrites the old value in the database.

It is not available on the Lock Results. 

A code and value indicating the name of the variable and the corresponding value. This field is mandatory for samples received as of January 1st 2014.
Current codes are: androsterone, epitestosterone, 5b-androstanediol, 5a-androstanediol, testosterone, etiocholanolone, T/E.

The code, value and unit of the prohibited substance.

If the record is not 'locked', the values from the file supersede the values in the database, otherwise any new substances will be added to the database. If a metabolite is included in the file, the substance becomes mandatory.

This is optional and available under the Threshold substances when Date_Received is after 01 April 2021.

When adjusted DL value is entered then adjusted DL Unit is mandatory.

A flag indicating whether merely metabolite(s) are involved

If a Threshold substance is concerned, the Mean/ Uncertainty values and units can be indicated

It is optional for the following substances for the sample Received after 01 May 2021: 

• erythropoietin (EPO)
• methoxy polyethylene glycol-epoetin beta (CERA)
• darbepoetin (dEPO)
• EPO-Fc

The multiple value is allowed : 

• IEF-PAGE
• SDS-PAGE 
• SAR-PAGE
• Other

The new methods will be added to the existing methods. 

Cannot remove an existing method for the substance with  the batch update. 

To indicate whether the sample was analysed for the Monitoring programmed. Tag: monitoring with possible values 'true' or 'false'

Comments on the monitored sample. Tag: commentsMonitored

The comments are free text, whereas the 'code' is an ISO code as has been pre-defined by the Lab administrator.

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", and is not-mandatory.

All are decimal values

Similar for the confirmed values:

ratio_5aand_a_confirmed and ratio_5band_etio_confirmed (ratio_freet_totalt doesn't require confirmation)

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

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

This field is mandatory for 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.

The confirmation request status is required for samples that have triggered an ATPF-CPR under certain conditions.

The uncertainty field (uc) is not required when the value of the associated steroidal profile variable is either “-1” or “-2”.

From 01 April 2021: 

For Confounding Factors:

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

"Concentration" is mandatory when “presence” is True.

“Unit” is not required anymore.

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

Specific code of the Confirmed Confounding Factor variable. It is mandatory for all CFs where CF-presence (initial value) = ‘True’ – the Lab result should eventually contain a CF_code_confirmed = CF_code

Presenceconfirmed: 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

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

From 01 April 2021: 

For Confounding Factors:

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

"ConcentrationConfirmed” is mandatory when “presenceConfirmed” is True

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.

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)

<code>: specific code of the IRMS Target_Compound variable.

<value>: δ (0/00) decimal value or integer as per ADAMS settings for each variable. Mandatory if a TC_code is included for the same code.

<uc>: uc (0/00) decimal value or integer as per ADAMS settings for each variable. Mandatory if a TC_code is included for the same code.

Possible values with Specific Code between brackets:

• Pregnanediol (PD)
• 5α-androst-16-en-3α-ol (16-en),
• 11β-hydroxyandrosterone (11-OHA),
• 11-ketoetiocholanolone (11-O-Etio),
• Androsterone (Androsterone)

New Endogenous Reference Compounds: is available from 01-May-2021:

• Pregnanetriol (PT)

"EndogenousReferenceCompounds2" is added.  

Required Fields:

<endogenousReferenceCompound>: mandatory when  analysis_attribute = IRMS 

<endogenousReferenceCompound2>: optional

For each Endogenous Reference Compounds must entered the following values:  

<code>: specific code of the Endogenous Reference Compound variable for IRMS.

 <value>: δ(0/00) decimal value or integer as per ADAMS settings for the variable. Mandatory if the analysis_attribute = IRMS is included.

<uc>: uc (0/00) decimal value or integer as per ADAMS settings for the variable. Mandatory if the analysis_attribute = IRMS is included.

Example :  

<endogenousReferenceCompounds> 
 <endogenousReferenceCompound> 
 <code>E</code> 
 <value>7.123456789</value> 
 <uc>6</uc> 
 </endogenousReferenceCompound> 

 <endogenousReferenceCompound2> 
 <code>T</code> 
 <value>15</value> 
 <uc>6</uc> 
 </endogenousReferenceCompound2> 
 </endogenousReferenceCompounds> 

This variable becomes effective as per release 4.7.0

Tag irmsConclusion with 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).

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

free text comments to the IRMS analysis for the sample (optional)

Required under substance when Substance is 19-norandrosterone. 

Possible values with code between brackets: 

• > 15 ng/mL (> 15 ng/mL)
• <= 15 ng/mL (&#60;= 15 ng/mL)
• > 10 ng/mL (>10 ng/mL)
• <= 10 ng/mL (&#60;=10 ng/mL)

Example : 

<estConcentration>> 15 ng/mL</estConcentration>

<estConcentration>&#60;= 15 ng/mL</estConcentration>

<estConcentration>>10 ng/mL</estConcentration>

<estConcentration>&#60;=10 ng/mL</estConcentration>

Required under the substance when Substance is 19-norandrosterone.Default value is No presence. 

Example: 

<presenceTHNE><presenceTHNEIncompatible>true</presenceTHNEIncompatible>
</presenceTHNE>

Optional under Substance 19-norandrosterone , when CG/C/IRMS performed for 19-norandrosterone then must be True. 

Optional under substance 19-norandrosterone with decimal value.

When Date_ Received is after 01-April-2021 and GC/C/IRMS 19-NA 19-NE is true then the new Target Compounds can be entered under substances 19-norandrosterone with Specific code between brackets : 

• 19-NA(19NA)
• 19-NE(19NE)

<code>: specific code of the IRMS Target Compound variable.

<value>: δ (0/00) decimal value or integer as per ADAMS settings for each variable. Mandatory if a Target Compounds code is included for the same code.

<uc>: uc (0/00) decimal value or integer as per ADAMS settings for each variable. Mandatory if a Target Compound is included for the same code.

Required Fields under substance 19-norandrosterone when GC/C/IRMS 19-NA 19-NE is true :

<endogenousReferenceCompound>: mandatory when  GC/C/IRMS 19-NA 19-NE is true. 

<endogenousReferenceCompound2>: optional

For each Endogenous Reference Compounds must entered the following values:  

<code>: specific code of the Endogenous Reference Compound variable for IRMS.

 <value>: δ(0/00) decimal value or integer as per ADAMS settings for the variable.

<uc>: uc (0/00) decimal value or integer as per ADAMS settings for the variable. 

Required under substance when substance is 19-norandrosterone and GC/C/IRMS 19-NA 19-NE is true.

codes can be: 

• inconclusive_exogenous_origin_19NA
• consistent_endogenous_origin_19NA
• found_in_the_sample_19NA
• found_not_compatible_19NA
• not_consistent_norethisterone_19NA
• not_consistent_with_pregnancy_19NA
• other_19NA