Quantitative Data Dictionary

The spreadsheet output from a quantitative data export will contain the quantitative data for the studies in your SyRF project.

Each row corresponds to a single timepoint and includes it’s associated system and selected custom annotations. In addition, the associated IDs and labels for experiment, cohort, outcome, treatment, and diseaseModel entities are included.

Data Export Example

Quantitative data example

---

Column Headings

Bibliographic Data Columns

If the Show bibliographic data option is selected in the SyRF interface then Bibliographic Data Columns are included in the export.

The StudyId, DateTimeStudyAdded, SystematicSearchId and SystematicSearchName columns will always be included regardless.

• Reconciled

  Whether the annotation is part of a reconciliation session.

  (“TRUE”|“FALSE”)

Investigator Info Columns

Investigator information columns will be included depending on which option is selected for the “Choose level of blinding” setting. Click here for more details.

Each selected annotation question

Each annotation question that is selected for the quantitative data export in the “select annotation questions to include in export” is represented with a single column.

Each question header (below) contains the question text as defined by the project admins.

• <QuestionText>

  Where <QuestionText> is the text of the selected annotation question.

  The value in each cell is the answer to that question that corresponds to the specific timepoint.

  (String)

Standard Quantitative Data Columns

• DateTimeDataEntered

  When the outcome data was entered by the reviewer in SyRF. In the ISO 8601 format, e.g. “2019-02-26 14:53:58”

  (DateTime)

• ExperimentId

  The unique 32 digit alphanumeric identifier that SyRF uses to refer to this specific experiment entry.

  (UUID)

• ExperimentLabel

  String input by the reviewer to label this experiment entry.

  (String)

• CohortId

  The unique 32 digit alphanumeric identifier that SyRF uses to refer to this specific cohort entry.

  (UUID)

• CohortLabel

  String input by the reviewer to label this cohort entry.

  (String)

• NumberOfAnimals

  The number of animals defined in the cohort.

  (Integer)

• IsDiseaseModelControl

  Whether the associated disease model(s) is a control. Multiple disease models associated with the cohort will have their control status separated with the “;” character.

  (“TRUE”|“FALSE”[;”TRUE”|“FALSE”]*)

• DiseaseModelId(s)

  The unique 32 digit alphanumeric identifier that SyRF uses to refer to this specific disease model entry. Multiple disease models associated with the cohort will have their IDs separated with the “;” character.

  (UUID[;UUID]*)

• DiseaseModelLabel(s)

  String input by the reviewer to label this disease model. Multiple disease models associated with the cohort will have this value separated with the “;” character.

  (String[;String]*)

• IsTreatmentControl

  Whether the associated treatment(s) is a control. Multiple treatments associated with the cohort will have their control status separated with the “;” character.

  (“TRUE”|“FALSE”[;”TRUE”|“FALSE”]*)

• TreatmentId(s)

  The unique 32 digit alphanumeric identifier that SyRF uses to refer to this specific treatment entry. Multiple treatments associated with the cohort will have their IDs separated with the “;” character.

  (UUID[;UUID]*)

• TreatmentLabel(s)

  String input by the reviewer to label this treatment entry. Multiple treatments associated with the cohort will have this value separated with the “;” character.

  (String[;String]*)

• OutcomeId

  The unique 32 digit alphanumeric identifier that SyRF uses to refer to this specific outcome assessment entry.

  (UUID)

• OutcomeLabel

  String input by the reviewer to label this outcome assessment entry.

  (String)

• GreaterIsWorse

  Whether the outcome assessment associated with this timepoint is a greater-is-worse outcome.

  (“TRUE”|“FALSE”)

• TimeInMinutes

  The timepoint in minutes.

  (Integer)

• OutcomeAverage

  The average value of the outcome assessment associated with this timepoint.

  (Number)

• OutcomeAverageType

  The type of average used to calculate the OutcomeAverage value.

  (“mean”|“median”|“mode”)

• OutcomeUnit

  The unit of the outcome assessment associated with this timepoint.

  (String)

• OutcomeError

  The error value of the outcome assessment associated with this timepoint.

  (Number)

• OutcomeErrorType

  The type of error used to calculate the OutcomeError value.

  (“SD”|“SEM”|“IQR”)