The Created_Variables_Common_2021 table in CFE contains the values created by Created_Variables_Common_maker_2021 query. They are stored rather than generated on the fly because the query is slow for the volume of data involved (many minutes on Tina's PC) and because SAS can not read some data from queries. It is used by the statistician for reporting and data extracts.
Testing
During Testing, the query will need to be filled by manually:
ER Delay
|
- I suppose you are changing the columns from adm to ER-delay, are these correct? are you just changing the data source from L_Log to tmp service or changing how to present the LOS - by record or by each service of each record?
- I just changed the source from the L_Log values to the tmp values, where available, ie they would still be by profile.
- I am defining it as
ER_Delay: Nz([created_FirstNonER_BoardingLoc].[dttm],[Arrive_dttm])-Nz([Admit_DtTm]) , ie you could use the created_FirstNonER_BoardingLoc query for other things as well. Ttenbergen 16:44, 2022 January 11 (CST)
|
Transfer Ready DtTm
|
- how about the transfer delay for MED involving High obs and regular ward where there are more than one legit transfer dates - are you including that in the calculation?
- re multiples: -Tina to review
- re High-obs: -Tina to review
- If we wanted them by service it could not really go onto Created Variables as it is right now, since it outputs one line per profile. I can make queries that e.g. do LOS per service, but those would have to be different queries that would have more than one line per profile, and we would need to define them before I can build them. Ttenbergen 15:10, 2021 June 3 (CDT)
|
GCS *
|
- I need the rest for the ALERT Score in Medicine report - these have no change, right?
- No change to the GCS entries, do you mean anything else? Ttenbergen 16:44, 2022 January 11 (CST)
|
Data Structure
Background
Replacement for the old Created Variables Common table to deal with process changes such as PatientFollow Project. A new table/query was set up instead of modifying the old one in order to allow for testing over a period of time.
Log
|
|
- added: 2022-04-21
- action: 2022-04-21
|
Related articles