auto complete appraisal + assignment