Created BoardingLoc plus historical query: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| Line 21: | Line 21: | ||
{{Related Articles}} | {{Related Articles}} | ||
[[Category: Data structure]] | [[Category:Data structure]] | ||
Latest revision as of 10:33, 30 July 2025
The created_BoardingLoc_plus_historical query in CFE contains the Boarding Locs and their equivalent Service/Location entries including their level of care.
The level of care is generated as follows:
level_of_care_imp: IIf([patientfollow], IIf([is_ED], IIf([program]="Med",50,90), [level_of_care]), Nz([s_dispo].[acuity_level],IIf([program]="Med",50,90)))
where is_ED is generated as
is_ED: [s_level_of_care_BL].[boarding_loc_item] Like "*Emergency*" Or [s_level_of_care_BL].[boarding_loc_item] Like "*ED1*" Or [s_level_of_care_BL].[boarding_loc_item] Like "*_ER" Or [s_level_of_care_BL].[boarding_loc_item] Like "* - ER"
Log
2022-09-06 - created query
Related articles
| Related articles: |