S tmp table: Difference between revisions

(30 intermediate revisions by 2 users not shown)

Line 1:

The '''~~S_Tmp~~''' table contains the possible values for the [[L_TmpV2]] ~~table on the PDA and~~ in ~~the~~ [[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 sent to the OUTPUT folder on the Reginal 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~~. ~~[[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]] table on the PDA and in the [[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 sent to the OUTPUT folder on the Reginal 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. [[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]]