Function long LOS()

From CCMDB Wiki
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, Admit DtTm, 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:

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 LOS as per Function LOS() to this meanLOS3STD and gives a warning (an error that can be OK'd past) if the current patient has been there longer.


  • 2022-04-21 - updated s_dispo table.meanLOS3STD with data from Julie
  • 2019-03-20 - updated s_dispo table.meanLOS3STD with new values from Julie

Related articles

Related articles: