S tmp table: Difference between revisions

Revision as of 12:41, 2012 September 5

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

Study - name of study for which this variable is relevant
Value - think of this as the "field name" for that study
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 "--"
complete_send - see S Tmp Complete send
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

@@ Line 10: / Line 10: @@
 * 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 - determines when results will be sent
+* complete_send - see [[S Tmp Complete send]]
-** if true/checked then record is sent only once final-check is true (ie when the patient is sent)
-** 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
 * hosp