---
title: "GOT - Assay System"
canonical: "https://servicedesk.maxgeo.com/space/MAXGEO/1063780353/GOT%20-%20Assay%20System"
format: markdown
---
**Normalised Assay table**: tblAssay. Where the results are stored in a normalised format. The only calculation performed on the result is to convert the unit of the result from the unit specified from the lab to the database wide preferred unit for the element or to convert a character to a numeric value as specified in the substituations table. The data is **Merged** into this table from the Incoming Assay table.

 

**Incoming Assay Table**: tblSYSAssIncomingData. This is the table where the data is populated after being normalised on importing. The data can remain in here until all the validation is complete and the data can be merged into tblAssay. All results in the incoming are processed when the **Merge** process happens.

 

**Flat Assay Table**: tblAssayFlat. This table contains calculated assay results taken from tblAssay as specified in the Database Structures in DataShed. A field containing a preferred result will be a ranked result. This table is populated during the **DataShed Ranking Process**

 

**Merge**: this is the process by which DataShed validates the data stored in the Assay Incoming table and then appends any records that pass the validation process into the normalised Assay Table. The record is then deleted out of the Assay Incoming table and the batch statistics in tblSYSAssBatch are updated to reflect this.

 

**Import**:The process in DataShed where a data from a lab loaded into the DataShed system and the result are normalised and appended to the Incoming Assay Table, where they will be validated.

 

**Ranking**: (DataShed Ranking Process). The process by which assay results are taken from the normalised assay table and are flattened as specified by the client and the Assay Flat table is populated.

 

**Assay Status codes**

**BDL**:  Below Detection Limit: A result that has a grade that is less than the detection limit of the analytical technique.

**OR**: Over Range. A result that has a grade higher than the upper dectection limit of the analytical technique.

 

Common codes from lab

**IS**: Insufficient Sample: A sample which is too small to analyse.

**SNR: **Sample not received.

**LNR: **Listed not received

**Outliers**: A result that falls outside a percentage value set in the database from the standards mean expected value. These results should be excluded from statistical analysis of a standards performance.