Form Instance Export Values
Form Instance Export Values
| Field | Type | Description |
|---|---|---|
id 🔑 | STRING | Stable identifier for this row, SHA256 of form_instance_id |
agency_id 🔗 | INTEGER | The ID of the agency this tool submission belongs to. |
form_instance_id 🔗 | INTEGER | The ID of the tool's form instance (form_instances.id). |
form_version_id 🔗 | INTEGER | The ID of the form version (form_versions.id) the form instance is bound to. Null until the form is first answered. |
questionnaire_key | STRING | Key of the questionnaire (form page) the question belongs to. |
export_key | STRING | Dotted 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_key | STRING | Path of the innermost list block entry this value belongs to (e.g. visits, visits.0.checks). Null outside list blocks. |
group_index | INTEGER | 0-based index of the list block entry within group_key. Null outside list blocks. |
value_index | INTEGER | 0-based position of the selected option among a checkbox question's selections. Null for other questions. |
value_text | STRING | Text value - the selected option value for radio/checkbox questions, or the answer for text questions. |
value_number | FLOAT64 | Numeric value - the option score on .score rows, or the answer for integer questions. |
value_date | DATE | Date value - the answer for date questions. |
value_boolean | BOOLEAN | Boolean value - the option's exclude_from_aggregate flag on .exclude_from_aggregate rows. |
value_status | STRING | answered (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_path | STRING | Dotted path of the raw answer in questionnaire_responses.data, for debugging. Not stable across form versions. |
error_message | STRING | Why the value could not be evaluated when value_status is error. |
spec_digest | STRING | SHA256 of the questionnaire's question configuration and the exporter's evaluator version used to compute the row. |
computed_at | TIMESTAMP | When this row was computed. |
source_updated_at | TIMESTAMP | When 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.
Updated 27 days ago
Did this page help you?
