[MI/URSA-CORE] Ursa Import Object Metadata

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.