Date overlap with lots of data

1 post / 0 new
CFE4130
Offline
Joined: 08/05/2019 - 12:59
Date overlap with lots of data

 
A while back, I used the script in the link below to identify hospital overlap. 
https://ideascripting.com/forum/overlapping-dates
 
Hospital overlap occurs when a provider bills a patient for service at doctor's office, home, etc. while the patient is actually in the hospital. The script in the link did identify the overlap. For example:

Provider
Start Date
End Date
Over Lap

St. Martin Hospital
5/2/2016
5/30/2016
-27

Performance Care LLC
5/3/2016
5/3/2016
0

Thomas Medical Center
5/3/2016
5/3/2016
1

Performance Care LLC
5/4/2016
5/4/2016
0

Smith Charles MD
5/4/2016
5/4/2016
5

Performance Care LLC
5/9/2016
5/9/2016
0

Speedy Transportation
5/9/2016
5/9/2016
2

Performance Care LLC
5/11/2016
5/11/2016
1

Performance Care LLC
5/12/2016
5/12/2016
4

You can see the hospital stay along with dates that overlap. The problem is that most of the time we have over a hundred thousand claims to search through. Is there another script that can be run that would extract the hospital stay and all of the conflicting claims that fall in the date range? FYI the data will also have different patients with in it. 
*I attached the Excel file which shows how it's laid out unlike when I copied and pasted it into the body of this message. 

Files: