Patient Timelines of Primary Plan Membership
  • 24 Apr 2023
  • 1 Minute to read
  • Dark
    Light

Patient Timelines of Primary Plan Membership

  • Dark
    Light

Article summary

Object Description

One record per patient timeline period in which the patient has at least one active insurance plan coverage, with attribution to the primary plan; primary plan is determined based on the following criteria, evaluated in this order (1) the plan identified as primary in the membership record; (2) the plan with a plan-assigned provider; (3) the plan with the plurality of paid claims in that calendar year; (4) the plan that is not a Medicaid plan; (5) the plan with the lowest Plan ID (tiebreaker).

Metadata

  • Table Name: ursa.so_ursa_core_fin_005
  • Layer: Synthetic Object
  • Object Type: Attribution Timeline
  • Temporal Class: Interval (Timeline)
  • Case ID: Patient ID
  • Interval Start Date: Period Start Date
  • Interval End Date: Period End Date
  • Primary Key: Patient ID, Period Start Date, Period End Date

Relational Diagram

Patient Timelines of Primary Plan Membership.png

None.

Dedicated Precursors

None.

FAQs

None.


Was this article helpful?