Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Link cost table to payer_plan_period table #121

Closed
gowthamrao opened this issue Sep 23, 2017 · 1 comment
Closed

Link cost table to payer_plan_period table #121

gowthamrao opened this issue Sep 23, 2017 · 1 comment
Labels

Comments

@gowthamrao
Copy link
Member

gowthamrao commented Sep 23, 2017

Proposal to link cost table to payer_plan_period_id.
Add the pk of payer_plan_period to cost table

Cost

Add new field - optional

Field Required Type Description
payer_plan_period_id No integer A foreign key to the payer_plan_period_id in the payer_plan_period table that was responsible for the payment related to the cost

Use cases -
http://forums.ohdsi.org/t/how-to-represent-visit-payer-information-in-the-model/369
http://forums.ohdsi.org/t/add-drug-benefit-flag-to-payer-plan-table/2093 (can be addressed by plan)
Meets use cases of both payers and providers. Providers may not have denominator file that contains timespans when a person had coverage but did not receive care - in those cases, the payer_plan_period_start_date and payer_plan_period_end_date will be the period the person received care (i.e. same as visit_start_date and visit_end_date). Payers who have beneficiary denominator file will use payer_plan_period to represents spans of time with coverage irrespective of visits.

Backward compatible - yes

Related to:
#107
#120

@gowthamrao gowthamrao changed the title Link payer_plan_period to visit_occurrence and visit_detail tables Link cost table to payer_plan_period table Oct 3, 2017
@gowthamrao
Copy link
Member Author

looks like cost table is already linked to payer-plan-period. so this proposal is not required and may be deleted!

clairblacketer added a commit that referenced this issue Apr 24, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants