Centralized data front end.accdb Change Log 2021: Difference between revisions

Line 30: Line 30:
** [[query TISS_Errors_vent_vs_vent2300]]
** [[query TISS_Errors_vent_vs_vent2300]]
** TISS_admitted_date_range (undocumented)
** TISS_admitted_date_range (undocumented)
**
** helper queries that are now no longer used: has_TISS_19_spont_breath_ETT_trach, has_TISS_22_ETT_present, has_TISS_23_trach_present, has_TISS_32_33_34_Dialysis, has_TISS_32_Hemodialysis, has_TISS_33_CRRT, has_TISS_34_peritoneal_dialysis, has_TISS_42_tmp_pacemaker, has_TISS_43_endoscopic_px, ND_sub_CLI_has_TISS17_CentralLine, has_TISS_18_vent, has_TISS_22_ETT_OR_23_trach_present, has_TISS_48_vent_2300
** helper queries that are now no longer used: has_TISS_19_spont_breath_ETT_trach, has_TISS_22_ETT_present, has_TISS_23_trach_present, has_TISS_32_33_34_Dialysis, has_TISS_32_Hemodialysis, has_TISS_33_CRRT, has_TISS_34_peritoneal_dialysis, has_TISS_42_tmp_pacemaker, has_TISS_43_endoscopic_px, ND_sub_CLI_has_TISS17_CentralLine, has_TISS_18_vent, has_TISS_22_ETT_OR_23_trach_present, has_TISS_48_vent_2300
* renamed query ''P_Count_of_Sent'' to [[CT Count of sent query]] and updated it to work as a crosstab rather than a pivot.


=== 2021-08-25 ===
=== 2021-08-25 ===