How to Complete Template 027

Overview:

Here are the quick instructions for utilizing Template 027 Student Transcript Student Academic Record Diploma.

Make sure to read the general reporting information for templates before proceeding. Failure to follow these guidelines will result in errors and/or data validation issues.

Before Beginning, Note:

• All steps will be completed in Row 7, downwards.

Instructions:

1. Enter the SchoolYear for the data being submitted.

• This is the current reporting school year and NOT the calendar year.

  • Example: If the reporting school year is 2023-2024, the school year field should be 2024.

• Note: Incorrect school year provided will cause data to not be found in Data Exchange.

2. Enter the EdOrgID.

• See the chart below for more details.

3. Enter the STN. 

• Note: Any STNs beginning with a zero will need the field or entire column to be formatted to hold the nine digits being reported. Leading zeros will be dropped upon reopening the csv file.

4. Enter the TermDescriptor. The allowable Term Descriptors are listed below on the green chart.

• Note: The descriptors are both case and space-sensitive.

• Note: The “Term” reported must match with the term provided on the Calendar Template 001.

5. Enter the DiplomaAwardDate.

• This is the date the student is awarded their diploma or certificate of completion. There are several rules to keep in mind:

  • This date does not have to be a school calendar date.

  • Students with an award date from October 1st to June 30th will be certified in July of the reporting school year.

  • Students with an award date of July 1st to September 30th will be certified in the following year’s October certification, while still being acknowledge as a prior school year graduate.

• Note: The date needs to be formatted as TEXT as “MM/DD/YYYY”.

6. Enter the DiplomaLevelDescriptors using the chart below.

• This provides the level of diploma or certificate a student has earned. 

• Note: These descriptors must be exactly entered (including parenthesis) and are space and case sensitive.

7. Enter the DiplomaTypeDescriptor as “Regular diploma” (be sure to match casing and spacing, no quotation marks), UNLESS:

• If you entered “Course Completion” for Step #6. If you did, enter “Certificate of attendance” (be sure to match casing and spacing) for Step #7.

• Or, If you entered “Certificate of Completion (IEP program Completed)” for Step #6. If you did, enter “Certificate of completion” (be sure to match casing and spacing) for Step #7.

8. Enter the EmployabilitySkills using one of the allowable descriptors:

• Note: These descriptors are space and case sensitive.

9. Enter the PostSecondaryCompetency using one of the allowable descriptors:

• Note: These descriptors are space and case sensitive.

10. For LocallyCreatedPathway, provide one of the five pathway numbers allowable for reporting.

• If the student used a Locally Created Pathway, report the number 10001, 10002, 10003, or 10004. Use this resource to help decide which number is appropriate to report, under Grad Pathway Requirement 3: Postsecondary Ready Competencies. 

• If a student did not use a Locally Created Pathway, report the number 10000.

Remember: Templates must be saved as a CSV file (with cells formatted as TEXT) inside of a Compressed Zipped Folder, in order to process correctly.