Description	Assignment dimension table contains the staff assigned to a prospect through normal assignment or through a proposal and attributed noting the type of assignment, if the staff is a solicitor, if the assignment if active and the assignment priority. It uses the cleansing rules in the EDW for the short and long descriptions.