If a report is built from a query template and the search is set on Records, how many times will a single patient appear in the results?

If a report is built from a query template and the search is set on Records, how many times will a single patient appear in the results?

• A. More than once
• B. Only once
• C. Twice
• D. As many times as contacts

Answer: (B)

When you build a report from a query template and set the search scope to Records, you’re pulling data from the patient records themselves. Each patient is treated as one record, so the result set is built around distinct patient records that meet the criteria. Even if a patient has multiple related contacts or visits, those are linked to the same patient record and do not create additional rows in this search scope. So a single patient will appear only once in the results. If you were searching on Contacts instead of Records, you might see multiple rows for the same patient—one for each contact. But with the search on Records, you get one row per patient record, hence only one appearance.

When you build a report from a query template and set the search scope to Records, you’re pulling data from the patient records themselves. Each patient is treated as one record, so the result set is built around distinct patient records that meet the criteria. Even if a patient has multiple related contacts or visits, those are linked to the same patient record and do not create additional rows in this search scope. So a single patient will appear only once in the results.

If you were searching on Contacts instead of Records, you might see multiple rows for the same patient—one for each contact. But with the search on Records, you get one row per patient record, hence only one appearance.