Federal Aviation Administration
Dangerous Goods Tracking
Infostrat developed the web-based system for tracking inspection of shippers and repair stations handling dangerous goods for the Federal Aviation Administration (FAA). The system was developed using Microsoft’s web development tools and server platform.
Shipper and Repair Stations handle the movement of hazardous materials across the United States. The Federal Aviation Administration (FAA) is required to inspect these shippers. Approximately 150 agents at 25 different offices are required to conduct several inspections per quarter.
For each inspection, the agent gathers specific data. Originally, the agent would collect some data and submit it to a supervisor for approval via fax or e-mail. The submission was not uniform making reviewing and reporting on all inspections time consuming and tedious.
SOLUTION
By creating a national, centralized database to store the data from all inspections, both data entry and reporting are simplified. A password protected web site developed by Infostrat allows FAA inspectors to review a shipper or repair station and easily submit the report for approval.
____________________________________
Business ProfileThe Federal Aviation AdministrationSolution at a glanceDevelped web-based system for tracking inpection of dangerous goodsTechnologies involved.NET FrameworkASP.NETVisual Basic.NETVisual Studio .NETSQL Server 2000
The record is created prior to inspection when the agent enters the shipper’s name and location. Once the record is created, with one click of the mouse the agent can print a form to be completed on the inspection visit.
After returning from an inspection, the agent logs on to the password protected web site to enter the data collected during the visit to a shipper or repair station. The agent then submits all data to a supervisor for review. The supervisor will then approve or disapprove the inspection report. The agent can view the supervisor’s report queue to learn when the report is approved or disapproved.
The system generates three reports that are used for internal review.
By placing assessment data on the web, agents and supervisors can edit data from any location with web access. The reports and approved assessments are also accessible to FAA headquarters in Washington, DC. Infostrat was contracted to construct a data structure and develop the web application that accesses the data.
The FAA Dangerous Goods tracking system runs on Microsoft Internet Information Server. All data is stored in Microsoft SQL Server and the email component of the site uses Microsoft Exchange Server. The active server pages were constructed in Microsoft Visual Interdev.
___________________________
These case studies are provided to illustrate the capabilities of Infostrat in delivering solutions on the Microsoft platform. They do not represent an endorsement of Infostrat or Microsoft Corporation by the customer.