---
title: "[MI/URSA-CORE] Source Local Patient ID Timelines of Master Patient ID History"
slug: "mi-ursa-core-source-local-patient-id-timelines-of-master-patient-id-history"
updated: 2026-11-04T20:15:31Z
published: 2026-11-04T20:15:31Z
canonical: "docs.ursahealth.com/mi-ursa-core-source-local-patient-id-timelines-of-master-patient-id-history"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ursahealth.com/llms.txt
> Use this file to discover all available pages before exploring further.

# [MI/URSA-CORE] Source Local Patient ID Timelines of Master Patient ID History

## 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.