Skip to end of metadata
Go to start of metadata

ADAMS 4.0 - the anticipated changes as of 1 January 2015:

  • Testing Authority (TA) is mandatory
  • Additional optional field Result Management Authority (RMA) 

Click here for a sample CSV-file for ADAMS v4.0

Each BPLR record in the CSV file should contain at least 4 mandatory fields. Once the update is triggered for the BPLR sample record in the input file, ADAMS will look for the corresponding BPLR record in the database, based on the unique identification of 4 fields: sample code, sample type, Lab name, date received.

As a general rule, each time an update is proposed for a BPLR record in the database, ADAMS will validate on mandatory fields and business rules as they are prevalent on the BPLR page. ADAMS will apply validity-checks on the resultant of the value in the database and the value in the input file.

Below are comments on updatable fields (the sequence of the columns is not relevant).

Field

Column header

Description

Example(s)

Sample Code

sample_code
MANDATORY

No update allowed.
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
MANDATORY

No update allowed
(should default to "blood_passport")

 

Date Received by Lab

date_received
MANDATORY

No update allowed 
(yyyy-MM-dd hh:mm)

 "2012-11-28 06:00"

Lab name

Lab

MANDATORY

 

"TESTLab"

Sample Collection Date

date_collection

(yyyy-MM-dd) There are business rules, such as date_received cannot be earlier than sample_collection date etc

"2012-02-19"

Testing Authority

ta

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

"UCI"
"IAAF"

Sample Collection Authority

sca

If the mandatory SCA is missing in the database and in the file, AND the status of the BPLR is submitted/Not analysed, then an error is given.

"UCI"
"IAAF"

Results Management Authority rmaThis is an optional field for samples reported after January 1st 2015. (ADAMS Release 4.0)"UCI"
"IAAF"

Analysis Date

analysis_date

Date and time of the analysis (yyyy-MM-dd hh:mm). There are business rules, such as analysis_date cannot be earlier than sample_collection date etc.

"2012-02-18 14:12"

Test Type

test_type

 

"IC", "OOC"

Sport

sport_code

The combination of sport and discipline is validated.

"AT"
"CY"

Discipline

discipline_code

One may indicate only the discipline in the file (sport in the database is taken)

"AT"

Lin#

lin

 

"123-a"

Blood Analyzer

analyser

The field value must start with either of the codes listed. Ex: "XT-1234"

"XT", "XN", "XE"

Gender

gender

 

"M", "F", "X"

Mission order#

mo_number

 

"M-12345"

Country

country

 

"US" or "USA"

Region

region

The combination of country and region is validated.

"US-KY"

City

city

 

"Cairo"

Blood Parameters

<blood parameter specific code>

Blood parameters specific code.

"HCT"

Date format

Please note that if you are using an older version of Excel, the date format may not be shown as yyyy-MM-dd but as dd/MM/yyyy. You can find out the actual values however by opening your CSV-file in Wordpad. So don't be misled by how it is displayed in Excel.

 

Blood parameters specific code: (contact WADA for the latest)

  • No labels