myhealth_monthly_surgery_query: MyHealth Monthly Surgery File

In spsanderson/LICHospitalR: Hospital Data Analysis Workflow Tools

Description

This query will generate the data needed to produce the monthly MyHealth Surgery file and send to MyHealth.

Usage

myhealth_monthly_surgery_query()

Details

• Need a valid DSS connection and rights to query.

• Utilizes both db_connect() and db_disconnect() functions

• Returns data as a tibble

• This query contains the following fields:

1. Facilty Account Number

2. Provider_ID

3. Provider Short Name

4. Room ID

5. Start Date

6. Enter Procedure Room Time

7. Leave Procedure Room Time

8. Procedure Description (from ORSOS)

9. Anesthesia Start Date

10. Anesthesia Start Time

11. Anesthesia Stop Date

12. Anesthesia Stop Time

13. Patient Type

14. Admit Recovery Date

15. Admit Recovery Time

16. Leave Recovery Date

17. Leave Recovery Time

The date fields are dynamically set to look back one month. There are no parameters to this function

Value

A tibble

Author(s)

Steven P. Sanderson II, MPH

Examples

## Not run: 
  myhealth_monthly_surgery_query()

## End(Not run)

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