ADAMS 4.0 - the anticipated changes as of 1 January 2015:
- Testing Authority (TA) is mandatory
- Additional optional field Result Management Authority (RMA)
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).
No update allowed.
No update allowed
Date Received by Lab
No update allowed
Sample Collection Date
(yyyy-MM-dd) There are business rules, such as date_received cannot be earlier than sample_collection date etc
This is a mandatory field for samples reported after January 1st 2015. (ADAMS Release 4.0)
Sample Collection Authority
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.
|Results Management Authority||rma||This is an optional field for samples reported after January 1st 2015. (ADAMS Release 4.0)||"UCI" |
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.
The combination of sport and discipline is validated.
One may indicate only the discipline in the file (sport in the database is taken)
The field value must start with either of the codes listed. Ex: "XT-1234"
"XT", "XN", "XE"
"M", "F", "X"
"US" or "USA"
The combination of country and region is validated.
<blood parameter specific code>
Blood parameters specific code.
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)