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”)