Schema Location for Electronic Transcripts

You can find the standard XML and EDI schemas and documentation about them on the PESC website (http://www.pesc.org).

XML Schema

To find the standard schemas on the PESC website, go to the XML College Transcript page at http://www.pesc.org/pesc-approved-standards.html. From this location you can find links to the CollegeTranscript_v1.1.0.xsd and the CoreMain_v1.4.0.xsd and AcademicRecord_v1.3.0.xsd which it references. These schemas can be copied to a local location (recommended) or referenced directly from the PESC location (if you do not expand the references to the supporting schemas).

The CollegeTranscript_v1.1.0.xsd assumes the CoreMain_v1.4.0.xsd and AcademicRecord_v1.3.0.xsd, which it references, are stored in the same location. On the PESC website, this is not true and can cause problems if the software tool being used to validate the XML file tries to expand the included supporting schemas instead of directly using the paths defined in the XML file header and cannot find them. A configuration option in the Maintain Config Table window allows you to copy the XML Transcript schema from the PESC website into a local directory, define the local schema location in the Configuration Table, and reference it from there. The default schema location is the PESC location.

Copy the schemas into a local location, putting all three schemas into the same folder. Then open the Maintain Config Table window. Find the following row:

Module = ‘CM’

Function = ‘SCHEMA’

Characteristic = ‘XML_TRANSCRIPT’

In the Configuration Value column, enter the path to your local folder.

If you wish to reference the schemas using the PESC locations, the issue of all the PESC schemas not being stored in the same location can be addressed by using an XML Editor that does not expand to validate the files.

One software package, XML Notepad, does not expand and will therefore validate the XML files without errors when providing PESC paths to all three schemas. Visual Studio and XML Copy Editor are examples of those that do expand and will generate errors when using the default header.

If you are required to use some other schema by your state or other organization, follow their recommendations for referencing their schemas locally or from their locations. You can put that location in the Configuration Table or customize the stored procedure to reference that location.

Schema Location for Electronic Transcripts

XML Schema

EDI Schema