Setting up a new tmp project
This are instructions for setting up a Temporary data collection project. See Projects for a list of previous ones.
Project Initiation
For external data requests, ask the requestor to fill out File:Request for additional collection.pdf. Additional start-up instructions and a bit of a checklist of what to consider are at Temporary data collection#Information relevant to data users.
When there is serious consideration of a project, follow the instructions in Creating a new project article to establish a central place to document the project even during the consultation and design phase.
Consider any Data Integrity Checks that might help, our Checklist when changing or adding a variable or tmp project can help.
If an entry will be required for all records (or all at a site or program), consider Automatic Generation of TMP entries.
|
Need to break that out as a broader concept to contain "add an "not entered yet" item etc. |
If an entry will need to be added programmatically from VBA eg based on other data and a collector input, use Function GenerUpdate_tmp_entry.
|
|
Need to integrate the rest of this after adding page Temporary data collection |
Here are the pages that document how to run a project:
- if you don't already understand how our project data works, see Entity–attribute–value model of the L Tmp V2 table to understand what your options are in our framework
- Creating a new project article - almost always a good first step, a place to take notes about the details for the project
- Consider if there is data that would benefit from Data Integrity Checks; if so, they are set up by building a query that will have lines if the test fails and adding that query to Function TmpChecker, which is run as part of Pre-send Checker
- Add the line(s) for the project to s_tmp table
- To make them only show up for one Program, eg a CC project, add that program's key to the program column
- To make the project only show up for some sites, enter an (almost) identical line for each site and enter the hospital in the hosp column
- if the combination doesn't exist in s_tmp table then query s_tmp_project_item_consistent will flag the query during Pre-send Checker
"dropdown" functionality
To make "dropdown" functionality available, add a line to s_tmp table. The "project" will be the same for each dropdown, and the item will be different. See the s_tmp table for examples, and try the dropdown there.
| implementation details |
|
This is driven by some code that updates the dropdown source for the item combobox when the project combobox triggers a change event. This happens both in Patient Viewer Tab Tmp and in TmpV2 editor form. |
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.
Checklist when changing or adding a variable or tmp project
We have had some pitfalls over time in getting started with these, see Checklist when changing or adding a variable or tmp project to help avoid repeating them.