XSD for SBA_MicroloanServicing 1.0, Microloan Update To view the full content, you must right click the page and select "View Page Source". This is a format for Electronic Transfer of loan information, the original meaning of "ETran". In that sense, it should not be too confusing that the SBA loan guaranty and direct loan programs are also colloquially called "ETran". In SBA_MicroloanServicing format, there are 4 levels of tags: the root tag (<SBA_MicroloanServicing>), the transaction tag, table tags and column tags. "Transaction Tags": In the SBA loan guaranty and direct loan programs, Servicing of new loan appications have transaction tag <App>, and Servicing of existing loans have transaction tag <SBALoan>. In the SBA Microloan program, the transaction tag is <Microloan>. Everything inside the transaction tag either commits to the SBA database (success) or rolls back (failure), together, as a unit. "Table Tags": Within a transaction tag, table tags can occur in any order. Some tables allow only one occurrence, but for tables that allow multiple occurrences, giving more than one will result in multiple rows on the SBA database. There is no need to cluster together table tags of the same type. "Column Tags": Like table tags in transaction tags, within a given table tag, column tags can occur in any order. Many column tags are optional. They will how up in this XSD with the attribute minOccurs="0". The Root Element (<SBA_MicroloanServicing>) The SBA's "root tag" (<SBA_MicroloanServicing>) for Microloan initial data entry must contain at least one <Microloan> tag. It may contain more than one. If more than one <Microloan> tag is given, each <Microloan> tag will commit to the SBA's database, or roll back from it, independently of all other <Microloan> tags in the same submission. For this reason, <Microloan> is sometimes referred to as the "transaction tag" of Microloan. Your "root tag" should be <SBA_MicroloanServicing version="m.1"> for XML that conforms to this XSD. See SBA_MicroloanTypes.xsd for an explanation of Microloan version numbers and their coding implications. The Transaction Element (<Microloan>) Because this element doesn't contain any minOccurs or maxOccurs attributes, both are left at their XSD default, which is 1. There must be at least one Loan element. There may be no more than one Loan element. (Exactly one per Microloan transaction.) The "Table Tags" <Loan> Sequence number returned when Microloan was originated (prime key), used here to update status. Used in conjunction with LenderLoanNmb as an alternative to Sequence Number (LoanSeqNmb) Used in conjunction with LoanNmb as an alternative to Sequence Number (LoanSeqNmb) If not given, value not changed. If not given, value not changed. 1 = Current or up to 30 Days Delinquent, 3 = 31 to 60 Days Delinquent, 4 = 61 to 90 Days Delinquent, 5 = 91 to 120 Days Delinquent, 6 = Over 120 Days Delinquent/Defaulted, 7 = Paid In Full, 8 = Charged Off If not given, value not changed. Outcome value, only required for PIF and CO status. Outcome value, only required for PIF and CO status. Outcome value, only required for PIF and CO status. Annual Profit/Loss (positive or negative number).Outcome value, only required for PIF and CO status. If not given, value not changed. For now, only insert is allowed.