Hospital Billing Model - Episodes

• beatrixkiddo

  Newbie

  Points: 5

  More actions

  August 22, 2014 at 11:37 am

  #310362

  Hey everyone,

  I am working on a hospital billing model. Charges, Payments, Adjustments, Episodes, all by doctor, patient, financial class, etc.

  What I have so far -

  FactAR_Transactions - payments, adjustments, etc

  FactEpisode - the actual admission event

  DimPatient

  DimPhysician

  DimFinancialClass

  DimDepartment

  DimService

  DimProcedure

  and other Dims

  I'm stuck on episodes. At times, an episode seems like a dimension and a fact. For example, sometimes we look at Payments by Episode. The Episode fact grain does not include payments, nor does FactPayments include episodes. An episode is an event, right? So I figured it was only to be a fact.

  So if we have FactPayments and FactEpisodes, how would I get to Payments by Episode? This is where Episode seemed like a dimension needed in the grain of FactPayments.

  I have no problem creating an Episode Dim, but I just wondered if I'm missing something in a drill-across method or some way to bring payments and episodes together when FactPayments doesn't include episodes?

  Thank you for any help!

• aaron.reese

  SSChampion

  Points: 13498

  More actions

  November 14, 2014 at 5:25 am

  #1758519

  For me, an Episode is a DIMension (probably Type II SCD) and EpisodeEvents and EpisodeStatus are FACTs.