XML File Naming Requirements

1.       For each interchange file submitted to the EDW, the system must identify the correct organization and data collection in order to process the file correctly:

District Code: The LEA code for which the data is being uploaded. (6 digits in length)

Campus ID: The Campus ID is used when the file that is being loaded contains data for one campus. If the file contains data for more than one campus or for all campuses, the value Campus ID is “000”. (3 digits in length)

      Note: Data Transfer Utility (DTU) submissions should always use Campus ID “000”.

Collection Code: The collection code is a character string that uniquely identifies the data collection (9 characters in length).

·        The first four characters of the Collection Code will be the ending year of the school year. For example, the first four characters would be “2014” for the 2013-2014 school year.

·        The next four to five characters of the Collection Code will indicate the type of data being submitted. Currently, the possible values are:

“FALL1” which represents the PEIMS Fall First Submission.

“FALL2” which represents the PEIMS Fall Resubmission.

“FALL3” which represents the PEIMS Fall Working Collection.

“MDYR1” which represents the PEIMS Mid-Year First Submission.

“MDYR2” which represents the PEIMS Mid-Year Resubmission.

“MDYR3” which represents the PEIMS Mid-Year Working Collection.

“SUMR1” which represents the PEIMS Summer First Submission.

“SUMR2” which represents the PEIMS Summer Resubmission.

“SUMR3” which represents the PEIMS Summer Working Collection.

“EXYR1” which represents the PEIMS Extended Year First Submission.

“EXYR2” which represents the PEIMS Extended Year Resubmission.

“EXYR3” which represents the PEIMS Extended Year Working Collection.

“TSDS” which represents the EDW data the LEAs submit for all reporting other than PEIMS.

Timestamp: The timestamp is a date in YYYYMMDDHHMM format (e.g. 201406021015). The Timestamp will be a system generated value at the time the data is extracted. (12 digits in length)

Interchange: The interchange is the name of the interchange being submitted.

2.       There must be an underscore (_) between each element in the file name.

Examples:

227950_000_2014FALL1_201310271015_InterchangeStaffAssociationExtension.xml   = 2013-2014 Fall First Submission Collection Staff Association Interchange for Region XIII.

227901_000_2014FALL1_201310271015_InterchangeStudentExtension.xml = 2013-2014 Fall First Submission Collection Student Interchange for Austin ISD.

227901_002_2014FALL1_201310271015_InterchangeStudentExtension.xml = 2013-2014 Fall First Submission Collection Student Interchange for Austin High School in Austin ISD.

227950_000_2014FALL2_201310271015_InterchangeStaffAssociationExtension.xml   = 2013-2014 Fall Resubmission Collection Staff Association Interchange for Region XIII.

227950_000_2014FALL3_201310271015_InterchangeStaffAssociationExtension.xml   = 2013-2014 Fall Working Collection Staff Association Interchange for Region XIII.

227901_000_2014TSDS_201308301159_InterchangeStudentExtension.xml = 2013-2014 TSDS Collection Student Interchange for Austin ISD.