started putting assignment_type filtering into index - ran into weird db problem so commented out offending lines for now