Patient Re-admission Measure (count)

mark.tan at 09h11
15
May
2009
Patient Re-admission Measure (count)

Dear DM Experts,

I am ponding this interesting scenario. What is the best way to resolve this requirement?

The simple is requirement is to track the patient re-admission rate in a hospital. For e.g., if patient A was admitted on 1st March 2009, 20th March 2009 and 12th May 2009. I will have 3 records in the fact table. To constitute a "re-admission" criteria, users can define a date range. Let's assume the u
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Hi ngalemmo or fourm members, Can I get advice on how to create a bridge table for patient diagnosis? To keep it simple, I have a patient, facilities, and doctor dimensions and one fact table. For a specific patient, I need to show all diagnosis in a
Gurus, I have relational database where there is only one measure that is at an aggregated level whereas Dimensions are at lower level of granularity. Let me give you an
Hi all, I am currently wroking on a Star Schema [with few dimensions and one fact :-)] but ran into some issues regarding Unduplicated Aggregates. Let me explain: we have the following dimensions : Ofices Staff
I'm trying to figure out how to best model a DataWarehouse Star Schema structure to capture certain medical information that will answer the questions we ask. First the questions to put in some context: 1) How many distinct patients had a BMI in the
I have a transactional fact table containing results of inspections. The results are non-numeric, but do represent a measurement, that is inspection result (like "pass", "fail", "pass with infraction", "failure with
Forums from same category
See also
more_less
Informations

6 Replies For the topic :
"Patient Re-admission Measure (count)"

This topic has been viewed 1375 times.

Last message :
15/05/2009 at 09h11 by "mark.tan"