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
Author
Message
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

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

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, November 17, 2014 2:27 AM
Points: 418, Visits: 652
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