flush every 1000 records
fix test to match change in cdep_id value