Created BoardingLoc plus historical query

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