Automatic Generation of TMP entries

Template:Potential Change Whenever we run a project using TMP tab entries, data collectors have to generate one or more lines before they can actually enter data. This results in extra steps.

We have at least one project for which we automatically generate an entry: Postal code collection. Whenever a new patient is entered, a "Postal Code" line is generated in the TMP tab and the collector can just fill in the PC, doesn't need to make a line first.

We could add functionality to generate lines automatically for other projects.

CCMDB.mdb_Change_Log_2012#ver_2012-11-16

• added/changed entries in s_tmp to autogenerate lines
  • for postal code, just checked "auto_add_at_patient_creation"
  • for Overstay had to create generic lines collectors can change to acceptable lines
• created sub add_automatic_tmp_entries and append query s_tmp__auto_record_adder to add lines
• added function call to cb_addPt_Click(), removed old code that generated Postal Codes since this will take care of it
• updated query check_overstay_not_entered to ensure that auto entries for overstay won't slip through as completed

CCMDB.mdb_Change_Log_2012#ver_2012-10-19

Added relevant columns to S Tmp because they were needed for another change implemented in

S_Tmp table usage

• auto_add_at_patient_creation - if true then the line is auto-added at patient creation time if applicable for a location (not yet implemented)
• auto_cant_add_manually - entry can't be added manually, ie. will show up in dropdowns
• auto_cant_edit - entry will not be visible in tmp tab to be edited manually