XSD for SBA_MicroloanOrigination 1.1, Microloan Initial Data Entry 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_MicroloanOrigination format, there are 4 levels of tags: the root tag (<SBA_MicroloanOrigination>), the transaction tag, table tags and column tags. "Transaction Tags": In the SBA loan guaranty and direct loan programs, Origination 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_MicroloanOrigination>) The SBA's "root tag" (<SBA_MicroloanOrigination>) 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_MicroloanOrigination 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> 1=Material,2=Equipment,3 =Supply,4=Working Capital, 6=Furniture,7=Fixtures,8=Debt Refinance Is primary borrower new or old? New = Startup, Old = Existing Business. Deprecated. Now inferred based on Zip. Is primary borrower a child care organization? Y = Yes, N = No. Date should be in MM/DD/YYYY format. (01/31/1999) Element-specific guidance may be added here. Currently In Business ? Y = Yes, N = No. Element-specific guidance may be added here. Element-specific guidance may be added here. Does the primary borrower guarantee the microloan? Y = Yes, N = No. Element-specific guidance may be added here. Element-specific guidance may be added here. Element-specific guidance may be added here. Element-specific guidance may be added here. Element-specific guidance may be added here. Element-specific guidance may be added here. Element-specific guidance may be added here. Microlender's loan number for this loan. Number of months from first disbursement to maturity date. Element-specific guidance may be added here. 1 = Sole Proprietorship, 2 = Partnership, 3 = Corporation, 4 = Limited Liability Company(LLC), 5 = Joint Venture, 11 = Non-Profit Organization. If not given, LoanAmt is assumed. Element-specific guidance may be added here. If not given, 1 (current or up to 30 days delinquent) is assumed. 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 1 = 100% woman-owned, 2 = 51% to 100% woman-owned, 3 = 0% to 50% woman-owned. Employee Head Count (FTE). 2-letter state code used by US Postal Service. Element-specific guidance may be added here. Element-specific guidance may be added here. Element-specific guidance may be added here. Element-specific guidance may be added here. Does the parole or probation? Y = Yes, N = No. Does the Online lending ? Y = Yes, N = No. Primary Borrower Related. B = business, P = person. Element-specific guidance may be added here. HY = Hispanic or Latino, HN = Not Hispanic or Latino, UN = Unknown/Not Stated 2-letter state code used by US Postal Service. Element-specific guidance may be added here. Element-specific guidance may be added here. Element-specific guidance may be added here. Element-specific guidance may be added here. 0 = Black or African American, 2 = American Indian or Alaska Native, 4 = Asian, 6 = Unanswered, 7 = White, 9 = Native Hawaiian or Other Pacific Islander First digit is type, followed by Tax ID, no hyphens. (See SBA_SimpleTypes.xsd.) 1 = Non-Veteran, 4 = Service Disabled Veteran, 6 = Veteran, 5 = Unknown/Not Stated Deprecated. Now inferred based on Zip. Borrower Business Related (Give if BusinessPersonInd is B.) Date should be in MM/DD/YYYY format. (01/31/1999) Element-specific guidance may be added here. Borrower Person Related (Give if BusinessPersonInd is P.) Element-specific guidance may be added here. Element-specific guidance may be added here. Element-specific guidance may be added here. <UseOfProceeds> (purpose of the loan) 1 = Materials, 2 = Equipment, 3 = Supplies, 4 = Working Capital, 5 = Inventory Method MlManageTA (Microloan Manage Technical Assistance data) 1-Yes 0-No 1, 2, 3 Y-Yes, N-No Business Formation date should be in MM/DD/YYYY format. (01/31/1999). R-Rural, U-Urban 1 - Sole Proprietorship, 2 - Partnership, 3 - Corporation, 4 - Limited Liability Company(LLC), 5 - Joint Venture Business Trade Name Current Job no 1 = 100% woman-owned, 2 = 51% to 100% woman-owned, 3 = 0% to 50% woman-owned. Element-specific guidance may be added here. Element-specific guidance may be added here. Element-specific guidance may be added here. Participent state code Element-specific guidance may be added here. Y-Yes, N-No 2 digit country code M-Male, F-Female Y-Yes, N-No 1 = Non-Veteran, 4 = Service Disabled Veteran, 6 = Veteran, 5 = Unknown/Not Stated Date should be in MM/DD/YYYY format. (01/31/1999) Y-Yes, N-No 0 = Black or African American, 2 = American Indian or Alaska Native, 4 = Asian, 6 = Unanswered, 7 = White, 9 = Native Hawaiian or Other Pacific Islander four digit year (2013) 1-First Quater, 2- Secound Quater, 3-Third Quater, 4-Fourth Quater 10-One-on-One Counseling, 20- Classroom / Computer-based, 30-Peer group TA, 40-Sectoral-based networking Y-Yes, N-No Date should be in MM/DD/YYYY format. (01/31/1999) Date should be in MM/DD/YYYY format. (01/31/1999) Date should be in MM/DD/YYYY format. (01/31/1999) For now, only insert is allowed.