Mqa Tool Submissions
Mqa Tool Submissions
| Field | Type | Description |
|---|---|---|
mqa_tool_submission_id 🔑 | INTEGER | Unique identifier of the tool submission |
agency_id 🔗 | INTEGER | ID of the agency that owns the review item |
mqa_review_item_id 🔗 | INTEGER | ID of the review item being evaluated (mqa_review_items.id) |
mqa_review_id 🔗 | INTEGER | 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 |
review_item_status | STRING | Status of the review item (pending, awaiting_approval, completed, replacement, eliminated). Filter scorecards to completed items on this column |
rejection_status | STRING | Live rejection request status (approved, pending, denied); NULL when no request exists |
mqa_review_tool_id 🔗 | INTEGER | 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 🔗 | INTEGER | ID of the tool being filled out (mqa_tools.id) |
form_instance_id 🔗 | INTEGER | ID of the form instance holding the answers (form_instances.id) |
form_id 🔗 | INTEGER | ID of the form the answers belong to (forms.id); stable per tool |
form_version_id 🔗 | INTEGER | 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) |
form_instance_state | STRING | Completion state of the form instance (inactive, in_progress, completed, requires_manual_esign, all_signed, abandoned) |
form_instance_started_at | TIMESTAMP | When work on the form instance began (form_instances.started_at); NULL until the instance is started |
form_instance_finished_at | TIMESTAMP | When 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_at | TIMESTAMP | When the submission was created |
updated_at | TIMESTAMP | When 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 itemmqa_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 columnmqa_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 usedmqa_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 toolform_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)
Updated 5 days ago
Did this page help you?
