ts_readmit_excess_query: Time Series - Readmission Excess Query

In spsanderson/LICHospitalR: Hospital Data Analysis Workflow Tools

Description

This query gets the data necessary to do a time series analysis on the excess readmission rates.

Usage

ts_readmit_excess_query()

Details

• Requires a connection to DSS, uses both db_connect() and db_disconnect()

• The start date is set to 2016-04-01

• The end date is set dynamically to the end of the previous month.

• It gets data from:

1. smsdss.BMH_PLM_PtAcct_V

2. smsdss.pract_dim_v

3. Customer.Custom_DRG

4. smsdss.c_LIHN_Svc_Line_Tbl

5. smsdss.vReadmits

6. smsdss.c_Readmit_Dashboard_Bench_Tbl

7. smsdss.c_ppr_apr_drg_global_exclusions

Value

A tibble

Author(s)

Steven P. Sanderson II, MPH

Examples

## Not run: 
ts_readmit_excess_query()

## End(Not run)

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