Mqa Tool Submissions

Mqa Tool Submissions

FieldTypeDescription
mqa_tool_submission_id 🔑INTEGERUnique identifier of the tool submission
agency_id 🔗INTEGERID of the agency that owns the review item
mqa_review_item_id 🔗INTEGERID of the review item being evaluated (mqa_review_items.id)
mqa_review_id 🔗INTEGERID of the review the review item belongs to (mqa_reviews.id). Provider agencies' datasets have no mqa_review_items rows, so join reviews on this column
review_item_statusSTRINGStatus of the review item (pending, awaiting_approval, completed, replacement, eliminated). Filter scorecards to completed items on this column
rejection_statusSTRINGLive rejection request status (approved, pending, denied); NULL when no request exists
mqa_review_tool_id 🔗INTEGERID of the review tool (per-review tool configuration) this submission was created against (mqa_review_tools.id); pins the exact config row a submission used
mqa_tool_id 🔗INTEGERID of the tool being filled out (mqa_tools.id)
form_instance_id 🔗INTEGERID of the form instance holding the answers (form_instances.id)
form_id 🔗INTEGERID of the form the answers belong to (forms.id); stable per tool
form_version_id 🔗INTEGERID of the form version the answers are bound to (form_versions.id). Join mqa_tool_questions, mqa_tool_question_options and mqa_tool_responses on this column. NULL when the tool is unpinned and the instance is not yet bound (answers follow the live form)
form_instance_stateSTRINGCompletion state of the form instance (inactive, in_progress, completed, requires_manual_esign, all_signed, abandoned)
form_instance_started_atTIMESTAMPWhen work on the form instance began (form_instances.started_at); NULL until the instance is started
form_instance_finished_atTIMESTAMPWhen the form instance was finished (form_instances.finished_at); NULL until the instance is completed. Use this to date completed submissions for the review period
created_atTIMESTAMPWhen the submission was created
updated_atTIMESTAMPWhen the submission was last updated

Key Information

Primary Keys

  • mqa_tool_submission_id - Unique identifier of the tool submission

Foreign Keys

  • agency_id - ID of the agency that owns the review item
  • mqa_review_item_id - ID of the review item being evaluated (mqa_review_items.id)
  • mqa_review_id - ID of the review the review item belongs to (mqa_reviews.id). Provider agencies' datasets have no mqa_review_items rows, so join reviews on this column
  • mqa_review_tool_id - ID of the review tool (per-review tool configuration) this submission was created against (mqa_review_tools.id); pins the exact config row a submission used
  • mqa_tool_id - ID of the tool being filled out (mqa_tools.id)
  • form_instance_id - ID of the form instance holding the answers (form_instances.id)
  • form_id - ID of the form the answers belong to (forms.id); stable per tool
  • form_version_id - ID of the form version the answers are bound to (form_versions.id). Join mqa_tool_questions, mqa_tool_question_options and mqa_tool_responses on this column. NULL when the tool is unpinned and the instance is not yet bound (answers follow the live form)

Did this page help you?