refactored temp table for assignees
rewrapping statements to allow parameterized method extraction