Annotation (Wide Format) Data Dictionary

The spreadsheet output from a wide format annotation data export will contain the annotation questions and answers specific to the systematic review being performed, as input by the team conducting the systematic review.

Data Export Example

Wide-format example

This examples contains questions from a review conducted by CAMARADES Berlin. The questions in your spreadsheet will depend on the specific questions in your systematic review.


Column Headings

Bibliographic Data Columns (click to view)

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 (click to view)

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 annotation level after Study level has additional standard columns

Disease Model Induction Level

  • DiseaseModelId

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

    (UUID)

  • DiseaseModelLabel

    String input by the reviewer to label this disease model.

Treatment Level

  • TreatmentId

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

    (UUID)

  • TreatmentLabel

    String input by the reviewer to label this treatment entry.

    (String)

Outcome Assessment Level

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

Cohort Level

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

Experiment Level

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

Each annotation question

Additionally, each custom user defined annotation question that has been added to the project is represented with the four columns defined below. These column headers also contain:

  1. The question text
  2. The question ID (except when the Single header row simple option is selected for the Choose wide format header type property)

N.B.: The format of the headers for each of these four columns is determined by the option selected for the property Choose wide format header type in the annotation data export settings (wide format). Click here for more detail.

  • AnnotationId

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

    (UUID)

  • Answer

    The answer to the question as input by the reviewer.

    (String)

  • Comments

    Any comments added by the reviewer pertaining to the question.

    (String)

  • DateTimeAnnotated

    The Date and time of the annotation In the ISO 8601 format, e.g. “2019-02-26 14:53:58”

    (DateTime).