added agency, notes, coder, and hash fields
added check constraints for adm names