Column reference
The columns and headings on this page work the same way in every study type. The columns a particular study uses, which of them it needs and what to enter in each are under Columns on that study's reference page. See also Import a file, Numbers, units and identifiers and Templates and downloads.
Fields every study type offers
Section titled “Fields every study type offers”These columns are optional.
| Column use | What to enter |
|---|---|
| Excluded | yes/no, true/false or 1/0, any case. Leave empty to include the row. An excluded row needs a reason |
| Exclusion reason | Free text, up to 500 characters |
| Unit | Compared with the study's unit, ignoring letter case and spaces. Rows in other units form separate groups |
| Analyte | Compared with the study's analyte, ignoring letter case |
| Sample type | For example Serum. Compared with the study's matrix |
| Instrument | Compared with the study's instrument |
Unit, Analyte, Sample type and Instrument sort rows into groups. This study gets the rows that match it, and other groups can become new studies. See Files that mix analytes, matrices, instruments or units. Qualitative agreement has no unit, so delete any Unit column before importing. In instrument comparison, Instrument is required.
When the file has no level, day or run column, each is set to 1. Other missing columns, the level in linearity, and the day and run in a bias check stay blank.
Headings the app recognizes
Section titled “Headings the app recognizes”A matching heading is read as that column use. Case and a trailing unit in brackets are ignored, so Result (mg/dL) counts as result. A heading that contains a recognized word, in English, German or French (for example Ergebnis or Probe), is read the same way. Numbered columns such as Rep1 and Rep2 are offered as one result column with a row per value. A heading that can mean several things (x, y, test, reference, id, sample, value, concentration, time, factor, group, sex, system or reason) is offered as a suggestion for you to confirm. If two columns match one use, you choose.
| Field | Recognized headings |
|---|---|
| ID | specimen, specimen id, specimen_id, material id, material_id, id, sample, sample id, subject, subject id, pool, pool id, specimen / material id |
| Result | result, value, measurement, measured, measured result, measured value, result category |
| Comparative method result | comparator, comparator result, comparator_result, reference, reference result, x, comparative, comparative result, comparative method result |
| Test method result | candidate, candidate result, candidate_result, test, test result, y, test method result |
| Level | level, group, partition, sex, analyte level, material level, concentration level |
| Day, Run, Replicate | day; run; replicate |
| Unit, Analyte, Matrix | unit; analyte; matrix |
| Instrument | instrument, device, analyzer, system |
| Excluded | excluded |
| Exclusion reason | exclusion reason, exclusion_reason, reason |
| Expected or assigned concentration | expected, expected concentration, expected result, nominal concentration, assigned concentration, concentration |
| Lot | lot, reagent lot, reagent_lot, calibrator lot, calibrator_lot |
| Specimen volume | specimen volume, volume specimen, volume_specimen, sample volume |
| Diluent volume | diluent volume, volume diluent, volume_diluent |
| Stated dilution factor | dilution factor, dilution_factor, factor, dilution, stated factor |
| Serial steps | serial steps, serial_steps, steps |
| Diluent | diluent |
| Sequence position | position, sequence position, order, sequence |
| Role | role, sample role, aliquot role, material role |
| Interferent concentration | interferent concentration, interferent conc, interferent_conc, interferent |
| Elapsed time | timepoint, time point, time, elapsed time, storage time |
| Storage condition | condition, storage condition, handling condition, storage |