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

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