ts_alos_elos_query: Time Series - ALOS/ELOS 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 length of stay rates.

Usage

ts_alos_elos_query()

Details

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

• The start date is set to 2014-04-01 which is when the Customer.Custom_DRG table starts

• 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.c_LIHN_Svc_Line_tbl

3. Customer.Custom_DRG

4. smsdss.c_LIHN_SPARCS_BenchmarkRates

5. smsdss.pract_dim_v

6. smsdss.c_LIHN_APR_DRG_OutlierThresholds

7. smsdss.pyr_dim_v

Value

A tibble

Author(s)

Steven P. Sanderson II, MPH

Examples

## Not run: 
ts_alos_elos_query()

## End(Not run)

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