Object Description
One record per Source ID - Source Local Patient ID timeline period during which the local ID was associated with the same (mastered) Matched Patient ID value.
Metadata
- Table Name: ursa.mi_ursa_core_021_history
- Layer: METADATA_AND_INTEGRATION
- Object Type: Simple Timeline
- Temporal Class: Interval (Timeline)
- Case ID: Source ID, Source Local Patient ID
- Interval Start Date: Period Start Date
- Interval End Date: Period End Date
- Primary Key: Source ID, Source Local Patient ID, Period Start Date, Period End Date
Published Fields
-
Source Local Keys
- Source ID -- The identifier for the original source data system from which the current record originated.
- Source Local Patient ID -- The internal database identifier for the patient in the source data system this record originated from. (See also [URSA-CORE] Patient)
-
Date Fields
- Period Start Date -- The date identifying the start of a period of time. Period Start Date values are inclusive; e.g., a period with Period Start Date = January 1 would begin be considered to begin at 00:00 on January 1.
- Period End Date -- The date identifying the end of an period of time. Period End Date values are exclusive; e.g., a period with Period End Date = January 1 would begin be considered to end at precisely 00:00 on January 1 (meaning that the period did not include any time on January 1).
-
Data Model Keys
- Matched Patient ID
-
Metadata Fields
- Matched Patient ID Raw
- Is Source Local Patient ID with Multiple Matched Patient ID Values
Foreign Keys
- matched_pat_id → ursa.no_ursa_core_pat_001.pat_id
Dedicated Precursors
- [MI/URSA-CORE] Source Local Patient ID Timelines of Master Patient ID History, Precursor 1 (All Historical Crosswalk Entries): One record per record in the upstream Source Local Patient ID Crosswalk to Master Patient ID object per ELT run; i.e., a full history of the contents of that upstream object over all ELTs in which this object was included.