维度建模几个问题
我逐渐熟悉维度模型，因此开始研究健康声明流程。我正在努力实现以下目标：
1) 能够按专业和服务提供商（每月、每季度和每年）报告患者的索赔
2) 按服务提供商转介提供商的索赔
3) 按收到的 (1) 和 (1) 和 (1) 的每月付款提出索赔2)
4) 按服务月份针对 (1) 和 (2) 提出的索赔
以下是维度模型：
FactClaims
费用金额
付款金额
服务日期键 (FK)
付款日期键 (FK)
患者键(FK)
服务提供商密钥 (FK)
设施密钥 (FK)
引用提供商密钥 (FK)
维度表：
DimServiceProvider ServiceProviderID (SK)
服务提供商名称
专业
DimPatient 患者 ID (SK)
姓名
地址
DimDate
昏暗设施 设施 ID（SK、PK）
设施名称 设施
区域
设施状态
问题： 1）我应该将费用和付款的事实表分开吗？
2) 不确定我对于“Referred Provider Key”（也指向 DimServiceProvider）的想法是否正确
3) 有任何经验法则可以组合某些维度表或将它们分开？组合维度表或将它们分开的规则是什么？
I am getting familiar with Dimensional model, so started looking at health claims process. I am trying to acheive the following:
1) ability to report claims by patient by speciality and service provider (monthly, quarterly and yearly)
2) claims by referring provider by service provider
3) claims by monthly payments received for (1) and (2)
4) claims by month of services for (1) and (2)
Here is the 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 i separate fact tables for Charges and Payments?
2) Not sure whether I am thinking correct for Referred Provider Key (which also points to DimServiceProvider)
3) Any rule of thumb to combine some of the dimension tables or separate them? what are the rules to combine Dimension tables or keep them separate?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
是否单独付款和收费取决于您要运行哪种类型的报告。另外，您是否考虑过向保险、二级保险（如果适用）以及患者/患者负责人支付/收费？
如果您保留推荐提供者密钥，您应该为自我推荐的患者提供特殊值。
您的模型中没有可以考虑进行合并的维度。
Whether separate payments and charges depends on what kind of reports you are going to run. Also, did you consider payments/charges to the insurance, to secondary insurance, if applicable, and to the patient/person responsible for the patient?
If you keep Referred Provider Key, you should provide a special value for self-reffed patients.
There are no dimensions in your model that might be considered for consolidation.