- 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
- 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
- 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
Query maintenance_s_tmp_deletables can be used to see if any values can be made inactive.
- Check Accept Loc Park
- Query check CCI CRRT vs Tmp
- Query check overstay no colour
- Query check overstay not entered
- Query check overstay pt from our med
- Query check tmp 2 BL TR S same tm
- Query check tmp Boarding Loc Service first same
- Query check tmp ER Boarding Loc should exist if from ER
- Query check tmp Service and Boarding Loc during admission timeframe
- Query check tmp Transfer Ready not before Boarding Loc
- Query check tmp generate allowed
- Query check tmp service and program consistency
- Query check tmp service or location duplicate
- Query s tmp ABO TEE checks
- Query s tmp Boarding Loc ER delay reasonable
- Query s tmp Boarding Loc date item
- Query s tmp Boarding Loc no borrow but entry
- Query s tmp Borrow duplicates
- Query s tmp Borrow no borrow on own unit
- Query s tmp Borrow sensible DtTm vs no borrow
- Query s tmp IICU consult DtTm
- Query s tmp IICU consult dispo to IICU but no tmp
- Query s tmp QASeptic Dx no tmp ICD10
- Query s tmp QASeptic tmp no dx
- Query s tmp apostrophe in comment
- Query s tmp check Boarding Loc and TransferReadyDtTm pairs
- Query s tmp check combined BL and TRDtTm nonsequential
- Query s tmp check combined Boarding Loc and TransferReadyDtTm
- Query s tmp project item consistent