ITD Database Phase II Improvements The basic goal of the Phase II improvements, beyond implementing user suggestions, is to make the overall system more user-defined and free from the need to perform additional programming each time a table change is required. Also, by making the table structure more user-defined and allowing changes to be made on the fly, this will allow ITD staff to design and implement an updated table hierarchy according to its requirements and time schedule. Generic Table Creation and Maintenance. Now, create and maintain database tables on the fly. Input forms determined by table data and therefore userdefined. Eliminates need for programming each time new tables need to be created or existing tables modified. Create / Modify / Delete Table Fields under program control. Right now, you must use the ALTER SQL command to update table fields (columns). This modification would let high level staff users modify table fields using the web interface without prior knowledge of SQL. This will help speed up the process of adding and deleting fields as necessary. Automated Field Input Restriction. Restrict input on certain fields to pulldown menus which either retrieve options from fields in other tables or allows administrator to create custom selections. This requirement will make sure endusers enter correct data into sensitive fields. User-Defined Table Organization. Currently, the table organization as represented in “Table Maintenance” and in general Table Maintenance hierarchy is hard coded. The system should be modified to make this organization userdefined so that new tables can be easily added without programming support. Comma Delimited (CSV) File Export. Modify SQL Query module to alternately print results in standard CSV format (comma delimited), so that output can be saved and imported into standard spreadsheets. Dynamic Table Search Templates. When searching a table, the user would be able to define the field(s) to be searched. If creation and modification of all tables were dynamic, then the system could be programmed to automatically create a search template based upon the table choosen -- so, we wouldn't have to create 40+ different templates, but one program to dynamically create the correct template for the specific table as needed.