Information systems lab

profileblank.
AdvancedExcelProjectData2.xlsx
Home>Business & Finance homework help>Management homework help>Information systems lab

Monthly Summary

Patient Summary

Practice Summary

Patient Accounts

Practice Name Tax Identification Number First Name Last Name Account Number Date of Service Month Balance
AC Wright, MD Clay Ahart 1200-0043 1/12/16 January $95.00
Bluegrass Community Family Practice Jessica Akin 1200-0044 1/13/16 January $200.00
Dee & Associates Laura D. Allen 1200-0001 1/1/16 January $25.00
Family Medicine Associates of Flemingsburg Rayan A. Almalki 1200-0002 1/2/16 January $50.00
Family Practice Associates of Lexington Majed R. Almutairi 1200-0003 1/3/16 January $75.00
Graves Gilbert Clinic Nawaf Alotaibi 1200-0045 1/14/16 January $220.00
Internal Medicine Associates of Frankfort Haif O. Al-Otaibi 1200-0004 1/4/16 January $60.00
Jackson Purchase Medical Associates Faisal A. Alresheedi 1200-0005 1/5/16 January $40.00
Lewis County Primary Care Shadi I. Alruthea 1200-0006 1/6/16 January $20.00
London Womens Care Nader Alsharari 1200-0046 1/15/16 January $240.00
Monticello Medical Marivic M. Alvear 1200-0007 1/7/16 January $10.00
Norton Health System (Hospital) Nicole B. Armstrong 1200-0008 1/8/16 January $30.00
Ohio County Family Care Chase Berry 1200-0047 1/16/16 January $260.00
Owensboro Health Maleah J. Boisture 1200-0009 1/9/16 January $50.00
Primary Care Medical Center Laura Boone 1200-0048 1/17/16 January $280.00
AC Wright, MD Lawrence Brown 1200-0049 1/18/16 January $290.00
Bluegrass Community Family Practice Abdulaziz R. Bunji 1200-0010 1/10/16 January $70.00
Dee & Associates Stacey L. Camp 1200-0011 1/11/16 January $90.00
Family Medicine Associates of Flemingsburg Dillion Carver 1200-0050 1/19/16 January $270.00
Family Practice Associates of Lexington Maggie Clark 1200-0051 1/20/16 January $250.00
Graves Gilbert Clinic Desirae J. Cocanougher 1200-0012 1/12/16 January $100.00
Internal Medicine Associates of Frankfort Luke Coleman 1200-0052 1/21/16 January $230.00
Jackson Purchase Medical Associates Chelsea D. Conner 1200-0013 1/13/16 January $125.00
Lewis County Primary Care Nicholas N. Courtney 1200-0014 1/14/16 January $150.00
London Womens Care Jordan L. Crain 1200-0015 1/15/16 January $140.00
Monticello Medical Randa Denning 1200-0053 1/22/16 January $210.00
Norton Health System (Hospital) Nhung Dinh 1200-0054 1/23/16 January $8.00
Ohio County Family Care Lauren Dixon 1200-0055 1/24/16 January $18.00
Owensboro Health Alissa M. Doan 1200-0016 1/16/16 January $130.00
Primary Care Medical Center Melanie Duitsman 1200-0056 1/25/16 January $28.00
AC Wright, MD Katie Ernwine 1200-0057 1/26/16 January $38.00
Bluegrass Community Family Practice Nanci A. Escobar 1200-0017 1/17/16 January $120.00
Dee & Associates Alyx Fey 1200-0058 1/27/16 January $48.00
Family Medicine Associates of Flemingsburg Shamira Feytul 1200-0059 1/28/16 January $58.00
Family Practice Associates of Lexington Juan A. Garcia 1200-0018 1/18/16 January $110.00
Graves Gilbert Clinic Rebecca Garrison 1200-0060 1/29/16 January $68.00
Internal Medicine Associates of Frankfort Joyce O. Gecheo 1200-0019 1/19/16 January $29.00
Jackson Purchase Medical Associates Alexandria M. Glenn 1200-0020 1/20/16 January $49.00
Lewis County Primary Care Taylor N. Gowen 1200-0021 1/21/16 January $69.00
London Womens Care Jessica L. Grant 1200-0022 1/22/16 January $89.00
Monticello Medical Megan Haile 1200-0061 1/30/16 January $78.00
Norton Health System (Hospital) Ashley Haley 1200-0062 1/31/16 January $88.00
Ohio County Family Care Whitney Hankins 1200-0063 1/1/16 January $98.00
Owensboro Health Nicole Hirschler 1200-0064 1/2/16 January $7.00
Primary Care Medical Center Heather L. Jackson 1200-0023 1/23/16 January $5.00
AC Wright, MD Jamie Jaggers 1200-0065 1/3/16 January $17.00
Bluegrass Community Family Practice Brooke A. Johnson 1200-0024 1/24/16 January $190.00
Dee & Associates Elizabeth J. Koehler 1200-0025 1/25/16 January $170.00
Family Medicine Associates of Flemingsburg Parker Kuhn 1200-0066 1/4/16 January $27.00
Family Practice Associates of Lexington Keri Legg 1200-0067 1/5/16 January $37.00
Graves Gilbert Clinic Mack McKeown 1200-0068 1/6/16 January $47.00
Internal Medicine Associates of Frankfort Emily A. McMurtrey 1200-0026 1/26/16 January $150.00
Jackson Purchase Medical Associates Jordon Metcalf 1200-0069 1/7/16 January $57.00
Lewis County Primary Care Olivia A. Mock 1200-0027 1/27/16 January $130.00
London Womens Care Ameerah Muhammad 1200-0070 1/8/16 January $67.00
Monticello Medical Samir Music 1200-0028 1/28/16 January $110.00
Norton Health System (Hospital) Anh Nguyen 1200-0071 1/9/16 January $77.00
Ohio County Family Care Brooke Nichols 1200-0072 1/10/16 January $87.00
Owensboro Health Natalie L. Oliver 1200-0029 1/29/16 January $115.00
Primary Care Medical Center Susan M. Pennington 1200-0030 1/30/16 January $135.00
AC Wright, MD Megan B. Pitts 1200-0031 1/31/16 January $155.00
Bluegrass Community Family Practice Casey Price 1200-0073 1/11/16 January $97.00
Dee & Associates Ashton Puckett 1200-0074 1/12/16 January $3.00
Family Medicine Associates of Flemingsburg Kyle T. Ray 1200-0032 1/1/16 January $175.00
Family Practice Associates of Lexington Colton Richardson 1200-0075 1/13/16 January $13.00
Graves Gilbert Clinic Betty Richter 1200-0076 1/14/16 January $23.00
Internal Medicine Associates of Frankfort Ashlee M. Robinson 1200-0033 1/2/16 January $195.00
Jackson Purchase Medical Associates Freddie Rowe 1200-0077 1/15/16 January $33.00
Lewis County Primary Care Mallory A. Runnels 1200-0034 1/3/16 January $5.00
London Womens Care Jake Schoeff 1200-0078 1/16/16 January $43.00
Monticello Medical Logan D. Shaw 1200-0035 1/4/16 January $15.00
Norton Health System (Hospital) Olivia M. Sheaffer 1200-0036 1/5/16 January $25.00
Ohio County Family Care Madison E. Shirley 1200-0037 1/6/16 January $35.00
Owensboro Health Megan N. Sircy 1200-0038 1/7/16 January $45.00
Primary Care Medical Center Tayler Smith 1200-0079 1/17/16 January $53.00
AC Wright, MD Celeste A. Somerville 1200-0039 1/8/16 January $55.00
Bluegrass Community Family Practice James B. Stephens 1200-0040 1/9/16 January $65.00
Dee & Associates Rachel Tilley 1200-0080 1/18/16 January $63.00
Family Medicine Associates of Flemingsburg Jordan M. Webb 1200-0041 1/10/16 January $75.00
Family Practice Associates of Lexington Joseph T. Williamson 1200-0042 1/11/16 January $85.00
Graves Gilbert Clinic Shea Wilson 1200-0081 1/19/16 January $73.00
AC Wright, MD Clay Ahart 1200-0043 2/5/16 February $95.00
Bluegrass Community Family Practice Jessica Akin 1200-0044 2/13/16 February $200.00
Dee & Associates Laura D. Allen 1200-0001 2/1/16 February $25.00
Family Medicine Associates of Flemingsburg Rayan A. Almalki 1200-0002 2/2/16 February $50.00
Family Practice Associates of Lexington Majed R. Almutairi 1200-0003 2/3/16 February $75.00
Graves Gilbert Clinic Nawaf Alotaibi 1200-0045 2/14/16 February $220.00
Internal Medicine Associates of Frankfort Haif O. Al-Otaibi 1200-0004 2/4/16 February $60.00
Jackson Purchase Medical Associates Faisal A. Alresheedi 1200-0005 2/5/16 February $40.00
Lewis County Primary Care Shadi I. Alruthea 1200-0006 2/6/16 February $20.00
London Womens Care Nader Alsharari 1200-0046 2/15/16 February $240.00
Monticello Medical Marivic M. Alvear 1200-0007 2/7/16 February $10.00
Norton Health System (Hospital) Nicole B. Armstrong 1200-0008 2/8/16 February $30.00
Ohio County Family Care Chase Berry 1200-0047 2/16/16 February $260.00
Owensboro Health Maleah J. Boisture 1200-0009 2/9/16 February $50.00
Primary Care Medical Center Laura Boone 1200-0048 2/17/16 February $280.00
AC Wright, MD Lawrence Brown 1200-0049 2/18/16 February $290.00
Bluegrass Community Family Practice Abdulaziz R. Bunji 1200-0010 2/10/16 February $70.00
Dee & Associates Stacey L. Camp 1200-0011 2/11/16 February $90.00
Family Medicine Associates of Flemingsburg Dillion Carver 1200-0050 2/19/16 February $270.00
Family Practice Associates of Lexington Maggie Clark 1200-0051 2/20/16 February $250.00
Graves Gilbert Clinic Desirae J. Cocanougher 1200-0012 2/12/16 February $100.00
Internal Medicine Associates of Frankfort Luke Coleman 1200-0052 2/21/16 February $230.00
Jackson Purchase Medical Associates Chelsea D. Conner 1200-0013 2/13/16 February $125.00
Lewis County Primary Care Nicholas N. Courtney 1200-0014 2/14/16 February $150.00
London Womens Care Jordan L. Crain 1200-0015 2/15/16 February $140.00
Monticello Medical Randa Denning 1200-0053 2/22/16 February $210.00
Norton Health System (Hospital) Nhung Dinh 1200-0054 2/23/16 February $8.00
Ohio County Family Care Lauren Dixon 1200-0055 2/24/16 February $18.00
Owensboro Health Alissa M. Doan 1200-0016 2/16/16 February $130.00
Primary Care Medical Center Melanie Duitsman 1200-0056 2/25/16 February $28.00
AC Wright, MD Katie Ernwine 1200-0057 2/26/16 February $38.00
Bluegrass Community Family Practice Nanci A. Escobar 1200-0017 2/17/16 February $120.00
Dee & Associates Alyx Fey 1200-0058 2/27/16 February $48.00
Family Medicine Associates of Flemingsburg Shamira Feytul 1200-0059 2/28/16 February $58.00
Family Practice Associates of Lexington Juan A. Garcia 1200-0018 2/18/16 February $110.00
Graves Gilbert Clinic Rebecca Garrison 1200-0060 2/29/16 February $68.00
Internal Medicine Associates of Frankfort Joyce O. Gecheo 1200-0019 2/19/16 February $29.00
Jackson Purchase Medical Associates Alexandria M. Glenn 1200-0020 2/20/16 February $49.00
Lewis County Primary Care Taylor N. Gowen 1200-0021 2/21/16 February $69.00
London Womens Care Jessica L. Grant 1200-0022 2/22/16 February $89.00
Monticello Medical Megan Haile 1200-0061 2/30/2016 February $78.00
Norton Health System (Hospital) Ashley Haley 1200-0062 2/31/2016 February $88.00
Ohio County Family Care Whitney Hankins 1200-0063 2/1/16 February $98.00
Owensboro Health Nicole Hirschler 1200-0064 2/2/16 February $7.00
Primary Care Medical Center Heather L. Jackson 1200-0023 2/23/16 February $5.00
AC Wright, MD Jamie Jaggers 1200-0065 2/3/16 February $17.00
Bluegrass Community Family Practice Brooke A. Johnson 1200-0024 2/24/16 February $190.00
Dee & Associates Elizabeth J. Koehler 1200-0025 2/25/16 February $170.00
Family Medicine Associates of Flemingsburg Parker Kuhn 1200-0066 2/4/16 February $27.00
Family Practice Associates of Lexington Keri Legg 1200-0067 2/5/16 February $37.00
Graves Gilbert Clinic Mack McKeown 1200-0068 2/6/16 February $47.00
Internal Medicine Associates of Frankfort Emily A. McMurtrey 1200-0026 2/26/16 February $150.00
Jackson Purchase Medical Associates Jordon Metcalf 1200-0069 2/7/16 February $57.00
Lewis County Primary Care Olivia A. Mock 1200-0027 2/27/16 February $130.00
London Womens Care Ameerah Muhammad 1200-0070 2/8/16 February $67.00
Monticello Medical Samir Music 1200-0028 2/28/16 February $110.00
Norton Health System (Hospital) Anh Nguyen 1200-0071 2/9/16 February $77.00
Ohio County Family Care Brooke Nichols 1200-0072 2/10/16 February $87.00
Owensboro Health Natalie L. Oliver 1200-0029 2/29/16 February $115.00
Primary Care Medical Center Susan M. Pennington 1200-0030 2/30/2016 February $135.00
AC Wright, MD Megan B. Pitts 1200-0031 2/31/2016 February $155.00
Bluegrass Community Family Practice Casey Price 1200-0073 2/11/16 February $97.00
Dee & Associates Ashton Puckett 1200-0074 2/12/16 February $3.00
Family Medicine Associates of Flemingsburg Kyle T. Ray 1200-0032 2/1/16 February $175.00
Family Practice Associates of Lexington Colton Richardson 1200-0075 2/13/16 February $13.00
Graves Gilbert Clinic Betty Richter 1200-0076 2/14/16 February $23.00
Internal Medicine Associates of Frankfort Ashlee M. Robinson 1200-0033 2/2/16 February $195.00
Jackson Purchase Medical Associates Freddie Rowe 1200-0077 2/15/16 February $33.00
Lewis County Primary Care Mallory A. Runnels 1200-0034 2/3/16 February $5.00
London Womens Care Jake Schoeff 1200-0078 2/16/16 February $43.00
Monticello Medical Logan D. Shaw 1200-0035 2/4/16 February $15.00
Norton Health System (Hospital) Olivia M. Sheaffer 1200-0036 2/5/16 February $25.00
Ohio County Family Care Madison E. Shirley 1200-0037 2/6/16 February $35.00
Owensboro Health Megan N. Sircy 1200-0038 2/7/16 February $45.00
Primary Care Medical Center Tayler Smith 1200-0079 2/17/16 February $53.00
AC Wright, MD Celeste A. Somerville 1200-0039 2/8/16 February $55.00
Bluegrass Community Family Practice James B. Stephens 1200-0040 2/9/16 February $65.00
Dee & Associates Rachel Tilley 1200-0080 2/18/16 February $63.00
Family Medicine Associates of Flemingsburg Jordan M. Webb 1200-0041 2/10/16 February $75.00
Family Practice Associates of Lexington Joseph T. Williamson 1200-0042 2/11/16 February $85.00
Graves Gilbert Clinic Shea Wilson 1200-0081 2/19/16 February $73.00

Practice

Provider Name State EMR Vendor OID Root Tax Identification Number NPI
AC Wright, MD KY eCW 2.16.840.1.113883.4.391.63.13139 610861500 1558455030
Bluegrass Community Family Practice KY eCW 2.16.840.1.113883.4.391.63.5642 800231376 1851689640
Dee & Associates KY Allscripts 1.3.6.1.4.1.22812.4.0.75727 810557522 1497839989
Family Medicine Associates of Flemingsburg KY Allscripts 1.3.6.1.4.1.22812.4.0.6794 611166318 1770573800
Family Practice Associates of Lexington KY Allscripts 1.3.6.1.4.1.22812.4.0.58257 611141828 1053316596
Graves Gilbert Clinic KY Allscripts 1.3.6.1.4.1.22812.3.0.82952 610700826 1114948288
Internal Medicine Associates of Frankfort KY Allscripts 1.3.6.1.4.1.22812.4.0.1519 611098789 1114130606
Jackson Purchase Medical Associates KY Allscripts 1.3.6.1.4.1.22812.3.0.82907 611228718 1699850263
Lewis County Primary Care KY Greenway 2.16.840.1.113883.3.441.1.50 extension 704 611033691 1043336506
London Womens Care KY Allscripts 1.3.6.1.4.1.22812.4.0.57097 352216071 1063454650
Monticello Medical KY Allscripts 1.3.6.1.4.1.22812.4.0.60896 610901605 1104963305
Norton Health System (Hospital) KY Epic 1.2.840.114350.1.13.317.2.7.2.688879 610703799 1043348808
Ohio County Family Care KY eCW 2.16.840.1.113883.4.391.63.7418 311310994 1942493275
Owensboro Health KY Epic 1.2.840.114350.1.13.276.2.7.2.688879 202872291 1285613612
Primary Care Medical Center KY Aprima 2.16.840.1.113883.19.5 611246752 1295716694
Turner, Whitley & Morton Internal Medicine KY Allscripts 1.3.6.1.4.1.22812.4.0.871 611169548 1609871581

Description