Automatic Generation of TMP entries

CCMDB.mdb has the following mechanisms to facilitate or automate the generation of entries in the L TmpV2 table to facilitate Tmp Project Collection under the Entity–attribute–value model of the L Tmp V2 table.

entries generated at record creation time

Adding a patient triggers Sub add_automatic_tmp_entries, which adds a tmp entry for each record in s_tmp table that matches the new admission based on

• s_tmp.hosp = s_dispo.Site
• s_tmp.program = s_dispo.Program
• active = true
• auto_add_at_patient_creation = true

To restrict ability to edit those from the data collector GUI in Patient Viewer Tab Tmp set the applicable parameter in s_tmp table to true:

• auto_cant_add_manually
• auto_cant_edit

using tmp entries to generate a dropdown-like user experience for temporary projects

This can be used in conjunction with Dropdown-like user experience for tmp projects to create a number of entries you want collectors to action. Let's say you want to add a project "colour" with options "red" and "green". To make it easy for collectors to enter this, you could automatically generate a s_tmp.value entry "not yet entered" with auto_add_at_patient_creation = true. After entering a new admission, the collector will see an entry "colour"-"not yet entered", where the "not yet entered" is a dropdown box with options "green" and "red".

Data Integrity Checks can be added to disallow sending with "not yet entered".

entries generated programmatically

Tmp entries can be generated or updated in VBA using Function GenerUpdate_tmp_entry.