more work on consolidated update procedure