medicaid fraud database structures
DESCRIPTION
In Spring of 2010 I was on a Georgetown student consulting team that worked on figuring out if it was possible to detect Medicaid fraud from #opendata in small, medium, and large states. This is the database work behind that project.TRANSCRIPT
![Page 1: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/1.jpg)
Medicaid Fraud The Database Approach
Jessica JacobsHESY 480
April 26, 2010Georgetown University
![Page 2: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/2.jpg)
DATA TABLES
![Page 3: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/3.jpg)
Affiliation
![Page 4: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/4.jpg)
![Page 5: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/5.jpg)
Phone
![Page 6: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/6.jpg)
Individual
![Page 7: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/7.jpg)
Notes
![Page 8: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/8.jpg)
State
![Page 9: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/9.jpg)
Source
![Page 10: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/10.jpg)
Reference
![Page 11: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/11.jpg)
Providers
![Page 12: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/12.jpg)
Providers
![Page 13: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/13.jpg)
Tips
![Page 14: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/14.jpg)
Tips
![Page 15: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/15.jpg)
Audits
Audits Lookup
![Page 16: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/16.jpg)
Audits
![Page 17: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/17.jpg)
Audits Lookup
![Page 18: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/18.jpg)
Integrity
Integrity Lookup
![Page 19: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/19.jpg)
Integrity
![Page 20: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/20.jpg)
Integrity Lookup
![Page 21: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/21.jpg)
Payment
Payment Lookup
![Page 22: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/22.jpg)
Payment
![Page 23: Medicaid Fraud Database Structures](https://reader038.vdocuments.us/reader038/viewer/2022110308/558100e7d8b42a9d198b5120/html5/thumbnails/23.jpg)
Payment Lookup