Function LOS(): Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "Function LOS() takes a Pat_ID as parameter and calculates the LOS as follows: {{Todo | who = Tina | todo_added = 2021-09-08 | todo_action = 2021-09-08 | question = _dev_CCMDB * need to update to new AdmDate }} == Related articles == {{Related Articles}}" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (9 intermediate revisions by the same user not shown) | |||
| 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: | ||
::LOS = Round(dis_dttm - ad_dttm, 3) | |||
See also [[Function LOS int()]]. | |||
== Log == | |||
* 2022-05-11 - added [[Function LOS int()|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 == | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category:Length of stay]] | |||
Latest revision as of 08:44, 2022 May 11
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().
Log
- 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