Mqa Review Item Assignments
Mqa Review Item Assignments
| Field | Type | Description |
|---|---|---|
worker_assignment_id š | INTEGER | Unique identifier for the reviewer assignment (worker_assignments.id). One row per assignment, including unassigned reviewers. |
agency_id š | INTEGER | Owner agency of the review item. Assignment rows are not copied to provider datasets. |
mqa_review_item_id š | INTEGER | Review item assigned to this reviewer (mqa_review_items.id). Multiple reviewers produce multiple rows for the same item. |
mqa_review_id š | INTEGER | Review containing the assigned item (mqa_reviews.id). |
agency_worker_id š | INTEGER | Assigned review-dashboard worker (users.id), not the free-text reviewer answer on an Alert tool. |
worker_name | STRING | Assigned worker's full name, including archived workers when available. |
role | STRING | Assignment role (mqa_review_item), not the worker's permissions role. |
assigned_at | TIMESTAMP | When the worker was assigned to the review item. |
unassigned_at | TIMESTAMP | When the assignment was removed. NULL means the worker is currently assigned; use this filter for current-reviewer reports. |
Key Information
Primary Keys
worker_assignment_id- Unique identifier for the reviewer assignment (worker_assignments.id). One row per assignment, including unassigned reviewers.
Foreign Keys
agency_id- Owner agency of the review item. Assignment rows are not copied to provider datasets.mqa_review_item_id- Review item assigned to this reviewer (mqa_review_items.id). Multiple reviewers produce multiple rows for the same item.mqa_review_id- Review containing the assigned item (mqa_reviews.id).agency_worker_id- Assigned review-dashboard worker (users.id), not the free-text reviewer answer on an Alert tool.
Updated 12 days ago
Did this page help you?
