renaming columns in other tables and special handling for subitems, now known as parent items