LAU LTC consult: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "{{Project |ProjectActive=planned |ProjectRequestor=Dr. Dan Roberts |ProjectCollectionStartDate={{LAU Collection StartDt}} |ProjectCollectionStopDate={{LAU Collection EndDt}} |Project={{PAGENAME}} }} This dataset contains data in support of the LAU Collection Project. Whether patient had or needed to get a public trustee during the stay. Possible cause of discharge delays. == Data Collection == {{DL| * For any record collected as part of LAU Collection Project..."
 
No edit summary
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Project
{{Project
|ProjectActive=planned
|ProjectActive=legacy
|ProjectProgram=LAU (temporary)
|ProjectRequestor=Dr. Dan Roberts
|ProjectRequestor=Dr. Dan Roberts
|ProjectCollectionStartDate={{LAU Collection StartDt}}
|ProjectCollectionStartDate={{LAU Collection StartDt}}
Line 8: Line 9:
This dataset contains data in support of the [[LAU Collection Project]].  
This dataset contains data in support of the [[LAU Collection Project]].  


Whether patient had or needed to get a public trustee during the stay. Possible cause of discharge delays.  
Whether a patient needed a consult for Long Term Care (LTC) during their stay. Possible cause of discharge delays.  


== Data Collection ==
== Data Collection ==
{{DL|
* For any record collected as part of [[LAU LTC consult]] enter:
* For any record collected as part of [[LAU Collection Project]], enter...
* The first dttm of consult to LTC
}}


=== Data Entry Instructions ===   
=== Data Description ===   
{{DL |
For every [[LAU LTC consult]] one line with Project = "LTC consult" and item = "not entered" was automatically be entered. That line should have been updated to one of the following:  
For every [[LAU Collection Project]] who '''XXX''' enter the following:  
* '''Project: ??''' - Item: "??"


* Date/Time:  
* '''Project: LTC Consult'''
** ??
** Item: "LTC first"
** Item: "no consult"


}}
Data Quality Issues:
* No cross-checks were implemented so 5 "not entered" records ended up in the data.
* all 600 records should have had an entry, but only 581 do
* will report absent and "not entered" as "unclear"


==== Sources ====
==== Sources ====
{{DL |
* Orders
* Orders
* consult section
* consult section
* progress notes
* progress notes
* EPR ER notes/documents
}}


== Data Use ==
== Data Use ==
This data is being collected as a current state for [[LAU Collection Project]].
This data is being collected as a current state for [[LAU Collection Project]].
This item is related to the "PCH Panel" item entry in [[Project Consults data]] and should be interpreted in conjunction with it.
=== LTC Medical Application vs Consult ===
* "LTC first" was entered for either
** throughout the collection: LTC Medical Application was entered (but sometimes those are not actually sent...)
** for the later part of the project:
*** for those that had an actual LTC consult where one of the following was true:
***** the dttm were either earlier than the LTC Medical Application
***** no medical application but had a LTC consult
**** I noted details in the Q column and the notes.
== Data Analysis Consideration ==
* for this field the default entry for yes is the LTC Medical application, however I later realized that this is not a consult per se, as some have this completed without an actual consult to LTC (the learning process for this project was confusing, I should have spoken to someone from LTC before starting this) I continued to enter it this way, but also answered "yes" for those that had an actual LTC consult where the dttm were either earlier than the medical application or they did not have a medical application but had a LTC consult, I noted details in the Q column and the notes.  I know this is an analysis nightmare but I think I can clean this up if before Julie does her analysis I go through these records [[User:Lkaita|Lisa Kaita]] 07:44, 11 April 2025 (CDT) 


{{Data Integrity Check List|}} <!-- this will populate automatically from the cross-checks -->
{{Data Integrity Check List|}} <!-- this will populate automatically from the cross-checks -->

Latest revision as of 13:24, 7 January 2026

Projects
Active?: legacy
Program: LAU (temporary)"LAU (temporary)" is not in the list (CC, Med, CC and Med) of allowed values for the "ProjectProgram" property.
Requestor: Dr. Dan Roberts
Collection start: 2025-03-15
Collection end: 2025-04-13
  • SMW

(inline)

  • Cargo


  • Categories
  • Form


This dataset contains data in support of the LAU Collection Project.

Whether a patient needed a consult for Long Term Care (LTC) during their stay. Possible cause of discharge delays.

Data Collection

  • For any record collected as part of LAU LTC consult enter:
  • The first dttm of consult to LTC

Data Description

For every LAU LTC consult one line with Project = "LTC consult" and item = "not entered" was automatically be entered. That line should have been updated to one of the following:

  • Project: LTC Consult
    • Item: "LTC first"
    • Item: "no consult"

Data Quality Issues:

  • No cross-checks were implemented so 5 "not entered" records ended up in the data.
  • all 600 records should have had an entry, but only 581 do
  • will report absent and "not entered" as "unclear"

Sources

  • Orders
  • consult section
  • progress notes

Data Use

This data is being collected as a current state for LAU Collection Project.

This item is related to the "PCH Panel" item entry in Project Consults data and should be interpreted in conjunction with it.

LTC Medical Application vs Consult

  • "LTC first" was entered for either
    • throughout the collection: LTC Medical Application was entered (but sometimes those are not actually sent...)
    • for the later part of the project:
      • for those that had an actual LTC consult where one of the following was true:
          • the dttm were either earlier than the LTC Medical Application
          • no medical application but had a LTC consult
        • I noted details in the Q column and the notes.

Data Analysis Consideration

  • for this field the default entry for yes is the LTC Medical application, however I later realized that this is not a consult per se, as some have this completed without an actual consult to LTC (the learning process for this project was confusing, I should have spoken to someone from LTC before starting this) I continued to enter it this way, but also answered "yes" for those that had an actual LTC consult where the dttm were either earlier than the medical application or they did not have a medical application but had a LTC consult, I noted details in the Q column and the notes. I know this is an analysis nightmare but I think I can clean this up if before Julie does her analysis I go through these records Lisa Kaita 07:44, 11 April 2025 (CDT)

Data Integrity Checks (automatic list)

none found

Related articles: