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 |