Current Daily Clean Custom SQL Update

We discovered that the Room ADT ID was missing from records where the Job Type Code was “Daily Clean” in the BTJob data source. This happened because daily cleans are generated at the room level, while the Room ADT ID is configured at the location level in Capacity IQ®. Since a room can have multiple locations, each with a different Room ADT ID, there is no direct way to associate a single Room ADT ID with a daily clean job.

The Room ADT ID for daily clean records will now be pulled from the latest modified location in each room. This ensures that the Room ADT ID is available in the BTJob data source for records with a Job Type Code of “Daily Clean.”