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 -- The internal database identifier (used, e.g., for joins and primary keys) for the patient. This value is typically mastered, i.e., all records for the same patient, regardless of the source data system from which that record originated, should have the same Patient ID value. (Note that while the mastered Patient ID value might resemble a local identifier used in one of the upstream data sources, this does not indicate any special priority of that source system in determining the characteristics of the patient.) (See also [URSA-CORE] Patient)
- 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