Form Instance Export Values

Form Instance Export Values

FieldTypeDescription
id 🔑STRINGStable identifier for this row, SHA256 of form_instance_id
agency_id 🔗INTEGERThe ID of the agency this tool submission belongs to.
form_instance_id 🔗INTEGERThe ID of the tool's form instance (form_instances.id).
form_version_id 🔗INTEGERThe ID of the form version (form_versions.id) the form instance is bound to. Null until the form is first answered.
questionnaire_keySTRINGKey of the questionnaire (form page) the question belongs to.
export_keySTRINGDotted path of the question within its questionnaire (e.g. q18, case_has_minor.q20, visits.0.quality). Checkbox selections append the option value (q19.yes). Scored options add .score and .exclude_from_aggregate rows (q18.score, q18.exclude_from_aggregate).
group_keySTRINGPath of the innermost list block entry this value belongs to (e.g. visits, visits.0.checks). Null outside list blocks.
group_indexINTEGER0-based index of the list block entry within group_key. Null outside list blocks.
value_indexINTEGER0-based position of the selected option among a checkbox question's selections. Null for other questions.
value_textSTRINGText value - the selected option value for radio/checkbox questions, or the answer for text questions.
value_numberFLOAT64Numeric value - the option score on .score rows, or the answer for integer questions.
value_dateDATEDate value - the answer for date questions.
value_booleanBOOLEANBoolean value - the option's exclude_from_aggregate flag on .exclude_from_aggregate rows.
value_statusSTRINGanswered (has a value), unanswered (never answered), cleared (previously answered, now blank), not_applicable (hidden behind an unexpanded conditional block), or error (see error_message).
source_pathSTRINGDotted path of the raw answer in questionnaire_responses.data, for debugging. Not stable across form versions.
error_messageSTRINGWhy the value could not be evaluated when value_status is error.
spec_digestSTRINGSHA256 of the questionnaire's question configuration and the exporter's evaluator version used to compute the row.
computed_atTIMESTAMPWhen this row was computed.
source_updated_atTIMESTAMPWhen the questionnaire response the row was read from was last updated. Null when nothing has been saved.

Key Information

Primary Keys

  • id - Stable identifier for this row, SHA256 of form_instance_id|questionnaire_key|export_key.

Foreign Keys

  • agency_id - The ID of the agency this tool submission belongs to.
  • form_instance_id - The ID of the tool's form instance (form_instances.id).
  • form_version_id - The ID of the form version (form_versions.id) the form instance is bound to. Null until the form is first answered.

Did this page help you?