Skip to content
Snippets Groups Projects

Add Product and Insurance Type to payer_profile.sql

Merged Boukus, Ellyn R requested to merge erb38_PayerProfile_grouping_update into main

Update payer_profile.sql: added ProductTypeCD and InsuranceTypeCD fields. Max and min dates now group by these fields. This update was made after Lisa B. noticed that HPHC-PPO and TAHP-PPO members were not being pulled into Covered Lives SAM. The reason was that PPO enrollment data lagged behind other product types by 1 month. This View update should allow all members to flow in based on latest eligibility, regardless of Insurance or Product Type.

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
  • Loading
  • Loading
Please register or sign in to reply
Loading