Created Variables Common 2021 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "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. == Data Structure == {| class="wikitable sortable" |- !| field !| type !| description !|..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 69: | Line 69: | ||
[[Category:Data structure]] | [[Category:Data structure]] | ||
[[Category:Reporting]] | [[Category:Reporting]] | ||
[[Category:PatientFollow Project]] | |||
Revision as of 16:30, 29 December 2021
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.
Data Structure
| field | type | description | source |
|---|---|---|---|
| D_ID | text | link to L_Log table | relational derived |
| age | integer | Age | calculated |
| adm | DtTm | derived from Accept DtTm resp Arrive DtTm | relational derived |
| trans | DtTm | Transfer Ready DtTm | relational derived |
| dis | DtTm | Dispo DtTm | relational derived |
| LOS | Double | LOS | calculated |
| Transfer_Delay | Single | Transfer Delay | 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
- 2021-04-21
- to do:
- change Age to use first service dttm instead of (Accept_DtTm if available, Arrive_DtTm otherwise)
- adm - (Accept_DtTm if available, Arrive_DtTm otherwise)
- trans - Transfer Ready DtTm, included because used to be calculated
- dis - Dispo DtTm, included because used to be calculated
- Transfer Delay
- ER Delay
- Glasgow Coma Scale