S tmp table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| Line 2: | Line 2: | ||
== Data Structure == | == Data Structure == | ||
* Study - name of study for which this variable is relevant | * '''Study''' - name of study for which this variable is relevant | ||
* Value - think of this as the "field name" for that study | * '''Value''' - think of this as the "field name" for that study | ||
* Instruction - this gets displayed for how to collect the specific variable | * '''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 "--" | * '''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 "--" | * '''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 "--" | * '''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 "--" | * '''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 "--" | * '''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]] | * '''complete_send''' - see [[S Tmp Complete send]] | ||
* active - only active lines show up in the dropdown | * '''active''' - only active lines show up in the dropdown | ||
* hosp | * '''hosp''' | ||
** gives location where dropdown should be available | ** gives location where dropdown should be available | ||
** if not entered, will be available for all locations | ** if not entered, will be available for all locations | ||
** make several lines with locations if available only in some places | ** make several lines with locations if available only in some places | ||
* program | * '''program''' | ||
** gives program for which dropdown should be available | ** gives program for which dropdown should be available | ||
** if not entered will be available for all programs | ** 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) | |||
** if false a specific scenario sets off the function to add this record, i.e. not added at patient creation | |||
** the "true" scenario is '''not''' implemented yet | |||
* '''auto_can_add_manually''' - entry can be ''added'' manually, ie. will show up in dropdowns | |||
* '''auto_can_edit''' - entry will be visible in tmp tab to be ''edited'' manually | |||
Revision as of 14:49, 2012 October 19
The S_Tmp table contains the possible values for the L_TmpV2 in CCMDB.mdb.
Data Structure
- 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
- auto_add_at_patient_creation - an entry that is auto-added at patient creation time if applicable for a location (not yet implemented)
- if false a specific scenario sets off the function to add this record, i.e. not added at patient creation
- the "true" scenario is not implemented yet
- auto_can_add_manually - entry can be added manually, ie. will show up in dropdowns
- auto_can_edit - entry will be visible in tmp tab to be edited manually