los_ra_index_query: Get LOS and Readmit Index Query

In spsanderson/LICHospitalR: Hospital Data Analysis Workflow Tools

Description

Get the Length of Stay and Readmit data with expected performance

Usage

los_ra_index_query()

Details

• Gets data from DSS query

• Uses db_connect() and db_disconnect() functions. See documentation.

• Gets

  1. Adm_Date

  2. Dsch_Date

  3. Encounter

  4. LIHN_Svc_Line

  5. ALOS

  6. ELOS

  7. Visit_Flag

  8. Readmit_Flag

  9. Readmit_Rate

• Data Tables

  1. smsdss.bmh_plm_ptacct_v

  2. smsdss.vReadmits

  3. smsdss.c_elos_bench_data

  4. smsdss.c_LIHN_Svc_Line_Tbl

  5. Customer.Custom (APR-DRG Data)

  6. smsdss.c_readmit_dashboard_bench_tbl

• Filters

  1. tot_chg_amt > 0

  2. Encounter does not start with 2 or 1999

  3. Dsch_Date >= '2001-01-01'

  4. Plm_Pt_Acct_Type = "I"

Value

A tibble

Author(s)

Steven P. Sanderson II, MPH

Examples

library(DBI)
library(odbc)
library(dplyr)
library(tibble)
library(janitor)
df_tbl <- los_ra_index_query()

spsanderson/LICHospitalR documentation built on Jan. 6, 2022, 12:32 a.m.