[SO/URSA-ACOREACH] Hospital Inpatient Admissions for URSA-ACOREACH-CMS Measures

Prev Next

Object Description

One record per hospital inpatient admission; includes fields to identify qualifying encounters for the CMS All-Condition Readmission (ACR) and Unplanned Admissions for Patients with Multiple Chronic Conditions (UAMCC) measures.

Metadata

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

Published Fields

  • Data Model Keys

    • Next Encounter Inpatient Admission Encounter ID
    • Next Encounter Facility Provider ID
    • 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)
    • Facility Provider ID -- The internal database identifier (used, e.g., for joins and primary keys) for the facility provider. (See also [URSA-CORE] Facility Provider)
    • Primary Encounter ID
  • Date Fields

    • Next Encounter Start Date
    • Elapsed Days from Encounter End Date to Next Encounter Start Date
    • Primary Encounter Start Date
    • Primary Encounter End Date
  • Encounter Fields

    • Is Emergency Department Visit Parent Encounter Document
    • ACR Cohort Description
    • Is Encounter ACR Surgery/Gyn Specialty Cohort Based on Procedure Codes
    • Is Encounter ACR Due to COVID Risk Factors
    • Is Encounter ACR Exclusion on Principal Discharge Diagnosis
    • Is Any Procedure in Encounter Always Planned
  • Provider Fields

    • Facility Provider NPI
    • Facility Provider CCN
    • Facility Provider Description
    • Primary NUCC Provider Taxonomy Code -- The 10-character National Uniform Claim Committee (NUCC) provider taxonomy code designated as the primary scope of practice in the referenced provider's entry in the National Provider Identifier (NPI) registry. Typically identifies an individual provider's primary specialty, or an organizational provider's facility type.
    • Primary NUCC Provider Taxonomy Description -- The natural language description of the provider's Primary NUCC Provider Taxonomy Code. (See also [URSA-CORE] Primary NUCC Provider Taxonomy Code)
    • Is Facility CCN Type Short-Term General or Specialty Hospital
    • Is Facility CCN Type Critical Access Hospital
    • Is Facility CCN Type Rehabilitation Hospital or Unit
    • Is Facility CCN Type Psychiatric Hospital or Unit
  • Clinical Services Fields

    • Principal ICD-10-PCS Code
    • Principal ICD-10-PCS Description
  • Diagnosis Fields

    • Principal Discharge Diagnosis ICD-10-CM Code
    • Principal Discharge Diagnosis ICD-10-CM Description
    • Principal Discharge Diagnosis AHRQ CCS Single-Level Diagnosis Category Code
    • Principal Discharge Diagnosis AHRQ CCS Single-Level Diagnosis Category Description
    • Next Encounter Principal Discharge Diagnosis ICD-10-CM Code
  • Billing and Claims Fields

    • CMS Admit Source Code -- The standard 1-character CMS Admit Source code; e.g., 1 = Physician Referral, 2 = Clinic Referral, etc.
    • CMS Patient Discharge Status Code -- The standard 2-digit CMS Patient Discharge Status code; 01 = Discharged to Home or Self Care, etc. Patient Discharge Status codes should include leading zeros.
    • CMS Patient Discharge Status Description -- The natural language description of a standard CMS Patient Discharge Status code. (See also [URSA-CORE] CMS Patient Discharge Status Code)
  • Metadata Fields

    • Encounter Ordinal Rank Within Patient
  • Module Fields

    • Is Any Planned Admission Procedure
    • Is Any Potentially Planned Admission Procedure
    • Is Acute Illness or Complication Principal Diagnosis
    • Is Planned Admission Condition Principal Diagnosis