Contents x
    Patient-Plan Timelines of Plan Membership
    • 26 Apr 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Patient-Plan Timelines of Plan Membership

    • Updated on 26 Apr 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    Object Description

    One record per patient-plan timeline period in which the patient had an active membership in the plan; overlapping periods are reconciled to eliminate overlapping periods, with precedence given to the period with the more recent start date.

    Metadata

    • Table Name: ursa.no_ursa_core_fin_005
    • Layer: Natural Object
    • Object Type: Simple Timeline
    • Temporal Class: Interval (Timeline)
    • Case ID: Patient ID, Plan ID
    • Interval Start Date: Period Start Date
    • Interval End Date: Period End Date
    • Primary Key: Patient ID, Plan ID, Period Start Date, Period End Date

    Relational Diagram

    Patient-Plan Timelines of Plan Membership.png

    None.

    Dedicated Precursors

    • [NO/URSA-CORE] Patient-Plan Timelines of Plan Membership, Precursor 1 (All Source Records): One record per patient-plan timeline period during which the patient had an active membership in the health plan; periods for the same patient-plan pair might be overlapping

    FAQs

    None.

    Was this article helpful?
    What's Next