L TmpV2 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| (15 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
L_TmpV2 table in [[CCMDB. | {{DISPLAYTITLE:L_TmpV2 table}}L_TmpV2 table in [[CCMDB.accdb]] and [[Centralized_data.accdb]] contains data that is either intermittent or just not currently accommodated in the rest of the database. All data that is stored in this table can be found at [[Projects]]. | ||
=== Entity–attribute–value model === | |||
See [[Entity–attribute–value model of the L Tmp V2 table]] | |||
=== Linking === | |||
This table is linked to [[L_Log table]] by [[D_ID]]. See [[CCMDB Data Structure]] for more info. | |||
===Data Structure=== | |||
To see the most up-to-date data structure of this table, see most up-to-date | To see the most up-to-date data structure of this table, see most up-to-date [[CCMDB data.mdb]] in [[Regional Server]]\data\Master. The fields are used differently depending on project, see [[Projects]] for a list and the individual project pages for field usage. | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
|- | |- | ||
! Field Name !! position !! type !! description | ! Field Name !! position !! type !! description | ||
|- | |- | ||
| | | Tmp_ID ||1 || AutoNumber (Long integer)|| unique identifier of tmp entry | ||
|- | |- | ||
| | | Pat_ID/[[D_ID]] ||2 || || | ||
|- | |- | ||
| | | Project ||3 || text () || name of the [[Projects|Project]], corresponds to [[s_tmp]].Study | ||
|- | |- | ||
| | | 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, see [[Separation of date and time fields]] | ||
|- | |- | ||
| | | obstime ||6 || Date/Time || automatically entered time of collection, see [[Separation of date and time fields]] | ||
|- | |- | ||
| | | date_var ||7 || Date/Time || date, if collected, specified in [[s_tmp]].date_var_label, see [[Separation of date and time fields]] | ||
|- | |- | ||
| int_var | | 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, specified in [[s_tmp]].int_var_label | |||
|- | |- | ||
| float_var | | float_var ||9 || number (double) || float/real variable, if collected, specified in [[s_tmp]].float_var_label | ||
|- | |- | ||
| bool_var | | bool_var ||10 || Yes/No || boolean variable, if collected, specified in [[s_tmp]].bool_var_label | ||
|- | |- | ||
| comment_var | | 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}} | |||
<noinclude> | <noinclude> | ||
| Line 43: | Line 49: | ||
[[Category:Data structure]] | [[Category:Data structure]] | ||
[[Category:L_TmpV2 Data | *]] | [[Category:L_TmpV2 Data | *]] | ||
[[Category: | [[Category:Tmp Project Infrastructure | *]] | ||
[[Category:L TmpV2 table | *]] | [[Category:L TmpV2 table | *]] | ||
[[Category:L Table]] | [[Category:L Table]] | ||
</noinclude> | </noinclude> | ||
Latest revision as of 22:58, 23 October 2025
L_TmpV2 table in CCMDB.accdb and Centralized_data.accdb contains data that is either intermittent or just not currently accommodated in the rest of the database. All data that is stored in this table can be found at Projects.
Entity–attribute–value model
See Entity–attribute–value model of the L Tmp V2 table
Linking
This table is linked to L_Log table by D_ID. See CCMDB Data Structure for more info.
Data Structure
To see the most up-to-date data structure of this table, see most up-to-date CCMDB data.mdb in Regional Server\data\Master. The fields are used differently depending on project, see Projects for a list and the individual project pages for field usage.
| Field Name | position | type | description |
|---|---|---|---|
| Tmp_ID | 1 | AutoNumber (Long integer) | unique identifier of tmp entry |
| Pat_ID/D_ID | 2 | ||
| Project | 3 | text () | name of the Project, corresponds to s_tmp.Study |
| Item | 4 | text () | value in project, or dropdown, corresponds to s_tmp.value |
| 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, see Separation of date and time fields |
| 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, specified in s_tmp.time_var_label, see Separation of date and time fields |
| 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, specified in s_tmp.float_var_label |
| bool_var | 10 | Yes/No | boolean variable, if collected, specified in s_tmp.bool_var_label |
| 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