[SO/URSA-QUALITY] Mental Health IP Index Events with Transfer Discharge Dates

Object Description

None

Metadata

• Table Name: ursa.so_ursa_quality_enc_011
• Layer: SYNTHETIC_OBJECT
• Object Type: Single Stack
• Case ID: None
• Primary Key: Ursa Serial ID

Published Fields

• [No Field Group]
  • Final Discharge Date
  • Index Document ID
  • Index Master Document ID
  • Index Patient ID
  • Index Claim ID
  • Index Document Effective Date
  • Index Document Effective Start Date
  • Index Document Effective End Date
  • Index Parent Document Effective Start Date
  • Index Parent Document Effective End Date
  • Index CMS Revenue Center Code
  • Index CMS Revenue Center Description
  • Index Document Effective End Date +1 Day
  • Is Index Shared Lineage with Inpatient Stay Document
  • Is Index Shared Lineage with Non-Acute Inpatient Stay Document
  • Is Index Shared Lineage with Inpatient Stay Except Psychiatric Residential Document
  • Is Index Inpatient Stay Except Psychiatric Residential Document
  • Is Index Any Fracture Document
  • Is Index Shared Lineage with Mental Illness Principal Diagnosis
  • Is Index Shared Lineage with Mental Health Principal Dx Document
  • Is Index Shared Lineage with Intentional Self Harm Document
  • Is Index Encounter That Meets Index Event Criteria
  • Index Rank for Readmission Selection
  • Index Episode ID
  • Index Episode Start Date
  • Index Episode End Date
  • Index Episode Length Days
  • Index Episode Count Components
  • Is Index First Component In Episode
  • Is Index Last Component In Episode
  • Next Index Event Start Date
  • Days to Next IP Index Event
  • Is MH Readmit Encounter that Meets Acute Readmission with Mental Health or Self Harm Dx Criteria
  • MH Readmit Episode ID
  • MH Readmit Episode Start Date
  • MH Readmit Episode End Date
  • Ursa Serial ID