Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Member eligibility dimension / fact

2 posters

Go down

Member eligibility dimension / fact Empty Member eligibility dimension / fact

Post  venky80 Tue Sep 21, 2010 3:00 pm

How can I think about Member eligibility as both dimension and fact? In health care member eligibility can be both a fact and dimension.

Like how many members are enrolled in a plan ?

Which member a particular claim came for?

We have a member benefits hierarchy which is per day basis, a member can be eligible for multiple benefits on a particular day, how can a dimension/ fact table be envisioned for such scenario?

venky80

Posts : 4
Join date : 2010-09-14

Back to top Go down

Member eligibility dimension / fact Empty Re: Member eligibility dimension / fact

Post  ngalemmo Tue Sep 21, 2010 4:05 pm

The member is a dimension. A member's eligibility is a fact (it is a business state).

If there is a claim from a member, you may include eligibility status and coverage at the time of the claim, as a dimension, but this information is derived during load from the member's eligibility state. This would be a dimension separate from the member dimension.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Member eligibility dimension / fact Empty Re: Member eligibility dimension / fact

Post  venky80 Tue Sep 21, 2010 4:14 pm

so member dimension is a valid dimension for both claims and member eligibility...and member eligibility at the time of claim submission is a dimension?

venky80

Posts : 4
Join date : 2010-09-14

Back to top Go down

Member eligibility dimension / fact Empty Re: Member eligibility dimension / fact

Post  ngalemmo Tue Sep 21, 2010 4:38 pm

venky80 wrote:...and member eligibility at the time of claim submission is a dimension?

It's a point in time context for the claim fact. It is separate from the eligibility fact table itself. It could, potentially, just be a degenerate dimension implemented as a boolean. If you have a coverage or plan dimension, I would use that instead as it implies eligibility... i.e. if you do not have coverage, you are not eligible.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Member eligibility dimension / fact Empty Re: Member eligibility dimension / fact

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum