|
Ad hoc List Report |
|
Purpose |
When you select ad hoc list report from the menu, you will go to a screen where you set up an ad hoc report. A list report will produce a table with a column for each item that you select to display, much like a spreadsheet.
|
Functionality |
What patient population would you like to use section- Displays options for certain organizations being able to run the ad hoc list report on other patients and is used to determine the initial patient base to use for the ad hoc report.
|
Select Patient Population Option |
Description |
Available Admin Role |
|
Patients Associated with Provider |
Selecting this option will return only patients who are active within the organization. |
Yes |
|
Patients Residing in County |
Selecting this option will return all patients residing in the displayed county. This report will not exclude patients based on if a patient is active within your organization or not. This option is only available to county providers. |
No |
|
Patients associated with Provider or patients residing in County |
Selecting this option will return a combination of the two previous options. It will return all patients active within your organization or residing within the county displayed. This option is only available to county providers. |
No |
What items would you like to display on the report section- Displays data element items that can be selected to appear on the Ad Hoc List report.
Add an Item to the Display List.
Select an Item from the left-hand list of available items.
|
Group |
Item Name |
Description |
|
Most Common Items |
Birth Date |
Patient's Birth Date. |
|
Patient First Name |
Patient's First Name. |
|
|
Patient Last Name |
Patient's Last Name. |
|
|
Vaccination Date |
Date vaccine was administered. |
|
|
Vaccine |
Vaccine that was administered. |
|
|
Vaccine Lot |
Vaccine Lot number for the vaccination administered. |
|
|
Vaccine Eligibility |
Vaccine Eligibility Code for the vaccination administered. |
|
|
Historical Immunization |
New or historical indicator for the vaccination administered. |
|
|
Immunization Items |
CVX Code |
CVX Code for the vaccination administered. |
|
From Inventory |
Indicates if the vaccination administered deducted from the Organization's inventory. |
|
|
NDC Code |
NDC information for the vaccination administered. |
|
|
Owning Organization |
Indicates the Owning Organization for the vaccination administered. |
|
|
Source of Last Update |
Source of Last Update for the vaccination administered. |
|
|
Trade Name |
Trade Name of the vaccination administered. |
|
|
Vaccine Group |
Vaccine Group of vaccination that was administered. |
|
|
Other Patient Items |
Active Status |
Patient's Active Status. |
|
County of Birth |
Patient's County of Birth. |
|
|
County of Residence |
Patient's County of Residence. |
|
|
Gender |
Patient's Gender. |
|
|
Language Preference |
Patient's Language Preference. |
|
|
Mother's HBsAG Status |
Patient's Mother's HBsAg Status. |
|
|
Patient ID |
Patient's ID. |
|
|
Patient Middle Name |
Patient's Middle Name. |
|
|
School |
Patient's School. |
|
|
Address |
Street Address |
Patient's Street Address. |
|
PO Box |
Patient's PO Box. |
|
|
Other Address |
Patient's Other Address. |
|
|
City |
Patient's City Address. |
|
|
State |
Patient's State. |
|
|
Zip |
Patient's Zip Code. |
Click the Add button to move the item the right-hand list of items to be displayed on the report.
Remove an Item to display
Select an Item from the right-hand list of items to be displayed on the report.
Click the Remove button to move the item from the right-hand list of report items to the left-hand list of available items.
Remove all Items to display
Click the Remove All button to move all items from the right-hand list of report items to the left-hand list of available items.
Display Order
The order which the user selects items will remain in that order within the same group. Example, a user can chose to have Last Name appear before First Name, but can not have Last Name listed between Ethnicity and Gender.
Command Button Functionality
|
Command Button |
Description |
|
|
Adds selected item from the first list of items to be displayed to the second list of items to be displayed on the report. |
|
|
Removes selected item from the second list of items to be displayed to the first list of items to be displayed on the report. |
|
|
Removes all items from the second list of items to be displayed to the first list of items to be displayed on the report. |
How would you like the report to be sorted section- Allows report to be sorted on one Item that was selected above to be displayed on the report. If exporting the report as an Excel Spreadsheet it is not recommended to sort the report, because the sort functionality within Excel can be utilized to sort the report.
Add sorting to the report.
Select an Item from the Item to sort on pick list.
Select a radio button to select the sort order as described below.
|
Sort Order |
Description |
|
First-to-Last |
Sorts the Item based on the following sort order. (spaces, special characters (#,',"), uppercase A-Z, lowercase a-z |
|
Last-to-First |
Sorts the Item based on the following sort order. (lowercase z-a, uppercase Z-A, special characters (",',#), spaces) |
How would you like to filter the data section- Reduces the patients from the initial patient population based on the filters selected.
Filtering patient population for the report.
Select an Item from the Item to Filter on pick list as described below along with comparison criteria.
|
Group |
Item Name |
Description |
Comparison |
Select from Pick List/Entered Comparison |
|
Patient Factors |
Active Status |
Patient's Active Status. |
Equals |
Select from Pick List |
|
Age Range |
Restricts results based on a Patients age. |
Between |
Entered Comparison |
|
|
Birth Date |
Patient's Birth Date. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Entered Comparison |
|
|
City |
City of the Patient address. |
Before/Equals/Not Equal To/After/Between/Is/Is Not/Begins With/Does Not Begin With |
Entered Comparison |
|
|
Comment |
Patient comments. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
County of Birth |
Patient's County of Birth. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
County of Residence |
County of the Patient's address. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
Gender |
Patient's Gender. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
Has 2 or More Immunizations |
Patient has had 2 or more immunizations. |
Equals |
Select from Pick List |
|
|
Language Preference |
Patient's Language Preference. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
Patient ID |
Patient's ID. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Entered Comparison |
|
|
Primary Care Physician |
Primary Care Physician of the Patient. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
School |
Patient's School. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
State |
State of the Patient's address. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
Zip |
Zip code of the Patients address. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Entered Comparison |
|
|
Immunization Factors |
Administering Clinician |
Administering Clinician of the vaccination administered |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
CVX Code |
CVX Code for the vaccination administered. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
Display Inadvertent Vaccine Group |
Vaccination was Inadvertently administered due to age and vaccine group |
Equals |
Select from Pick List |
|
|
Historical Immunization |
New or historical indicator for the vaccination administered. |
Equals |
Select from Pick List |
|
|
From Inventory |
Immunization was administered from Inventory |
Equals |
Select from Pick List |
|
|
Owned Immunization |
Y/N indication of organizational immunization ownership. |
Equals |
Select from Pick List |
|
|
Source of Last Update |
Source of Last Update for the vaccination administered. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
Trade name |
Trade Name of the vaccination administered |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
Vaccination Date |
Date the vaccination was administered |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Entered Comparison |
|
|
Vaccine |
Vaccine that was administered |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
Vaccine Eligibility |
Vaccine Eligibility Code for the vaccination administered |
Equals/Not Equal To |
Select from Pick List |
|
|
Vaccine Group |
Vaccine Group of vaccination that was administered |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
Vaccine Lot |
Vaccine Lot for the vaccination administered. |
Before/Equals/Not Equal To/After/Between/Is/Is Not |
Select from Pick List |
|
|
Valid immunization |
Vaccine that was administered is considered a valid dose |
Equals |
Select from Pick List |
Select an option from the Comparison pick list as described below. All Comparisons are not available to be selected for all Items in the Item to filter on list.
|
Comparison |
Description |
|
EQUALS |
Item to filter on is equal to the Value to compare to entered. |
|
NOT EQUAL TO |
Item to filter on is not equal to the Value to compare to entered. |
|
BEFORE |
Item to filter on is before the Value to be compare to entered. |
|
AFTER |
Item to filter on is after the Value to be compared to entered. |
|
BETWEEN |
Item to filter on is between two Values to be compared to entered. |
|
IS |
Item to filter on is the Value to be compared to entered. |
|
IS NOT |
Item to filter on is not the Value to be compared to entered. |
|
BEGINS WITH |
Item to filter on begins with the Value to be compared to entered. |
|
DOES NOT BEGIN WITH |
Item to filter on does not begin with the Value to be compared to entered. |
Enter Comparison Criteria
Entering Comparison Criteria depends on the Comparison that is selected and the Item that is selected to filter on.
If the Item that is selected to filter on has a pick list to select from the Value to compare to pick list will display options to select.
If the Item that is selected to filter on does not have a pick list to select from and needs values to be entered into a text box the text box next to the Value to compare pick list will be enabled to enter values in.
If the Between comparison is selected the and pick list will be enabled to be selected from or the text box will be enabled to enter values in.
Click the Add/Save Edit button to add the filter to the Selected Filters text box.
Repeat the filter process to add additional filters if needed.
Advanced filtering patient population for the report.
Selected Filters Section.
The Selected Filters Section allows for more advanced querying described below.
Upon adding multiple filters adds the filters as having both conditions to be met in order for information be returned.
Selecting a single filter in the Selected Filters section allows the user to be able to click the Edit or Remove buttons.
Clicking the Edit command button with a single filter selected in the Selected Filters section will allow the user to edit the filter criteria for the selected filter.
Clicking the Remove command button with a single filter selected in the Selected Filters section will remove the selected filter.
Selecting a Logical And or OR in the Selected Filters section allows the user to be able to click the And/Or button.
Clicking the And/Or button with a Logical And or OR selected in the Selected Filters section will allow the user to change the AND to an OR or an OR to an AND.
Selecting multiple filters in the Selected Filters section allows the user to be able to click the Group or UnGroup buttons.
Clicking the Group button with multiple filters selected in the Selected Filters section allows the user to group the selected filters into one logical statement.
Clicking the UnGroup button with multiple filters selected in the Selected Filters section allows the user to ungroup the selected filters into seperate logical statements.
Command Button Functionality
|
Command Button |
Description |
|
|
Allows users to edit the selected filter. |
|
|
Removes selected filter from the Selected Filter text box. |
|
|
Changes the logical operator selected from AND to OR or from OR to AND. |
|
|
Groups together multiple filters selected into one logical statement. |
|
|
Ungroups multiple filters selected into seperate logical statements. |
Generate Report section- Describes the Generate and Cancel buttons.
|
Command Button |
Description |
|
|
Generates the Ad Hoc List Report and displays the Ad hoc Report Results screen. |
|
|
Returns the user to the previous page. |
