[SO/URSA-PHU] Hospital Inpatient Admissions with Prior Related Encounter

  • Published on May 20, 2026
  • 4 minute(s) read
Prev Next

Object Description

One record per hospital inpatient admission with one or more of the following: (1) prior ED visit within 7 days prior to admission; (2) prior hospital inpatient admission with discharge date within 7 days prior to admission or within 30 days prior to admission and with similar principal discharge diagnoses; or (3) prior SNF stay with discharge date within 14 days prior to admission.

Metadata

  • Table Name: ursa.so_ursa_phu_enc_002
  • Layer: SYNTHETIC_OBJECT
  • Object Type: Single Stack
  • Temporal Class: Event
  • Case ID: Encounter ID
  • Event Date: Encounter Start 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)
    • Prior Admission Encounter ID
    • Prior ED Visit Encounter ID
    • 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)
    • Prior Admission Facility Provider ID
    • Prior ED Visit Facility Provider ID
    • Prior SNF Stay Facility Provider ID

  • Date Fields

    • Encounter Start Date
    • Encounter End Date

  • Encounter Fields

    • Prior Encounter Scenario Category -- A hospital inpatient admission with one or more of the following: (1) prior ED visit within 7 days prior to admission; (2) prior hospital inpatient admission with discharge date within 7 days prior to admission or within 30 days prior to admission and with similar principal discharge diagnoses; or (3) prior SNF stay with discharge date within 14 days prior to admission.
    • Is Prior Related Hospital Inpatient Admission
    • Is Prior Related ED Visit
    • Is Prior Related SNF Stay

  • Diagnosis Fields

    • AHRQ CCS Single-Level Diagnosis Category Code
    • AHRQ CCS Single-Level Diagnosis Category Description
    • AHRQ CCS Multi-Level Diagnosis Category Tier 1 Code
    • AHRQ CCS Multi-Level Diagnosis Category Tier 1 Description
    • AHRQ CCS Multi-Level Diagnosis Category Tier 2 Code
    • AHRQ CCS Multi-Level Diagnosis Category Tier 2 Description
    • Prior Admission Principal Diagnosis ICD-10-CM Description
    • Prior Admission AHRQ CCS Single-Level Diagnosis Category Description
    • Prior Admission AHRQ CCS Multi-Level Tier 1 Diagnosis Category Description
    • Prior Admission AHRQ CCS Multi-Level Tier 2 Diagnosis Category Description
    • Principal Discharge Diagnosis ICD-10-CM Code
    • Principal Discharge Diagnosis ICD-10-CM Description

  • Financial Fields

    • Primary Plan Allowed Amount -- The maximum amount that the payor agrees to pay the provider for a service or product, typically governed by a contract. The Allowed Amount for a claim or billing record is calculated by adding the Contractual Adjustment Amount (which is typically negative) to the Charge Amount. Adding the total Non-Contractual Adjustment Amount to the Allowed Amount yields the Total Due Amount. On billing records, which may identify up to three plans responsible for payment, the Primary Plan Allowed Amount, Secondary Plan Allowed Amount, and Tertiary Plan Allowed Amount fields identify the amounts paid by the primary, secondary, and tertiary plans listed on the bill, respectively. (See also [URSA-CORE] Charge Amount, [URSA-CORE] Contractual Adjustment Amount, [URSA-CORE] Non-Contractual Adjustment Amount, [URSA-CORE] Total Due Amount)
    • Primary Plan Paid Amount -- The amount actually paid by the health plan to the provider for a service or product. Subtracting the plan paid amount from the total due amount typically yields the patient responsibility amount. On billing records, which may identify up to three plans responsible for payment, the Primary Plan Paid Amount, Secondary Plan Paid Amount, and Tertiary Plan Paid Amount fields identify the amounts paid by the primary, secondary, and tertiary plans listed on the bill, respectively; the total paid by any and all plans on a bill is identified by the Any Plan Paid Amount field.
    • Total Plan Paid Amount from All Plans
    • Patient Paid Amount -- The amount paid by the patient to the provider for health care services or products.

  • Metadata Fields

    • ACS Admission PQI Category -- A categorical field identifying which specific AHRQ Prevention Quality Indicator (PQI) criterion the ambulatory care sensitive (ACS) admission meets. Values are:
      [01] PQI 01 Diabetes Short-Term Complications
      [02] PQI 02 Perforated Appendix
      [03] PQI 03 Diabetes Long-Term Complications
      [04] PQI 05 Older Adult COPD or Asthma
      [05] PQI 07 Hypertension
      [06] PQI 08 Heart Failure
      [07] PQI 09 Low Birth Weight
      [08] PQI 10 Dehydration
      [09] PQI 11 Bacterial Pneumonia
      [10] PQI 12 Urinary Tract Infection
      [11] PQI 14 Uncontrolled Diabetes
      [12] PQI 15 Younger Adult Asthma
      [13] PQI 16 Diabetic Lower-Extremity Amputation
      [97] Multiple PQI Criteria Met

This field is NULL for encounters that are not ACS admissions (i.e., where is_acs_hospital_inpat_admission = 0). Each PQI is determined by AHRQ-specified principal diagnosis value sets, age thresholds, and exclusion criteria (transfer admits, cardiac procedures, immunocompromised state, condition-specific exclusion diagnoses).

  • Validation Only Fields
    • Prior Admission Discharge Date
    • Days from Prior Admission Discharge Date to Admit Date

Foreign Keys

  • enc_id → ursa.so_ursa_core_enc_001.enc_id
  • pat_id → ursa.no_ursa_core_pat_001.pat_id
  • prior_ed_visit_facility_prov_id → ursa.no_ursa_core_prov_001.prov_id
  • prior_snf_stay_facility_prov_id → ursa.no_ursa_core_prov_001.prov_id
  • prior_admission_enc_id → ursa.so_ursa_core_enc_001.enc_id
  • prior_ed_visit_enc_id → ursa.so_ursa_core_enc_003.enc_id
  • facility_prov_id → ursa.no_ursa_core_prov_001.prov_id
  • prior_admission_facility_prov_id → ursa.no_ursa_core_prov_001.prov_id