I have clients with a lot of customer records and they use my pop-up table lookup feature to add new medical clinics. The problem is with near duplicate medical providers. The reason it is tricky is because computers are very exacting in their comparative analysis.
Look at the below two providers:
Early Medical Care Inc.
1234 Hope St.
San Jose, Ca. 90022
Phone: 555-3556
----------------------------------------------
Early Medical Case Corp.
1234 Hope Street
San Jose, Calif. 90022
Phone: 555-3556 X14
I do not currently have a separate list of providers for them to pick from. I present them with UNIQUE providers we find within their files. Any typo or modification in the company/address information we have on hand will ASSUME that this different record is ACTUALLY a new and different location. And therefore it will display it because it thinks it may be important. I have a sophisticated SQL command call that filters out the duplicates.
Now a human can usually tell that each of the above are one and the same place, but a computer can not.
It has been discussed that this issue may need a more creative solution. I would like your opinions. In short the question is, how much of a record needs to be considered in order for it to do a comparative analysis. (i.e. company,doctor,address, phone, fax).
One of the problems is that some staff members tend to type info they feel they know, because they are fast typists etc. The better choice is to REQUIRE that a staff member selects from a list, this will guarantee an EXACT match being recorded. And if it's an EXACT match, it gets eliminated from duplicate views in the pop up list. It is an issue we would like to address.
I hope the above makes a little sense. I'm soliciting the views of A5 users that have already addressed this issue.
Thanking you in advance.
Look at the below two providers:
Early Medical Care Inc.
1234 Hope St.
San Jose, Ca. 90022
Phone: 555-3556
----------------------------------------------
Early Medical Case Corp.
1234 Hope Street
San Jose, Calif. 90022
Phone: 555-3556 X14
I do not currently have a separate list of providers for them to pick from. I present them with UNIQUE providers we find within their files. Any typo or modification in the company/address information we have on hand will ASSUME that this different record is ACTUALLY a new and different location. And therefore it will display it because it thinks it may be important. I have a sophisticated SQL command call that filters out the duplicates.
Now a human can usually tell that each of the above are one and the same place, but a computer can not.
It has been discussed that this issue may need a more creative solution. I would like your opinions. In short the question is, how much of a record needs to be considered in order for it to do a comparative analysis. (i.e. company,doctor,address, phone, fax).
One of the problems is that some staff members tend to type info they feel they know, because they are fast typists etc. The better choice is to REQUIRE that a staff member selects from a list, this will guarantee an EXACT match being recorded. And if it's an EXACT match, it gets eliminated from duplicate views in the pop up list. It is an issue we would like to address.
I hope the above makes a little sense. I'm soliciting the views of A5 users that have already addressed this issue.
Thanking you in advance.
Comment