L TmpV2 table: Difference between revisions

m Text replacement - "[[Centralized_data.accdb]]" to "Centralized_data.accdb"
 
(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 () || Ward the patient was admitted to
| Project ||3 || text () || name of the [[Projects|Project]], corresponds to [[s_tmp]].Study
|-  
|-  
| Item ||4 || text () || date the variable was collected
| 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 ==