Output file format

In the output file that is created by running the export for name value pairs, fields are separated by pipes, and inapplicable fields are left blank, using the following data:

Name Value field Description
Subject identifier Subject initials followed by subject number in parentheses.
RefName path Path of RefNames in the following order:
  • Visit.
  • Repeating formset index, which is used to indicate which instance of a recurring unscheduled visit is referenced.

    If the visit is not an unscheduled visit, the value is 1.000.

  • Form.
  • Repeating form index.
  • Section.
  • Itemset.
  • Itemset index, which is used to indicate which row of an itemset is referenced.
  • Item.
  • Control.
Normalized value Value after conversion into the base units that are specified in the database.
Entered value Value as entered for the control.

Parent topic: Exporting name value pairs