Define a New Patient List
Depending on how you want to set up your model document, you can define a new patient list globally—for all scenarios in the model document—or when you create each scenario.
Note: The model document must be currently checked out to you. Models checked out to you have a white background.

- Access the Model - Define Patient List page.
- Select Go To > Contract Modeling > Model Document Management. The Model Document Management page opens.
- Click Add Model Document at the top of the page. The Model Document Add page opens.
- Click Define Patient List. The Model - Define Patient List page opens.
- Type a name for the new list in the Patient List Name field.
- Select one of the following from the Claim Source list:
- Claim Master – Original claim data directly from claims in your facility.
- Bill Master – Claim data from claims in your facility that have been charge-compiled (claims that have been grouped together by account). This includes critical changes (changes that are made directly to the claim or the account).
- Canary Claim Master – An existing canary claim group.
- Selecting this option requires you to select a group from the Canary Claim Group list. You can only select one group from this list.
- Selecting Canary Claim Group restricts the fields and lists that are available.
- This option is only available if canary claims are enabled for your facility. For more information about canary claims, refer to Canary Claims.
- Specify the remaining criteria for your group.
- For detailed descriptions of each criteria, refer to the Field Descriptions table below.
- When entering patient numbers in the Patient Number field, you can enter multiple patient numbers, separated by a comma with no spaces; for example, 1234567,2345678.
- You can select the Exclude check boxes to exclude criteria rather than include. For example, you can enter a discharge status in the Discharge Status field to search for claims with the entered status, or you can enter a status and select the Exclude check box to search for claims with every status except the entered status.
- Plan ID effective and termination dates are considered during the patient lists creation process so that termed plan ID codes for the selected payor are excluded from the patient list.
- The Define Patient List page only uses primary payors when creating patient lists.
- Select the Additional Extended Search Criteria check box to search for specific ranges or individual Revenue Codes, Procedure Codes, HCPCS/Rates, Diagnosis Codes, Condition Codes, Tax IDs, Patient Zip Codes, and Provider Zip Codes.
- Select the Contracts, Products, or Plan Names radio button for a list of contract, products, or plan names to include in your group.
- Select the contracts, products, or plan names to include in your patient list.
- Use Ctrl + Click to select multiple items in the list.
- When you select a contract, product, or plan name, the associated plan IDs display in the box to the right.
- By default, all associated plan IDs are selected, but you can select the specific plan IDs you want to include or exclude.
- To select all associated plan IDs, click Select All.
- To exclude all associated plan IDs, click Unselect All.
- If you have permission to enter SQL queries to define your patient list, you can use the following steps to manually create a query:
- Click Enter SQL. The SQL Query field displays.
- Type the query in the SQL Query field.
- Click Quick Estimate of Patient List Size. The number of accounts that match your query display.
- If there is a syntax error in your query, an error message displays that shows you the line in your query where the error occurred.
- To return to previously entered criteria on this page, click Enter Criteria. Do not click Back on your browser window. Clicking Back reloads the page and deletes your previously entered criteria.
- Click Quick Estimate of Patient List Size or Thorough Estimate of Patient List Size. The number of accounts that met your criteria displays
- Click Save Patient List to save the list and return to the Model Document Add page. For more information, refer to Create a Model Document.
Note: The Patient List is not actually created until the Model is executed. The Save function just saves the Patient List criteria.
- Optionally, you can click or check:
- Reset to Defaults returns all fields to their default settings.
- Cancel clears your entries or changes and returns you to the Model Document Add page.
- Include Claims Where No Contract Service Types Matched
- Include Claims Which Have Been Reversed
- Allow Patient List Definition To Be Saved Without Performing Estimate Of Patient List Size – use this if your patient list is so large that you experience timing out issues. If you check this feature and then click Save, the claims amount will show 0 until the model has been executed.

The following table describes the fields on the Model - Define Patient List page.
Field |
Description |
Admit Date |
Date of admission for the account |
Allow Patient List Definition To Be Saved Without Performing Estimate Of Patient List Size |
Option to save a patient list without estimating list size. |
Bill Type |
Bill type |
Broker |
Person(s) or agency who supports the use of the coverage plan and is associated with the claims included in the patient list |
Canary Claim Group |
A list of available canary claim groups you can include in your patient list. This list is only available if you selected Canary Claim Master as your claim source. You can only select one group from this list. |
Contracts/ Products |
A list of products or contracts to select from, depending upon which radio button you choose |
Discharge Status |
Patient’s destination upon discharge (home, LTC, etc.), to include or exclude in the search |
DRG |
Specific DRG(s) that appear on the claim, separated by comma, to include or exclude in the search |
Extended Search |
Specifies revenue codes, procedure codes, HCPCS/Rates, diagnosis codes, or transaction codes. Multiple codes with commas (or dashes to specify ranges) are valid, such as 270, 271, 200-300, 425 |
Financial Class |
Financial class code |
Hospital Service Code |
Hospital service code(s) associated with the claim. Separate multiple entries with a comma |
Include Claims Where No Contract Service Types Matched (Message Code 0021) |
Option to included claims without matching service types |
Include Claims Which Have Been Reversed (Message Code 0007) |
Option to include reversed claims |
Minimum Total Charges |
Least amount of total charges on the claims; Type .01 (or more) to exclude claims with $0 charges. |
NPI |
National Provider Identification (NPI) number to include or exclude in the search. You can type one or more NPI numbers, separated by commas, or include/exclude the following NPI types:
Note: If you selected Canary Claim Master as your claim source, this field is not available. |
Patient Age |
Age range for the patient age on the claims. If no “From” data is entered, “0” is assumed. Range must be chronological. |
Patient List Name |
Name of the patient list. Follow your standard naming conventions. |
Patient List Source |
Specifies the database from which your patient list is created:
|
Patient Number |
Patient account number (for UB claims) or insured ID (for CMS-1500 claims) to include or exclude in the search. You can enter multiple patient numbers, separated by a comma with no space; for example, 1234567,234568 |
Patient Sex |
Patient’s gender |
Patient Type |
Patient type assigned to the account: Inpatient/Outpatient |
Plan ID |
Identification code(s) of the coverage plan, separated by comma, to include or exclude in the search |
Provider Name |
Name of the healthcare provider |
Provider Number |
Provider’s tax ID number or ten-digit National Provider Identification (NPI) number required on all claims |
Service From Date |
Date range for claim Service From dates, in the format M/D/YY, MM/DD/YYYY or YYYYMMDD. |
Service To Date |
Date range for claim Service To dates, in the format M/D/YY, MM/DD/YYYY or YYYYMMDD. |
Submit Date |
Date rage for the submission of the claim(s), in the format M/D/YY, MM/DD/YYYY or YYYYMMDD. The default "to" date is the current date |
Taxonomy |
Provider/specialty type to include or exclude in the search |