Annotation (Long Format) Data Dictionary
Section titled “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
Section titled “Data Export 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
Section titled “Column Headings”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
Section titled “Reconciled”Whether the annotation is part of a reconciliation session.
(“TRUE”|“FALSE”)
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
Section titled “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
Section titled “AnnotationId”The unique 32 digit alphanumeric identifier that SyRF uses to refer to this specific annotation.
(UUID)
-
Question
Section titled “Question”The text of the question as input by the researcher conducting the review.
(String)
-
QuestionId
Section titled “QuestionId”The unique 32 digit alphanumeric identifier that SyRF uses to refer to this specific question.
(UUID)
-
Answer
Section titled “Answer”The answer to the question as input by the reviewer.
(String)
-
Comments
Section titled “Comments”Any comments added by the reviewer pertaining to the question.
(String)
-
AnswerType
Section titled “AnswerType”The data type of the answer.
(“string”|“boolean”|“integer”|“stringArray”|“integerArray”)
-
IsRootQuestion
Section titled “IsRootQuestion”Whether this is a root-question or a child-question.
(“TRUE”|“FALSE”)
-
ParentQuestionId
Section titled “ParentQuestionId”If question is a not a root-question, what is the QuestionId of the root-question.
(UUID)
-
ChildQuestionIds
Section titled “ChildQuestionIds”If question has child-questions, what are the QuestionIds of the child-questions.
(UUID[;UUID]*)
-
HasChildQuestions
Section titled “HasChildQuestions”Whether this question has child-questions.
(“TRUE”|“FALSE”)
-
ParentAnnotationId
Section titled “ParentAnnotationId”What is the AnnotationId of the annotation which contains the parent-question of this question?
(UUID)
-
ChildAnnotationIds
Section titled “ChildAnnotationIds”What is the AnnotationId of the annotation which contains the child-question of this question?
(UUID[;UUID]*)
-
HasChildAnnotations
Section titled “HasChildAnnotations”Whether this question has child-annotations.
(“TRUE”|“FALSE”)