TISS28.accdb Change Log

This is the log of changes for TISS28.mdb. For a list of requested changes see Requested TISS changes for the next 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.mdb
  • updated table tblTISPatient to have a D_ID field
  • updated Function LoadTISSPatientData to update D_ID as well
• Replacing Julie's SAS:
  • TISS_Errors_NrTissDays_NE_LOS
  • TISS_Errors_TISS_date_out_of_admission

Version 2013-02-28

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