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.

v2017-04-18

• started

to do

• re-connect module
• update importer for new structure

cleanup:

• removed modules basNotes, BOM_Removal, TeleForm_Update and Test_Area
• removed deprecated functions

v2016-08-15

edited on server Ttenbergen 14:48, 2016 August 15 (CDT)

• Modules, commented out some old content that doesn't seem to be used any longer.
• deleted old tables/queries
  • table tblPatientDateViewSAS
  • table TISS28 PROD 2012-12-11_ImportErrors
  • table tblTISSReference, see TISS28 items & points instead

• changing processing from separate fields to D_ID:
  • added D_ID to query qryConfirmImport

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)