TISS28.accdb Change Log: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 11: Line 11:
* Added new form to provide access to "canned" reports/queries
* Added new form to provide access to "canned" reports/queries
* Added ''Count of TISS Items'' query (accessible via the new form above)
* 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)
* Patched STB_CCU unit designation (removed leading space from CCU in existing data)



Revision as of 10:02, 2013 February 25

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-28 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 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.

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