Project Consults data: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) →Data Collection: option for "no consult" added in CCMDB.accdb Change Log 2025#2025-03-07-2 |
||
Line 18: | Line 18: | ||
* '''Project: Consults''' - Item: "PCH Panel" | * '''Project: Consults''' - Item: "PCH Panel" | ||
* '''Project: Consults''' - Item: "no consult" (cross-check item if there were no consults) | * '''Project: Consults''' - Item: "no consult" (cross-check item if there were no consults) | ||
* Date/Time: dttm of the consult, or [[Service tmp entry]] DtTm if patient arrived with consult in progress | * Date/Time: dttm of the consult, or [[Service tmp entry]] DtTm if patient arrived with consult in progress |
Revision as of 21:50, 7 March 2025
Projects | |
Active?: | planned |
Program: | |
Requestor: | Dr. Dan Roberts |
Collection start: | Whenever LAU Collection Project starts "Whenever LAU Collection Project starts" contains an extrinsic dash or other characters that are invalid for a date interpretation. |
Collection end: | Whenever [LAU Collection Project]] is done "Whenever [LAU Collection Project]] is done" contains an extrinsic dash or other characters that are invalid for a date interpretation. |
This dataset contains data in support of the LAU Collection Project.
Home care and PCH admissions suspected to be factors in long LOS on LAUs. We need to find out the time between consult and Dispo_DtTm find out if that is so.
Data Collection
- For any record collected as part of LAU Collection Project, enter the date and time of the first Homecare consult and the first Panelling request for each admission to an LAU
Data Entry Instructions
For every LAU Collection Project, a line with Project = "Consults" and item = "not entered" will automatically be entered. Update that line to one of the following:
- Project: Consults - Item: "Homecare"
- Project: Consults - Item: "PCH Panel"
- Project: Consults - Item: "no consult" (cross-check item if there were no consults)
- Date/Time: dttm of the consult, or Service tmp entry DtTm if patient arrived with consult in progress
- Checkbox, Integer, Real, Comment: not used
![]() |
|
Sources
- Orders
- consult section
- progress notes
- EPR ER notes/documents
Data Use
This data is being collected as a current state for LAU Collection Project.
Data Integrity Checks (automatic list)
App | Status | |
---|---|---|
query check_Project_Consults_data | CCMDB.accdb | implemented |
Query check_Project_OT_PT_Consults | CCMDB.accdb | implemented |
Related articles
Related articles: |