Created BoardingLoc plus historical query

The query created_BoardingLoc_plus_historical 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)))

Log

2022-09-06 - created query