S tmp table: Difference between revisions

(28 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]].

== to ~~do before de~~-~~stubbing ==~~

== Data Structure ==

* ~~explain 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 "--"

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

**Column sent complete - if '''box is checked''' in this column then that row of data will get sent to the OUTPUT folder on the Regional Server TmpV2_1.mdb '''only when''' the whole patient file is completed and sent in.

== Maintenance ==

**If box is '''not checked''' then that row of data will be ~~sent~~ to ~~TmpV2_1.mdb each time~~ any ~~data is sent to the Regional Server even if patient file is not complete~~. ~~Tmpv2 will fill up with repeated data for the same patient but with a different sending date. [[User:TOstryzniuk|TOstryzniuk]] 17:17, 18 June 2009 (CDT)~~

[[Query maintenance_s_tmp_deletables]] can be used to see if any values can be made inactive.

== Cross Checks ==

[[Category: Data structure]]

{{#ask: [[Category:Tmp check]]

|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]].
-== to do before de-stubbing ==
+== Data Structure ==
-* explain 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 "--"
+* '''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]]
-**Column sent complete - if '''box is checked''' in this column then that row of data will get sent to the OUTPUT folder on the Regional Server TmpV2_1.mdb  '''only when''' the whole patient file is completed and sent in.
+== Maintenance ==
-**If box is '''not checked''' then that row of data will be sent to TmpV2_1.mdb each time any data is sent to the Regional Server even if patient file is not complete. Tmpv2 will fill up with repeated data for the same patient but with a different sending date. [[User:TOstryzniuk|TOstryzniuk]] 17:17, 18 June 2009 (CDT)
+[[Query maintenance_s_tmp_deletables]] can be used to see if any values can be made inactive.
-{{stub}}
+== Cross Checks ==
-[[Category: Data structure]]
+{{#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:L_TmpV2 Data | * ]]
+[[Category:Tmp Project Infrastructure]]
+[[Category:Tmp Project Infrastructure]]