CCMDB Wiki

TISS28.accdb Change Log: Difference between revisions

← Older edit
added headings for questions rather than numbered list
m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"
 
(48 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{Discussion}}
{{LegacyContent
Hi Tina,Fred started this log. Maybe we should also have a Requested changes for TISS28.mdb next version article to keep track of requests for TISS28 mdb? [[User:TOstryzniuk|Trish Ostryzniuk]] 20:53, 2013 April 5 (EDT)
|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=




'''[[TISS28_Data.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 [[TISS28 items & points | TISS28]] form. The corresponding database therefore contains only TISS-28 data.
This is the log of changes for [[TISS28.accdb]].  


The [[TISS28.mdb 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.
== 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''


:''NOTE: The TISS-28 database consists of two Access files, '''[[TISS28.mdb]]''' and '''[[TISS28_Data.mdb]]''', representing the user interface and data components, respectively. The generic term '''database''' as used in this article refers to both components.''
== 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


==Version 2013-02-28==
== v2019-01-10 ==
==Problems==
* changed reconnector to draw from "frozen" rather than live data
{{Discussion}}{{Potential Change}}
 
=== multiple listings ===
== v2017-11-01 ==
July 19.13 - multiple pages of TISS are suppose to be sorted by Serial_Hosp_Loc in tiss28.mdb.  This is not occurring for some reason consistently.  Example would be serial 27621_STB_CCU.  This is problematic for data processor it that when person scanning has to check what previous pages have been scanned in, she must Search one by one to find. [[User:TOstryzniuk|Trish Ostryzniuk]] 17:43, 2013 July 19 (CDT)
* query ''TISS_Errors_D_ID_not_in_CFE'' for D_ID not in CFE Ttenbergen 16:16, 2017 November 1 (CDT)
#*this problem I can probably work out with Pagasa quickly. Pagasa, at your convenience, could you please book 0.5hr into my calendar to work on this? Ttenbergen 11:27, 2013 July 22 (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


=== read daily dates rather than infer ===
== v2016-08-15 ==
July 22.23 - Change request Dates in Teleform: Teleform - Read each DATE from top of each daily column rather than generating date based on first date on form box at top of form. Collector cannot see a missing date in middle of dates when scanning lots of form.  When pick up in QA check Julie run AFTER imported into TISS28.mdb, processor must pull paper form and check what date is missing, first, last or somewhere in the middle.[[User:TOstryzniuk|Trish Ostryzniuk]] 14:24, 2013 July 22 (CDT)
edited on server Ttenbergen 14:48, 2016 August 15 (CDT)
* From what I remember about the hand-off meeting with Fred that won't be an easy fix. I don't think Teleform actually even reads these dates. Will check into this with the other Teleform stuff when we have a second programmer. Ttenbergen 15:40, 2013 July 22 (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


=== File processing issues ===
* changing processing from separate fields to D_ID:  
Email sent to Fred, Tina, Linda & Julie: This started at TISS28 Teleform scan batch 1029March 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)
** added D_ID to query ''qryConfirmImport''


== Changes since last version ==
==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 32: 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 41: 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 53: 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 59: 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]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=TISS28.accdb_Change_Log"