NCTQ had a requirement to collect contract information for the districts in a variety of categories and sub-categories. They wanted to define the questions for each category that would be asked for a given district. We designed a generic system where the user can define the question they wanted, the category it should appear, and how the answer data should be entered (single value, currency, multiple values, date field, etc). This made the system extremely flexible for the client. Client needed to also gather general information on districts, source data for the question answers, and detailed reports to be send to the districts.

Frontend application is a dynamic user friendly web application running on the internet at www.nctq.org/tr3. This application allows users to access district contracts, calendars, and salary schedules. The most powerful feature in the Report Generator. User can generate dynamic reports by selecting districts and questions to include.

Both frontend and backend applications are web based application written in Java with a MySQL database. Backend system is secured allowing access to contributers all over the country. Other interesting features of the site are: dynamic Excel generation, PDF file parsing to extract contract text, and district map with pop-up information for each district.