S tmp table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (MCHP) |
Ttenbergen (talk | contribs) mNo edit summary |
||
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]] | ||
== Cross Checks == | |||
{{Data Integrity Check | |||
| DIC_summary = There must not be apostrophes in the comment field as they would mess with Julie's data analysis. | |||
| DIC_related_concepts = [[S Tmp]] | |||
| DIC_firmness = hard check | |||
| DIC_app = CCMDB.mdb | |||
| DIC_coding = query ''s_tmp_apostrophe_in_comment'' | |||
| DIC_status = implemented | |||
| DIC_implementation_date = 2017-Apr-27 | |||
}} | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: L_TmpV2 Data]] | [[Category: L_TmpV2 Data]] | ||
[[Category: TmpV2]] | [[Category: TmpV2]] |
Revision as of 18:35, 2018 September 19
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
Cross Checks
Data Integrity Checks | |
Summary: | There must not be apostrophes in the comment field as they would mess with Julie's data analysis. |
Related: | [[S Tmp]] |
Firmness: | hard check |
Timing: | always |
App: | CCMDB.mdb |
Coding: | query s_tmp_apostrophe_in_comment |
Uses L Problem table: | not relevant for this app |
Status: | implemented |
Implementation Date: | 2017-Apr-27 |
Backlogged: | true |