S tmp table

The S_Tmp table contains the possible values for the L_TmpV2 in CCMDB.mdb.

Data Structure

• Study - name of study for which this variable is relevant
• Value - think of this as the "field name" for that study
• Instruction - this gets displayed for how to collect the specific variable
• int_var_label - shows up as label for the integer in the detail view; if not used, put "--"
• float_var_label - shows up as label for the float in the detail view; if not used, put "--"
• bool_var_label - shows up as label for the boolean/checkbox in the detail view; if not used, put "--"
• date_var_label - shows up as label for the date in the detail view; if not used, put "--"
• time_var_label - shows up as label for the time in the detail view; if not used, put "--"
• complete_send - see S Tmp Complete send
• active - only active lines show up in the dropdown
• hosp
  • gives location where dropdown should be available
  • if not entered, will be available for all locations
  • make several lines with locations if available only in some places
• program
  • gives program for which dropdown should be available
  • if not entered will be available for all programs
• auto_add_at_patient_creation - an entry that is auto-added at patient creation time if applicable for a location (not yet implemented)
  • if false a specific scenario sets off the function to add this record, i.e. not added at patient creation
  • the "true" scenario is not implemented yet
• 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