data modeling - Dimensional modelling few questions -


i getting familiar dimensional model, started looking @ health claims process. trying acheive following:

1) ability report claims patient speciality , service provider (monthly, quarterly , yearly)

2) claims referring provider service provider

3) claims monthly payments received (1) , (2)

4) claims month of services (1) , (2)

here dimsion model:

factclaims

charge amount

payment amount

service date key (fk)

payment date key (fk)

patient key (fk)

service provider key (fk)

facility key (fk)

referred provider key (fk)

dimension tables:

dimserviceprovider serviceproviderid (sk)

service provider name

speciality

dimpatient patientid (sk)

name

address

dimdate

dimfacility facilityid (sk, pk)

facilityname

facilityregion

facilitystate

questions: 1) should separate fact tables charges , payments?

2) not sure whether thinking correct referred provider key (which points dimserviceprovider)

3) rule of thumb combine of dimension tables or separate them? rules combine dimension tables or keep them separate?

whether separate payments , charges depends on kind of reports going run. also, did consider payments/charges insurance, secondary insurance, if applicable, , patient/person responsible patient?

if keep referred provider key, should provide special value self-reffed patients.

there no dimensions in model might considered consolidation.


Comments

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

c++ - Is it possible to compile a VST on linux? -

url - Querystring manipulation of email Address in PHP -