L_TmpV2 table

From CCMDB Wiki
Revision as of 09:41, 2023 May 18 by Ttenbergen (talk | contribs) (Text replacement - "S_Tmp" to "s_tmp table")
Jump to navigation Jump to search

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
Serial 1 Number unique identifier of patient
Site 2 dropdown-limited text Hospital where the patient was admitted
Location 3 dropdown-limited 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
DtTm_var 7 Date/Time date/time variable collected, if needed
int_var 8 number integer variable, if collected
float_var 9 number float/real variable, if collected
bool_var 10 Yes/No boolean variable, if collected
comment_var 11 Text comment variable, if collected
Instruction 12 dropdown-limited text Instruction as given in the dropdown s_tmp table
data_sent 13 Date/Time Date/Time the patient was sent

Related articles

Related articles: