TISS28.accdb Change Log: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Fschumacher (talk | contribs)
No edit summary
Line 4: Line 4:


:''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.''
:''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==
==Version 2013-01-25==


Changes since last version:
Changes since the last version:
* Cosmetic UI changes
* Cosmetic UI changes
** added vertical scroll bar to edit form
** added vertical scroll bar to edit form

Revision as of 08:55, 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