XML Version 3.8i Differences when Updating an Existing Application

Version 3.8i is a subset of 3.8 restricted to the following, which update in 3 different ways:

<LoanApplication> subelements that are given override existing values on the SBA’s database. All other values (not given among the <LoanApplication> subelements) are left as-is on the SBA’s database. (Note the similarity to the Servicing Web Service.)

<Interest>, <Injection> and <UseOfProceeds> use “delete and insert logic”. That is, all existing entries are deleted from the database and the contents of the XML elements are inserted without worrying about creating a duplicate or unique index violation. These 3 XML element types are processed independently. For example, existing injection data is predeleted only if <Injection> elements are given.

Participants (<Borrower>, <BorrowerRace>, <Guarantor>, <Principal> and <PrincipalRace>) also use “delete and insert logic”, but as a group. So if any one of these 5 tags is given, all underlying borrower, guarantor, principal and race data are predeleted from the SBA’s database, and all <Borrower>, <BorrowerRace>, <Guarantor>, <Principal> and <PrincipalRace> data associated with the application must be given again.