|
|
Project Scope:
Compaq wanted to give employees access to health plan summarys on their corporate intranet. The medical plan coverage summaries gave an overview of the benefits provided by different medical plan options that may be offered by Compaq where an employee lived. They wanted a great resource for helping employees to compare plan options. From the list of available plans for their area, employees would be able to view the detailed plan summarys, compare plan costs, provider directory, contact phone numbers, and external web site links for each plan.
Technologies:
The back-end relational database was designed and developed on Microsoft SQL Server 2000. Compaq furnished us three comma-delimited files with the zipcode data for the United States, the plans detailed data, and one related the zipcodes to the plan areas (around 170,000 records). Three related tables were created on the SQL Server and DTS was used to filter the comma-delimited data into each. ODBC and ADO is used to connect the data to the IIS web server. The web-based user interface was designed to run on Microsoft's IIS and ASP technologies. The application was programmed using a combination of server-side VBScript and client-side JavaScript. Employees submit their local zipcode using a the web-based form. Using the ODBC connection, SQL requests to the relational database are returned as ADO (ActiveX Data Object) recordsets. Data views are created in ASP and sent to the Employee's browser.
|
