ER Delay: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 17: | Line 17: | ||
* Measure the time spent using ER bed/facilities/staff while already accepted under a Medicine or Critical Care Service. | * 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. | * Measure the delay of movement of patient from ER bed to Medicine or Critical Care bed. | ||
{{Discuss | | |||
*Lisa replied ‘when boarding loc is only ER the arrivedttm equals accept dttm equals first service dttm, dispo time should be the discharge dttm'. I have thought the same – that this is how we were doing it with EMIPs. Can’t find this rule in WIKI. | |||
*Before we move to tmp service and boarding loc. I calculated ER delay equals Arrive dttm – accept dttm. Now we added another or second way, ER Delay equals first post-ER Boarding Loc dttm - ER Boarding Loc dttm. | |||
*This caused an issue for boarding loc only ER. There is no post-ER boarding loc. if I follow the first way, ER delay is ZERO since arrive dttm is the same as accept dttm. | |||
*Should the whole stay at ER be considered as an ER delay or NOT? If yes, then in the past I was underestimating it because all EMIPs have ZERO delay. | |||
*If YES in the question above, then we should add this rule for EMIP or ECIP cases | |||
#Arrive dttm equals dispo dttm | |||
#first post-ER Boarding Loc dttm equals dispo dttm | |||
in this way, ER Delay will be consistent in both formulas. | |||
*For discussion. --[[User:JMojica|JMojica]] 10:17, 2022 March 9 (CST)}} | |||
{{Data Integrity Check List}} | {{Data Integrity Check List}} | ||
Revision as of 10:17, 2022 March 9
| 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, or ER Boarding Loc and first post-ER Boarding Loc, for patients arriving from the ER.
It's is calculated by Created_Variables_Common_maker query and stored in Created_Variables_Common table in CFE.
It is also calculated and checked by query check_ER_Delay_not_too_big.
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.
|
in this way, ER Delay will be consistent in both formulas.
|
Data Integrity Checks (automatic list)
| App | Status | |
|---|---|---|
| Query s tmp Boarding Loc ER delay reasonable | CCMDB.accdb | implemented |
Reporting and Analysis
The SAS Program to read the data is in X:\Julie\SAS_CFE\CFE_macros\datetimes.sas
Legacy
- Used to be just the difference between the Accept DtTm and Arrive_DtTm for patients arriving from the ER.
- Used to be collected as ER Wait and before that as Moves for Medicine.