U.S. Department of Agriculture desired an e-filings system for their coordinated facilities reporting for the testing. This system is national in scope and provides the end user facilities the ability to complete an on-line (web based) form to submit the information via the internet rather than on paper. The database solution incorporates: Web interface for the initial data collection Secure logon, and verification for each facility Special encryption scheme written to safeguard the information submitted via browser Internal USDA workflow for the review and approval Tracking of each submission throughout its life cycle, full audit trails Electronic update capabilities for facilities Generation of a .PDF file of the facilities submission (e-mailed to the facility) Integration with the central Oracle repository for final storage of a submission C-Technologies.net is web enabling the licensing and registration process for the Department of Agriculture. This entails designing and building the web version of an existing paper form, creating a workflow for the submitted data, and a report generator for the department. The system handles both New and Renewal Forms. The system requires username and password access before allowing a renewal and populates the form from past data maintained in the Oracle database. The form allows for multiple entries in certain fields and is dynamic to the data entered in designated fields. As a user enters data the form adapts to the required input areas and displays the necessary fields. The form also tabulates fees dependent upon the data entered into certain fields. The form validates and collects the data and stores it in a Notes database prior to its workflow. Next a reviewer checks the data on the computer and enters office information before designating it approved or denied. Once approved the form is submitted to the Oracle database for storage and reporting. This system is anticipated to save a tremendous amount of time, paper, and money for the department as it will reduce mailing, hard copy, and staff review time.