Hello all
I am trying to setup so that i can export xml from excel. below are my xsd file and xml file with data. i am getting the error that my schema contains denormalized data when i go to verify my map. any help would be apriciated
Begin XSD
<xs:schema attributeformdefault="unqualified" elementformdefault="qualified" targetnamespace="http://www.ed.gov/FSA/COD/2016/v4.0c" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://www.ed.gov/FSA/COD/2016/v4.0c" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="CommonRecord">
<xs:complexType>
<xs:sequence>
<xs:element name="TransmissionData">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:dateTime" name="DocumentID"/>
<xs:element type="xs:dateTime" name="CreatedDateTime"/>
<xs:element name="Source">
<xs:complexType>
<xs:sequence>
<xs:element name="School">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:int" name="RoutingID"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Destination">
<xs:complexType>
<xs:sequence>
<xs:element name="COD">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:byte" name="RoutingID"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Software">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="SoftwareProvider"/>
<xs:element type="xs:int" name="SoftwareVersion"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element type="xs:string" name="FullResponseCode"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ReportingSchool">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:int" name="RoutingID"/>
<xs:element name="ReportedFinancialSummary">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="FinancialAwardType"/>
<xs:element type="xs:short" name="FinancialAwardYear"/>
<xs:element type="xs:byte" name="TotalCount"/>
<xs:element type="xs:int" name="TotalReportedAward"/>
<xs:element type="xs:int" name="TotalReportedDisbursement"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AttendedSchool">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:int" name="RoutingID"/>
<xs:element name="Student" maxOccurs="unbounded" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="Index">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:int" name="SSN"/>
<xs:element type="xs:string" name="BirthDate"/>
<xs:element type="xs:string" name="LastName"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PersonIdentifiers">
<xs:complexType>
<xs:sequence>
<xs:element name="DriversLicense" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="DriversLicenseState"/>
<xs:element type="xs:int" name="DriversLicenseNumber"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element type="xs:string" name="SchoolAssignedPersonID"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Name">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="FirstName"/>
<xs:element type="xs:string" name="LastName"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Contacts">
<xs:complexType>
<xs:sequence>
<xs:element name="PermanentAddress">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="AddressLine"/>
<xs:element type="xs:string" name="City"/>
<xs:element type="xs:string" name="StateProvinceCode"/>
<xs:element type="xs:int" name="PostalCode"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Phone">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:long" name="PhoneNumber"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Email">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="EmailAddress"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Citizenship">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:byte" name="CitizenshipStatusCode"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="DLLoanInformation">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:float" name="OriginationFeePercent"/>
<xs:element type="xs:float" name="InterestRebatePercent"/>
<xs:element type="xs:byte" name="StudentLevelCode"/>
<xs:element type="xs:date" name="FinancialAwardBeginDate"/>
<xs:element type="xs:date" name="FinancialAwardEndDate"/>
<xs:element type="xs:date" name="AcademicYearBeginDate"/>
<xs:element type="xs:date" name="AcademicYearEndDate"/>
</xs:sequence>
<xs:attribute type="xs:byte" name="AwardKey" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="DLUnsubsidized">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:byte" name="AwardKey"/>
<xs:element type="xs:short" name="FinancialAwardYear"/>
<xs:element type="xs:byte" name="CPSTransactionNumber"/>
<xs:element type="xs:short" name="FinancialAwardAmount"/>
<xs:element type="xs:string" name="DependencyStatusCode"/>
<xs:element type="xs:string" name="EntranceCounseling"/>
<xs:element type="xs:byte" name="FinancialAwardNumber"/>
<xs:element type="xs:string" name="FinancialAwardID"/>
<xs:element type="xs:date" name="FinancialAwardCreateDate"/>
<xs:element type="xs:byte" name="StudentEligibilityCode"/>
<xs:element type="xs:string" name="AbilityToBenefitTestAdministratorCode" nillable="true"/>
<xs:element type="xs:string" name="AbilityToBenefitTestCode" nillable="true"/>
<xs:element type="xs:string" name="AbilityToBenefitCompletionDate" nillable="true"/>
<xs:element type="xs:string" name="HPPAIndicator"/>
<xs:element type="xs:string" name="AdditionalUnsubsidizedEligibilityIndicator"/>
<xs:element type="xs:string" name="PreprofessionalCourseworkIndicator"/>
<xs:element name="Disbursement">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:short" name="DisbursementAmount"/>
<xs:element type="xs:date" name="DisbursementDate"/>
<xs:element type="xs:string" name="DisbursementReleaseIndicator"/>
<xs:element type="xs:byte" name="DisbursementSequenceNumber"/>
<xs:element type="xs:int" name="EnrollmentSchoolCode"/>
<xs:element type="xs:date" name="PaymentPeriodStartDate"/>
<xs:element type="xs:string" name="EnrollmentStatus"/>
<xs:element type="xs:float" name="ProgramCIPCode"/>
<xs:element type="xs:float" name="PublishedPgmLengthYears"/>
<xs:element type="xs:string" name="SpecialPrograms"/>
<xs:element type="xs:byte" name="ProgramCredentialLevel"/>
<xs:element type="xs:short" name="DisbursementNetAmount"/>
<xs:element type="xs:byte" name="DisbursementFeeAmount"/>
<xs:element type="xs:byte" name="InterestRebateAmount"/>
</xs:sequence>
<xs:attribute type="xs:byte" name="Number" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
</xs:schema>
end of XSD
<?xml version="1.0"?>
<CommonRecord xmlns="http://www.ed.gov/FSA/COD/2016/v4.0c" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ed.gov/FSA/COD/2016/v4.0c CommonRecord4.0c.xsd">
<TransmissionData>
<DocumentID>2017-11-01T10:34:58.6052805119</DocumentID>
<CreatedDateTime>2017-11-01T10:34:58.60</CreatedDateTime>
<Source>
<School>
<RoutingID>52805119</RoutingID>
</School>
</Source>
<Destination>
<COD>
<RoutingID>00000001</RoutingID>
</COD>
</Destination>
<Software>
<SoftwareProvider>PowerFAIDS</SoftwareProvider>
<SoftwareVersion>222085</SoftwareVersion>
</Software>
<FullResponseCode>F</FullResponseCode>
</TransmissionData>
<ReportingSchool>
<RoutingID>52805119</RoutingID>
<ReportedFinancialSummary>
<FinancialAwardType>DLUnsubsidized</FinancialAwardType>
<FinancialAwardYear>2018</FinancialAwardYear>
<TotalCount>6</TotalCount>
<TotalReportedAward>69155</TotalReportedAward>
<TotalReportedDisbursement>37327</TotalReportedDisbursement>
</ReportedFinancialSummary>
<AttendedSchool>
<RoutingID>52805119</RoutingID>
<Student>
<Index>
<SSN>123456789</SSN>
<BirthDate>1234-56-78</BirthDate>
<LastName>LANE</LastName>
</Index>
<PersonIdentifiers>
<SchoolAssignedPersonID>ID-ALT=12345</SchoolAssignedPersonID>
</PersonIdentifiers>
<Name>
<FirstName>AFTEN</FirstName>
<LastName>LANE</LastName>
</Name>
<Contacts>
<PermanentAddress>
<AddressLine>123 HAPPY ST</AddressLine>
<City>COLORADO SPRINGS</City>
<StateProvinceCode>CO</StateProvinceCode>
<PostalCode>80922</PostalCode>
</PermanentAddress>
<Phone>
<PhoneNumber>7191112222</PhoneNumber>
</Phone>
<Email>
<EmailAddress>ME@att.net</EmailAddress>
</Email>
</Contacts>
<Citizenship>
<CitizenshipStatusCode>1</CitizenshipStatusCode>
</Citizenship>
<DLLoanInformation AwardKey="1">
<OriginationFeePercent>1.069</OriginationFeePercent>
<InterestRebatePercent>0.000</InterestRebatePercent>
<StudentLevelCode>7</StudentLevelCode>
<FinancialAwardBeginDate>2017-08-14</FinancialAwardBeginDate>
<FinancialAwardEndDate>2018-05-11</FinancialAwardEndDate>
<AcademicYearBeginDate>2017-08-14</AcademicYearBeginDate>
<AcademicYearEndDate>2018-05-11</AcademicYearEndDate>
</DLLoanInformation>
<DLUnsubsidized>
<AwardKey>1</AwardKey>
<FinancialAwardYear>2018</FinancialAwardYear>
<CPSTransactionNumber>1</CPSTransactionNumber>
<FinancialAwardAmount>20500</FinancialAwardAmount>
<DependencyStatusCode>I</DependencyStatusCode>
<EntranceCounseling>false</EntranceCounseling>
<FinancialAwardNumber>001</FinancialAwardNumber>
<FinancialAwardID>112334455U18G01789001</FinancialAwardID>
<FinancialAwardCreateDate>2017-09-25</FinancialAwardCreateDate>
<StudentEligibilityCode>04</StudentEligibilityCode>
<AbilityToBenefitTestAdministratorCode xsi:nil="true" />
<AbilityToBenefitTestCode xsi:nil="true" />
<AbilityToBenefitCompletionDate xsi:nil="true" />
<HPPAIndicator>false</HPPAIndicator>
<AdditionalUnsubsidizedEligibilityIndicator>false</AdditionalUnsubsidizedEligibilityIndicator>
<PreprofessionalCourseworkIndicator>false</PreprofessionalCourseworkIndicator>
<Disbursement Number="1">
<DisbursementAmount>10250</DisbursementAmount>
<DisbursementDate>2017-09-29</DisbursementDate>
<DisbursementReleaseIndicator>true</DisbursementReleaseIndicator>
<DisbursementSequenceNumber>02</DisbursementSequenceNumber>
<EnrollmentSchoolCode>00178900</EnrollmentSchoolCode>
<PaymentPeriodStartDate>2017-08-14</PaymentPeriodStartDate>
<EnrollmentStatus>F</EnrollmentStatus>
<ProgramCIPCode>39.0602</ProgramCIPCode>
<PublishedPgmLengthYears>4.000</PublishedPgmLengthYears>
<SpecialPrograms>N</SpecialPrograms>
<ProgramCredentialLevel>5</ProgramCredentialLevel>
<DisbursementNetAmount>10141</DisbursementNetAmount>
<DisbursementFeeAmount>109</DisbursementFeeAmount>
<InterestRebateAmount>0</InterestRebateAmount>
</Disbursement>
</DLUnsubsidized>
</Student>
</AttendedSchool>
</ReportingSchool>
</CommonRecord>
Start XML
<!--?xml version="1.0"?-->
<commonrecord xmlns="http://www.ed.gov/FSA/COD/2016/v4.0c" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="http://www.ed.gov/FSA/COD/2016/v4.0c CommonRecord4.0c.xsd">
<transmissiondata>
<documentid>2017-11-01T10:34:58.6052805119</documentid>
<createddatetime>2017-11-01T10:34:58.60</createddatetime>
<source>
<school>
<routingid>52805119</routingid>
</school>
<destination>
<cod>
<routingid>00000001</routingid>
</cod>
</destination>
<software>
<softwareprovider>PowerFAIDS</softwareprovider>
<softwareversion>222085</softwareversion>
</software>
<fullresponsecode>F</fullresponsecode>
</transmissiondata>
<reportingschool>
<routingid>52805119</routingid>
<reportedfinancialsummary>
<financialawardtype>DLUnsubsidized</financialawardtype>
<financialawardyear>2018</financialawardyear>
<totalcount>6</totalcount>
<totalreportedaward>69155</totalreportedaward>
<totalreporteddisbursement>37327</totalreporteddisbursement>
</reportedfinancialsummary>
<attendedschool>
<routingid>52805119</routingid>
<student>
<index>
<ssn>123456789</ssn>
<birthdate>1234-56-78</birthdate>
<lastname>LANE</lastname>
</index>
<schoolassignedpersonid>ID-ALT=12345</schoolassignedpersonid>
</personidentifiers>
<name>
<firstname>AFTEN</firstname>
<lastname>LANE</lastname>
</name>
<contacts>
<addressline>123 HAPPY ST</addressline>
<city>COLORADO SPRINGS</city>
<stateprovincecode>CO</stateprovincecode>
80922</postalcode>
</permanentaddress>
7191112222</phonenumber>
</phone>
<email>
<emailaddress>ME@att.net</emailaddress>
</email>
</contacts>
<citizenship>
<citizenshipstatuscode>1</citizenshipstatuscode>
</citizenship>
<dlloaninformation awardkey="1">
<originationfeepercent>1.069</originationfeepercent>
<interestrebatepercent>0.000</interestrebatepercent>
<studentlevelcode>7</studentlevelcode>
<financialawardbegindate>2017-08-14</financialawardbegindate>
<financialawardenddate>2018-05-11</financialawardenddate>
<academicyearbegindate>2017-08-14</academicyearbegindate>
<academicyearenddate>2018-05-11</academicyearenddate>
</dlloaninformation>
<dlunsubsidized>
<awardkey>1</awardkey>
<financialawardyear>2018</financialawardyear>
<cpstransactionnumber>1</cpstransactionnumber>
<financialawardamount>20500</financialawardamount>
<dependencystatuscode>I</dependencystatuscode>
<entrancecounseling>false</entrancecounseling>
<financialawardnumber>001</financialawardnumber>
<financialawardid>112334455U18G01789001</financialawardid>
<financialawardcreatedate>2017-09-25</financialawardcreatedate>
<studenteligibilitycode>04</studenteligibilitycode>
<abilitytobenefittestadministratorcode xsi:nil="true">
<abilitytobenefittestcode xsi:nil="true">
<abilitytobenefitcompletiondate xsi:nil="true">
<hppaindicator>false</hppaindicator>
<additionalunsubsidizedeligibilityindicator>false</additionalunsubsidizedeligibilityindicator>
false</preprofessionalcourseworkindicator>
<disbursement number="1">
<disbursementamount>10250</disbursementamount>
<disbursementdate>2017-09-29</disbursementdate>
<disbursementreleaseindicator>true</disbursementreleaseindicator>
<disbursementsequencenumber>02</disbursementsequencenumber>
<enrollmentschoolcode>00178900</enrollmentschoolcode>
2017-08-14</paymentperiodstartdate>
<enrollmentstatus>F</enrollmentstatus>
39.0602</programcipcode>
4.000</publishedpgmlengthyears>
<specialprograms>N</specialprograms>
5</programcredentiallevel>
<disbursementnetamount>10141</disbursementnetamount>
<disbursementfeeamount>109</disbursementfeeamount>
<interestrebateamount>0</interestrebateamount>
</disbursement>
</abilitytobenefitcompletiondate></abilitytobenefittestcode></abilitytobenefittestadministratorcode></dlunsubsidized>
</student>
</attendedschool>
</reportingschool>
</commonrecord>
End of XML
I am trying to setup so that i can export xml from excel. below are my xsd file and xml file with data. i am getting the error that my schema contains denormalized data when i go to verify my map. any help would be apriciated
Begin XSD
<xs:schema attributeformdefault="unqualified" elementformdefault="qualified" targetnamespace="http://www.ed.gov/FSA/COD/2016/v4.0c" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://www.ed.gov/FSA/COD/2016/v4.0c" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="CommonRecord">
<xs:complexType>
<xs:sequence>
<xs:element name="TransmissionData">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:dateTime" name="DocumentID"/>
<xs:element type="xs:dateTime" name="CreatedDateTime"/>
<xs:element name="Source">
<xs:complexType>
<xs:sequence>
<xs:element name="School">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:int" name="RoutingID"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Destination">
<xs:complexType>
<xs:sequence>
<xs:element name="COD">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:byte" name="RoutingID"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Software">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="SoftwareProvider"/>
<xs:element type="xs:int" name="SoftwareVersion"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element type="xs:string" name="FullResponseCode"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ReportingSchool">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:int" name="RoutingID"/>
<xs:element name="ReportedFinancialSummary">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="FinancialAwardType"/>
<xs:element type="xs:short" name="FinancialAwardYear"/>
<xs:element type="xs:byte" name="TotalCount"/>
<xs:element type="xs:int" name="TotalReportedAward"/>
<xs:element type="xs:int" name="TotalReportedDisbursement"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AttendedSchool">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:int" name="RoutingID"/>
<xs:element name="Student" maxOccurs="unbounded" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="Index">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:int" name="SSN"/>
<xs:element type="xs:string" name="BirthDate"/>
<xs:element type="xs:string" name="LastName"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PersonIdentifiers">
<xs:complexType>
<xs:sequence>
<xs:element name="DriversLicense" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="DriversLicenseState"/>
<xs:element type="xs:int" name="DriversLicenseNumber"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element type="xs:string" name="SchoolAssignedPersonID"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Name">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="FirstName"/>
<xs:element type="xs:string" name="LastName"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Contacts">
<xs:complexType>
<xs:sequence>
<xs:element name="PermanentAddress">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="AddressLine"/>
<xs:element type="xs:string" name="City"/>
<xs:element type="xs:string" name="StateProvinceCode"/>
<xs:element type="xs:int" name="PostalCode"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Phone">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:long" name="PhoneNumber"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Email">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="EmailAddress"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Citizenship">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:byte" name="CitizenshipStatusCode"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="DLLoanInformation">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:float" name="OriginationFeePercent"/>
<xs:element type="xs:float" name="InterestRebatePercent"/>
<xs:element type="xs:byte" name="StudentLevelCode"/>
<xs:element type="xs:date" name="FinancialAwardBeginDate"/>
<xs:element type="xs:date" name="FinancialAwardEndDate"/>
<xs:element type="xs:date" name="AcademicYearBeginDate"/>
<xs:element type="xs:date" name="AcademicYearEndDate"/>
</xs:sequence>
<xs:attribute type="xs:byte" name="AwardKey" use="optional"/>
</xs:complexType>
</xs:element>
<xs:element name="DLUnsubsidized">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:byte" name="AwardKey"/>
<xs:element type="xs:short" name="FinancialAwardYear"/>
<xs:element type="xs:byte" name="CPSTransactionNumber"/>
<xs:element type="xs:short" name="FinancialAwardAmount"/>
<xs:element type="xs:string" name="DependencyStatusCode"/>
<xs:element type="xs:string" name="EntranceCounseling"/>
<xs:element type="xs:byte" name="FinancialAwardNumber"/>
<xs:element type="xs:string" name="FinancialAwardID"/>
<xs:element type="xs:date" name="FinancialAwardCreateDate"/>
<xs:element type="xs:byte" name="StudentEligibilityCode"/>
<xs:element type="xs:string" name="AbilityToBenefitTestAdministratorCode" nillable="true"/>
<xs:element type="xs:string" name="AbilityToBenefitTestCode" nillable="true"/>
<xs:element type="xs:string" name="AbilityToBenefitCompletionDate" nillable="true"/>
<xs:element type="xs:string" name="HPPAIndicator"/>
<xs:element type="xs:string" name="AdditionalUnsubsidizedEligibilityIndicator"/>
<xs:element type="xs:string" name="PreprofessionalCourseworkIndicator"/>
<xs:element name="Disbursement">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:short" name="DisbursementAmount"/>
<xs:element type="xs:date" name="DisbursementDate"/>
<xs:element type="xs:string" name="DisbursementReleaseIndicator"/>
<xs:element type="xs:byte" name="DisbursementSequenceNumber"/>
<xs:element type="xs:int" name="EnrollmentSchoolCode"/>
<xs:element type="xs:date" name="PaymentPeriodStartDate"/>
<xs:element type="xs:string" name="EnrollmentStatus"/>
<xs:element type="xs:float" name="ProgramCIPCode"/>
<xs:element type="xs:float" name="PublishedPgmLengthYears"/>
<xs:element type="xs:string" name="SpecialPrograms"/>
<xs:element type="xs:byte" name="ProgramCredentialLevel"/>
<xs:element type="xs:short" name="DisbursementNetAmount"/>
<xs:element type="xs:byte" name="DisbursementFeeAmount"/>
<xs:element type="xs:byte" name="InterestRebateAmount"/>
</xs:sequence>
<xs:attribute type="xs:byte" name="Number" use="optional"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
</xs:schema>
end of XSD
<?xml version="1.0"?>
<CommonRecord xmlns="http://www.ed.gov/FSA/COD/2016/v4.0c" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ed.gov/FSA/COD/2016/v4.0c CommonRecord4.0c.xsd">
<TransmissionData>
<DocumentID>2017-11-01T10:34:58.6052805119</DocumentID>
<CreatedDateTime>2017-11-01T10:34:58.60</CreatedDateTime>
<Source>
<School>
<RoutingID>52805119</RoutingID>
</School>
</Source>
<Destination>
<COD>
<RoutingID>00000001</RoutingID>
</COD>
</Destination>
<Software>
<SoftwareProvider>PowerFAIDS</SoftwareProvider>
<SoftwareVersion>222085</SoftwareVersion>
</Software>
<FullResponseCode>F</FullResponseCode>
</TransmissionData>
<ReportingSchool>
<RoutingID>52805119</RoutingID>
<ReportedFinancialSummary>
<FinancialAwardType>DLUnsubsidized</FinancialAwardType>
<FinancialAwardYear>2018</FinancialAwardYear>
<TotalCount>6</TotalCount>
<TotalReportedAward>69155</TotalReportedAward>
<TotalReportedDisbursement>37327</TotalReportedDisbursement>
</ReportedFinancialSummary>
<AttendedSchool>
<RoutingID>52805119</RoutingID>
<Student>
<Index>
<SSN>123456789</SSN>
<BirthDate>1234-56-78</BirthDate>
<LastName>LANE</LastName>
</Index>
<PersonIdentifiers>
<SchoolAssignedPersonID>ID-ALT=12345</SchoolAssignedPersonID>
</PersonIdentifiers>
<Name>
<FirstName>AFTEN</FirstName>
<LastName>LANE</LastName>
</Name>
<Contacts>
<PermanentAddress>
<AddressLine>123 HAPPY ST</AddressLine>
<City>COLORADO SPRINGS</City>
<StateProvinceCode>CO</StateProvinceCode>
<PostalCode>80922</PostalCode>
</PermanentAddress>
<Phone>
<PhoneNumber>7191112222</PhoneNumber>
</Phone>
<Email>
<EmailAddress>ME@att.net</EmailAddress>
</Email>
</Contacts>
<Citizenship>
<CitizenshipStatusCode>1</CitizenshipStatusCode>
</Citizenship>
<DLLoanInformation AwardKey="1">
<OriginationFeePercent>1.069</OriginationFeePercent>
<InterestRebatePercent>0.000</InterestRebatePercent>
<StudentLevelCode>7</StudentLevelCode>
<FinancialAwardBeginDate>2017-08-14</FinancialAwardBeginDate>
<FinancialAwardEndDate>2018-05-11</FinancialAwardEndDate>
<AcademicYearBeginDate>2017-08-14</AcademicYearBeginDate>
<AcademicYearEndDate>2018-05-11</AcademicYearEndDate>
</DLLoanInformation>
<DLUnsubsidized>
<AwardKey>1</AwardKey>
<FinancialAwardYear>2018</FinancialAwardYear>
<CPSTransactionNumber>1</CPSTransactionNumber>
<FinancialAwardAmount>20500</FinancialAwardAmount>
<DependencyStatusCode>I</DependencyStatusCode>
<EntranceCounseling>false</EntranceCounseling>
<FinancialAwardNumber>001</FinancialAwardNumber>
<FinancialAwardID>112334455U18G01789001</FinancialAwardID>
<FinancialAwardCreateDate>2017-09-25</FinancialAwardCreateDate>
<StudentEligibilityCode>04</StudentEligibilityCode>
<AbilityToBenefitTestAdministratorCode xsi:nil="true" />
<AbilityToBenefitTestCode xsi:nil="true" />
<AbilityToBenefitCompletionDate xsi:nil="true" />
<HPPAIndicator>false</HPPAIndicator>
<AdditionalUnsubsidizedEligibilityIndicator>false</AdditionalUnsubsidizedEligibilityIndicator>
<PreprofessionalCourseworkIndicator>false</PreprofessionalCourseworkIndicator>
<Disbursement Number="1">
<DisbursementAmount>10250</DisbursementAmount>
<DisbursementDate>2017-09-29</DisbursementDate>
<DisbursementReleaseIndicator>true</DisbursementReleaseIndicator>
<DisbursementSequenceNumber>02</DisbursementSequenceNumber>
<EnrollmentSchoolCode>00178900</EnrollmentSchoolCode>
<PaymentPeriodStartDate>2017-08-14</PaymentPeriodStartDate>
<EnrollmentStatus>F</EnrollmentStatus>
<ProgramCIPCode>39.0602</ProgramCIPCode>
<PublishedPgmLengthYears>4.000</PublishedPgmLengthYears>
<SpecialPrograms>N</SpecialPrograms>
<ProgramCredentialLevel>5</ProgramCredentialLevel>
<DisbursementNetAmount>10141</DisbursementNetAmount>
<DisbursementFeeAmount>109</DisbursementFeeAmount>
<InterestRebateAmount>0</InterestRebateAmount>
</Disbursement>
</DLUnsubsidized>
</Student>
</AttendedSchool>
</ReportingSchool>
</CommonRecord>
Start XML
<!--?xml version="1.0"?-->
<commonrecord xmlns="http://www.ed.gov/FSA/COD/2016/v4.0c" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="http://www.ed.gov/FSA/COD/2016/v4.0c CommonRecord4.0c.xsd">
<transmissiondata>
<documentid>2017-11-01T10:34:58.6052805119</documentid>
<createddatetime>2017-11-01T10:34:58.60</createddatetime>
<source>
<school>
<routingid>52805119</routingid>
</school>
<destination>
<cod>
<routingid>00000001</routingid>
</cod>
</destination>
<software>
<softwareprovider>PowerFAIDS</softwareprovider>
<softwareversion>222085</softwareversion>
</software>
<fullresponsecode>F</fullresponsecode>
</transmissiondata>
<reportingschool>
<routingid>52805119</routingid>
<reportedfinancialsummary>
<financialawardtype>DLUnsubsidized</financialawardtype>
<financialawardyear>2018</financialawardyear>
<totalcount>6</totalcount>
<totalreportedaward>69155</totalreportedaward>
<totalreporteddisbursement>37327</totalreporteddisbursement>
</reportedfinancialsummary>
<attendedschool>
<routingid>52805119</routingid>
<student>
<index>
<ssn>123456789</ssn>
<birthdate>1234-56-78</birthdate>
<lastname>LANE</lastname>
</index>
<schoolassignedpersonid>ID-ALT=12345</schoolassignedpersonid>
</personidentifiers>
<name>
<firstname>AFTEN</firstname>
<lastname>LANE</lastname>
</name>
<contacts>
<addressline>123 HAPPY ST</addressline>
<city>COLORADO SPRINGS</city>
<stateprovincecode>CO</stateprovincecode>
80922</postalcode>
</permanentaddress>
7191112222</phonenumber>
</phone>
<email>
<emailaddress>ME@att.net</emailaddress>
</email>
</contacts>
<citizenship>
<citizenshipstatuscode>1</citizenshipstatuscode>
</citizenship>
<dlloaninformation awardkey="1">
<originationfeepercent>1.069</originationfeepercent>
<interestrebatepercent>0.000</interestrebatepercent>
<studentlevelcode>7</studentlevelcode>
<financialawardbegindate>2017-08-14</financialawardbegindate>
<financialawardenddate>2018-05-11</financialawardenddate>
<academicyearbegindate>2017-08-14</academicyearbegindate>
<academicyearenddate>2018-05-11</academicyearenddate>
</dlloaninformation>
<dlunsubsidized>
<awardkey>1</awardkey>
<financialawardyear>2018</financialawardyear>
<cpstransactionnumber>1</cpstransactionnumber>
<financialawardamount>20500</financialawardamount>
<dependencystatuscode>I</dependencystatuscode>
<entrancecounseling>false</entrancecounseling>
<financialawardnumber>001</financialawardnumber>
<financialawardid>112334455U18G01789001</financialawardid>
<financialawardcreatedate>2017-09-25</financialawardcreatedate>
<studenteligibilitycode>04</studenteligibilitycode>
<abilitytobenefittestadministratorcode xsi:nil="true">
<abilitytobenefittestcode xsi:nil="true">
<abilitytobenefitcompletiondate xsi:nil="true">
<hppaindicator>false</hppaindicator>
<additionalunsubsidizedeligibilityindicator>false</additionalunsubsidizedeligibilityindicator>
false</preprofessionalcourseworkindicator>
<disbursement number="1">
<disbursementamount>10250</disbursementamount>
<disbursementdate>2017-09-29</disbursementdate>
<disbursementreleaseindicator>true</disbursementreleaseindicator>
<disbursementsequencenumber>02</disbursementsequencenumber>
<enrollmentschoolcode>00178900</enrollmentschoolcode>
2017-08-14</paymentperiodstartdate>
<enrollmentstatus>F</enrollmentstatus>
39.0602</programcipcode>
4.000</publishedpgmlengthyears>
<specialprograms>N</specialprograms>
5</programcredentiallevel>
<disbursementnetamount>10141</disbursementnetamount>
<disbursementfeeamount>109</disbursementfeeamount>
<interestrebateamount>0</interestrebateamount>
</disbursement>
</abilitytobenefitcompletiondate></abilitytobenefittestcode></abilitytobenefittestadministratorcode></dlunsubsidized>
</student>
</attendedschool>
</reportingschool>
</commonrecord>
End of XML