S tmp table: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
| (18 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The ''' | {{DISPLAYTITLE:s_tmp table}}The '''s_Tmp''' table contains the possible values for the [[L_TmpV2]] in [[CCMDB.accdb]]. | ||
== Data Structure == | == Data Structure == | ||
* '''Study''' - name of study for which this variable is relevant | * '''Study''' - name of study for which this variable is relevant | ||
* '''Value''' - think of this as the "field name" for that study | * '''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 | * '''Instruction''' - this gets displayed for how to collect the specific variable | ||
* '''instruction_url''' - link to the project's wiki page | |||
* '''int_var_label''' - shows up as label for the integer in the detail view; if not used, put "--" | * '''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 "--" | * '''float_var_label''' - shows up as label for the float in the detail view; if not used, put "--" | ||
| Line 10: | Line 12: | ||
* '''date_var_label''' - shows up as label for the date 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 "--" | * '''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 | * '''active''' - only active lines show up in the dropdown | ||
* '''hosp''' | * '''hosp''' | ||
| Line 22: | 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]] | |||
== Maintenance == | |||
[[Query maintenance_s_tmp_deletables]] can be used to see if any values can be made inactive. | |||
[[Category: Data structure]] | == Cross Checks == | ||
[[Category: L_TmpV2 Data]] | {{#ask: [[Category:Tmp check]] | ||
[[Category: | |default=No corresponding old article found | ||
|format=UL | |||
|limit=100 | |||
|link=all | |||
|headers=show | |||
}} | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:Data structure]] | |||
[[Category:L_TmpV2 Data | * ]] | |||
[[Category:Tmp Project Infrastructure]] | |||
[[Category:Tmp Project Infrastructure]] | |||