Spreadsheet: d4088125-d319-4877-b2b3-39f25654f48d
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> | When both tags are present in the header section of the file. | XSD file format error given. | NA | NA
Neither <Sites> or <DistrictWide> | If neither tag is present in the file. | 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(s), then the new staff data is added. | Student data removed for included site, then the Student data is added.  If Student data is ever removed with the Staff File, then the Student data needs to be reloaded for the affected site data.
<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(s), then the new staff data is added for sites with data. | Student data removed for the included site(s), then the Student data found in the file is added for site(s) listed in the header. If Student data is ever removed with the Staff File, then the Student data needs to be reloaded for the affected site 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.   If Student data is ever removed with the Staff File, then the Student data needs to be reloaded for the affected site data.
<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.   If Student data is ever removed with the Staff File, then the Student data needs to be reloaded for the affected site data.
<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