Spreadsheet: 20ad4b35-0e39-45c8-a18d-252afe785683
Sheet: SitesProcessing

Scenarios for processing the <Sites> and <DistrictWide> tag entries in the Header of Staff and Student XML files.
Tag Option | Condition | Processing Result | Staff file | Student file
<Sites> and <DistrictWide> | Only one of the tag options may be included in the header section.  If both are used. | XSD file format error given. | NA | NA
<Sites> and <DistrictWide> | Only one of the tag options may be included in the header section.  If neither are present in the Header. | XSD file format error given. | NA | NA
<Sites> | SiteNumber listed  in <Sites> section and that site's data is found in the XML file | Site's data is processed and replaces all data in the MCCC Application for that site. | Staff and student data removed for included site, then the new staff data is added. | Student data removed for included site, then the Student data is added.
<Sites> | SiteNumber listed  in <Sites> section and that site's data is NOT found in the XML file | MCCC Application will remove all data for the Site listed. | Staff and student data removed for included site. | Student data removed for included site.
<Sites> | Combinations of the data found and Not found can exist and the MCCC Application will process each site as described above. | The MCCC Application will process only the sites listed in the <Sites> tag section.  Any missing from the section will not be changed. | Staff and student data removed for included site, then the new staff data is added for sites with data. | Student data removed for included site, then the Student data is added for site with data.
<Sites> | If there is data for a site that is not listed in the <Sites> tag section. | An error will be given and the processing will be stopped. | NA | NA
<Sites> | No <SiteNumber> values found in <Sites> sections. | XSD file format error given. | NA | NA
<Sites> | The "000" District Wide site is used in the <Sites> section. | XSD file format error given. | NA | NA
<DistrictWide> | Non-zero site placed in the <DistrictWide> tag section | XSD file format error given. | NA | NA
<DistrictWide> | "000" placed in the <DistrictWide> tag, and the data for all district sites are included in the XML file. | The file is processed and the new data replaces all data for all sites included in the file. | Staff and student data removed for all sites, then the new staff data is added. | Student data removed for all sites, then the Student data is added.
<DistrictWide> | "000" placed in the <DistrictWide> tag, and the data for SOME district sites are included in the XML file.  SOME are missing. | The file is processed and the sites that have data in the file will replace any data that exists for those sites.  Any sites that do not have data in the file will have their data deleted. | Staff and student data removed for all sites, then the new staff data is added. | Student data removed for all sites, then the Student data is added.
<DistrictWide> | "000" placed in the <DistrictWide> tag, and no data for any district sites are included in the XML file.  (Empty file) | The MCCC Application will remove all data for all sites in the district. | Staff and student data removed for all sites. | Student data removed for all sites.
<DistrictWide> | Empty <DistrictWide> tag. | XSD file format error given. | NA | NA