TISS28.accdb Change Log: Difference between revisions
Ttenbergen (talk | contribs) m →Version 2016-07-11: log |
Ttenbergen (talk | contribs) m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb" |
||
| (37 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
This is the log of changes for [[TISS28. | {{LegacyContent | ||
|explanation=TISS is now collected as part of CCI, so collected in [[CCMDB.accdb]] and stored in [[CFE]] / [[Centralized_data.accdb]]. | |||
|successor=[[Change log]] | |||
|content= | |||
This is the log of changes for [[TISS28.accdb]]. | |||
== v2020-03-05 == | |||
* updated a bunch of things for [[Update of D ID to include a laptop identifier]] | |||
** specifically, how D_ID is made in query ''qryExportFix_Add_D_ID'' | |||
== v2019-02-11 == | |||
* updated [[Query TISS Errors missing days]] to '''include''' vetted | |||
* updated [[Query TISS Errors D ID not in CFE]] - changed to ckeck last 90 days now that Pagasa has explained that TISS collection might be far behind. | |||
* updated [[Query TISS Errors NrTISSDays NE LOS]] - changed to only look at discharges within the last 90 days, instead of admits since 2013 | |||
* updated [[Query TISS Errors TISS date out of admission]] - changed to only look at discharges within the last 90 days | |||
* updated [[Query TISS Errors duplicate Items]] - to check the last 90 days of TISS items rather than all since 2016 | |||
== v2019-01-10 == | |||
* changed reconnector to draw from "frozen" rather than live data | |||
== v2017-11-01 == | |||
* query ''TISS_Errors_D_ID_not_in_CFE'' for D_ID not in CFE Ttenbergen 16:16, 2017 November 1 (CDT) | |||
== v2017-06-21 == | |||
* fixed query ''TISS_Error_missing_days'' to include the first day of the stay, was not listing that | |||
* fixed the image open button, was using the wrong path | |||
== v2017-05-23 == | |||
* added query ''TISS_Errors_missing_days'' and table ''Dates'''. Ttenbergen 14:30, 2017 May 23 (CDT) | |||
== v2017-04-18 == | |||
* Added a reconnect module to make sure all tables are linked to external mdbs properly Ttenbergen 12:26, 2017 April 19 (CDT) | |||
* Importer | |||
** added column ''D_ID'' to ''[[tmp_TISS_Export table]]'' | |||
** in [[L_TISS_Form table]], removed column ''BATCH_NO'' ; changed name of ''BATCH_NO_TEXT'' to ''BATCH_NO_TEXT''; it's now a text field only because some are "*_old" | |||
** updated query ''ImportQry'' to reference the new table names | |||
* cleanup: | |||
** removed modules ''basNotes'', ''BOM_Removal'', ''TeleForm_Update'' and ''Test_Area'' | |||
** removed deprecated functions | |||
** removed old tmp tables ''2016-08-17_orphans'' and ''2016-08-17min_patientID'' | |||
** removed old tmp queries ''2016-08-15_LOS attempt'', ''2016-08-17_min_patientID_maker'', ''2016-08-17_orphan_deleter_'', ''2016-08-17_orphan_deleter'', ''2016-08-17_tblTISSpatient_dedupe_form_re-assigner'' | |||
** removed query ''2016-08-22_lower-Casing'' that will not be used any longer, replaced by query ''qryFix_Location_Names'' that does more | |||
== v2016-08-15 == | |||
edited on server Ttenbergen 14:48, 2016 August 15 (CDT) | |||
* Modules, commented out some old content that doesn't seem to be used any longer. | |||
* deleted old tables/queries | |||
** table ''tblPatientDateViewSAS'' | |||
** table ''TISS28 PROD 2012-12-11_ImportErrors'' | |||
** table ''tblTISSReference'', see [[TISS Item List]] instead | |||
* changing processing from separate fields to D_ID: | |||
** added D_ID to query ''qryConfirmImport'' | |||
==Version 2016-07-11== | ==Version 2016-07-11== | ||
* confirming impact of [[:Category:2016 Time and Place changes]] Ttenbergen 14:49, 2016 July 11 (CDT) | * confirming impact of [[:Category:2016 Time and Place changes]] Ttenbergen 14:49, 2016 July 11 (CDT) | ||
* impacts: | * impacts: | ||
** query '' | ** query ''qryPatientDateView2'' - changed to use service_location | ||
** | ** linked in [[s_dispo table]] from c:\ccmdb_program\ccmdb.accdb | ||
** updated table ''tblTISPatient'' to have a D_ID field | |||
** updated ''Function LoadTISSPatientData'' to update D_ID as well | |||
* Replacing Julie's SAS: | |||
** [[Query TISS Errors NrTISSDays NE LOS]] | |||
** [[Query TISS_Errors_TISS_date_out_of_admission]] | |||
==Version 2013-02-28== | ==Version 2013-02-28== | ||
| Line 15: | Line 75: | ||
==Version 2013-02-22== | ==Version 2013-02-22== | ||
Changes since the last version: | Changes since the last version: | ||
* Grouped and added controls to the main form to access new functions | * Grouped and added controls to the main form to access new functions | ||
| Line 24: | Line 83: | ||
==Version 2013-01-25== | ==Version 2013-01-25== | ||
Changes since the last version: | Changes since the last version: | ||
* Cosmetic UI changes | * Cosmetic UI changes | ||
| Line 36: | Line 94: | ||
==Version 2013-01-18== | ==Version 2013-01-18== | ||
Changes since the last version: | Changes since the last version: | ||
* Added code to prevent the importing of duplicate forms | * Added code to prevent the importing of duplicate forms | ||
| Line 42: | Line 99: | ||
==Version 2013-01-16== | ==Version 2013-01-16== | ||
This is the original release of the TISS-28 database. It contains limited functionality as follows: | This is the original release of the TISS-28 database. It contains limited functionality as follows: | ||
* Importing TISS data as generated by Teleform | * Importing TISS data as generated by Teleform | ||
* Looking up a TISS form image file name (from the corresponding SERIAL number) | * Looking up a TISS form image file name (from the corresponding SERIAL number) | ||
}} | |||
[[Category:TISS28.accdb]] | |||
[[Category:TISS28 | |||
[[Category:Development Documentation]] | [[Category:Development Documentation]] | ||