CCMDB Wiki

L TmpV2 table: Difference between revisions

← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
mNo edit summary
 
(43 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The '''L_TmpV2''' table (also know as TMP file), contains data on the PDA and in the [[CCMDB.mdb]] that is either intermittent or just not currently accomodated in the rest of the database. When the data collector sends, the data gets dumped to [[Regional Server]]\Output\[[TmpV2_1.mdb]].
{{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]].
Usually the data in L_TmpV2 will be data generated by [[:Category:Special Short Term Projects | Special Short Term Projects]] but some other data such as [[Moves for Medicine]] is stored here as well.  


The table has fields to accomodate dates, integers, reals/floating point variables, text or booleans. It can accomodate 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 accomodate 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]]


For details about the dropdown options for various projects, and their actual project identifier, see the corresponding project's article. For a list of any projects that have been stored in L_TmpV2, see  [[:Category:L TmpV2 Data | Category:L TmpV2 Data]].
=== Linking ===
This table is linked to [[L_Log table]] by [[D_ID]]. See [[CCMDB Data Structure]] for more info.


==Data Structure==
===Data Structure===
{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
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.
|- style="font-size:11pt"  valign="bottom"
| width="89" height="16" | Field Name
| width="74" | Data Type
| width="230" | Usage


|- style="font-size:11pt"  valign="bottom"
{| class="wikitable sortable"
| height="16" | Serial
|-
| Number
! Field Name !! position !! type !! description
| unique identifier of patient
|-
 
| Tmp_ID ||1 || AutoNumber (Long integer)|| unique identifier of tmp entry
|- style="font-size:11pt"  valign="bottom"
|-
| height="16" | Site
| Pat_ID/[[D_ID]] ||2 || ||  
| dropdown-limited text
|-
| Hospital where the patient was admitted
| Project ||3 || text () || name of the [[Projects|Project]], corresponds to [[s_tmp]].Study
 
|-  
|- style="font-size:11pt"  valign="bottom"
| Item ||4 || text () || value in project, or [[Dropdown-like user experience for tmp projects |dropdown]], corresponds to [[s_tmp]].value
| height="16" | Location
|-  
| dropdown-limited text
| obsdate ||5 || Date/Time || automatically entered date of collection, see [[Separation of date and time fields]]
| Ward the patient was admitted to
|-  
 
| obstime ||6 || Date/Time || automatically entered time of collection, see [[Separation of date and time fields]]
|- style="font-size:11pt"  valign="bottom"
|-  
| height="16" | collected
| date_var ||7 || Date/Time || date, if collected, specified in [[s_tmp]].date_var_label, see [[Separation of date and time fields]]
| Date/Time
|-  
| date the variable was collected
| time_var ||8 || Date/Time || time, if collected, specified in [[s_tmp]].time_var_label, see [[Separation of date and time fields]]
 
|-
|- style="font-size:11pt"  valign="bottom"
| int_var ||9 || number (long integer) || integer variable, if collected, specified in [[s_tmp]].int_var_label
| height="16" | Project
|-  
| dropdown-limited text
| float_var ||9 || number (double) || float/real variable, if collected, specified in [[s_tmp]].float_var_label
| &nbsp;
|-  
 
| bool_var ||10 || Yes/No || boolean variable, if collected, specified in [[s_tmp]].bool_var_label
|- style="font-size:11pt"  valign="bottom"
|-
| height="16" | Item
| comment_var ||11 || Text || comment variable, if collected, not specified in [[s_tmp]] since generally permitted as free text comment
| 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"
== why separate? ==
| height="16" | comment_var
See [[separation of date and time fields]]
| 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
 
|}


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


{{stub}}
<noinclude>
[[Category: Data structure]]
[[Category:Project | *]]
[[Category: L_TmpV2 Data]]
[[Category:Data structure]]
[[Category: TmpV2]]
[[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"