S
SageOne
I have a table of over 100,00 membership health coverage records. Each
record displays a start date of membership, an end date of membership, and a
name.
Start Date End Date Name
Plan
11/05/2006 12/20/2007 Joe Smith Plan A
12/21/2007 12/21/2008 Joe Smith Plan B
There can only be one Plan per person per time period. But because of human
data entry error, some people in this list have overlapping coverage and show
as having two plans per the same time period.
Example
Start Date End Date Name
Plan
11/05/2006 12/20/2007 Joe Smith
Plan A
10/20/2007 12/21/2008 Joe Smith
Plan B
As you can see above, Joe Smith's Plan coverage over laps during the months
of Oct, Nov, and Dec.
Is there a way to pull from the 100,000 records only the occurrences where
coverage is over lapping?
record displays a start date of membership, an end date of membership, and a
name.
Start Date End Date Name
Plan
11/05/2006 12/20/2007 Joe Smith Plan A
12/21/2007 12/21/2008 Joe Smith Plan B
There can only be one Plan per person per time period. But because of human
data entry error, some people in this list have overlapping coverage and show
as having two plans per the same time period.
Example
Start Date End Date Name
Plan
11/05/2006 12/20/2007 Joe Smith
Plan A
10/20/2007 12/21/2008 Joe Smith
Plan B
As you can see above, Joe Smith's Plan coverage over laps during the months
of Oct, Nov, and Dec.
Is there a way to pull from the 100,000 records only the occurrences where
coverage is over lapping?