09-12-2019 01:56 PM
I am looking for a query that list all patients in our system with MRN, patient first and last name, plus date of birth.
We do not use MPI.
Thanks for your suggestions on how to get this accomplished.
09-13-2019 05:19 AM
Hi Angele,
I believe this query will return the information you are looking for:
SELECT medrecnumber 'MRN' ,ptfirstname 'First Name' ,ptlastname 'Last Name' ,ptdob 'DOB'FROM hsi.medrec (NOLOCK)
Please let me know if this helps out.
Best,
Joel
09-13-2019 05:19 AM
Hi Angele,
I believe this query will return the information you are looking for:
SELECT medrecnumber 'MRN' ,ptfirstname 'First Name' ,ptlastname 'Last Name' ,ptdob 'DOB'FROM hsi.medrec (NOLOCK)
Please let me know if this helps out.
Best,
Joel
09-13-2019 09:39 AM
Hi Joel,
Thanks for the quick response.
I do need to start with
"set transaction isolation level read uncommitted", right?
09-13-2019 09:58 AM
Hi Angele,
The (NOLOCK) hint I included will solve the same problem scoping the isolation level will, so no need to change anything with this query explicitly. If you intend on running more queries in the same session, I'd recommend setting the isolation level instead.
Please let me know if you have any further questions.
Best,
Joel
09-13-2019 01:52 PM
that works. Thanks Joel. I appreciate it.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.