Grace Medicine ADT Report: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m q
Line 15: Line 15:
** Rural
** Rural
** Long Term Care
** Long Term Care
* {{discussion}} Same groupings as Tables 3 and 4 I think. Need to find out if these groupings are used in other reports and how done... Ttenbergen 11:22, 2014 September 18 (CDT)
* Same groupings as Tables 3 and 4 I think. Need to find out if these groupings are used in other reports and how done... Ttenbergen 11:22, 2014 September 18 (CDT)
** Julie confirmed she uses groupings based on admit_from only, ie ignore hosp_previous; in one query she used deceased as well. Ttenbergen 17:33, 2014 September 18 (CDT)


===Table2. Mortality Counts===
===Table2. Mortality Counts===

Revision as of 17:33, 18 September 2014

Table1. Number of Admissions

  • SAS code X:\Julie\MedProjects\2014\2014-MG-003_GRAStats\CFE_GRA.sas
  • draft in CFE R_Gra_ADT_1_nr_Admissions

Table1-2. Number of Admissions and Originating Sources

  • draft in CFE R_Gra_ADT_12_admission_sources
  • this report groups "from" locations...
    • Gra ER
    • Gra Ambulatory
    • Gra MICU
    • Gra Ward
    • HSC/SBGH
    • Community Hosp
    • Home
    • Rural
    • Long Term Care
  • Same groupings as Tables 3 and 4 I think. Need to find out if these groupings are used in other reports and how done... Ttenbergen 11:22, 2014 September 18 (CDT)
    • Julie confirmed she uses groupings based on admit_from only, ie ignore hosp_previous; in one query she used deceased as well. Ttenbergen 17:33, 2014 September 18 (CDT)

Table2. Mortality Counts

  • draft in CFE R_Gra_ADT_2_mortality
  • bases date groupings on discharge date

Table3. Number of Intra-facility and Inter-facility Transfers

  • is this in? out? both in one table? waiting for sample report.

Table4. Number Discharges

  • draft query in CFE R_Gra_ADT_4_nr_Discharges

Table5. Distribution of Patients' Discharge Time

  • draft query in CFE R_Gra_ADT_5_discharge_hr_distribution
    • Template:Discussion seems like this is limited to >7am... is there a reason? Ttenbergen 11:43, 2014 September 18 (CDT)

Requester

Mary Anne Lynch

log

2014-09-05 Julie identified this as a candidate for transfer to CFE.