---
title: Identifying Unassigned Patients for Data Transfer
slug: portal-sub/identifying-unassigned-patients-for-data-transfer
docTags: 
createdAt: 2026-03-04T12:03:22.817Z
---

The process for identifying patients not assigned to a provider in Find Objects is very similar to the process to [find patients by provider.](docId\:Eu5Yp9BMHxQu2RnsVPVSF)  The main difference is the provider code used in the search.  

Below are the steps to identify patients not assigned to a provider:

::::WorkflowBlock
:::WorkflowBlockItem
In the Find Objects window, click on the Objects drop down window and select Patient.  This will display the Patient related objects we can query.  For the purposes of this query, we will only select details relevant to identifying patients for export.  From the Patient Object list, select the following objects by dragging the object to the top right window labelled Select.  These will be fields that will be displayed in the output of the query:

- FileNum
- Name Last Name
- Name First Name
- National Num

::Image[]{src="https://api.qa.archbee.co/api/optimize/zICxj0dnLereb6UUrBA3-/dtH9dMqX8CBrRsoGFkcoL_dbgey8k34ef6-fiaxyyc7n0ou3-mzgxhmw.png" size="100" isUploading="false" initialPath="assets/DBGEY8K34EF6-fiAXYYC7N0oU3-MzgxHmw.png" githubPath="en/Technical Resources/Data Transfer/assets/DBGEY8K34EF6-fiAXYYC7N0oU3-MzgxHmw.png" position="flex-start" showCaption="false" indent="2"}
:::

:::WorkflowBlockItem
The second part of the query will be the conditions required for filtering.  To identify patients not assigned to a provider, we will be identifying patients with no usual provider.  To add the conditions to the Find Objects query:

1.   In the Patient Object list, locate the Usual Doctor folder and click once to expand the folder.  
2. Locate the Code object and drag the object over to the bottom right window labelled Where.   
3. In the Condition field, click on the drop-down button, and select **is null** (NULL refers to a blank field)
4. In the Patient Object list, locate Type, and drag to the Where field.  Select Patient from the value field to filter only Patients.
5. Click the Play button to generate the report in Profile.

::Image[]{src="https://api.qa.archbee.co/api/optimize/zICxj0dnLereb6UUrBA3-/P4pbI4LzLqRk1sqaA2YyJ_iwovfc8edavqzzoryuroctiwqz360oxbq.png" size="100" isUploading="false" initialPath="assets/iWOvfc8EDavQZzoRyuroCtiwqz_360OXbQ.png" githubPath="en/Technical Resources/Data Transfer/assets/iWOvfc8EDavQZzoRyuroCtiwqz_360OXbQ.png" position="flex-start" showCaption="false" indent="2"}

6. This will generate a list of patients belonging to no provider code.  This can be exported to file if required by checking the Direct to Disk checkbox and pressing Play again to generate either a report, or a CSV file that can be imported into Excel for additional processing.
:::
::::