S tmp table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Data Structure: m) |
Ttenbergen (talk | contribs) m (MCHP) |
||
Line 23: | Line 23: | ||
* '''auto_cant_add_manually''' - 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]] | * '''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]] | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: L_TmpV2 Data]] | [[Category: L_TmpV2 Data]] | ||
[[Category: TmpV2]] | [[Category: TmpV2]] |
Revision as of 16:51, 2017 April 11
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
- 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 "--"
- complete_send - no longer used, was related to sending pre-CFE
- 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