TISS28.accdb Change Log: Difference between revisions

(66 intermediate revisions by 4 users not shown)

Line 1:

~~'''~~TISS~~.mdb'''~~ is ~~a Microsoft Access database for storing TISS form data after scanning by~~ [[~~Teleform~~]]~~. Since January 1, 2013, data collection has switched to the new~~ [[~~TISS General Info|TISS-28~~]] ~~form~~. ~~The corresponding database therefore contains only TISS-28 data~~.

{{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 change log reflects the ongoing evolution of the database in response to emerging requirements from the [[Main office|Main Office]] as well as bug fixes. Problems with the current version of the database or requests for enhancements or both should be communciated via email.

:''~~NOTE: The~~ TISS-~~28 database consists~~ of ~~two Access files~~, '''~~TISS.mdb~~''' and '''~~TISS_Data~~.~~mdb~~''', ~~representing~~ the ~~user interface~~ and ~~data components~~, ~~respectively~~. ~~The generic term~~ '''~~database~~''' ~~as used~~ in ~~this article refers~~ to ~~both components.~~''

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==

* confirming impact of [[:Category:2016 Time and Place changes]] Ttenbergen 14:49, 2016 July 11 (CDT)

* impacts:

** 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==

Changes since the last version:

* Removed sorting by batch number (edit window - forms section)

* TISS Forms can now be deleted from the database via the edit window

* After importing new data, a list of forms just added to the database is displayed to allow confirmation/validation by the data processor

* Added tblTISSReport as a linked table in TISS28_Data.mdb

==Version 2013-02-22==

Changes since the last version:

* Grouped and added controls to the main form to access new functions

* Added new form to provide access to "canned" reports/queries

* Added ''Count of TISS Items'' query (accessible via the new form above)

* Added ''Patient and Date" query (accessible via the new form above)

* Added ''Patient and Date'' query (accessible via the new form above)

* Patched STB_CCU unit designation (removed leading space from CCU in existing data)

==Version 2013-01-25==

Changes since the last version:

* Cosmetic UI changes

Line 27:

Line 94:

==Version 2013-01-18==

Changes since the last version:

* Added code to prevent the importing of duplicate forms

Line 33:

Line 99:

==Version 2013-01-16==

This is the original release of the TISS-28 database. It contains limited functionality as follows:

* Importing TISS data as generated by Teleform

* Looking up a TISS form image file name (from the corresponding SERIAL number)

~~==See also==~~

}}

[[Category:TISS28.accdb]]

* [[TISS28 data specifications]]

[[Category:Development Documentation]]

[[Category:TISS28]]

[[Category:~~IT Instructions~~]]

@@ Line 1: / Line 1: @@
-'''TISS.mdb''' is a Microsoft Access database for storing TISS form data after scanning by [[Teleform]]. Since January 1, 2013, data collection has switched to the new [[TISS General Info|TISS-28]] form. The corresponding database therefore contains only TISS-28 data.
+{{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 change log reflects the ongoing evolution of the database in response to emerging requirements from the [[Main office|Main Office]] as well as bug fixes. Problems with the current version of the database or requests for enhancements or both should be communciated via email.
-:''NOTE: The TISS-28 database consists of two Access files, '''TISS.mdb''' and '''TISS_Data.mdb''', representing the user interface and data components, respectively. The generic term '''database''' as used in this article refers to both components.''
+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==
+* confirming impact of [[:Category:2016 Time and Place changes]] Ttenbergen 14:49, 2016 July 11 (CDT)
+* impacts:
+** 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==
+Changes since the last version:
+* Removed sorting by batch number (edit window - forms section)
+* TISS Forms can now be deleted from the database via the edit window
+* After importing new data, a list of forms just added to the database is displayed to allow confirmation/validation by the data processor
+* Added tblTISSReport as a linked table in TISS28_Data.mdb
 ==Version 2013-02-22==
 Changes since the last version:
 * Grouped and added controls to the main form to access new functions
 * Added new form to provide access to "canned" reports/queries
 * Added ''Count of TISS Items'' query (accessible via the new form above)
-* Added ''Patient and Date" query (accessible via the new form above)
+* Added ''Patient and Date'' query (accessible via the new form above)
 * Patched STB_CCU unit designation (removed leading space from CCU in existing data)
 ==Version 2013-01-25==
 Changes since the last version:
 * Cosmetic UI changes
@@ Line 27: / Line 94: @@
 ==Version 2013-01-18==
 Changes since the last version:
 * Added code to prevent the importing of duplicate forms
@@ Line 33: / Line 99: @@
 ==Version 2013-01-16==
 This is the original release of the TISS-28 database. It contains limited functionality as follows:
 * Importing TISS data as generated by Teleform
 * Looking up a TISS form image file name (from the corresponding SERIAL number)
-==See also==
+}}
+[[Category:TISS28.accdb]]
-* [[TISS28 data specifications]]
+[[Category:Development Documentation]]
-[[Category:TISS28]]
-[[Category:IT Instructions]]