L TmpV2 table: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "[[Centralized_data.accdb]]" to "Centralized_data.accdb" |
Ttenbergen (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 18: | Line 18: | ||
| Pat_ID/[[D_ID]] ||2 || || | | Pat_ID/[[D_ID]] ||2 || || | ||
|- | |- | ||
| Project ||3 || text () || | | Project ||3 || text () || name of the [[Projects|Project]], corresponds to [[s_tmp]].Study | ||
|- | |- | ||
| Item ||4 || text () || | | Item ||4 || text () || value in project, or [[Dropdown-like user experience for tmp projects |dropdown]], corresponds to [[s_tmp]].value | ||
|- | |- | ||
| obsdate ||5 || Date/Time || automatically entered date of collection | | obsdate ||5 || Date/Time || automatically entered date of collection, see [[Separation of date and time fields]] | ||
|- | |- | ||
| obstime ||6 || Date/Time || automatically entered time of collection | | obstime ||6 || Date/Time || automatically entered time of collection, see [[Separation of date and time fields]] | ||
|- | |- | ||
| date_var ||7 || Date/Time || date, if collected | | date_var ||7 || Date/Time || date, if collected, specified in [[s_tmp]].date_var_label, see [[Separation of date and time fields]] | ||
|- | |- | ||
| time_var ||8 || Date/Time || time, if collected | | time_var ||8 || Date/Time || time, if collected, specified in [[s_tmp]].time_var_label, see [[Separation of date and time fields]] | ||
|- | |- | ||
| int_var ||9 || number (long integer) || integer variable, if collected | | int_var ||9 || number (long integer) || integer variable, if collected, specified in [[s_tmp]].int_var_label | ||
|- | |- | ||
| float_var ||9 || number (double) || float/real variable, if collected | | float_var ||9 || number (double) || float/real variable, if collected, specified in [[s_tmp]].float_var_label | ||
|- | |- | ||
| bool_var ||10 || Yes/No || boolean variable, if collected | | bool_var ||10 || Yes/No || boolean variable, if collected, specified in [[s_tmp]].bool_var_label | ||
|- | |- | ||
| comment_var ||11 || Text || comment variable, if collected | | comment_var ||11 || Text || comment variable, if collected, not specified in [[s_tmp]] since generally permitted as free text comment | ||
|} | |} | ||
== why separate? == | |||
See [[separation of date and time fields]] | |||
== Related articles == | == Related articles == | ||