A former England international and a legend at Sheffield United, Hodgy had two spells at City and most City supporters will remember for his last spell under McAllister and Eric Black.
The 71 year old is currently at Oxford United.
Other recipients from Coventry and Warwickshire are:
Ioan Morgan, Principal of Warwickshire College in Leamington Spa
Professor Muhammad Anwar, Professor of Ethnic Relaions,University of Warwick
Dr Rowena Jane Tye, Team Leader of Water Services Regulation Authority (OFWAT)
Jennifer Hocking, Associate Dean at Warwick Business School