TISS28.accdb Change Log

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

This 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, 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.

Version 2013-02-28

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

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