TISS28.accdb Change Log: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(60 intermediate revisions by 3 users not shown)
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.mdb]].
|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 communicated 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]].  


==Version 2013-02-28==
== v2020-03-05 ==
{{Discussion}}
* updated a bunch of things for [[Update of D ID to include a laptop identifier]]
*Problem ID'd today. Email sent to Fred, Tina, Linda & Julie: This started at TISS28 Teleform scan batch 1029 March 1.13.  In TISS28.mdb when Pagasa clicks the “Import TISS Data” button in Access, the TISS28.csv file on X is being copied/moved into "archive" however, Julie’s tblPatientDateViewSAS is not being updated. Fred stated last week (Wed Feb 27), that he would fix Access so Pagasa would not  have to press the “prepare report” button. He told Pagasa and Julie that he automated the copy to archive and update to Julie’s tbl when Pagasa presses the “import TISS Data” button.    It appear that only the copy/move to archive is working. Please fix ASAP or advise of a work around to get scanned batches into Julie’s tblPatientDateViewSAS. [[User:TOstryzniuk|Trish Ostryzniuk]] 18:15, 2013 March 5 (EST)
** 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:
Changes since the last version:
* Removed sorting by batch number (edit window - forms section)
* Removed sorting by batch number (edit window - forms section)
Line 17: 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 26: 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 38: 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 44: 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)


==See also==
}}
 
[[Category:TISS28.accdb]]
* [[TISS28 data specifications]]
[[Category:Development Documentation]]
 
[[Category:TISS28]]
[[Category:IT Instructions]]

Latest revision as of 11:26, 2022 July 28

Legacy Content

This page contains Legacy Content.

Click Expand to show legacy content.

This is the log of changes for TISS28.accdb.

v2020-03-05

v2019-02-11

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 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)
  • 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
    • added vertical scroll bar to edit form
    • edit form maximizes on open
    • added record navigation controls to image lookup form
  • Additions and deletions are now allowed on ITEMS subform (on edit form)
  • Added Edit and Save buttons to the edit form; form now opens in "view" mode to prevent accidential editing of data
  • Added feature on image lookup to open image PDF file
  • Fixed data display issue on edit form

Version 2013-01-18

Changes since the last version:

  • Added code to prevent the importing of duplicate forms
  • Added form to facilitate controlled editing of TISS data elements already contained in the database

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)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=TISS28.accdb_Change_Log&oldid=156903"