Function long LOS(): Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
Line 12: Line 12:
== Needs review after [[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]] ==
== Needs review after [[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]] ==
{{Discuss | who = Julie |
{{Discuss | who = Julie |
[[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]] changed [[Service/Location]] to aggregate values for the whole stay in a program. The values used in [[s_dispo table]] for the longest likely LOS were filled with previous entries from the same program, but should likely be longer now, since an aggregate stay would on average be longer. Once we have some data with the new aggregate model we should update these values. }}
[[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]] changed [[Service/Location]] to aggregate values for the whole stay in a program. The values used in [[s_dispo table]] for the longest likely LOS were filled with previous entries from the same program, but should likely be longer now, since an aggregate stay would on average be longer. Once we have some data with the new aggregate model we should update these values.
** I will re-run using the first service dttm and dispo dttm. --[[User:JMojica|JMojica]] 15:38, 2022 January 19 (CST) }}


== Earlier notes ==
== Earlier notes ==

Revision as of 16:38, 2022 January 19

Data Integrity Checks
Summary: LOS/Length of Stay should not be unlikely long based on historical LOS for a given ward (Service/Location field).
Related: LOS, Arrive DtTm field, Dispo DtTm field
Firmness: soft check
Timing: complete
App: CCMDB.accdb
Coding: Function long_LOS()
Uses L Problem table: not relevant for this app
Status: needs review
Implementation Date: 2014-01-01
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

Needs review after Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry

Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry changed Service/Location to aggregate values for the whole stay in a program. The values used in s_dispo table for the longest likely LOS were filled with previous entries from the same program, but should likely be longer now, since an aggregate stay would on average be longer. Once we have some data with the new aggregate model we should update these values.

    • I will re-run using the first service dttm and dispo dttm. --JMojica 15:38, 2022 January 19 (CST)
  • SMW


  • Cargo


  • Categories

Earlier notes

This was probably implemented much earlier, but can't find reference before this.

The statistician provided mean LOS + 3 standard variations. This is stored in s_dispo table field meanLOS3STD.

The function compares the difference between Dispo DtTm field and Arrive DtTm field to this meanLOS3STD and gives a warning (an error that can be OK'd past) if the current patient has been there longer.

Log

  • 2019-03-20 - updated s_dispo table.meanLOS3STD with new values from Julie

Related articles

Related articles: