Sleep clinic

Tidewell Hollow Sleep Center · Sleep clinic · Portland, ME

Bram Zubiri is the clinic manager at Tidewell Hollow Sleep Center, a sleep medicine clinic in Portland, and he opens it each Monday to see how many studies ran and what they charged and collected, split by study type, payer and referring office.

HealthcareReportingDimensions4 tables · 6 views · 1 form · 2 dimension sets · 1 dashboard · 1 drill-down · 1 digest · 1 stage rule set · 1 agent
Use this template

Study board

Studies
Scheduled8
Askarov, Gwendolyn — home sleep apnea test (second night)Gwendolyn AskarovHome sleep apnea test
Delmonaco, Fenwick — in-lab polysomnography (second night)Fenwick DelmonacoIn-lab polysomnography
Baptiste, Ingrid — home sleep apnea test (second night)Ingrid BaptisteHome sleep apnea test
Treadwell, Osvaldo — cpap titrationOsvaldo TreadwellCPAP titration
Kasprzak, Philomena — daytime nap studyPhilomena KasprzakDaytime nap study
3 more
Completed4
Oyinlola, Magdalena — home sleep apnea testMagdalena OyinlolaHome sleep apnea test
Aldous, Percival — in-lab polysomnographyPercival AldousIn-lab polysomnography
Eriksen, Tamsin — split-night studyTamsin EriksenSplit-night study
Kimathi, Hollis — home sleep apnea testHollis KimathiHome sleep apnea test
Read by physician4
Montenegro, Drusilla — in-lab polysomnographyDrusilla MontenegroIn-lab polysomnography
Yildirim, Ambrose — home sleep apnea testAmbrose YildirimHome sleep apnea test
Rowntree, Cecily — cpap titrationCecily RowntreeCPAP titration
Lindenmeyer, Evander — home sleep apnea testEvander LindenmeyerHome sleep apnea test
Report sent16
Askarov, Gwendolyn — home sleep apnea testGwendolyn AskarovHome sleep apnea test
Delmonaco, Fenwick — in-lab polysomnographyFenwick DelmonacoIn-lab polysomnography
Baptiste, Ingrid — home sleep apnea testIngrid BaptisteHome sleep apnea test
Treadwell, Osvaldo — split-night studyOsvaldo TreadwellSplit-night study
Kasprzak, Philomena — home sleep apnea testPhilomena KasprzakHome sleep apnea test
11 more
No-show4
Brackenwood, Prudence — home sleep apnea testPrudence BrackenwoodHome sleep apnea test
Ferrandez, Casimir — in-lab polysomnographyCasimir FerrandezIn-lab polysomnography
Okonjo, Clementine — split-night studyClementine OkonjoSplit-night study
Linnell, Thaddeus — cpap titrationThaddeus LinnellCPAP titration
Cancelled4
Halvorsen, Beatrix — home sleep apnea test (second night)Beatrix HalvorsenHome sleep apnea test
Sutherland, Kwame — in-lab polysomnographyKwame SutherlandIn-lab polysomnography
Pemberley, Odalys — home sleep apnea testOdalys PemberleyHome sleep apnea test
Ugochukwu, Barnaby — daytime nap studyBarnaby UgochukwuDaytime nap study

Tables

Studies

40 sample rows · 17 columns

Every sleep study the center books, from the referral to the report, with what it charged and collected.

StudyPatientStudy typeStudy nightStatusPayerReferred by
Marchetti, Cornelius — home sleep apnea test (second night)Cornelius MarchettiHome sleep apnea testOct 30, 1:30 AMScheduledCommercialDentist
Ottoway, Seraphine — pediatric sleep studySeraphine OttowayPediatric sleep studyOct 27, 1:30 AMScheduledMedicarePrimary care
Nakamoto, Jebediah — home sleep apnea testJebediah NakamotoHome sleep apnea testOct 24, 1:30 AMScheduledSelf payENT
Kasprzak, Philomena — daytime nap studyPhilomena KasprzakDaytime nap studyOct 20, 1:00 PMScheduledCommercialPulmonology
Treadwell, Osvaldo — cpap titrationOsvaldo TreadwellCPAP titrationOct 18, 1:30 AMScheduledMedicaidPrimary care
Baptiste, Ingrid — home sleep apnea test (second night)Ingrid BaptisteHome sleep apnea testOct 15, 1:30 AMScheduledCommercialENT
Delmonaco, Fenwick — in-lab polysomnography (second night)Fenwick DelmonacoIn-lab polysomnographyOct 12, 1:30 AMScheduledMedicarePrimary care
Askarov, Gwendolyn — home sleep apnea test (second night)Gwendolyn AskarovHome sleep apnea testOct 9, 1:30 AMScheduledCommercialPulmonology
Kimathi, Hollis — home sleep apnea testHollis KimathiHome sleep apnea testOct 6, 1:30 AMCompletedCommercialSelf-referred
Eriksen, Tamsin — split-night studyTamsin EriksenSplit-night studyOct 5, 1:30 AMCompletedMedicareDentist
Aldous, Percival — in-lab polysomnographyPercival AldousIn-lab polysomnographyOct 4, 1:30 AMCompletedSelf payPrimary care
Oyinlola, Magdalena — home sleep apnea testMagdalena OyinlolaHome sleep apnea testOct 3, 1:30 AMCompletedCommercialENT

28 more rows

Patients

24 sample rows · 8 columns

The people referred to the center, with how to reach them and why they came.

PatientChart numberDate of birthPhoneMain complaintUses a CPAPStudies
Ambrose YildirimTSC-20219Feb 22, 1981(207) 555-0124Loud snoringNoYildirim, Ambrose — home sleep apnea test
Barnaby UgochukwuTSC-20205Apr 24, 1967(207) 555-0122Daytime sleepinessYesUgochukwu, Barnaby — home sleep apnea test, Ugochukwu, Barnaby — daytime nap study
Beatrix HalvorsenTSC-20184Jan 15, 1991(207) 555-0119Restless legsYesHalvorsen, Beatrix — home sleep apnea test, Halvorsen, Beatrix — home sleep apnea test (second night)
Casimir FerrandezTSC-20163Oct 6, 1970(207) 555-0116Loud snoringYesFerrandez, Casimir — home sleep apnea test, Ferrandez, Casimir — in-lab polysomnography
Cecily RowntreeTSC-20226Jul 9, 1988(207) 555-0125Restless legsYesRowntree, Cecily — cpap titration
Clementine OkonjoTSC-20170Mar 17, 1977(207) 555-0117Daytime sleepinessNoOkonjo, Clementine — in-lab polysomnography, Okonjo, Clementine — split-night study
Cornelius MarchettiTSC-20149Dec 8, 1956(207) 555-0114Witnessed pauses in breathingNoMarchetti, Cornelius — home sleep apnea test, Marchetti, Cornelius — home sleep apnea test (second night)
Drusilla MontenegroTSC-20212Sep 11, 1974(207) 555-0123Witnessed pauses in breathingNoMontenegro, Drusilla — in-lab polysomnography
Evander LindenmeyerTSC-20233Dec 20, 1995(207) 555-0126Daytime sleepinessNoLindenmeyer, Evander — home sleep apnea test
Fenwick DelmonacoTSC-20107Jun 14, 1959(207) 555-0108Daytime sleepinessNoDelmonaco, Fenwick — in-lab polysomnography, Delmonaco, Fenwick — in-lab polysomnography (second night)
Gwendolyn AskarovTSC-20100Jan 3, 1952(207) 555-0107Loud snoringYesAskarov, Gwendolyn — home sleep apnea test, Askarov, Gwendolyn — home sleep apnea test (second night)
Hollis KimathiTSC-20261Aug 16, 1978(207) 555-0130Daytime sleepinessNoKimathi, Hollis — home sleep apnea test

12 more rows

Study types

6 sample rows · 9 columns

The kinds of sleep study the center runs, with the code, fee and usual length of each.

Study typeType codeBilling codeStandard feeUsual hoursOvernight stayStudies
CPAP titrationST-10495811$1,6508YesNakamoto, Jebediah — cpap titration, Pemberley, Odalys — cpap titration, Rowntree, Cecily — cpap titration, Treadwell, Osvaldo — cpap titration, Linnell, Thaddeus — cpap titration
Daytime nap studyST-10595805$1,9809NoBrackenwood, Prudence — daytime nap study, Kasprzak, Philomena — daytime nap study, Ugochukwu, Barnaby — daytime nap study
Home sleep apnea testST-10195800$4208NoAskarov, Gwendolyn — home sleep apnea test, Baptiste, Ingrid — home sleep apnea test, Kasprzak, Philomena — home sleep apnea test, Marchetti, Cornelius — home sleep apnea test, Ferrandez, Casimir — home sleep apnea test, Halvorsen, Beatrix — home sleep apnea test, Ugochukwu, Barnaby — home sleep apnea test, Yildirim, Ambrose — home sleep apnea test, Lindenmeyer, Evander — home sleep apnea test, Oyinlola, Magdalena — home sleep apnea test, Kimathi, Hollis — home sleep apnea test, Askarov, Gwendolyn — home sleep apnea test (second night), Baptiste, Ingrid — home sleep apnea test (second night), Nakamoto, Jebediah — home sleep apnea test, Marchetti, Cornelius — home sleep apnea test (second night), Brackenwood, Prudence — home sleep apnea test, Halvorsen, Beatrix — home sleep apnea test (second night), Pemberley, Odalys — home sleep apnea test
In-lab polysomnographyST-10295810$2,1508YesDelmonaco, Fenwick — in-lab polysomnography, Ottoway, Seraphine — in-lab polysomnography, Okonjo, Clementine — in-lab polysomnography, Montenegro, Drusilla — in-lab polysomnography, Aldous, Percival — in-lab polysomnography, Delmonaco, Fenwick — in-lab polysomnography (second night), Ferrandez, Casimir — in-lab polysomnography, Sutherland, Kwame — in-lab polysomnography
Pediatric sleep studyST-10695782$2,3009YesLinnell, Thaddeus — pediatric sleep study, Ottoway, Seraphine — pediatric sleep study
Split-night studyST-10395811$2,4808YesTreadwell, Osvaldo — split-night study, Sutherland, Kwame — split-night study, Eriksen, Tamsin — split-night study, Okonjo, Clementine — split-night study

Also included

  • Collected by week and study typeDrill-down
  • Study boardStage rules
  • Monday numbersDigest