Health care patient benefits eligibility research system and methods
View Patent ↗The software of the present invention provides a means for creating a file of unpaid claims for a service provider. The software is used to create one or more queries to compare information in the file of claims against records in a benefit provider's database to determine the eligibility status of the claim. A file is created containing each claim for which a matching record in the benefit provider's database is found, and the information from that matching record. A report can be generated from the file of matching claims and benefit provider records, so the claims can be submitted for payment by the service provider.
1. A tangible, non-transitory computer program product for comparing a service provider's medical care claims against a benefit provider's database, the computer program product having a computer readable medium with a computer program executable by a computer embodied thereon, the computer program comprising instructions which, when executed by the computer, cause the computer to perform the following operations:
a. generating a first file of claims from the service provider, wherein said first file is organized such that data associated with at least two fields for each of the claims is formatted for comparison with the benefit provider's database, wherein the at least two fields are different from each other;
b. executing a first query of the benefit provider's database using data from one of said at least two fields for a claim in the first file and executing a second query of the benefit provider's database using data from another of said at least two fields for said claim;
c. adding said claim to a second file if a record in the benefit provider's database is responsive to said first query and said second query; and
d. generating a report indicative of one or more differences between said claim for which a responsive record was found and said responsive record.
2. The tangible computer program product of claim 1 further comprising instructions for executing a first group of queries along with said first query wherein each query among the first group of queries uses data in at least one field from different claims in the first file in a comparison to data in corresponding fields in records in the benefit provider's database.
3. The tangible computer program product of claim 2 wherein the data used in each individual query among the first group of queries is related to a patient identification number and the corresponding fields in records in the benefit provider's database are related to a patient identification number.
4. The tangible computer program product of claim 2 further comprising instructions for tracking the effectiveness of queries.
5. The tangible computer program product of claim 4 wherein the effectiveness of queries is based on whether it produces one or more responsive records from the benefit provider's database.
6. The tangible computer program product of claim 4 further comprising instructions for adaptively modifying queries based on the effectiveness of queries.
7. The tangible computer program product of claim 6 wherein the modifying of queries is executed automatically.
8. The tangible computer program product of claim 1 wherein the data used in either of the first query or the second query is a subset of data associated with a field.
9. The tangible computer program product of claim 8 wherein the subset of data is the first four letters of an individual's last name.
10. The tangible computer program product of claim 1 wherein either the first query or the second query searches for partial matches of data in multiple different fields.
11. The tangible computer program product of claim 1 wherein said claim is added to the second file because the data in a predefined number of fields match with at least one record in said benefit provider's database.
12. The tangible computer program product of claim 1 wherein the first query and the second query are run sequentially.
13. The tangible computer program product of claim 1 wherein the first query and the second query are run simultaneously.
14. A tangible, non-transitory computer program product for comparing a service provider's medical care claims against a benefit provider's database, the computer program product having a computer readable medium with a computer program executable by a computer embodied thereon, the computer program comprising instructions which, when executed by the computer, cause the computer to perform the following operations:
a. generating a first file comprising claims from the service provider formatted for comparison with the benefit provider's database;
b. executing a first query of the benefit provider's database using data from a claim in the first file and adding the claim to a second file if one or more records in the benefit provider's database are responsive to said first query;
c. establishing one or more time intervals and executing one or more additional queries of the benefit provider's database using data from said claim following the one or more time intervals if no record of the benefit provider's database is responsive to said first query; and
d. adding said claim to said second file if one or more records in the benefit provider's database are responsive to said one or more additional queries, wherein the one or more responsive records in the benefit provider's database comprise new or corrected information following the one or more time intervals.
15. The computer program product of claim 14 wherein the one or more time intervals are related to a duration wherein a patient who was not found to be eligible for reimbursement before the one or more time intervals is found to be eligible for reimbursement after the one or more time intervals.
16. The computer program product of claim 14 wherein the one or more time intervals are bi-weekly or monthly.
17. The computer program product of claim 14 wherein at least one claim in said first file is related to a newborn baby.
18. The computer program product of claim 14 further comprising instructions for not re-executing a given query prior to the one or more time intervals if one or more records in the benefit provider's database are responsive to said given query upon an initial execution of said given query.
19. A tangible, non-transitory computer program product for comparing a service provider's medical care claims against a benefit provider's database, the computer program product having a computer readable medium with a computer program executable by a computer embodied thereon, the computer program comprising instructions which, when executed by the computer, cause the computer to perform the following operations:
a. generating a first file comprising claims from the service provider, wherein said first file is organized such that data associated with at least one field for each of said claims in said first file is formatted for comparison with the benefit provider's database;
b. executing a first query of the benefit provider's database, wherein the first query compares data in at least one field of a first claim in the first file with the benefit provider's database, and adding the first claim to a second file if one or more records in the benefit provider's database are responsive to said first query;
c. executing a second query of the benefit provider's database, wherein the second query compares data in at least one field of a second claim in the first file with the benefit provider's database, and adding the second claim to the second file if one or more records in the benefit provider's database are responsive to said second query; and
d. generating a report including data from claims in the second file and data from responsive records in the benefit provider's database, wherein differences between the claims from the second file and the responsive records from the benefit provider's database are shown.
20. The tangible computer program product of claim 19 further comprising:
a. instructions for executing a first group of queries wherein each individual query in the first group of queries uses data associated with a different claim in the first file and compares that data to the same corresponding fields in records in the benefit provider's database as compared in said first query;
b. instructions for adding a first subset of claims to a second file based on the results of the first query and the first group of queries;
c. instructions for executing a second group of queries wherein each individual query in the second group of queries uses data associated with a different claim in the first file and compares that data to the same corresponding fields in records in the benefit provider's database as compared in said first query;
wherein the second query and the second group of queries use data associated with claims in the first file that are not part of the first subset of claims.
21. The tangible computer program product of claim 19 further comprising instructions for executing a first group of queries along with said first query wherein each query among the first group of queries uses data in at least one field from different claims in the first file in a comparison to data in corresponding fields in records in the benefit provider's database.
22. The tangible computer program product of claim 21 wherein the data used in each individual query among the first group of queries is related to a patient identification number and the corresponding fields in records in the benefit provider's database are related to a patient identification number.
23. The tangible computer program product of claim 21 further comprising instructions for tracking the effectiveness of queries.
24. The tangible computer program product of claim 23 wherein the effectiveness of a query is based on whether such query produces one or more responsive records from the benefit provider's database.
25. The tangible computer program product of claim 23 further comprising instructions for adaptively modifying queries based on the effectiveness of queries.
26. The tangible computer program product of claim 25 wherein the modifying of queries is executed automatically.
27. The tangible computer program product of claim 19 wherein the data used in either of the first query or the second query is a subset of data associated with a field.
28. The tangible computer program product of claim 27 wherein the subset of data is the first four letters of an individual's last name.
29. The tangible computer program product of claim 19 wherein either the first query or the second query searches for partial matches of data in multiple different fields.
30. The tangible computer program product of claim 19 wherein at least one of said first claim and said second claim is added to the second file because the data in a predefined number of fields match with at least one record in said benefit provider's database.
31. The tangible computer program product of claim 19 wherein the first query and the second query are run sequentially.
32. The tangible computer program product of claim 19 wherein the first query and the second query are run simultaneously.
33. A tangible, non-transitory computer program product for comparing a service provider's medical care claims against a benefit provider's database, the computer program product having a computer readable medium with a computer program executable by a computer embodied thereon, the computer program comprising instructions which, when executed by the computer, cause the computer to perform the following operations:
a. generating a first file comprising claims from the service provider, wherein said first file is organized such that data associated with at least two fields for each of said claims in said first file is formatted for comparison with the benefit provider's database;
b. for each of said claims, executing a first query of the benefit provider's database, wherein the first query compares data in a first field of a respective claim in the first file with the benefit provider's database, and adding the respective claim to a second file if one or more records in the benefit provider's database are responsive to said first query;
c. for each of said claims, executing a second query of the benefit provider's database if no records in the benefit provider's database are responsive to said first query, wherein the second query compares data in a second field of the respective claim in the first file with the benefit provider's database, and adding the respective claim to the second file if one or more records in the benefit provider's database are responsive to said second query; and
d. generating a report including data from claims in the second file and data from responsive records in the benefit provider's database, wherein differences between the claims from the second file and the responsive records from the benefit provider's database are shown.
34. The tangible computer program product of claim 33 wherein said first field comprises a patient identification number and said second field comprises a name.
35. The tangible computer program product of claim 33 wherein the second query compares data in multiple fields other than the first field of the respective claim in the first file with the benefit provider's database.
36. The tangible computer program product of claim 35 wherein said first field comprises a patient identification number and wherein said multiple fields comprise a date of birth, a first name, and the first four letters of a last name.