Application Form Responses

Application Form Responses

FieldTypeDescription
application_form_response_id 🔑STRINGUnique ID for a single form response.
agency_id 🔗INTEGERThe ID of the agency that owns the application form.
form_instance_id 🔗INTEGERThe ID of the form instance (the filled-out form) this response belongs to.
application_id 🔗INTEGERThe ID of the application the form response belongs to.
form_id 🔗INTEGERThe ID of the form the response was collected for.
form_version_id 🔗INTEGERThe ID of the bound form version, if the application form has one.
section_keySTRINGThe questionnaire section key, i.e. the top-level segment of the answer path (the questionnaire response key).
pathSTRINGThe dot-delimited path identifying the question (and option, for checkbox/radio expansions) within the questionnaire response.
value_typeSTRINGThe classified type of the response value before stringification: one of string, numeric, boolean, or other.
valueSTRINGThe stringified response value.
option_labelSTRINGFor option-expansion rows (checkbox/radio), the option value from the last path segment; null for plain response rows.

Key Information

Primary Keys

  • application_form_response_id - Unique ID for a single form response.

Foreign Keys

  • agency_id - The ID of the agency that owns the application form.
  • form_instance_id - The ID of the form instance (the filled-out form) this response belongs to.
  • application_id - The ID of the application the form response belongs to.
  • form_id - The ID of the form the response was collected for.
  • form_version_id - The ID of the bound form version, if the application form has one.

Did this page help you?