[NO/URSA-CORE] CMS LISHIST Low Income Periods, Precursor 1 (All Source Records)

Object Description

One record per period of designated Low Income status according to the CMS Low-Income Status History (LISHIST) file.

Metadata

• Table Name: ursa.no_ursa_core_fin_025_pre_1
• Layer: NATURAL_OBJECT
• Object Type: Integrator
• Case ID: None
• Primary Key: Ursa Serial 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)

• 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).

• [No Field Group]

  • Patient ID -- The internal database identifier (used, e.g., for joins and primary keys) for the patient. This value is typically mastered, i.e., all records for the same patient, regardless of the source data system from which that record originated, should have the same Patient ID value. (Note that while the mastered Patient ID value might resemble a local identifier used in one of the upstream data sources, this does not indicate any special priority of that source system in determining the characteristics of the patient.) (See also [URSA-CORE] Patient)
  • Ursa Serial ID