ER Delay: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
JMojica (talk | contribs)
No edit summary
Line 18: Line 18:
=={{CCMDB Data Integrity Checks| ready to implement}} ==
=={{CCMDB Data Integrity Checks| ready to implement}} ==
The data collector will receive an error if the ER Delay is greater than:   
The data collector will receive an error if the ER Delay is greater than:   
* CC  - 9 hours
* CC  - 8 hours
* Med – 44 hours
* Med – 44 hours


Line 24: Line 24:
* as of 2017-10-17 Julie would like that cross check; Tina needs to implement it still.
* as of 2017-10-17 Julie would like that cross check; Tina needs to implement it still.
** Julie, this warning, it should only apply if the patient is from the location collection's own ER, right? Or also if from other ER?Ttenbergen 17:51, 2017 December 6 (CST)
** Julie, this warning, it should only apply if the patient is from the location collection's own ER, right? Or also if from other ER?Ttenbergen 17:51, 2017 December 6 (CST)
**Own ER only.  also I change the limits of CC from 9 to 8. I did a rerun on the corrected data after the audit. --[[User:JMojica|JMojica]] 09:29, 2017 December 7 (CST)


== related fields ==
== related fields ==

Revision as of 09:29, 2017 December 7

Data Element (edit)
Field Name: ER Delay
CCMDB Label: not stated
CCMDB tab: not stated
Table: Created_variables_common table
Data type: date
Length: n/a
Program: Med and CC
Created/Raw: Created
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 8

The ER Delay is the difference between the Accept DtTm and Arrive_DtTm for patients arriving from the ER.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


It's is calculated by created_variables_common_maker query and stored in created_variables_common table in CFE.

data use

  • Measure the time spent using ER bed/facilities/staff while already accepted under a Medicine or Critical Care Service.
  • Measure the delay of movement of patient from ER bed to Medicine or Critical Care bed.

Template:CCMDB Data Integrity Checks

The data collector will receive an error if the ER Delay is greater than:

  • CC - 8 hours
  • Med – 44 hours

Template:Discussion

  • as of 2017-10-17 Julie would like that cross check; Tina needs to implement it still.
    • Julie, this warning, it should only apply if the patient is from the location collection's own ER, right? Or also if from other ER?Ttenbergen 17:51, 2017 December 6 (CST)
    • Own ER only. also I change the limits of CC from 9 to 8. I did a rerun on the corrected data after the audit. --JMojica 09:29, 2017 December 7 (CST)

related fields

Reporting and Analysis

The SAS Program to read the data is in X:\Julie\SAS_CFE\CFE_macros\CFE_ERWait_Moves.sas

Legacy

Used to be collected as ER Wait and before that as Moves for Medicine.