PDMP Partial Name Searches - Virginia but for most states!

PDMP - Partial Name Searches - How to do it.

Sometimes less is MORE!

If you are not finding the patient you need, you might try casting a broader search - yes, we like to be as precise as we can.  But, with SQL tables, sometimes we need to ask a question which will return a larger subset of data.  For example,  Looking for Mary C Smith with a DOB of 1/10/1999,  If there are several Mary Smith with same DOB, you may or may not get the one that you want!   

I had exactly this problem.  E.g.  Mary C Smith and  Mary J Smith both had same DOB but were two different people.  Entering Mary Smith and Mary J Smith got the wrong person and entering Mary C Smith got the same wrong person!  Entering phone number and address got me NO RESULT!   A call to my local PDMP Admin and after a few questions the answer was to use a PARTIAL SEARCH to find a list of ALL the patients in order to display the one I wanted and then be able to choose that one.

If you are not finding the patient you need, you might try casting a broader search - yes, we like to be as precise as we can.  But, with SQL tables, sometimes we need to ask a question which will return a larger subset of data.  For example,  Looking for Mary J Smith with a DOB of 1/10/1999,  If there are several Mary  Smiths  with same DOB, you may or may not get the one that you want!   
Here is the situation that I ran into with VA PDMP query ( NarxCare Returned the correct patient but VA PDMP did not!):

I am looking for Mary J Smith   with DOB: 1/1/1999 -  1 North Street,  Town1, VA  22222
I put in the Name: Mary J Smith   DOB: 1/1/1999   - no address.  
VA PDMP RETURNED:  Mary C Smith  DOB: 1/1/1999 - 2 South Street,  Town2, VA 22312
I COULD NOT Get Mary J Smith - even with putting in her correct address  and phone number- that returned Nothing!    Mary  Smith with DOB did not return all of the Mary Smiths! 
After speaking with the folks at VA PDMP the solution was:

First Name: Mar     Last Name: Smi      DOB: 01/10/1999   Click the Partial Spelling Boxes for first and last names ( this tells the database to return any potential matches)
Click "Agree"  and SUBMIT.


 

Result set included:
Mary C Smith 
Mary J Smith
and others!
I was able to pick Mary J Smith from the list and get the information I needed!!!

NEXT TIME:  NarxCare Reports: The Good, The Bad and The Ugly.....


PDMP Query - it's the Law.

Ron

 

 

Leave your comments

Comments

  • No comments found