Design for dynamic Beat allocation RRS feed

  • Question

  • Hello, 

    I am seeking some design advise on creating structure for dynamic beat allocation. We have an application where workers go to survey different homes in a specific region. The requirement is that a worker assigned to work in a specific territory needs to be assigned a beat every month to complete survey of about 2000 houses in their area. The beat is broken down by daily assignment of roughly 200 houses within a specif geographic boundary. 

    My requirement is to dynamically assign beats for 200 houses daily to the worker working in that territory. Once the survey is completed the house will be marked as complete and will get assigned on the next cycle. 

    I need some help in designing a tables for beat allocation every month for every employee. Any suggestion will be of great help! 



    Regards, Deven ----------------------------------------- Please vote if you find any of my post helpful.

    • Edited by dbp2784 Saturday, April 4, 2020 7:11 PM
    Saturday, April 4, 2020 4:05 PM

All replies