List of all patient with MRN in our system

[Angele_Djogou]

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.

[Joel_Moore1 · Accepted solution]

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

[Angele_Djogou]

Hi Joel,

Thanks for the quick response.

I do need to start with

"set transaction isolation level read uncommitted",  right?

[Joel_Moore1]

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 

[Angele_Djogou]

that works. Thanks Joel. I appreciate it.