SQL programming project

profilesabin1520
3304_Proj1_fl201821.xlsx

Sheet1

Appt Num Appt Date Appt Time Block Code Block Code Desc Block Time Appt Reason Code Appt Reason Desc Patient ID Patient Name Patient Phone Billing Type Billing Type Desc Ins Co ID Ins Co Name Doctor ID Doctor Name Appt Status Code Appt Status Desc
101 9/1/18 9:00 AM L1 Level 1 10 Minutes NP New Patient 101 Wesley Tanner (817)555-1193 I Insurance 323 Humana 2 Michael Smith CM Complete
L2 Level 2 15 Minutes GBP General Back Pain
102 9/1/18 9:00 AM L1 Level 1 10 Minutes PSF Post-Surgery Follow Up 100 Breanna Rhodes (214)555-9191 I Insurance 129 Blue Cross 5 Janice May CM Complete
L1 Level 1 10 Minutes SR Suture Removal
103 9/1/18 9:30 AM L1 Level 1 10 Minutes PSF Post-Surgery Follow Up 15 Jeff Miner (469)555-2301 SP Self Pay 2 Michael Smith CM Complete
104 9/1/18 9:30 AM L3 Level 3 20 Minutes PT Physical Therapy 77 Kim Jackson (817)555-4911 WC Worker's Comp 210 State Farm 3 Ray Schultz CM Complete
105 9/1/18 9:45 L1 Level 1 10 Minutes NP New Patient 119 Mary Vaughn (817)555-2334 I Insurance 129 Blue Cross 2 Michael Smith CM Complete
L2 Level 2 15 Minutes AI Auto Injury
106 9/1/18 10:00 AM L4 Level 4 30 Minutes PT Physical Therapy 97 Chris Mancha (469)555-3440 SP Self Pay 3 Ray Schultz CN Confirmed
107 9/1/18 10:30 AM L3 Level 3 20 Minutes PT Physical Therapy 28 Renee Walker (214)555-9285 I Insurance 129 Blue Cross 3 Ray Schultz CN Confirmed
108 9/1/18 10:30 AM L2 Level 2 15 Minutes GBP General Back Pain 105 Johnny Redmond (214)555-1084 I Insurance 323 Humana 2 Michael Smith NC Not Confirmed
109 9/1/18 11:00 AM L1 Level 1 10 Minutes PSF Post-Surgery Follow Up 84 James Clayton (214)555-9285 I Insurance 135 TriCare 5 Janice May CN Confirmed
110 9/1/18 11:15 AM L4 Level 4 30 Minutes PT Physical Therapy 84 James Clayton (214)555-9285 I Insurance 135 TriCare 3 Ray Schultz CN Confirmed
111 9/1/18 1:00 PM L4 Level 4 30 Minutes PT Physical Therapy 23 Shelby Day (817)555-1198 I Insurance 323 Humana 3 Ray Schultz NC Not Confirmed

Sheet2

Sheet3