[SO/URSA-CORE] Dialysis Facility Encounters

Object Description

One record per Dialysis Facility Encounter; this object executes the logic to generate the final encounter-level properties based on the full set of documents related to the encounter collected in the aggregator object.

Metadata

• Table Name: ursa.so_ursa_core_enc_009
• Layer: SYNTHETIC_OBJECT
• Object Type: Single Stack
• Temporal Class: Event
• Case ID: Encounter ID
• Event Date: Encounter Date
• Primary Key: Encounter ID

Published Fields

• Data Model Keys

  • Encounter ID -- The internal database identifier (used, e.g., for joins and primary keys) for the encounter. (See also [URSA-CORE] Encounter)
  • 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)
  • Encounter Primary Payor ID
  • Encounter Primary Plan ID
  • Facility Provider ID
  • Service Provider ID
  • Attending Provider ID
  • Provider Group Provider ID
  • Primary HCPCS Procedure Provider ID

• Date Fields

  • Encounter Date

• Encounter Fields

  • Qualifying Document HCPCS Code
  • Qualifying Document CMS Revenue Center Code
  • Qualifying Document CMS Type of Bill Code
  • Qualifying Document EMR Encounter Type Description

• Clinical Services Fields

  • Primary HCPCS Procedure HCPCS Code

• Diagnosis Fields

  • Principal Diagnosis ICD-10-CM Code
  • Principal Diagnosis ICD-10-CM Description

• Billing and Claims Fields

  • CMS Admission Type Code
  • CMS Admit Source Code
  • CMS Patient Discharge Status Code
  • CMS Place of Service Code

Foreign Keys

• pat_id → ursa.no_ursa_core_pat_001.pat_id
• enc_primary_payor_id → ursa.no_ursa_core_struct_004.payor_id
• enc_primary_plan_id → ursa.no_ursa_core_struct_005.plan_id
• facility_prov_id → ursa.no_ursa_core_prov_001.prov_id
• service_prov_id → ursa.no_ursa_core_prov_001.prov_id
• attending_prov_id → ursa.no_ursa_core_prov_001.prov_id
• prov_group_prov_id → ursa.no_ursa_core_prov_001.prov_id