[SO/URSA-CORE] Continuous Primary Payor Membership Episodes

  • Published on Jul 17, 2025
  • 1 minute(s) read
Prev Next

Object Description

One record per continuous episode of membership with the payor identified as the patient's primary payor at that time.

Metadata

  • Table Name: ursa.so_ursa_core_episode_001
  • Layer: SYNTHETIC_OBJECT
  • Object Type: Single Stack
  • Temporal Class: Interval
  • Case ID: Episode ID
  • Interval Start Date: Episode Start Date
  • Interval End Date: Episode End Date
  • Primary Key: Episode ID

Published Fields

  • Data Model Keys

    • Episode ID
    • Patient ID
    • Primary Payor ID -- The internal database identifier (used, e.g., for joins and primary keys) for the Primary Payor. (See also [URSA-CORE] Primary Payor)

  • Date Fields

    • Episode Start Date
    • Episode End Date

  • Episode Fields

    • Episode Length Days

  • Metadata Fields

    • Last Episode Start Date
    • Last Episode End Date
    • Last Episode Primary Payor ID
    • Next Episode Start Date
    • Next Episode End Date
    • Next Episode Primary Payor ID

Foreign Keys

  • pat_id → ursa.no_ursa_core_pat_001.pat_id
  • primary_payor_id → ursa.no_ursa_core_struct_004.payor_id

Dedicated Precursors

  • [SO/URSA-CORE] Continuous Primary Payor Membership Episodes, Precursor 1 (Patient Timelines with Episode Metadata): One row per timeline period of membership with the patient's primary payor, with episode metadata added