L TmpV2 table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| Line 6: | Line 6: | ||
{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext> | {| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext> | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| width=" | | width="89" height="16" | Field Name | ||
| width="74" | Data Type | | width="74" | Data Type | ||
| width=" | | width="230" | Usage | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | Serial | ||
| Number | | Number | ||
| unique identifier of patient | | unique identifier of patient | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | Site | ||
| dropdown-limited text | | dropdown-limited text | ||
| Hospital where the patient was admitted | | Hospital where the patient was admitted | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | Location | ||
| dropdown-limited text | | dropdown-limited text | ||
| Ward the patient was admitted to | | Ward the patient was admitted to | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | collected | ||
| Date/Time | | Date/Time | ||
| date the variable was collected | | date the variable was collected | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | Project | ||
| dropdown-limited text | | dropdown-limited text | ||
| | | | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | Item | ||
| Text | | Text | ||
| Project-Item identifier | | Project-Item identifier | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | DtTm_var | ||
| Date/Time | | Date/Time | ||
| date/time variable collected, if needed | | date/time variable collected, if needed | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | int_var | ||
| number | | number | ||
| integer variable, if collected | | integer variable, if collected | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | float_var | ||
| number | | number | ||
| float/real variable, if collected | | float/real variable, if collected | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | bool_var | ||
| Yes/No | | Yes/No | ||
| boolean variable, if collected | | boolean variable, if collected | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | comment_var | ||
| Text | | Text | ||
| comment variable, if collected | | comment variable, if collected | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | Instruction | ||
| dropdown-limited text | | dropdown-limited text | ||
| Instruction as given in the dropdown [[ | | Instruction as given in the dropdown [[S_Tmp]] | ||
|- style="font-size:11pt" valign="bottom" | |- style="font-size:11pt" valign="bottom" | ||
| height="16" | | height="16" | data_sent | ||
| Date/Time | | Date/Time | ||
| Date/Time the patient was sent | | Date/Time the patient was sent | ||
|} | |} | ||
== to do before de-stubbing == | == to do before de-stubbing == | ||
Revision as of 08:33, 22 August 2008
The L_TmpV2 table contains the data for Temporary Studies we collect on the PDA and in the CCMDB.mdb.
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.
Data Structure
| Field Name | Data Type | Usage |
| Serial | Number | unique identifier of patient |
| Site | dropdown-limited text | Hospital where the patient was admitted |
| Location | dropdown-limited text | Ward the patient was admitted to |
| collected | Date/Time | date the variable was collected |
| Project | dropdown-limited text | |
| Item | Text | Project-Item identifier |
| DtTm_var | Date/Time | date/time variable collected, if needed |
| int_var | number | integer variable, if collected |
| float_var | number | float/real variable, if collected |
| bool_var | Yes/No | boolean variable, if collected |
| comment_var | Text | comment variable, if collected |
| Instruction | dropdown-limited text | Instruction as given in the dropdown S_Tmp |
| data_sent | Date/Time | Date/Time the patient was sent |
to do before de-stubbing
- explain data structure