Episode, Item modelling,
2 posters
Page 1 of 1
Episode, Item modelling,
A general DM question for modelling Episode and Item data within health models. This question may more broadly relate to general Header and Item analysis in other non health models.
Our requirements are for both,
1. Episode analysis - Length of Stay, DRG, Admission date, Discharge date, Episode cost, Provider etc.
2. Item analysis – Episode, Number of items, Item cost, Provider, Service date etc.
Due to the differing grain of the requirements we expect 2 facts will be created, an Episode fact and an Item fact.
Our question is how best to create the relation between the two process models to facilitate the Episode relationship?
Is the simple answer to create an Episode dimension which contains a managed Episode ID. If this is the case we end up with an Episode dimension growing at the same rate as the Episode fact and a tendency to move the Episode Admission date, Discharge date and other Episode attributes to the dimension rather than resolving these in the Episode fact.
We’d be keen to hear other’s view on this scenario.
Our requirements are for both,
1. Episode analysis - Length of Stay, DRG, Admission date, Discharge date, Episode cost, Provider etc.
2. Item analysis – Episode, Number of items, Item cost, Provider, Service date etc.
Due to the differing grain of the requirements we expect 2 facts will be created, an Episode fact and an Item fact.
Our question is how best to create the relation between the two process models to facilitate the Episode relationship?
Is the simple answer to create an Episode dimension which contains a managed Episode ID. If this is the case we end up with an Episode dimension growing at the same rate as the Episode fact and a tendency to move the Episode Admission date, Discharge date and other Episode attributes to the dimension rather than resolving these in the Episode fact.
We’d be keen to hear other’s view on this scenario.
MJ- Posts : 5
Join date : 2009-02-03
Re: Episode, Item modelling,
"Our question is how best to create the relation between the two process models to facilitate the Episode relationship?"
By not creating a relationship between the two process models.
Simply carry dimensional FK's in the item table that would also be found in the episode table. Treat episode ID as a degenerate dimension.
By not creating a relationship between the two process models.
Simply carry dimensional FK's in the item table that would also be found in the episode table. Treat episode ID as a degenerate dimension.
Similar topics
» How to model single item vs multiple item components
» Dimensional Modelling compared to Relational (3NF +) Modelling for DSS
» Item Costs - Dimension or Fact
» Insured item
» Item Master and Inventory Organisation
» Dimensional Modelling compared to Relational (3NF +) Modelling for DSS
» Item Costs - Dimension or Fact
» Insured item
» Item Master and Inventory Organisation
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum