Request for Information Network



Download 30.56 Kb.
Date conversion24.12.2016
Size30.56 Kb.


Request for Information
Network Access Analysis—Dental

State of North Carolina

December 23, 2016

Network Access Instructions


Introduction


One of our client’s key objectives is to determine if your organization can provide accessible health care services to its employees. In order to assess your network’s ability to meet our needs, we ask that you prepare a network match (GeoAccess® analysis or Quest Access Analysis) using residential ZIP Codes and your network of providers. Instructions for using both software applications are included in this document.

We ask that you prepare your results in the following formats:



1. GeoNetworks or Quest Analytics Report (Adobe Acrobat .pdf file)

2. Microsoft Access Database (Access 2002)
In order for your organization’s response to be evaluated, it is critical that you comply with all instructions and respond to this by the RFP due date.

File Attachments

Summary of Census Information


Included with this request is a summary database in Microsoft Access format. The database summarizes unique ZIP Codes and total employees.

The following fields are included in the table named “ Census for Analysis” and defined as:



1. Zip—Employee’s residential ZIP Codes

2. STD_Class—R=Rural, S=Suburban, U=Urban

3. Total Employees—Total number of employees residing in that ZIP Code and class



Note: ZIP Codes for employees in the Northeast may not have a leading zero.

***If using GeoNetworks, read below; if using Quest Analytics, go to page 3***


Creating GeoNetworks Reports


It is important that the most current version of GeoNetworks software and GeoAccess System Data is used to create these reports.

GeoNetworks Report Format


The GeoNetworks report (Adobe Acrobat file) should be set up as it appears in Table 1.1. Please do not include any additional information.

Table 1.1:

The information in Table 1.1 should be part of the standard GeoNetworks report format except for the “Number” column circled in red in Table 1.1. To include the Number of Employees with desired access (circled in Table 1.1) double-click on each report page to display the page options as shown in Table 1.2. Click on the Options tab and check the “Number in Filter” box and click OK.



Table 1.2

***If using Quest Analytics, read below; if using GeoNetworks, go back to page 1***


Creating Quest Analytics Reports


It is important that the most current version of the software and System Data is used to create these reports.

Quest Analytics Report Format


The Quest Analytics report (Adobe Acrobat file) should be set up as it appears in Table 1.1. Please do not include any additional information.

Table 1.1:

The information in Table 1.1 should be part of the standard Quest report format.


Table 1.2



Go to Accessibility Detail Pages on page 5.Accessibility Detail Pages


The access report will be created with three Employee Groups; Urban, Suburban, and Rural employees. The report should also include a Provider Group for each provider type that is to be analyzed. Table 1.3 details the access standards that should be used to analyze each employee and provider group.

Table 1.3—Dental



Employee Group

Provider Group

Access Standard

Urban

General Dentists

2 providers within 5 miles

Suburban

General Dentists

2 providers within 10 miles

Rural

General Dentists

2 providers within 20 miles

Urban

Pedodontists

1 provider within 5 miles

Suburban

Pedodontists

1 provider within 15 miles

Rural

Pedodontists

1 provider within 25 miles

Urban

Orthodontists

1 provider within 5 miles

Suburban

Orthodontists

1 provider within 15 miles

Rural

Orthodontists

1 provider within 25 miles

Urban

Periodontists

1 provider within 5 miles

Suburban

Periodontists

1 provider within 15 miles

Rural

Periodontists

1 provider within 25 miles

Urban

Oral Surgeons

1 provider within 5 miles

Suburban

Oral Surgeons

1 provider within 15 miles

Rural

Oral Surgeons

1 provider within 25 miles

Urban

Endodontists

1 provider within 5 miles

Suburban

Endodontists

1 provider within 15 miles

Rural

Endodontists

1 provider within 25 miles


Please Note: Only show access to providers that are accepting new patients (i.e., open physician practices). Use Estimated Driving Distance for calculating distance.

After each access standard has been defined using the Table above, an Accessibility Detail Page for each combination of Employee Group, Provider Group, and Access Standard should be created. Using Table 1.3, the report should contain 18 Accessibility Detail pages (18 tables in Microsoft Access).


***If using GeoNetworks, read below; if using Quest Analytics, go to page 7***

Setting up the Report Page Options


VERY IMPORTANT: Your reports should include every ZIP Code that is in our census summary, even ZIP Codes with no access should be included.

For each Accessibility Detail Page that is added to the report, double-click on the report page to display the page options as shown below (Table 1.4). Click on the Include tab.



Table 1.4

Click on the Field drop-down list and select Total Employees along with the Test and Value as shown below. Click OK to close the Accessibility Detail Page options dialog box.



cid:image003.png@01cd132c.32e04620

This will ensure that every ZIP Code is shown in the report regardless of access percentage.


***If using Quest Analytics, read below; if using GeoNetworks, go back to page 6***

Setting up the Report Page Options


VERY IMPORTANT: Your reports should include every ZIP Code that is in our census summary, even ZIP Codes with no access should be included.

By default, the Quest Access Analysis software includes all employees.


***If using GeoNetworks, read below; if using Quest Analytics, go to page 11***

Saving the Page Results to a Data File


When the Accessibility Detail Pages are complete and the Report Page Options have been set, the pages must be saved to a Microsoft Access database. Highlight the pages that should be saved as shown in Table 1.5.

Table 1.5

Click on Page, Save Page Calculations, and Selected Pages from the Page menu (Table 1.6).



Table 1.6

The Specify a Table dialog will be displayed as shown below (Table 1.7).



Table 1.7

Navigate to the desired folder and select an existing database file from the list of database files shown. Click Save. The Select Table dialog will be displayed as shown below (Table 1.8).



Table 1.8



VERY IMPORTANT: Please name the tables according to what is shown below.

For example—Dental:


2: Endo_U = Urban Endodontists

2: Endo_S = Suburban Endodontists

2: Endo_R = Rural Endodontists

3: GenDent_U = Urban General Dentists

3: GenDent_S = Suburban General Dentists

3: GenDent_R = Rural General Dentists

4: Oral_U = Urban Oral Surgeons

4: Oral_S = Suburban Oral Surgeons

4: Oral_R = Rural Oral Surgeons

5: Ortho_U = Urban Orthodontists

5: Ortho_S = Suburban Orthodontists

5: Ortho_R = Rural Orthodontists

6: Pedo_U = Urban Pedodontists

6: Pedo_S = Suburban Pedodontists

6: Pedo_R = Rural Pedodontists

7: Perio_U = Urban Periodontists

7: Perio_S = Suburban Periodontists

7: Perio_R = Rural Periodontists


***If using Quest Analytics, read below; if using GeoNetworks, go back to page 8***

Saving the Page Results to a Data File


When the Accessibility Detail Pages are complete and the Report Page Options have been set, the pages must be saved to a Microsoft Access database. Simply select the pages to export and export to Microsoft Access. Each report page will be a separate table in your Access database.

Table 1.4



VERY IMPORTANT: Please name the tables according to what is shown below.

For example—Dental:


2: Endo_U = Urban Endodontists

2: Endo_S = Suburban Endodontists

2: Endo_R = Rural Endodontists

3: GenDent_U = Urban General Dentists

3: GenDent_S = Suburban General Dentists

3: GenDent_R = Rural General Dentists

4: Oral_U = Urban Oral Surgeons

4: Oral_S = Suburban Oral Surgeons

4: Oral_R = Rural Oral Surgeons

5: Ortho_U = Urban Orthodontists

5: Ortho_S = Suburban Orthodontists

5: Ortho_R = Rural Orthodontists

6: Pedo_U = Urban Pedodontists

6: Pedo_S = Suburban Pedodontists

6: Pedo_R = Rural Pedodontists

7: Perio_U = Urban Periodontists

7: Perio_S = Suburban Periodontists

7: Perio_R = Rural Periodontists


Microsoft Access Report Format—All Software Applications


The GeoNetworks/Quest Analytics report data has now been saved to a Microsoft Access database. Open the newly saved database and open the tables to ensure that the data was extracted correctly.

VERY IMPORTANT: All tables created in Microsoft Access must be identical to the column headings as in Table 1.9. If your tables do not show the column headings identical to Table 1.9.

Table 1.9

access table sample

GeoNetworks—The column headings should appear as in Table 1.9 by default (with the exception of EMPSFILTER, which was added previously in the Report Page Options section of these instructions).

Quest Analytics—The columns should appear as in Table 1.9 by default. You will need to rename your headings to match those above in Microsoft Access.

Each column heading corresponds to the Report (Adobe Acrobat file) as follows:

ZIP—ZIP Code

EMPS—Total Employees in ZIP Code

EMPSFILTER—Employees in ZIP Code with Desired Access

PCTFILTER—Percent of Employees in ZIP Code with Desired Access

PRVS—Number of Providers in ZIP Code

AVGDIST_A1—Average Distance to One Provider



AVGDIST_A2—Average Distance to Two Providers

Microsoft Access Version


VERY IMPORTANT: The Microsoft Access file you receive is in version 2002.

Sending Files to Purchase and Contracts


Double-check that the GeoNetwork/Quest Analytics Report (Adobe Acrobat file) and Microsoft Access Database (18 tables) are complete and accurate. When finished, use a compressing software program (such as SecureZIP or WinZip) to compress the two files and include with proposal submission.


The database is protected by copyright ©dentisty.org 2016
send message

    Main page