S tmp table: Difference between revisions

(19 intermediate revisions by the same user not shown)

Line 1:

The '''~~S_Tmp~~''' table contains the possible values for the [[L_TmpV2]] in [[CCMDB.~~mdb~~]].

{{DISPLAYTITLE:s_tmp table}}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

* '''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 "--"

* '''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 "--"

* '''time_var_label''' - shows up as label for the time in the detail view; if not used, put "--"

* '''complete_send''' - see [[S Tmp Complete send]]

* '''active''' - only active lines show up in the dropdown

* '''hosp'''

Line 19:

Line 20:

** gives program for which dropdown should be available

** if not entered will be available for all programs

* '''auto_add_at_patient_creation''' - ~~an entry that is auto-added at patient creation time if applicable for a location (not yet implemented)~~

* '''auto_add_at_patient_creation''' - see [[Automatic Generation of TMP entries]]

** if false a specific scenario sets off the function to add this record, i.e. not added at patient creation

* '''auto_cant_add_manually''' - see [[Automatic Generation of TMP entries]]

** the "true" scenario is '''~~not~~''' ~~implemented yet~~

* '''auto_cant_edit''' - see [[Automatic Generation of TMP entries]]

* '''~~auto_cant_add_manually~~''' - ~~entry can't be ''added'' manually, ie. will show up in dropdowns~~

* '''MCHP''' - True/False whether this study will be included in the [[Manitoba Centre for Health Policy export]]

* '''~~auto_cant_edit~~''' - ~~entry~~ will ~~not~~ be ~~visible~~ in ~~tmp tab to be ''edited'' manually~~

== 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: ~~TmpV2~~]]

|default=No corresponding old article found

|format=UL

|limit=100

|link=all

|headers=show

}}

== Related articles ==

[[Category:Data structure]]

[[Category:L_TmpV2 Data | * ]]

[[Category:Tmp Project Infrastructure]]

@@ Line 1: / Line 1: @@
-The '''S_Tmp''' table contains the possible values for the [[L_TmpV2]] in [[CCMDB.mdb]].
+{{DISPLAYTITLE:s_tmp table}}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
+* '''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 "--"
 * '''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 "--"
 * '''time_var_label''' - shows up as label for the time in the detail view; if not used, put "--"
-* '''complete_send''' - see [[S Tmp Complete send]]
 * '''active''' - only active lines show up in the dropdown
 * '''hosp'''
@@ Line 19: / Line 20: @@
 ** gives program for which dropdown should be available
 ** if not entered will be available for all programs
-* '''auto_add_at_patient_creation''' - an entry that is auto-added at patient creation time if applicable for a location (not yet implemented)
+* '''auto_add_at_patient_creation''' - see [[Automatic Generation of TMP entries]]
-** if false a specific scenario sets off the function to add this record, i.e. not added at patient creation
+* '''auto_cant_add_manually''' - see [[Automatic Generation of TMP entries]]
-** the "true" scenario is '''not''' implemented yet
+* '''auto_cant_edit'''  - see [[Automatic Generation of TMP entries]]
-* '''auto_cant_add_manually''' - entry can't be ''added'' manually, ie. will show up in dropdowns
+* '''MCHP''' - True/False whether this study will be included in the [[Manitoba Centre for Health Policy export]]
-* '''auto_cant_edit''' - entry will not be visible in tmp tab to be ''edited'' manually
+== 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: TmpV2]]
+|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]]