thinking of having a job that pulls the info daily from the prior date and get the local DB updated.