|
Request VFC Reports Screen |
|
Purpose |
The request VFC reports screen exists so that an administrator can generate and print a report containing information on immunizations given within specific funding categories.
|
Functionality |
The VFC Report will produce data only for the organization selected in the date range specified that has entered non-historical immunization data into the system. In the event an organization is selected that has no such transaction data, a message informing the user will be displayed on the report.
Generating the VFC Report for an Organization
Select an organization from the Organization pick list.
Enter the Report Date Range by typing start/end dates into the From and To text boxes in the format MM/DD/CCYY. Or, click on the calendar icon to select a date for the corresponding text box.
Select the Report Type, "Age Group" or "Vaccine Group".
Select the File Type, "PDF" or "Spreadsheet". NOTE: Age Group Report will only print in PDF File Type.
Click on the Generate Report button.
The system will process the report and then display the report in the File Type specified.
Generating the VFC Summary Report for all Organizations
Select the "--All Org Summary" option from the Organization pick list.
Enter the Report Date Range by typing start/end dates into the From and To text boxes in the format MM/DD/CCYY. Or, click on the calendar icon to select a date for the corresponding text box.
Click on the Generate Report button.
The system will process the report and then display the report in a PDF File Format.
Generating the VFC Detail Report for all Organizations
Select the "--All Org Detail" option from the Organization pick list.
Enter the Report Date Range by typing start/end dates into the From and To text boxes in the format MM/DD/CCYY. Or, click on the calendar icon to select a date for the corresponding text box.
Select the Report Type, "Age Group" or "Vaccine Group".
Select the File Type, "PDF" or "Spreadsheet". NOTE: Age Group Report will only print in PDF File Type.
Click on the Generate Report button.
The system will process the report and then display the report in a PDF File Format.
|
VFC Report Output |
Sample VFC Age Group Report Output
The VFC Report output will only ever display vaccine administered from inventory. The dose must be given from inventory at the organization selected on the report. Each shot must have an administered date within the date range specified by the user. The following screen shot shows how the VFC Age Group Report Output will display:
Rows
The rows on the report give a breakdown of the immunizations and patients by age in years. Note that a patient who received a shot at 6 years and 9 months of age will count in the 1-6 age group row. The following table describes the rows on the report:
|
Row |
Description |
|
Under 1 |
This row includes exactly those doses given to patients who were under 1 year of age at the time of dose administration. |
|
1-6 |
This row includes exactly those doses given to patients who were between 1 and 6 years of age at the time of dose administration. |
|
7-18 |
This row includes exactly those doses given to patients who were between 7 and 18 years of age at the time of dose administration. |
|
19+ |
This row includes exactly those doses given to patients who were 19 years of age or older at the time of dose administration. |
|
Annualized |
The system computes the annualized numbers by taking the actual immunization and patient counts in each age grouping and applying a multiplier to estimate a yearly amount. For example, if you run the report for 01/01/2006 to 01/31/2006, the annualized numbers will be roughly 12 times the actual counts. In this example, the multiplier isn't exactly 12 because not all months are of equal length. |
Columns
The columns on the report give a breakdown of the immunizations and patients by VFC eligibility. The following table describes the columns on the report:
|
Column |
Description |
|
Unknown Insurance Status |
The immunization has an unknown insurance status eligibility or no eligibility status specified. |
|
Not VFC Eligible |
The immunization has an 'insured, unable to afford co-pay/deductible' or 'underinsured, not an fqhc' or 'other state supplied' or 'special projects' or 'ig only' or locally owned' or 'billable/not eligible' or '(private clinic, not a delegate, not enrolled in VFC)' eligibility. |
|
Medicaid / Medicare Managed Care |
The immunization has a medicaid, oregon health plan eligibility. |
|
Uninsured |
The immunization has a no insurance eligibility. |
|
American Indian /Alaska Native |
The immunization has an american indian/alaska native eligibility. |
|
Underinsured FQHC |
The immunization has an underinsured, fqhc eligibility. |
|
Subcolumn |
Description |
|
Imms |
This sub column counts the number of immunizations given within the date range specified to patients with the VFC eligibility. |
|
Distinct Patients |
This sub column counts the number of distinct patients associated to the immunizations given within the date range specified for the VFC eligibility. Note that a single patient who received three doses would contribute +3 to the Imms column but only +1 to the Distinct Patients column. |
Totals
There are totals by VFC eligibility, by age group, and grand totals. Here are some details on the totaling done in the report:
|
Total Field |
Description |
|
Total by VFC Eligibility |
These are the cells in the bottommost row of the report. They represent the total count of immunizations or distinct patients for the VFC eligibility, regardless of the age when the dose was administered to the patient. Note: These numbers are not annualized. Also, the total of distinct patients may be less than the value of adding the numbers in this column because the same patient may count in different age groups. |
|
Sum of Imms by Age Group |
These are the cells in the second to last column of the report. These cells count the number of immunizations given for the age category, regardless of VFC eligibility. |
|
Sum of Patients by Age Group |
These are the cells in the last column of the report. These cells count the number of patients who received immunizations at an age within the bounds of the age category, regardless of VFC eligibility. |
Sample VFC Vaccine Group Report Output
The VFC Report output will only ever display vaccine administered from inventory. The dose must be given from inventory at the organization selected on the report. Each shot must have an administered date within the date range specified by the user. The following screen shot shows how the VFC Vaccine Group Report Output will display:
Rows
The rows on the report give a breakdown of the immunizations by Vaccine Group.
Columns
The columns on the report give a breakdown of the immunizations by VFC eligibility. The following table describes the columns on the report:
|
Column |
Description |
|
VFC Immunization Eligibility Counts |
The Eligibilities that are considered to be VFC Eligible. |
|
Total # of VFC Eligible Doses Administered (V02-V05) |
This column counts the total number of immunizations given within the date range specified to patients with the 'medicaid, oregon health plan' and 'no insurance' and 'american indian/alaska native' and 'underinsured, fqhc' eligibilities. |
|
Unknown Insurance Status (V00) |
This column counts the number of immunizations given within the date range specified to patients with the unknown insurance status eligibility or with out an eligibility specified. |
|
Not VFC Eligible (V01) |
This column counts the number of immunizations given within the date range specified to patients with a 'insured, unable to afford co-pay/deductible' or 'underinsured, not an fqhc' or 'other state supplied' or 'special project' or 'ig only' or 'locally owned' or 'billable/not eligible' or '(private clinic, not a delegate, not enrolled in vfc)' eligibilities. |
|
Total # of Non-VFC Eligible Doses Administered (V00, V01) |
This column counts the total number of immunizations given within the date range specified to patients with the 'unknown insurance status' and 'insured, unable to afford co-pay/deductible' and 'underinsured, not an fqhc' and 'other state supplied' and 'special project' and 'ig only' and 'locally owned' and 'billable/not eligible' and 'private clinic, not a delegate, not enrolled in vfc' eligibility and with out an eligibility specified. |
|
Subcolumn |
Description |
|
Medicaid, Oregon Health Plan (V02) |
This sub column counts the number of immunizations given within the date range specified to patients with the medicaid, oregon health plan eligibility. |
|
No Insurance (V03) |
This sub column counts the number of immunizations given within the date range specified to patients with the no insurance eligibility. |
|
American Indian/Alaskan Native (V04) |
This sub column counts the number of immunizations given within the date range specified to patients with the american indian/alaska native eligibility. |
|
Underinsured, FQHC (V05) |
This sub column counts the number of immunizations given within the date range specified to patients with the underinsured, fqhc eligibility. |
Totals
There are totals by VFC eligibility. Here are some details on the totaling done in the report:
|
Total Field |
Description |
|
Total by VFC Eligibility |
These are the cells in the bottom most row of the report. They represent the total count of immunizations for the VFC eligibility. |
|
Notes |
Generating Reports Note
If the computer does not have Adobe Acrobat Reader version 6.0 or greater installed on it, then please see the "**REPORT VIEWING REQUIREMENTS**" notification on the New Patient Form screen, or contact your administrator.