Created Variables Common 2021 table: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 3: | Line 3: | ||
== Update to [[PatientFollow Project]] structure == | == Update to [[PatientFollow Project]] structure == | ||
=== ER Delay === | === ER Delay === | ||
[[ER Delay] | See [[ER Delay]]. | ||
=== GCS === | === GCS === | ||
Revision as of 08:37, 17 October 2024
The Created_Variables_Common_2021 table in CFE contains the values created by Created_Variables_Common_maker_2021 query when the Calc created variables button is pressed. 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.
Update to PatientFollow Project structure
ER Delay
See ER Delay.
GCS
No change to the GCS entries. They are in Created Variables Common 2021 table because they are also used by the ALERT Scale.
Data Structure
| field | type | description | source |
|---|---|---|---|
| D_ID | text | link to L_Log table | relational derived |
| age | integer | Age | calculated |
| adm | DtTm | pulled in from Created AdmitDtTm query | |
| dis | DtTm | Dispo DtTm | relational derived |
| LOS | Double | LOS | calculated |
| ER_Delay | Single | ER Delay | calculated |
| GCS_Eye_pts | byte | from L Log table and s_GCS_eye query | relational derived |
| GCS_Eye_text | string | from L Log table and s_GCS_eye query | relational derived |
| GCS_Motor_pts | byte | from L Log table and s_GCS_motor query | relational derived |
| GCS_Motor_text | string | from L Log table and s_GCS_motor query | relational derived |
| GCS_Verbal_pts | byte | from L Log table and s_GCS_verbal query | relational derived |
| GCS_Verbal_text | string | from L Log table and s_GCS_verbal query | relational derived |
| GCS_Total | byte | sum of GCS_Eye_pts, GCS_Motor_pts, GCS_Verbal_pts | calculated |
| Site | string | from L Log table and s_dispo table | relational derived |
| Ward | string | from L Log table and s_dispo table | relational derived |
| Program | string | from L Log table and s_dispo table | relational derived |
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
- 2022-06-09 or before
- updated definition for ER Delay
- removed RecordStatus discontinued from the query
- 2022-04-27
- removed Transfer Ready DtTm/Transfer Ready DtTm tmp entry resp Transfer Delay because there can be more than one of these per record; see those pages for how it will now be calculated
- confirmed "Adm" and Age are based on Admit_DtTm
- updated LOS to use Function LOS()
- removed Transfer Delay because there can be more than one, see the relevant pages
- confirmed ER Delay uses new definition of Admit DtTm
- 2021-04-21 - original implementation