WSUPG Disease Manager

The Wayne State University Physician's Group (via the School of Medicine) needed a way of classifying diseases by physician specialty area and physician area of interest (area of focus/expertise). Once this massive list of diseases (over 3,500) were mapped to specialties and areas of interest, this data would be used in a public, front-end search application.

I was asked to build the manager that would allow a select group of users map individual diseases to appropriate specialties and areas of interest. Some of the key functionality included a queue of diseases that were at square one, and needed specialties and areas of interest added to them, an active disease list, alpha-separated and sorted, and an inactive disease list, where problem diseases, or diseases that have been deemed unneccessary for the front-end search, could sit without being completely removed from our database.

This application required interfacing with approximately 9+ database tables, usually using on average 2-4 tables in conjunction with each other for almost all database queries.