Student Information

This report produces student demographic and course enrollment information for submission to the JTED. The report includes each student enrolled in a JTED course taught at a member district. The JTED and the member district together receive up to 1.25 ADM (membership) for the student, depending on the number of instruction minutes provided. The report results are produced in tab-delimited format. The report runs for the current school only and cannot be run district-wide.

This report will always report a student’s highest ranked (lowest number) JTED Course Enrollment, as determined by the JTED Section Ranking page, when reporting JTED Section Enrollments. For example, if a student is enrolled in a JTED class, but then later in the year is enrolled in a higher ranked JTED class while still attending the lower ranked JTED class, the report will report an ‘exit’ for the lower ranked class (with an exit date equaling the school day before the date of enrollment in the new class), then report a new enrollment in the higher ranked class.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] table based on the following criteria:

The student must be enrolled in the current school.
The student must not be excluded from state reporting.
The student’s grade level must be between 9 and 12.
The student must have “Yes” selected for “JTED Student Indicator” on the Transfer Info page for a school enrollment that occurs during the report dates.
The student’s school entry date must occur on or before the report end date.
The student’s school exit date must occur on or after the report start date.
The student’s school exit date must occur after the entry date (excludes no-shows).

Section Enrollment Selection

The report selects records from the [Sections] and [CC] table based on the following criteria:

A student who meets the criteria above must be enrolled in the section.
The student’s section entry date must occur on or before the report end date.
The student’s section exit date must occur on or after the report start date.
The student’s section entry date must occur after the section exit date.
The section must be associated with a term that occurs within the report date range.
The section must be marked “Yes” for “JTED Section Led by a CTE Instructor.”

Note: If the student is enrolled in more than one JTED section, then the section with the highest ranking is reported for the student. See JTED Section Ranking for more information.

Report Input

To generate the report, do the following:

On the Start Page, click Special Functions. The Special Functions page appears.
Click Interfaces to other systems. The Interfaces to Other Systems page appears.
Click JTED. The JTED – Arizona’s Joint Technical Education District Ranking and Reporting page appears.
Click AZ Student Information Report. The Student Information Report page appears.
Enter information in all of the required fields.
Click Submit to generate the report.

Field	Description
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
Start Date	Enter the start date for the report.
End Date	Enter the end date for the report.
Display Header	Choose one of the following from the pop-up menu: Yes – Choose this option to display the name of each data element in the first line of the report results. No – Choose this option to omit the first line with data element names.
JTED File Format	Choose one of the following from the pop-up menu: Standard Format (FY13) – Choose this option to output the results using the FY13 file specifications Standard Format (Pre-FY13) – Choose this option to output the results using the original file specifications (FY12 and prior) Pima County Format – Choose this option if reporting to the Pima County JTED
Bypass Validation	Choose one of the following from the pop-up menu: Yes – Choose this option to force the report to validate for data conditions known to cause the report to fail. No – Choose this option to bypass validation.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Standard Format (FY13)

Item #	Data Element	Description	[Table]FieldName
1	Add/Drop	Indicates whether the student exited the JTED section before the end of the term. If the student’s section exit date occurs on or after the last day of the term, then Add is reported. If the student’s section exit date occurs before the last day of the term, the Drop is reported.	[CC]DateLeft [Terms]LastDay
2	Drop Code	If Drop is reported for data element #1, then the code W1 is reported.	N/A
3	SAIS ID	The student’s SAIS ID.	[Students]State_StudentNumber
4	Student ID	The student’s locally assigned student number.	[Students]Student_Number
5	Last Name	The student’s last name.	[Students]Last_Name
6	First Name	The student’s first name.	[Students]First_Name
7	Middle Name	The student’s middle name.	[Students]Middle_Name
8	Gender Code	The student’s gender.	[Students]Gender
9	Ethnicity Group	The student’s ethnicity.	[Students]Ethnicity
10	Birthdate	The student’s date of birth.	[Students]DOB
11	Grade Level	The student’s grade level at the time of the report dates.	[Students]Grade_Level [ReEnrollments]Grade_Level
12	Birth State	The state in which the student was born.	[Students]AZ_SAIS_StateBirthCode
13	Birth Country	The country in which the student was born.	[Students]AZ_SAIS_CountryBirthCode
13	Grad Class	The student’s expected data of graduation.	[Students]Sched_YearofGraduation
14	Class Section ID	The course and section number of the JTED section in which the student is enrolled, reported in the format CourseNumber-SectionNumber.	[Sections]Course_Number [Sections]Section_Number
15	Course Title	The name of the course.	[Courses]Course_Name
16	Entry Date	The student’s entry date for the JTED section enrollment. This should be the date that the student was both enrolled in a JTED section and marked with Yes for the JTED indicator on their school enrollment. Generally, the student’s section enrollment date is reported. However, if the student’s school enrollment flagged for JTED occurs later, then the school entry date is reported.	[CC]DateEnrolled [Students]EntryDate [ReEnrollments]EntryDate
17	Exit Date	The student’s exit date for the section enrollment. This should be the date that either the student exited the JTED section, or the JTED indicator on their school enrollment was changed to No. In order for attendance to calculate correctly, a student’s course exit date needs to be the day after his last day. JTEDs require the student’s actual last day in class to be reported, so the report extracts the most recent in session day in the school calendar that occurs before the exit date. Note: If the student’s school exit date occurs before the student’s section exit date, then the report extracts the student’s school exit date. Exit Date is calculated in instances where the student is enrolled in two different overlapping JTED classes with differing start dates and Section Rankings, ensuring that the student’s highest ranked JTED enrollment is always reported. (See JTED Report Descriptions)	[CC]DateLeft [Students]ExitDate [ReEnrollments]ExitDate Calculated.
18	Teacher Last Name	The last name of the teacher assigned to each the JTED section.	[Teachers]Last_Name
19	Teacher First Name	The first name of the teacher assigned to teach the JTED section.	[Teachers]First_Name
20	Teacher Birth Date	The birth date of the teacher assigned to the section.	[Teachers]dob
20	Teacher ID	The locally assigned teacher number.	[Teachers]TeacherNumber
21	Teacher Other ID	The Educator Stakeholder ID of the teacher assigned to the section.	[Teachers]AZ_EducatorID
21	Course Period	The period during which the section is taught.	[Sections]Expression
22	Term	The term during which the section is taught.	[Terms]Abbreviation [Terms]ID = [Sections]TermID
23	State ID (CIP Code)	The CIP code associated with the course.	[Courses]Code
24	JTED ADM Course	Indicates whether the course is used to calculate JTED membership. The student’s school enrollment and section enrollment must both be identified as JTED for the course to be counted in JTED membership.	[Sections]JTED_Indicator = 1 [Students]JTED_Indicator
25	Home CTDS	The County Code-Type Code-District Code-Site Number (CTDS) of the student’s home school.	[Prefs]Value [Prefs]Name=districtnumber [Students]Schoolid
	Hispanic or Latino Y/N	Is the student Hispanic of Latino?	[Students]FedEthnicity
	American Indian or Alaska Native	Indicates if the student is of the American Indian or Alaskan Native race.	[StudentRace]RaceCd
	Asian	Indicates if the student is of the Asian race.	[StudentRace]RaceCd
	Black or African American	Indicates if the student is of the Black or African American race.	[StudentRace]RaceCd
	Native Hawaiian or Pacific Islander	Indicates if the student is of the Native Hawaiian or Pacific Islander race.	[StudentRace]RaceCd
	White	Indicates if the student is of the White race.	[StudentRace]RaceCd
26	SCED Code	The State SCED Code associated with the course.	[Courses]alt_course_number
26	JTED School CTDS	The CTDS of the student’s JTED school.	[Students]JTED_School_CTDS

Standard Format (Pre-FY13)

Item #	Data Element	Description	[Table]FieldName
1	Add/Drop	Indicates whether the student exited the JTED section before the end of the term. If the student’s section exit date occurs on or after the last day of the term, then Add is reported. If the student’s section exit date occurs before the last day of the term, the Drop is reported.	[CC]DateLeft [Terms]LastDay
2	Drop Code	If Drop is reported for data element #1, then the code W1 is reported.	N/A
3	SAIS ID	The student’s SAIS ID.	[Students]State_StudentNumber
4	Student ID	The student’s locally assigned student number.	[Students]Student_Number
5	Last Name	The student’s last name.	[Students]Last_Name
6	First Name	The student’s first name.	[Students]First_Name
7	Middle Name	The student’s middle name.	[Students]Middle_Name
8	Gender Code	The student’s gender.	[Students]Gender
9	Ethnicity Group	The student’s ethnicity.	[Students]Ethnicity
10	Birthdate	The student’s date of birth.	[Students]DOB
11	Grade Level	The student’s grade level at the time of the report dates.	[Students]Grade_Level [ReEnrollments]Grade_Level
12	Birth State	The state in which the student was born. If the state is not recorded for the student, then the report extracts the student’s country of birth.	[Students]AZ_SAIS_StateBirthCode [Students]AZ_SAIS_CountryBirthCode
13	Grad Class	The student’s expected data of graduation.	[Students]Sched_YearofGraduation
14	Class Section ID	The course and section number of the JTED section in which the student is enrolled, reported in the format CourseNumber-SectionNumber.	[Sections]Course_Number [Sections]Section_Number
15	Course Title	The name of the course.	[Courses]Course_Name
16	Entry Date	The student’s entry date for the JTED section enrollment. This should be the date that the student was both enrolled in a JTED section and marked with Yes for the JTED indicator on their school enrollment. Generally, the student’s section enrollment date is reported. However, if the student’s school enrollment flagged for JTED occurs later, then the school entry date is reported.	[CC]DateEnrolled [Students]EntryDate [ReEnrollments]EntryDate
17	Exit Date	The student’s exit date for the section enrollment. This should be the date that either the student exited the JTED section, or the JTED indicator on their school enrollment was changed to No. In order for attendance to calculate correctly, a student’s course exit date in PowerSchool needs to be the day after his last day. JTEDs require the student’s actual last day in class to be reported, so the report extracts the most recent in session day in the school calendar that occurs before the exit date. Note: If the student’s school exit date occurs before the student’s section exit date, then the report extracts the student’s school exit date. Exit Date is calculated in instances where the student is enrolled in two different overlapping JTED classes with differing start dates and Section Rankings, ensuring that the student’s highest ranked JTED enrollment is always reported. (See JTED Report Descriptions)	[CC]DateLeft [Students]ExitDate [ReEnrollments]ExitDate Calculated.
18	Teacher Last Name	The last name of the teacher assigned to each the JTED section.	[Teachers]Last_Name
19	Teacher First Name	The first name of the teacher assigned to teach the JTED section.	[Teachers]First_Name
20	Teacher ID	The locally assigned teacher number.	[Teachers]TeacherNumber
21	Course Period	The period during which the section is taught.	[Sections]Expression
22	Term	The term during which the section is taught.	[Terms]Abbreviation [Terms]ID = [Sections]TermID
23	State ID (CIP Code)	The CIP code associated with the course.	[Courses]Code
24	JTED ADM Course	Indicates whether the course is used to calculate JTED membership. The student’s school enrollment and section enrollment must both be identified as JTED for the course to be counted in JTED membership.	[Sections]JTED_Indicator = 1 [Students]JTED_Indicator
25	Concurrent CTDS	The County Code-Type Code-District Code-Site Number (CTDS) of the student’s concurrent school.	[Students]JTED_Concurrent_CTDS
26	JTED School CTDS	The CTDS of the student’s JTED school.	[Students]JTED_School_CTDS
27	District of Residence CTDS	The student’s district of residence.	[Students]DistrictOfResidence [ReEnrollments]DistrictOfResidence

Pima County Format

Item #	Data Element	Description	[Table]FieldName
1	SAIS ID	The student’s SAIS ID.	[Students]State_StudentNumber
2	Student ID	The student’s locally assigned student number.	[Students]Student_Number
3	Last Name	The student’s last name.	[Students]Last_Name
4	First Name	The student’s first name.	[Students]First_Name
5	Middle Name	The student’s middle name.	[Students]Middle_Name
6	Birthdate	The student’s date of birth.	[Students]DOB
7	Grade Level	The student’s grade level at the time of the report dates.	[Students]Grade_Level [ReEnrollments]Grade_Level
8	Birth State Code	The state in which the student was born.	[Students]AZ_SAIS_StateBirthCode
9	Birth Country Code	The country in which the student was born.	[Students]AZ_SAIS_CountryBirthCode
10	Cohort	The student’s expected data of graduation.	[Students]Sched_YearofGraduation
11	Class ID	The course and section number of the JTED section in which the student is enrolled, reported in the format CourseNumber-SectionNumber.	[Sections]Course_Number [Sections]Section_Number
12	Class Title	The name of the course.	[Courses]Course_Name
13	Schedule Entry Date	The student’s entry date for the JTED section enrollment. This should be the date that the student was both enrolled in a JTED section and marked with Yes for the JTED indicator on their school enrollment. Generally, the student’s section enrollment date is reported. However, if the student’s school enrollment flagged for JTED occurs later, then the school entry date is reported.	[CC]DateEnrolled [Students]EntryDate [ReEnrollments]EntryDate
14	Schedule Exit Date	The student’s exit date for the section enrollment. This should be the date that either the student exited the JTED section, or the JTED indicator on their school enrollment was changed to No. In order for attendance to calculate correctly, a student’s course exit date in PowerSchool needs to be the day after his last day. JTEDs require the student’s actual last day in class to be reported, so the report extracts the most recent in session day in the school calendar that occurs before the exit date. Note: If the student’s school exit date occurs before the student’s section exit date, then the report extracts the student’s school exit date. Exit Date is calculated in instances where the student is enrolled in two different overlapping JTED classes with differing start dates and Section Rankings, ensuring that the student’s highest ranked JTED enrollment is always reported. (See JTED Report Descriptions)	[CC]DateLeft [Students]ExitDate [ReEnrollments]ExitDate Calculated.
15	Teacher Last Name	The last name of the teacher assigned to each the JTED section.	[Teachers]Last_Name
16	Teacher First Name	The first name of the teacher assigned to teach the JTED section.	[Teachers]First_Name
17	Teacher Number	The locally assigned teacher number.	[Teachers]TeacherNumber
18	Teacher Other ID	The Educator Stakeholder ID of the teacher assigned to the section.	[Teachers]AZ_EducatorID
19	Class Period	The period during which the section is taught. If the class spans multiple periods, the first period is reported as the period number.	[Sections]Expression
20	Class Term	The term during which the section is taught. Valid Values: Q1 - First Quarter Q2 - Second Quarter Q3 - Third Quarter Q4 - Fourth Quarter S1 - First Semester S2 - Second Semester Y1 - Year The abbreviation of the associated term will be reported, except for the year term. If the termid ends in 00 (the year term), then Y1 is reported.	[Terms]Abbreviation [Terms]ID = [Sections]TermID
21	CIP Code	The CIP code associated with the course.	[Courses]Code
22	JTED ADM	Indicates whether the course is used to calculate JTED membership. The student’s school enrollment and section enrollment must both be identified as JTED for the course to be counted in JTED membership.	[Sections]JTED_Indicator = 1 [Students]JTED_Indicator
23	Attended CTDS	The County Code-Type Code-District Code-Site Number (CTDS) of the student’s home school.	[Prefs]Value [Prefs]Name=districtnumber [Students]Schoolid
24	Hispanic or Latino Y/N	Is the student Hispanic of Latino?	[Students]FedEthnicity
25	Asian	Indicates if the student is of the Asian race.	[StudentRace]RaceCd
26	Native American	Indicates if the student is of the American Indian or Alaskan Native race.	[StudentRace]RaceCd
27	Black or African American	Indicates if the student is of the Black or African American race.	[StudentRace]RaceCd
28	Native Hawaiian or Pacific Islander	Indicates if the student is of the Native Hawaiian or Pacific Islander race.	[StudentRace]RaceCd
29	White	Indicates if the student is of the White race.	[StudentRace]RaceCd
30	District of Residence CTD	The CTD of the student’s resident district. This will only be reported if the student’s district of residence is not the same as his district of attendance.	[Students]DOR (The first 6 digits are reported)

Report Validation

See the below for possible validation error messages and recommended correction steps.

Validation Error	Description
Course.Section (Course Name) has a duplicate section rank of nn for the year	Indicates that the section listed has a duplicate section ranking. Each section in a school must have a unique section ranking. Update a section’s ranking using the JTED Section Ranking screen. (See JTED Section Ranking for more information)
Course.Section (Course Name) has an invalid JTED Indicator Value (value).	Indicates that the section has an invalid JTED Indicator Value. The valid values for the JTED_Indicator field are: 1 (Yes) 0 (No) Null Update a single section’s JTED_Indicator field by navigating to the section, choosing the correct ‘JTED Section Led by a CTE Instructor’ value, then submitting the page. Update multiple section records using DDA (usm). Valid database values are either 0,1, or blank (null).
Student (Student Name) has an invalid JTED Indicator Value (value).	Indicates that the student enrollment record has an invalid JTED Indicator Value. The valid values for the JTED_Indicator field are: 1 (Yes) 0 (No) Null Update a student’s JTED_Indicator field by navigating to the student Transfer Info screen, choosing the appropriate enrollment record, selecting the correct JTED Indicator value, then submitting the page. Update multiple student records using DDA (usm). Valid database values are either 0,1, or blank (null).
Student (student name) has duplicated (value) race code on StudentRace record ID:nnnnn	Indicates the student has duplicate StudentRace table records. A student may have more than one race code, but cannot have duplicates of the same race code. For example, a student may have WH and BL but cannot have WH and WH. Update a student’s race codes using the Student Demographics screen. Uncheck the duplicate race code, submit the demographics screen, then re-check the race code and submit the screen.