Mqa Review Item Assignments

Mqa Review Item Assignments

FieldTypeDescription
worker_assignment_id šŸ”‘INTEGERUnique identifier for the reviewer assignment (worker_assignments.id). One row per assignment, including unassigned reviewers.
agency_id šŸ”—INTEGEROwner agency of the review item. Assignment rows are not copied to provider datasets.
mqa_review_item_id šŸ”—INTEGERReview item assigned to this reviewer (mqa_review_items.id). Multiple reviewers produce multiple rows for the same item.
mqa_review_id šŸ”—INTEGERReview containing the assigned item (mqa_reviews.id).
agency_worker_id šŸ”—INTEGERAssigned review-dashboard worker (users.id), not the free-text reviewer answer on an Alert tool.
worker_nameSTRINGAssigned worker's full name, including archived workers when available.
roleSTRINGAssignment role (mqa_review_item), not the worker's permissions role.
assigned_atTIMESTAMPWhen the worker was assigned to the review item.
unassigned_atTIMESTAMPWhen 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.

Did this page help you?