s_tmp table

From CCMDB Wiki
Jump to navigation Jump to search

The s_Tmp table contains the possible values for the L_TmpV2 in CCMDB.accdb.

Data Structure

  • Study - name of study for which this variable is relevant
  • Value - think of this as the "field name" for that study
  • order - order in which the value entries will be listed after project/study is chosen
  • 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 "--"
  • 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 - see Automatic Generation of TMP entries
  • auto_cant_add_manually - see Automatic Generation of TMP entries
  • auto_cant_edit - see Automatic Generation of TMP entries
  • MCHP - True/False whether this study will be included in the Manitoba Centre for Health Policy export

Maintenance

Query maintenance_s_tmp_deletables can be used to see if any values can be made inactive.

Cross Checks

Related articles

Related articles: