sub check_branch_code { sub check_borrower_category { Both do a search of the db based on the values in the import file for each borrower - it seems we could lookup the allowed values once and cache them? We also fetch the category another time to get the expiratoin date, it feels like we could store these early on.