S tmp table: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) No edit summary |
||
| (12 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 == | ||
| Line 6: | Line 6: | ||
* '''order''' - order in which the value entries will be listed after project/study is chosen | * '''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 11: | 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 25: | Line 25: | ||
* '''MCHP''' - True/False whether this study will be included in the [[Manitoba Centre for Health Policy export]] | * '''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 == | == Cross Checks == | ||
{{#ask: [[Category:Tmp check]] | {{#ask: [[Category:Tmp check]] | ||
|default= | |default=No corresponding old article found | ||
|format=UL | |format=UL | ||
|limit=100 | |||
|limit= | |||
|link=all | |link=all | ||
|headers=show}} | |headers=show | ||
}} | |||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||
[[Category: L_TmpV2 Data]] | [[Category:L_TmpV2 Data | * ]] | ||
[[Category: | [[Category:Tmp Project Infrastructure]] | ||
[[Category:Tmp Project Infrastructure]] | |||