Use this dialog to select the criteria to use in the search.
To open this dialog, select the Add or Edit button in the Add/Modify Searches dialog to open the Select Search Criteria dialog.
Fields & buttons
Search name
Use this field to add the name of a new search or change the name of an existing search that you or someone in your firm created.
note
Each search within the client database that you selected from the Data Mining window must have a unique name.
Product
Select federal or a state to indicate which returns or input screens you want to search for specific forms, calculated values, and/or input screen field values. This field lists all licensed federal and state applications for the client database that you selected in the Data Mining window.
Form
Select this option to display the list of forms available for the selected federal or state application. When you select a form from this list, the search examines the database to find clients for whom that form was prepared. To search for clients for whom the form was
not
prepared, select the
Form
option and select the
Not prepared
option.
note
Forms criteria only applies to clients whose returns have been calculated.
Calculated value
Select this option to display the list of calculated value criteria available for the selected federal or state application. When you select calculated value criteria from this list, the search examines the database to find clients whose data contains those search criteria.
note
Calculated value criteria do not apply to clients whose returns have not been calculated.
If the list of available criteria does not meet your needs (for example, if you want to specify the numeric values for the available criteria), select the Add/Modify button to add or modify calculated value criteria.
Predefined search criteria, which are included with Data Mining, cannot be modified.
Input screen field
Select this option to display the list of all available input screen field search criteria. When you select an input screen field from this list, the search examines the database to find clients whose data includes the acceptable values for that input screen field.
note
If the list of available criteria does not meet your needs, you can add or modify input screen field criteria.
note
Predefined search criteria, which are included with Data Mining, cannot be modified.
State Attachment
Select this option to display the selected state application. When you select state attachment from this list, the search examines the database to find clients for whom that state was attached. To search for clients for whom the state return was not attached, select the State attachment option and select the Not attached option.
note
This option is available only when a state is selected from the Product drop-down menu.
Return type
Select this option to display the list of all available return types.
note
This option is available only when Federal is selected from the Product drop-down menu.
Client status
Select this option to display the list of all client status events.
note
Tips
To change what display in the pane, select the
Logged anytime
,
Current status
or
Not logged
options.
If the list of available criteria does not meet your needs, you can add or modify input screen field criteria.
note
This option is available only when Federal is selected from the Product drop-down menu.
Add/Modify
For calculated values - Select the Add/Modify button to open the Add/Modify Search Criteria dialog with the Calculated values list displayed. Here you can change the numeric values you want to find for each calculated value search criterion that you or someone in your firm created. You can also add new search criteria based on existing criteria.
For input screen fields - Select the Add/Modify button to open the Add/Modify Search Criteria dialog with the Input screen fields list displayed. Here you can add input screen fields to the list of available criteria and specify the data you want to find for each input screen field search criterion.
For Client status - Select the Add/Modify button to open the Add/Modify Search Criteria dialog with the Client status list displayed. Here you can add status events to the list of available criteria and specify the data you want to find for each event.
note
This button is available only if you select the
Calculated value
, the
Input screen field
, or the
Client status
option.
note
When you add or modify a search criterion in the Search Criteria list, the new definition applies to all searches that use that criterion. If you do not want to affect existing searches, do not modify the search criterion. Instead, add and edit a new search criterion.
Available criteria
Select an available search criterion in this list and choose the Select button to include the criterion in the search. The search examines the database to find clients whose data includes the criterion.
note
If the
Form
option is selected, the Available criteria list shows all forms for the selected federal or state application as prepared.
If the
Not prepared
option is selected, the Available criteria list shows all forms for the federal or state application as not prepared.
If the
Calculated value
option is marked, the Available criteria list shows the calculated value criteria available for the federal or state application.
If you select the
Input screen field
option, the Available criteria list shows all input screen fields that have been selected in the Add/Modify Search Criteria dialog as available criteria.
if you select the&
State Attachment
option, the Available criteria list shows the attached or not attached options. (This option is available only when a state is selected in the Product drop-down menu.)
If you select the
Return type
option, the Available criteria list shows all available return types for the entity.&
(This option is available only when Federal is selected in the Product drop-down menu.)
If you select the
Client status
option, the Available criteria list shows all status events, both UltraTax CS status events and user-defined status events.
&
(This option is available only when Federal is selected in the Product drop-down menu.)
Calculated value and form criteria do not apply to clients whose returns have not been calculated.
note
If the list of available criteria does not meet your needs, you can add or modify input screen field criteria.
note
Predefined search criteria, which are included with Data Mining, cannot be modified.
Select
Select this button to move the highlighted search criterion from the Available criteria list to the Selected criteria list below.
note
Select the Remove button to remove the highlighted search criterion from the Selected criteria list.
Remove
To remove a search criterion from the search, select the criterion in the Selected criteria list, then select this button. The criterion returns to the Available criteria list.
Selected criteria
Displays the AND and OR relationships in the search formula if the selected search contains more than one criterion. If desired, you can edit the search formula.
note
Highlight a search criterion and select the Remove button to remove a search criterion from the list.
Edit Formula
Select this button to open the Edit Formula dialog. In this dialog, you can change the relationship between search criteria.