now upsert recored so we can re-process any range w/o duplication
also build and persit audit trail log