Centralized data front end.accdb Change Log 2021: Difference between revisions
Ttenbergen (talk | contribs) m (→2021-???) |
Ttenbergen (talk | contribs) m (→2021-08-26) |
||
(65 intermediate revisions by the same user not shown) | |||
Line 4: | Line 4: | ||
== Log == | == Log == | ||
=== 2021-08-26 === | |||
not rolled out yet [[User:Ttenbergen|Ttenbergen]] 12:40, 2021 August 25 (CDT) | |||
* made query structure for [[Created_FirstLocation query]] in [[CFE]] the same as counterpart in [[CCMDB.accdb]], and updated ''created_variables_common_2021'' query to use the new field names. | |||
=== 2021-08-25 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 11:54, 2021 August 26 (CDT) | |||
* created crosstab queries to replace pivot tables since 2019 doesnt' support them any more: | |||
** [[CT_Summary_Discharges query]] to replace old ''P_Summary_Discharges query'' | |||
** [[CT_Summary_Discharges_FiscalYear query]] to replace old ''P_Summary_Discharges_FiscalYear query'' | |||
=== 2021-08-24 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 12:40, 2021 August 25 (CDT) | |||
* fixed [[created_AdmitDtTm query]] to explicitly turn the date into date data type; somehow the query turned it into something else that was being sorted differently on Pagasa's computer than on Tina's. [[User:Ttenbergen|Ttenbergen]] 14:06, 2021 August 24 (CDT) | |||
* created crosstab queries to replace pivot tables since 2019 doesnt' support them any more: | |||
** [[CT_Count_of_Admissions query]] to replace old ''P_Count_of_Admissions query'' | |||
** [[CT_Outstandings_Dispo query]] confirmed, replaces old ''P_Outstandings_Dispo'' | |||
** [[CT_Outstandings query]] (though not a crosstab because not needed) to replace ''P_Outstandings'' | |||
=== 2021-08-05 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 11:20, 2021 August 24 (CDT) | |||
* updated algorithm behind [[Populate linking pairs]] which had been generating twin pairs. | |||
* updated [[Link suspect mismatch pre inpt ours incomplete query]] to only look a the last three years | |||
=== 2021-08-04 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 14:46, 2021 August 5 (CDT) | |||
* updated query [[PL missing L Tables content]] to no longer look at old [[L Labs Flowsheet table]] | |||
* updated Sub Encounter_processor which was requiring assent after accidental changes in last round | |||
=== 2021-07-27 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 22:31, 2021 August 3 (CDT) | |||
* tweak to query ''encounter_clean_3_del_pers_where_no_L_Person'' which is part of [[Person ID field]] generate person ids; it was failing, but because of how we run these queries that was not visible. | |||
* updated algorithm behind [[Populate linking pairs]] which was impracticably slow under Access 2019 | |||
=== 2021-07-20 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 17:00, 2021 July 20 (CDT) | |||
* made a crosstab query ''P_Outstandings_Dispo'' to replace ''Query P_Outstandings_Dispo'' to test as replacement for Pivot Tables, since those no longer work in Access 2019 [[User:Ttenbergen|Ttenbergen]] 16:55, 2021 July 20 (CDT) | |||
=== 2021-07-15 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 17:25, 2021 July 15 (CDT) | |||
* updated [[PL_SamePHIN_Site_Diff_chart]] to get past 2GB limit [[User:Ttenbergen|Ttenbergen]] 12:08, 2021 July 15 (CDT) | |||
* removed query PL_missing_L_Tables_content_L_Problems; it was used by [[PL_missing_L_Tables_content]] but I integrated it there instead | |||
* per requests from [[Centralized data front end.accdb Change Request]] | |||
** changed order of columns in ICD10 tab to be more like they are in [[CCMDB.accdb]] | |||
** added column "TDI" to list [[CCI Categories]] to [[Query L_CCI_Combined]] | |||
** added "LSusp" button to Patient List (counterpart to NDCs and PLs) | |||
* added [[query NCD_dx_implying_death_across_encounters]] | |||
* finished work on [[Created_AdmitDtTm query]], [[Created_FirstLocation query]], [[Created_FirstService query]] | |||
=== 2021-04-21 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 15:20, 2021 June 3 (CDT) | |||
* started update for [[Created_Variables_Common_maker query]], see [[Created Variables Common table#Log]] for details; for now I created a second query Created_Variables_Common_maker'''_2021''' | |||
* started update for[[Created_Variables_CC_maker query]], see [[Created Variables CC table#Log]] for details; for now I created a second query Created_Variables_CC_maker'''_2021''' | |||
* started [[Created_FirstLocation query]] | |||
* started [[Created_FirstService query]] | |||
* started [[Created AdmitDtTm query]] | |||
=== 2021-02-11 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 14:39, 2021 February 11 (CST) | |||
* updated [[query L_ICD10_primary]] to include records even if their ICD10 code is in a gap in [[S ICD10 Chapter block pattern table]]. | |||
=== 2021-02-04 === | |||
copied to server [[User:Ttenbergen|Ttenbergen]] 14:30, 2021 February 4 (CST) | |||
* added automatic linking to [[s_level_of_care table]] on re-connect[[User:Ttenbergen|Ttenbergen]] 13:05, 2021 February 4 (CST) | |||
=== 2021-01-21 === | |||
Copied to server | |||
* updated to list by laptop: | |||
** ''query P_Outstandings'' | |||
** ''query P_Outstandings_Dispo'' | |||
* tweaked | |||
** [[Link suspect transfer ready before arrive date]] and then stopped when I realized that will go away with the old [[Transfer Ready DtTm field]]. | |||
** Sub likely_match_finder so that just matching DOB and Chart will match a pt, without also requiring the first name to match; this is so that both first and last names being wrong won't lose the match as it did with one pt Pagasa pointed out [[User:Ttenbergen|Ttenbergen]] 19:46, 2021 January 26 (CST) | |||
** [[Link suspect mismatch to ours incomplete query]] to only consider the last 365 days to make it faster | |||
** [[query NDC_CLI_vs_DX_but_no_TISS17_CentralLine]] - removed old dx schema component | |||
** [[Query NDC_Bad_Postal_Code]] - changed query to only look at the last year of data to make it faster; any older records were already fixed | |||
* removed | |||
** defunct ''query NDC_CLI_unacceptable_date_old'' - CLI tmp has been legacy for some time; there was no wiki page for this | |||
** query ''ND_sub_CLI_DateinTMPV2'', ''ND_sub_CLI_has_CLI_TmpV2'' | |||
** query ''PL_1orphans_old'' | |||
** [[query NDC_VAP_unacceptable_date]] | |||
** [[query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2]] | |||
** accessory queries ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component1, ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component, ND_sub_NO_VAPin ACqDX_VAP_dateinTMPV2_sub_had_VAP_acqDX1, ND_sub_NO_VAPin ACqDX_VAP_dateinTMPV2_sub_had_VAP_acqDX | |||
** [[Link_suspect_transfer_ready_greater_than_dispo]] | |||
** [[Link_suspect_transfer_ready_before_arrive_date]] | |||
** old single-use tables "2016-09-19_random100" and "1tmp" | |||
** old unused table "linking_location_var_pairs" | |||
** undocumented table "z_known_problem_D_IDs" - put the contents into the [[L_Problem table]] | |||
** old likely single use and empty queries: encounter_err_twin_phin_foo1, encounter_err_twin_phin_foo, L_tmp_SepticSet, Labs_requester | |||
** [[Query NDC zCRRT TISS no tmp]] and [[Query NDC zCRRT TISS no tmp]]_old | |||
** [[Query NDC zCRRT tmp no TISS]] and [[Query NDC zCRRT tmp no TISS]]_old | |||
** query Patient_List_twek | |||
** query tmp_2020-04-21_sample_for_chastity | |||
=== 2021-01-20 === | === 2021-01-20 === | ||
Pagasa has copied to server | Pagasa has copied to server | ||
* updated [[P_Count_of_sent query]] to be laptop based and to more closely show Pagasa what she actually needs. | * updated [[P_Count_of_sent query]] to be laptop based and to more closely show Pagasa what she actually needs. | ||
* removed defunct queries | * removed defunct queries | ||
** | ** ''Query NDC CLI AcqDX but NoCLI DateinTMPV2'' | ||
** | ** ''Query NDC CLI No AcqDX but CLI DateinTMPV2'' | ||
== Earlier changes == | == Earlier changes == |
Revision as of 15:01, 2021 September 16
see the Development Documentation Category for other development logs This article is the change log for Centralized data front end.accdb. Also see Centralized data front end.accdb Change Request and CFE Data Integrity Checks.
Log
2021-08-26
not rolled out yet Ttenbergen 12:40, 2021 August 25 (CDT)
- made query structure for Created_FirstLocation query in CFE the same as counterpart in CCMDB.accdb, and updated created_variables_common_2021 query to use the new field names.
2021-08-25
copied to server Ttenbergen 11:54, 2021 August 26 (CDT)
- created crosstab queries to replace pivot tables since 2019 doesnt' support them any more:
- CT_Summary_Discharges query to replace old P_Summary_Discharges query
- CT_Summary_Discharges_FiscalYear query to replace old P_Summary_Discharges_FiscalYear query
2021-08-24
copied to server Ttenbergen 12:40, 2021 August 25 (CDT)
- fixed created_AdmitDtTm query to explicitly turn the date into date data type; somehow the query turned it into something else that was being sorted differently on Pagasa's computer than on Tina's. Ttenbergen 14:06, 2021 August 24 (CDT)
- created crosstab queries to replace pivot tables since 2019 doesnt' support them any more:
- CT_Count_of_Admissions query to replace old P_Count_of_Admissions query
- CT_Outstandings_Dispo query confirmed, replaces old P_Outstandings_Dispo
- CT_Outstandings query (though not a crosstab because not needed) to replace P_Outstandings
2021-08-05
copied to server Ttenbergen 11:20, 2021 August 24 (CDT)
- updated algorithm behind Populate linking pairs which had been generating twin pairs.
- updated Link suspect mismatch pre inpt ours incomplete query to only look a the last three years
2021-08-04
copied to server Ttenbergen 14:46, 2021 August 5 (CDT)
- updated query PL missing L Tables content to no longer look at old L Labs Flowsheet table
- updated Sub Encounter_processor which was requiring assent after accidental changes in last round
2021-07-27
copied to server Ttenbergen 22:31, 2021 August 3 (CDT)
- tweak to query encounter_clean_3_del_pers_where_no_L_Person which is part of Person ID field generate person ids; it was failing, but because of how we run these queries that was not visible.
- updated algorithm behind Populate linking pairs which was impracticably slow under Access 2019
2021-07-20
copied to server Ttenbergen 17:00, 2021 July 20 (CDT)
- made a crosstab query P_Outstandings_Dispo to replace Query P_Outstandings_Dispo to test as replacement for Pivot Tables, since those no longer work in Access 2019 Ttenbergen 16:55, 2021 July 20 (CDT)
2021-07-15
copied to server Ttenbergen 17:25, 2021 July 15 (CDT)
- updated PL_SamePHIN_Site_Diff_chart to get past 2GB limit Ttenbergen 12:08, 2021 July 15 (CDT)
- removed query PL_missing_L_Tables_content_L_Problems; it was used by PL_missing_L_Tables_content but I integrated it there instead
- per requests from Centralized data front end.accdb Change Request
- changed order of columns in ICD10 tab to be more like they are in CCMDB.accdb
- added column "TDI" to list CCI Categories to Query L_CCI_Combined
- added "LSusp" button to Patient List (counterpart to NDCs and PLs)
- added query NCD_dx_implying_death_across_encounters
- finished work on Created_AdmitDtTm query, Created_FirstLocation query, Created_FirstService query
2021-04-21
copied to server Ttenbergen 15:20, 2021 June 3 (CDT)
- started update for Created_Variables_Common_maker query, see Created Variables Common table#Log for details; for now I created a second query Created_Variables_Common_maker_2021
- started update forCreated_Variables_CC_maker query, see Created Variables CC table#Log for details; for now I created a second query Created_Variables_CC_maker_2021
- started Created_FirstLocation query
- started Created_FirstService query
- started Created AdmitDtTm query
2021-02-11
copied to server Ttenbergen 14:39, 2021 February 11 (CST)
- updated query L_ICD10_primary to include records even if their ICD10 code is in a gap in S ICD10 Chapter block pattern table.
2021-02-04
copied to server Ttenbergen 14:30, 2021 February 4 (CST)
- added automatic linking to s_level_of_care table on re-connectTtenbergen 13:05, 2021 February 4 (CST)
2021-01-21
Copied to server
- updated to list by laptop:
- query P_Outstandings
- query P_Outstandings_Dispo
- tweaked
- Link suspect transfer ready before arrive date and then stopped when I realized that will go away with the old Transfer Ready DtTm field.
- Sub likely_match_finder so that just matching DOB and Chart will match a pt, without also requiring the first name to match; this is so that both first and last names being wrong won't lose the match as it did with one pt Pagasa pointed out Ttenbergen 19:46, 2021 January 26 (CST)
- Link suspect mismatch to ours incomplete query to only consider the last 365 days to make it faster
- query NDC_CLI_vs_DX_but_no_TISS17_CentralLine - removed old dx schema component
- Query NDC_Bad_Postal_Code - changed query to only look at the last year of data to make it faster; any older records were already fixed
- removed
- defunct query NDC_CLI_unacceptable_date_old - CLI tmp has been legacy for some time; there was no wiki page for this
- query ND_sub_CLI_DateinTMPV2, ND_sub_CLI_has_CLI_TmpV2
- query PL_1orphans_old
- query NDC_VAP_unacceptable_date
- query NDC_VAP_AcqDX_but_NoVAP_DateinTMPV2
- accessory queries ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component1, ND_Sub_VAPinAcqDX_NoVAP_DateinTMPV2_Sub_TMPV2_Component, ND_sub_NO_VAPin ACqDX_VAP_dateinTMPV2_sub_had_VAP_acqDX1, ND_sub_NO_VAPin ACqDX_VAP_dateinTMPV2_sub_had_VAP_acqDX
- Link_suspect_transfer_ready_greater_than_dispo
- Link_suspect_transfer_ready_before_arrive_date
- old single-use tables "2016-09-19_random100" and "1tmp"
- old unused table "linking_location_var_pairs"
- undocumented table "z_known_problem_D_IDs" - put the contents into the L_Problem table
- old likely single use and empty queries: encounter_err_twin_phin_foo1, encounter_err_twin_phin_foo, L_tmp_SepticSet, Labs_requester
- Query NDC zCRRT TISS no tmp and Query NDC zCRRT TISS no tmp_old
- Query NDC zCRRT tmp no TISS and Query NDC zCRRT tmp no TISS_old
- query Patient_List_twek
- query tmp_2020-04-21_sample_for_chastity
2021-01-20
Pagasa has copied to server
- updated P_Count_of_sent query to be laptop based and to more closely show Pagasa what she actually needs.
- removed defunct queries
- Query NDC CLI AcqDX but NoCLI DateinTMPV2
- Query NDC CLI No AcqDX but CLI DateinTMPV2
Earlier changes
See Centralized data front end.accdb Change Log 2020
Related articles
Related articles: |