[SO/URSA-CORE] Patient - Month Starts with Primary Payor Membership in Prior 12 Months

Object Description

For each continuous primary payor membership episode, one record per calendar month start ("reference date") in which some part of the given membership episode overlapped with the 12 months ending on the reference date. Membership episodes are left-truncated to start at most a year prior to the start of each reference date and right-truncated to end on that same reference date, at the latest. Note that a patient with multiple membership episodes might have multiple records with the same reference date.

Metadata

• Table Name: ursa.so_ursa_core_pat_011
• Layer: SYNTHETIC_OBJECT
• Object Type: Single Stack
• Temporal Class: Event
• Case ID: Patient ID, Episode ID, Reference Date
• Event Date: Reference Date
• Primary Key: Patient ID, Episode ID, Reference Date

Published Fields

• Data Model Keys

  • Patient ID
  • Episode ID

• Date Fields

  • Reference Date
  • Reference Date Lead 1 Month
  • Truncated Continuous Membership Episode Start Date
  • Truncated Continuous Membership Episode End Date

• Episode Fields

  • Truncated Coverage Episode Length Days

• Validation Only Fields

  • Original Membership Episode Start Date
  • Original Membership Episode End Date