August 22, 2014 at 11:37 am
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!
November 14, 2014 at 5:25 am
For me, an Episode is a DIMension (probably Type II SCD) and EpisodeEvents and EpisodeStatus are FACTs.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply