Quality_Control_Flags

List view

Voter Registration and Quality Control
Canvassers
Deliveries
Delivery_Form_Exclusions
Field_Management_Goals
Field_Management_Projections
Flag_Triggers_Turfs
Flags_Triggering_Forms
Locations
Performance_Reviews
Performance_Reviews_Flags
Performance_Reviews_Shifts
Phone_Verification_Responses
Quality_Control_Comments
Quality_Control_Flag_Triggers
Quality_Control_Flags
Quality_Control_Flags_Views
Quality_Control_Phone_Verification_Calls
Quality_Control_Phone_Verification_Scripts
Quality_Control_Schedules
Registration_Forms
Scheduled_Exports
Scheduled_Exports_Turfs
Shifts
Twilio_Calls
Visual_Review_Responses
Visual_Review_Triggers
Visual_Reviews
Voter Registration Scan Visual Review Responses
Organizing
Addresses
Campaigns_People
Campaigns_Teams
Check_In_Answers
Check_In_Questions
Check_Ins
Contact_Methods
Coorganizations
Documents
Email_Templates
Event_Attendees
Event_Documents
Event_Shifts
Events
Events_Teams
Imports
Imports_Error_Rows
List_Folders
List_Folders_Users
Lists
Lists_People
Locations
Meetings
Notes
Organization_Memberships
Organizations
Organizations_Teams
People
Public_Event_Links
Relationships
Sent_Emails
Team_Memberships
Teams
Volunteerships
Petitions and Quality Control
Canvassers
Locations
Petition_Packets
Petitions_Pages
Petitions_Signatures
Shifts
Visual_Review_Responses
Visual_Reviews
Admin
Dashboard_Layouts
Roles
Turfs
Turf_VRRs
Users
Campaigns
Phone Banking
Phone_Banking_Answer_Options
Phone_Banking_Calls
Phone_Banking_Phone_Banks
Phone_Banking_Questions
Phone_Banking_Responses
Phone_Banking_Script_Objects
Phone_Banking_Script_Texts
Phone_Banking_Scripts
Phone_Banking_Sessions
Twilio_Calls
 

Quality_Control_Flags

 
This table displays information about flags triggered in the quality control process
 

Field
Type
Description
Joins
id
primary key (int)
id of quality control flag trigger
flags_triggering_forms.quality_control_flag_id, performance_reviews_flags.flag_id, quality_control_comments.flag_id, quality_control_flags_views.flag_id
status
text
status of flag in Blocks - open, ready, reviewed, completed
unique to table
action_plan
text
action plan on flag sent to group (set to ready)
unique to table
notes
text
noted entered on flag
unique to table
created_at
timestamp
date&time flag was created
unique to table
updated_at
timestamp
date&time flag was last updated
unique to table
trigger_id
foreign key (int)
id of flag_trigger that created the flag
quality_control_flag_triggers.id
completed_at
timestamp
date&time flag was resolved in Blocks
unique to table
shift_id
foreign key (int)
id of shift in Blocks the flag was triggered on
shifts.id
ready_at
timestamp
date&time flag was marked ready (sent to group)
unique to table
reviewed_at
timestamp
date&time flag was marked reviewed (ready to resolve)
unique to table