Versions Compared

Key

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

...

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"

Analyser

Blood Analyzer

analyser

The

short code for the Analyser instrument."sysmex

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

"XT", "

advix

XN", "

other

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"

Note
titleDate 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.

...