Quality_Control_Flag

Field	Type	Description	Joins
id	primary key (int)	id of quality control flag trigger	quality_control_flags.trigger_id
name	text	name of flag trigger	unique to table
resource_type	text	canvasser/ shift - what triggers the flag	unique to table
threshold_type	text	percent/number - occurrences that will trigger the flag	unique to table
threshold_value	integer	count/percentage of occurrences that will trigger the flag	unique to table
threshold_range_in_days	integer	count of days Blocks will consider in threshold to trigger flag	unique to table
visual_review_response_id	foreign key (int)	id of visual_review_response that will trigger the flag	visual_review_responses.id
phone_verification_response	text	abbreviation of response to the phone verification question: t - true, f - false, lm - left message, lb - language barrier, rf - refused, cb - call back, b - busy, dc - disconnected, dn - do not call, wn - wrong number, vm - voicemail message is not the applicant	phone_verification_responses.response
needs_reupload	text	t/f if the flag requires reupload	unique to table
default_action_plan	text	default action plan when this flag is triggered	unique to table
stops_qc	text	t/f if the flag stops QC when triggered	unique to table
canvasser_collection_threshold	integer	count of how many forms the canvasser needs to collect before this flag can be triggered	unique to table
minimum_form_count	integer	count of how many forms must be in the shift before this flag can be triggered	unique to table
implies_canvasser_issue	text	t/f if the flag implies a canvasser issue	unique to table
visual_review_implication	text	implication of visual review response that should trigger this flag - incomplete form	unique to table
question_key	text	text of phone verification question associated with the response that triggers this flag	phone_verification_responses.question_key

No result found