[MI/URSA-CORE] Source Local Patient ID Crosswalk to Data Model Patient ID

  • Published on Apr 10, 2026
  • 3 minute(s) read
Prev Next

Object Description

One record per Source Local Patient ID value, with the matched Patient ID data model key; implements matching logic to find records for the same patient in source data and consolidate them under a single Patient ID value.

Metadata

  • Table Name: ursa.mi_ursa_021
  • Layer: METADATA_AND_INTEGRATION
  • Object Type: Integrator
  • Temporal Class: Entity
  • Case ID: Source ID, Source Local Patient ID
  • Primary Key: Source ID, Source Local Patient ID

Published Fields

  • Data Model Keys

    • Source ID -- The identifier for the original source data system from which the current record originated.

  • Source Local Keys

    • 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)
    • Source Local Patient Master Identity ID -- An identifier used to uniquely identify the patient in the original source data system; typically derived through a data mastering process that identifies duplicate Source Local Patient ID values for the same (real-life) patient.

  • Operations Support Fields

    • Patient Operational ID -- The user-facing value used by staff used to uniquely identify the Patient in their administrative systems and/or day-to-day operations. (See also [URSA-CORE] Patient)

  • Patient Fields

    • Patient SSN
    • Patient MBI -- The patient's Medicare Beneficiary Identifier (MBI). On the Patients Natural Object, this reflects the most recent MBI known for the patient; on the Patient-Plan Timelines of Plan Membership Natural Object, this reflects the contemporaneous MBI during the respective timeline period.
    • Patient First Name
    • Patient Middle Name
    • Patient Middle Initial
    • Patient Last Name
    • Patient Date of Birth -- The patient's date of birth. On the Patients Natural Object, this field reflects the "best" known value for the patient available from all data sources; on other Natural Objects, e.g., MMR Member-Months, the value faithfully reflects the date of birth found on that particular type of record in the source data.
    • Patient Date of Death
    • Patient Address Line 1
    • Patient Address Line 2
    • Patient City
    • Patient State Abbreviation
    • Patient ZIP Code 5-Digit
    • Patient ZIP Code 9-Digit
    • Patient ZIP Code 3-Digit
    • Patient Phone
    • Patient Email
    • Is Patient Sex Female -- Indicates the patient's sex is female. On the Patients Natural Object, this field reflects the "best" known value for the patient available from all data sources; on other Natural Objects, e.g., MMR Member-Months, the value faithfully reflects the patient sex documented on that particular type of record in the source data.
    • Is Patient Sex Male -- Indicates the patient's sex is male. On the Patients Natural Object, this field reflects the "best" known value for the patient available from all data sources; on other Natural Objects, e.g., MMR Member-Months, the value faithfully reflects the patient sex documented on that particular type of record in the source data.
    • Employer Description
    • Patient Employee Number

  • Metadata Fields

    • Documentation Datetime
    • Source Data Effective Datetime -- The "as of" date and time of the original source data system at the moment the current record was extracted. For example, if a snapshot of the data in a production system is taken at 12:05 AM on the first of each month and used to generate a package of flat files that are eventually loaded into the Ursa Studio client database later that month, the Source Data Effective Datetime of all records in that month's package will be 12:05 AM on the first. Not to be confused with Record Last Updated Datetime. (See also [URSA-CORE] Record Last Updated Datetime)

  • Validation Only Fields

    • Patient Operational ID Original
    • Source Local Patient Master Identity ID Original
    • Patient SSN Original
    • Patient MBI Original
    • Patient First Name Original
    • Patient Middle Name Original
    • Patient Middle Initial Original
    • Patient Last Name Original
    • Patient Date of Birth Original
    • Patient Date of Death Original
    • Patient Address Line 1 Original
    • Patient Address Line 2 Original
    • Patient City Original
    • Patient State Abbreviation Original
    • Patient ZIP Code 5-Digit Original
    • Patient ZIP Code 9-Digit Original
    • Patient ZIP Code 3-Digit Original
    • Patient Phone Original
    • Patient Email Original
    • Is Patient Sex Female Original
    • Is Patient Sex Male Original
    • Employer Description Original
    • Patient Employee Number Original
    • Earliest Source Data Effective Datetime
    • Earliest Documentation Datetime