S tmp table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (17 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 | ||
* Instruction - this gets displayed for how to collect the specific variable | * '''order''' - order in which the value entries will be listed after project/study is chosen | ||
* int_var_label - shows up as label for the integer in the detail view; if not used, put "--" | * '''Instruction''' - this gets displayed for how to collect the specific variable | ||
* float_var_label - shows up as label for the float 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 "--" | ||
* bool_var_label - shows up as label for the boolean/checkbox 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 "--" | ||
* date_var_label - shows up as label for the date 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 "--" | ||
* time_var_label - shows up as label for the time 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 | |||
* hosp | * '''hosp''' | ||
** gives location where dropdown should be available | ** gives location where dropdown should be available | ||
** if not entered, will be available for all locations | ** if not entered, will be available for all locations | ||
** make several lines with locations if available only in some places | ** make several lines with locations if available only in some places | ||
* program | * '''program''' | ||
** gives program for which dropdown should be available | ** gives program for which dropdown should be available | ||
** if not entered will be available for all programs | ** 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]] | |||
== Maintenance == | |||
[[Query maintenance_s_tmp_deletables]] can be used to see if any values can be made inactive. | |||
== Cross Checks == | |||
{{#ask: [[Category:Tmp check]] | |||
|default=No corresponding old article found | |||
|format=UL | |||
|limit=100 | |||
|link=all | |||
|headers=show | |||
}} | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: L_TmpV2 Data]] | [[Category: L_TmpV2 Data]] | ||
[[Category: TmpV2]] | [[Category: TmpV2]] | ||
Latest revision as of 15:09, 2023 May 17
The s_Tmp table contains the possible values for the L_TmpV2 in CCMDB.accdb.
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 "--"
- 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
Maintenance
Query maintenance_s_tmp_deletables can be used to see if any values can be made inactive.
Cross Checks
- Check Accept Loc Park
- Query cardiac arrest throughout admission
- 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 BedHeld
- 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 EuroSCORE II checks
- 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