S tmp table: Difference between revisions

Line 1:

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

then that row of data will get sent to the OUTPUT folder on the Regional Server TmpV2_1.mdb

== to do before de-stubbing ==

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

* complete_send - determines when results will be sent

**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.~~

** if true/checked then record is sent only once final-check is true (ie when the patient is sent)

**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. * active

** if false/not checked then record will be sent 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. The newest sent record is what will be looked at.

* active - only active lines show up in the dropdown

* location

** gives location where dropdown should be available

** ~~use "All"~~ if available ~~everywhere~~

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

** ~~use "All"~~ if available for all programs

** if not entered will be available for all programs

[[Category: Data structure]]

@@ Line 1: / Line 1: @@
 The '''S_Tmp''' table contains the possible values for the [[L_TmpV2]] in [[CCMDB.mdb]].
+then that row of data will get sent to the OUTPUT folder on the Regional Server TmpV2_1.mdb
 == to do before de-stubbing ==
@@ 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
+* complete_send - determines when results will be sent
-**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.
+** if true/checked then record is sent only once final-check is true (ie when the patient is sent)
-**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. * active
+** if false/not checked then record will be sent 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. The newest sent record is what will be looked at.
+* active - only active lines show up in the dropdown
 * location
 ** gives location where dropdown should be available
-** use "All" if available everywhere
+** 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
-** use "All" if available for all programs
+** if not entered will be available for all programs
 [[Category: Data structure]]