Object Description
One record per Source ID - Source Local Provider ID timeline period during which the local ID was associated with the same (mastered) Matched Provider ID value.
Metadata
- Table Name: ursa.mi_ursa_core_022_history
- Layer: METADATA_AND_INTEGRATION
- Object Type: Simple Timeline
- Temporal Class: Interval (Timeline)
- Case ID: Source ID, Source Local Provider ID
- Interval Start Date: Period Start Date
- Interval End Date: Period End Date
- Primary Key: Source ID, Source Local Provider 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 Provider ID -- The original value in the source system for the current record's Provider ID. (See also [URSA-CORE] Provider ID)
-
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 Provider ID
-
Metadata Fields
- Matched Provider ID Raw
- Is Source Local Provider ID with Multiple Matched Provider ID Values
Foreign Keys
- matched_pat_id → ursa.no_ursa_core_pat_001.pat_id
Dedicated Precursors
- [MI/URSA-CORE] Source Local Provider ID Timelines of Master Provider ID History, Precursor 1 (All Historical Crosswalk Entries): One record per record in the upstream Source Local Provider ID Crosswalk to Master Provider 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.