Tmp Project Collection: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
mNo edit summary
 
(14 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The Critical Care and Medicine Database has a flexible method of quickly adding additional values required for temporary projects.  
This page contains generic instructions for data collectors for data collected under the [[Entity–attribute–value model of the L_Tmp_V2 table]], usually for [[temporary data collection]]. See [[Projects]] for a list. Also see [[Setting up a new tmp project]].


For a list of projects we have collected and their collection instructions, see [[:Category:Project]].  
== Collection instructions ==
For a list of projects we have collected and their collection instructions, see [[Projects]].  


== Storage as attribute-value groups ==
To enter temporary study data for a patient:
Adding an actual new field to our database is not trivial, so in to get maximum flexibility our temporary project data is stored in attribute-value groups rather than in new fields for each project. The [[L TmpV2 table]] stores the data.
# open the patient to add a move in the [[Patient Viewer]]
* [[L TmpV2 table|L TmpV2]].project stores the project (or attribute name); there is no tight convention; but a lot of projects only need one entry but some need more, and for those two similarly named project entries will be used.
# go to the [[Patient Viewer Tab Tmp]]
* [[L TmpV2 table|L TmpV2]].item contains the value for that project
# for some projects, lines may have been added via [[Automatic Generation of TMP entries]]; if so, update them as instructed in the [[Projects|Project's]] page
* there are also a boolean, integer, real and notes field in each record of [[L TmpV2 table|L TmpV2]] that can be used to store additional data
# choose the '''[[:Category:Project | Project]]'''  as directed in the [[Projects|Project's]] page for the first dropdown
The '''project''' and '''item''' fields are limited to entries in [[S tmp table]], which are supplied in a drop-down.
# choose the '''item''' for the second dropdown
# if you want to see field names and the link to the relevant wiki page, open the [[TmpV2 editor]]:
#* click on the "pencil" to the left of the new entry to save it
#* click the "edit" button to '''open the entry with the labels appropriate for its study'''; this also contains a link to the wiki page for the project.
# enter the remaining required fields as instructed in the article for [[Projects|Project]] the study you are working on]


[[Category:TmpV2 | *]]
== Related articles ==
{{Related Articles}}
 
[[Category:Tmp Project Infrastructure]]

Latest revision as of 16:39, 23 October 2025

This page contains generic instructions for data collectors for data collected under the Entity–attribute–value model of the L_Tmp_V2 table, usually for temporary data collection. See Projects for a list. Also see Setting up a new tmp project.

Collection instructions

For a list of projects we have collected and their collection instructions, see Projects.

To enter temporary study data for a patient:

  1. open the patient to add a move in the Patient Viewer
  2. go to the Patient Viewer Tab Tmp
  3. for some projects, lines may have been added via Automatic Generation of TMP entries; if so, update them as instructed in the Project's page
  4. choose the Project as directed in the Project's page for the first dropdown
  5. choose the item for the second dropdown
  6. if you want to see field names and the link to the relevant wiki page, open the TmpV2 editor:
    • click on the "pencil" to the left of the new entry to save it
    • click the "edit" button to open the entry with the labels appropriate for its study; this also contains a link to the wiki page for the project.
  7. enter the remaining required fields as instructed in the article for Project the study you are working on]

Related articles

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