Function LOS(): Difference between revisions

(10 intermediate revisions by the same user not shown)

Line 1:

Function LOS() takes a Pat_ID as parameter and calculates the LOS as follows:

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

~~{{Todo~~

::LOS = Round(dis_dttm - ad_dttm, 3)

~~| who~~ = ~~Tina~~

See also [[Function LOS int()]].

| ~~todo_added = 2021~~-09-08

~~| todo_action = 2021~~-09-08

== Log ==

~~| question = _dev_CCMDB~~

* 2022-05-11 - added [[Function LOS int()|Function LOS int()]] to work where an integer result, ie the number of days, is required.

* ~~need~~ to ~~update to new AdmDate }}~~

* 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 ==

[[Category:Length of stay]]

[[Category:CCMDB.accdb]]

@@ Line 1: / Line 1: @@
-Function LOS() takes a Pat_ID as parameter and calculates the LOS as follows:
+Function LOS() takes a Pat_ID as parameter and calculates the three-decimal-point [[LOS]] as follows:
-{{Todo
+::LOS = Round(dis_dttm - ad_dttm, 3)
- | who = Tina
+See also [[Function LOS int()]].
- | todo_added = 2021-09-08
- | todo_action = 2021-09-08
+== Log ==
- | question =  _dev_CCMDB
+* 2022-05-11 - added [[Function LOS int()|Function LOS int()]] to work where an integer result, ie the number of days, is required.
-* need to update to new AdmDate }}
+* 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}}
+[[Category:Length of stay]]
+[[Category:CCMDB.accdb]]