Tmp Project Collection: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 5: Line 5:


For a quick link to the wiki pages of current TMP projects in CCMDB:
For a quick link to the wiki pages of current TMP projects in CCMDB:
* open the [[Patient viewer tab Tmp]] in [[CCMDB.accdb]]
* open the [[Patient Viewer Tab Tmp]] in [[CCMDB.accdb]]
* enter the line of the project you need
* enter the line of the project you need
* click the "edit" button
* click the "edit" button
Line 11: Line 11:


== Storage as attribute-value groups ==
== Storage as attribute-value groups ==
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.
For info about the data model of tmp project collection, see [[Entity–attribute–value model of the L Tmp V2 table]]
* [[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.
 
* [[L TmpV2 table|L TmpV2]].item contains the value for that project
== [[Automatic Generation of TMP entries]] ==
* 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
To make it easier for collectors to know what [[projects]] are currently collected, starting entries for projects that require an entry for ''every'' profile (possibly at a given site/program) are automatically created at profile creation through [[Automatic Generation of TMP entries]].
The '''project''' and '''item''' fields are limited to entries in [[S tmp table]], which are supplied in a drop-down.  


== Related articles ==  
== Related articles ==  

Latest revision as of 15:50, 2021 October 28

The Critical Care and Medicine Database has a flexible method of quickly adding additional values required for temporary Projects.

Collection instructions

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

For a quick link to the wiki pages of current TMP projects in CCMDB:

  • open the Patient Viewer Tab Tmp in CCMDB.accdb
  • enter the line of the project you need
  • click the "edit" button
  • this opens a window, with project-specific labels for the fields (e.g. how is the date used in this project) and a blue link to the corresponding wiki page for that project

Storage as attribute-value groups

For info about the data model of tmp project collection, see Entity–attribute–value model of the L Tmp V2 table

Automatic Generation of TMP entries

To make it easier for collectors to know what projects are currently collected, starting entries for projects that require an entry for every profile (possibly at a given site/program) are automatically created at profile creation through Automatic Generation of TMP entries.

Related articles

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