associate id stored associatelocations instead of associate user_id