TISS28.accdb Change Log

Template:Discussion 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? Trish Ostryzniuk 20:53, 2013 April 5 (EDT)

• not sure why this article was deleted?Trish Ostryzniuk 17:58, 2014 May 29 (CDT)

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 form. The corresponding database therefore contains only TISS-28 data.

The TISS28.mdb Change Log reflects the ongoing evolution of the database in response to emerging requirements from the 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, 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.

Problems

multiple listings - sorting by site,serial, location and dates

• 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. Trish Ostryzniuk 17:43, 2013 July 19 (CDT)
  • Pagasa says this happens when you do an Edit to site, serial location or first date on form while in TISS28.mdb.
    • so, Pagasa: Is the problem that when you edit an entry the list does not re-sort to put the new label into its place? There is a re-fresh or re-load in the menu, it should re-sort the list to default. Ttenbergen 08:52, 2013 July 25 (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)

read daily dates rather than infer

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.Trish Ostryzniuk 14:24, 2013 July 22 (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)

File processing issues

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. Trish Ostryzniuk 18:15, 2013 March 5 (EST)

Changes since last version

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)

See also

• TISS28 data specifications