L TmpV2 table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
 
(14 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.mdb]] 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]]
It is linked to [[L_Log table]] by [[D_ID]].
 
==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 [[CCMDB.mdb]].


=== 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.


{| class="wikitable sortable"
{| class="wikitable sortable"
|-
|-
! Field Name !! position !! type !! description
! Field Name !! position !! type !! description
|-
|-
| Serial ||1 || Number || unique identifier of patient
| Tmp_ID ||1 || AutoNumber (Long integer)|| unique identifier of tmp entry
|-
|-
| Site ||2 || dropdown-limited text || Hospital where the patient was admitted
| Pat_ID/[[D_ID]] ||2 || ||  
|-
|-
| Location ||3 || dropdown-limited text || Ward the patient was admitted to
| Project ||3 || text () || Ward the patient was admitted to
|-
| collected ||4 || Date/Time || date the variable was collected
|-
| Project ||5 || dropdown-limited text ||  
|-  
|-  
| Item ||6 || Text || Project-Item identifier
| Item ||4 || text () || date the variable was collected
|-  
|-  
| DtTm_var ||7 || Date/Time || date/time variable collected, if needed
| obsdate ||5 || Date/Time || automatically entered date of collection
|-  
|-  
| int_var ||8 || number || integer variable, if collected
| obstime ||6 || Date/Time || automatically entered time of collection
|-  
|-  
| float_var ||9 || number || float/real variable, if collected
| date_var ||7 || Date/Time || date, if collected
|-  
|-  
| bool_var ||10 || Yes/No || boolean variable, if collected
| time_var ||8 || Date/Time || time, if collected
|-
| int_var ||9 || number (long integer) || integer variable, if collected
|-  
|-  
| comment_var ||11 || Text || comment variable, if collected
| float_var ||9 || number (double) || float/real variable, if collected
|-  
|-  
| Instruction ||12 || dropdown-limited text || Instruction as given in the dropdown [[S_Tmp]]
| bool_var ||10 || Yes/No || boolean variable, if collected
|-
|-
| data_sent ||13 || Date/Time || Date/Time the patient was sent
| comment_var ||11 || Text || comment variable, if collected
|}
|}


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


 
<noinclude>
[[Category: Data structure]]
[[Category:Project | *]]
[[Category: L_TmpV2 Data]]
[[Category:Data structure]]
[[Category: TmpV2]]
[[Category:L_TmpV2 Data | *]]
[[Category: All Projects]]
[[Category:TmpV2 | *]]
[[Category: L TmpV2 table]]
[[Category:L TmpV2 table | *]]
[[Category:L Table]]
</noinclude>

Latest revision as of 12:48, 2023 June 27

L_TmpV2 table in CCMDB.accdb and Centralized_data.mdb 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 () Ward the patient was admitted to
Item 4 text () date the variable was collected
obsdate 5 Date/Time automatically entered date of collection
obstime 6 Date/Time automatically entered time of collection
date_var 7 Date/Time date, if collected
time_var 8 Date/Time time, if collected
int_var 9 number (long integer) integer variable, if collected
float_var 9 number (double) float/real variable, if collected
bool_var 10 Yes/No boolean variable, if collected
comment_var 11 Text comment variable, if collected

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=L_TmpV2_table&oldid=159731"