Function LOS()

From CCMDB Wiki

Function LOS() takes a Pat_ID as parameter and calculates the three-decimal-point LOS as follows:

LOS = Round(dis_dttm - ad_dttm, 3)

See also Function LOS int().


  • 2022-05-11 - added Function LOS int() to work where an integer result, ie the number of days, is required.
  • 2022-04-28 - updated how this is calculated to be consistent with how it's done in created variables common: Round(dis_dttm - ad_dttm, 3) was WorksheetFunction.Ceiling((dis_dttm) - (ad_dttm), 1); updated both CCMDB and CFE.
  • 2022-02-10 - Updated function to use Created_AdmitDtTm query/Admit DtTm as input instead of Arrive DtTm

Related articles

Related articles: