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