Annotation (Long Format) Data Dictionary

The spreadsheet output from a long format annotation data export will contain questions specific to the project, as input by the team conducting the systematic review.

In long format each row corresponds to a single annotation of a single study by a single reviewer. Each child-question will be in a separate row. A complete review of a single study will consist of many annotation rows.

Data Export Example

Long-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

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.

  • DateTimeAnnotated

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

    (DateTime)

  • AnnotationId

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

    (UUID)

  • Question

    The text of the question as input by the researcher conducting the review.

    (String)

  • QuestionId

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

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

  • AnswerType

    The data type of the answer.

    (“string”|“boolean”|“integer”|“stringArray”|“integerArray”)

  • IsRootQuestion

    Whether this is a root-question or a child-question.

    (“TRUE”|“FALSE”)

  • ParentQuestionId

    If question is a not a root-question, what is the QuestionId of the root-question.

    (UUID)

  • ChildQuestionIds

    If question has child-questions, what are the QuestionIds of the child-questions.

    (UUID[;UUID]*)

  • HasChildQuestions

    Whether this question has child-questions.

    (“TRUE”|“FALSE”)

  • ParentAnnotationId

    What is the AnnotationId of the annotation which contains the parent-question of this question?

    (UUID)

  • ChildAnnotationIds

    What is the AnnotationId of the annotation which contains the child-question of this question?

    (UUID[;UUID]*)

  • HasChildAnnotations

    Whether this question has child-annotations.

    (“TRUE”|“FALSE”)