Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Hospital Billing Model - Episodes Expand / Collapse
Posted Friday, August 22, 2014 11:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 23, 2014 10:08 AM
Points: 1, Visits: 62
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

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!
Post #1606445
Posted Friday, November 14, 2014 5:25 AM


Group: General Forum Members
Last Login: Yesterday @ 11:41 AM
Points: 498, Visits: 759
For me, an Episode is a DIMension (probably Type II SCD) and EpisodeEvents and EpisodeStatus are FACTs.

Post #1634510
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse