CCMDB Wiki

L TmpV2 table: Difference between revisions

← Older edit
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,607 edits
m clean-
 
(24 intermediate revisions by the same user not shown)
Line 1: Line 1:
L_TmpV2 table in [[CCMDB.mdb]] and [[Centralized_data.mdb]] contains data that is either intermittent or just not currently accommodated in the rest of the database. Collection projects that generate data for this table are categorized in [[:Category:All Projects]] / [[:Category:L TmpV2 Data | Category:L TmpV2 Data]].
{{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]].


The table has fields to accommodate dates, integers, reals/floating point variables, text or booleans. It can accommodate one of each of these per line, such that if two variables of the same data type are needed, two lines need to be entered. The table was set up this way to accommodate any possible combination of data, but this flexibility comes at the expense of some inefficiencies in data-entry.
=== Entity–attribute–value model ===
See [[Entity–attribute–value model of the L Tmp V2 table]]


==Data Structure==
=== Linking ===
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 [[CCMDB.mdb]].
This table is linked to [[L_Log table]] by [[D_ID]]. See [[CCMDB Data Structure]] for more info.


{| class="wikitable" border=1
===Data Structure===
|- style="font-size:11pt"  valign="bottom"
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.
| width="89" height="16" | Field Name
| width="74" | Data Type
| width="230" | Usage
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | Serial
| Number
| unique identifier of patient
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | Site
| dropdown-limited text
| Hospital where the patient was admitted
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | Location
| dropdown-limited text
| Ward the patient was admitted to
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | collected
| Date/Time
| date the variable was collected
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | Project
| dropdown-limited text
|  
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | Item
| Text
| Project-Item identifier
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | DtTm_var
| Date/Time
| date/time variable collected, if needed
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | int_var
| number
| integer variable, if collected
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | float_var
| number
| float/real variable, if collected
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | bool_var
| Yes/No
| boolean variable, if collected
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | comment_var
| Text
| comment variable, if collected
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | Instruction
| dropdown-limited text
| Instruction as given in the dropdown [[S_Tmp]]
 
|- style="font-size:11pt"  valign="bottom"
| height="16" | data_sent
| Date/Time
| Date/Time the patient was sent


{| class="wikitable sortable"
|-
! 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]]
|-
| 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]]


== Related articles ==
{{Related Articles}}


[[Category: Data structure]]
<noinclude>
[[Category: L_TmpV2 Data]]
[[Category:Project | *]]
[[Category: TmpV2]]
[[Category:Data structure]]
[[Category: All Projects]]
[[Category:L_TmpV2 Data | *]]
[[Category:Tmp Project Infrastructure | *]]
[[Category:L TmpV2 table | *]]
[[Category:L Table]]
</noinclude>
Retrieved from "https://ccmdb.kuality.ca/index.php?title=L_TmpV2_table"