[MI/URSA-CORE] Ursa Import Object Metadata

  • Published on Jul 17, 2025
  • 1 minute(s) read
Prev Next

Object Description

One record per instance of a file imported via an Ursa Import Object;

Metadata

  • Table Name: ursa.mi_ursa_core_001
  • Layer: METADATA_AND_INTEGRATION
  • Object Type: Single Stack
  • Temporal Class: Event
  • Case ID: Ursa File Instance ID
  • Event Date: Load Start Datetime
  • Primary Key: Ursa File Instance ID

Published Fields

  • Metadata Fields

    • Ursa File Instance ID
    • Source ID -- The identifier for the original source data system from which the current record originated.
    • File Instance Filename
    • File Cohort ID
    • Raw Data Table Name
    • Data Effective Datetime
    • Data Covered Start Datetime
    • Data Covered End Datetime
    • Load Start Datetime
    • Load End Datetime
    • Is Full Overwrite
    • Incremental Row Count
    • Final Row Count
    • Is File Instance With Any Records Loaded in Original Import
    • Is File Instance With Any Records Currently in Table

  • Validation Only Fields

    • Table Last Full Overwrite Load Start Datetime

Dedicated Precursors

  • [SD/URSA-CORE] Ursa Import Object Metadata, Precursor 1 (Source Data Registered Table): One record per instance of a file imported via an Ursa Import Object.