- Welcome
- Introduction
- How to Pages
-
Window and Field Descriptions
- Saved Queries Window
- Add Criteria Window
- Demographics Criteria
- Health Districts
- Last Known Residence
- Alive/Dead
- Pedigree Quality
- Birth Details Criteria
- Diagnosis Criteria
- Diagnosis Criteria Applied to the Utah Cancer Registry
- Diagnosis Criteria Applied to Utah Inpatient Claims and Death Certificates
- Diagnosis Classification
- Procedure Criteria
- Relationship Criteria
- Cohort Builder Window
- Totals Window
- Queries and Aggregation
- Select Grouping Criteria For Results Window
- Birth Order
- Examine Relationships Window
- Relationships
-
Common Error Messages
- Login failed. Please check your user ID and password and try again
- Please fix errors (red) before continuing
- Please select the aggregation criteria you would like to delete
- Please select the aggregation criteria you would like to move
- Please select the criteria you would like to delete
- Please select the query you would like to delete
- Registration Successful
- Server Error Request
- This will delete the selected criteria and all sub-criteria. Continue?
- You have agreed to adhere to the rules set forth in the Data Use Agreement
- You must choose at least one criteria to aggregate by, before running your query.
- You must select at least one criteria to aggregate by.
- Your cohort contains # individuals.
- Your selection did not include any criteria that would limit your cohort.
- Miscellaneous
These instructions assume that you have an existing query that you wish to run. If you need to create the query before running it. If you have just finished creating the query and are currently on the Aggregation page, start with step 5 below.
To run an existing query:
- Click on the Query UPDBL button on the upper right side of the window or click on the Query UPDBL button in the lower right corner of the window. The Saved Queries window open.
- Find the query you wish to run in the Saved Queries list and click on it.
- Click on the Load button on the right side of the Saved Queries window. The Cohort Builder window will open, listing the criteria for the selected query.
At this point, if you want to make any changes to the query before running it, you can do so.
- Click on the button marked Select and Run Aggregation to turn to the Totals window.
- Click on the Run Query button beneath the Format Results grid to run the query. The aggregated totals will appear in the bottom portion of the window. It may take a few minutes to run the query.
- The query has now been run. You may stop here, or — if you would like to download the results of the query as an Excel file — click on the Download Results button. A dialog will open asking if you want to open or save the resulting Excel file.
- Select Save. A dialog will open asking you to select the location where you want to save the results file.
The File Download dialog may appear different depending on which browser you are using. You may also choose to open the file instead of saving it.
- Choose a location, save the file and open it in Excel (or another spreadsheet application that can read Excel files) to view the resulting spreadsheet.
After running the query, you can also examine relationships between patients in the selected cohort.