Function LOS(): Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Log) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 3: | Line 3: | ||
== Log == | == Log == | ||
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); updated both CCMDB and CFE. | * 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 | * 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}} | ||
Revision as of 11:03, 2022 April 28
Function LOS() takes a Pat_ID as parameter and calculates the LOS as follows:
- Round(dis_dttm - ad_dttm, 3)
Log
- 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