PATH: KY State Reporting > TEDS Report

Search Term: TEDS Report

The TEDS Report pulls information from the TEDS tab and reports student participation in Federal vocational programs.

This article includes the following topics:

Image 1: TEDS Report Editor

Reporting Logic

Only students enrolled in the calendar(s) selected and meet the following criteria are reported:

The student must have had an enrollment record within the start and end date entered on the extract editor.
The student must be in grades 07, 08, 09, 10, 11, 12 or 14.
The student must have had a TEDS record active at some point during the reporting year.
State excluded students are included in report results if they meet all criteria mentioned above. This includes students in state excluded calendars, grade levels, and enrollments.

For the Enrollment Extract:

Report TEDS records associated with each school selected in the report.
- For example, a student has an enrollment in School A in the 15-16 school year
  - The student has TEDS records in both School A and School B
  - The report is run for the entire 15-16 school year for School A and School B
  - TEDS records from both School A and School B are returned
- OR
  - A student has an enrollment in School A in the 15-16 school year
  - The student has TEDS records in School B
  - The report is run for the entire 15-16 school year for School A and School B
  - Only TEDS records from School B are returned
- No records will report if the student does not have an enrollment in one of the selected calendars. Certain fields in the report are pulled from the Enrollment table and without an enrollment record in one of the selected school calendars the TEDS records cannot be extracted.
- For example, a student has an enrollment in School A in the 15-16 school year
  - The student has TEDS records in School B
  - The report is run for the entire 15-16 school year for School B
  - No TEDS records from School B are returned

Generating the Report

Enter the Date Range of the report.
Select the Extract Type - Enrollment or Demographic.
Select the Format for the report. Use the State Format (Fixed Width) when submitting information to the state. Use the HTML or XML formats for testing prior to state submission.
Select which Grade(s) (within the selected calendars) will report data. OR
Select an Ad Hoc Filter to only report data based on filter criteria.
Select the Calendar(s) to include in the report.
Click the Generate button to view the report immediately or select the Submit to Batch button to send the request to the Batch Queue.

Submitting to Batch is highly recommended when generating this tool for a large amount of enrollment records. This ensures system performance is not impacted.

Image 2: Example of TEDS Enrollment Report - HTML

Report Layouts

The following tables detail the TEDS Report Data Elements.

Demographic Report Layout

Data Element	Definition	Type, Format and Length	Campus Database	Campus Interface
Record Type	Indicates the type of TEDS record being submitted. Will always report as a D.	Alphanumeric, 1 character	Not dynamically stored	Not dynamically stored
SSID	Student's unique state identifier.	Numeric, 10 digits	Person.stateID	Census > People > Demographics > Person Identifiers > State ID
SSN	Student's Social Security Number.	Numeric, 9 digits	Identity.ssn	Census > People > Demographics > Person Information > SSN
Last Name	Student's last name.	Alphanumeric, 30 characters	Identity.lastName	Census > People > Demographics > Person Information > Last Name
First Name	Student's first name.	Alphanumeric, 20 characters	Identity.firstName	Census > People > Demographics > Person Information > First Name
Middle Name	Student's middle name.	Alphanumeric, 15 characters	Identity.middleName	Census > People > Demographics > Person Information > Middle Name
Birth Date	Student's date of birth.	Date field, 10 characters MM/DD/YYYY	Identity.dateofbirth	Census > People > Demographics > Person Information > Birth Date
Race Code	Student's race/ethnicity selection.	Alphanumeric, 1 character	Identity.raceEthnicity	Census > People > Demographics > Person Information > Race Ethnicity
Gender	Indication of student being either male or female.	Alphanumeric, 1 character M or F	Identity.gender	Census > People > Demographics > Person Information > Gender
Institution Number	Combination of County number, district number AND school number.	Numeric, 9 digits	District.number School.number District.countyCode	System Administration > Resources > District Information > State District Number System Administration > Resources > School > Number System Administration > Resources > Counties
Primary Mailing Street	Student's primary mailing address.	Alphanumeric, 40 characters	Address.number Address.tag Address.dir Address.apt Address.street Address.prefix	Census > Households > Address
Primary Mailing City	Student's mailing city.	Alphanumeric, 20 characters	Address.city	Census > Households > Address > City
State	Student's state in which mail is sent.	Alphanumeric, 2 characters	Address.state	Census > Households > Address > State
Zip	Zip code assigned to mailing address.	Alphanumeric, 9 digits	Address.zip	Census > Households > Address > Zip
Report Type	Indicates the type of report being submitted. Will report as IC.	Alphanumeric, 3 characters	Not dynamically stored	Not dynamically stored

Enrollment Report Layout

Data Element	Definition	Type, Format and Length	Campus Database	Campus Interface
Record Type	Indicates the type of TEDS record being submitted. Will always report as a E.	Alphanumeric, 1 character	Not dynamically stored	Not dynamically stored
SSID	Student's unique state identifier.	Numeric, 10 digits	Person.stateID	Census > People > Demographics > Person Identifiers > State ID
SSN	Student's Social Security number.	Numeric, 9 digits	Identity.ssn	Census > People > Demographics > Person Information > SSN
Last Name	Student's last name.	Alphanumeric, 30 characters	Identity.lastName	Census > People > Demographics > Person Information > Last Name
Enrollment Date	Student's enrollment date into the program.	Date field, 10 characters MM/DD/YYYY	TEDSKY.startDate	Student Information > General > TEDS > Start Date
Institution Number	Combination of County number, district number AND school number.	Numeric, 9 digits	District.number School.number District.countyCode	System Administration > Resources > District Information > State District Number System Administration > Resources > School > Number System Administration > Resources > Counties
ATC_CTC	Indicates the student participates in ATC/CTC programming.	Alphanumeric, 1 character	TEDSKY.tedsATCCTC	Student Information > General > TEDS > ATC_CTC
School Year	School year for which the student is enrolled in TEDS Programming.	Numeric, 9 digits 20XX-20XX	School.year	Student Information > General > Enrollment > Year
Program Section Number	Will report as 1, padded by two spaces after.	Numeric, 3 digits	Not dynamically stored	Not dynamically stored
Grade Level	Student's grade level of enrollment. The following logic is used if the student is in State Grade Level: Grade 07 will report as 1 Grade 08 will report as 2 Grade 09 will report as 3 Grade 10 will report as 4 Grade 11 will report as 5 Grade 12 will report as 6 Grade 14 will report as 6 Grade Level reports from the student’s most recent enrollment during the report date range.	Alphanumeric, 2 digits	Enrollment.grade	Student Information > General > Enrollment > General Enrollment Information > Grade
Attendance Hours	Total hours of daily attendance hours the student is enrolled in TEDS programming in Term 1.	Numeric, 5 digits X.XX	TEDSKY. tedsDailyAttHours	Student Information > General > TEDS > Term 1
CIP Code	Classification of Instructional Program (CIP) code used to select the appropriate career major.	Numeric, 7 digits	TEDSKY.cipCode	Student Information > General > TEDS > Daily > CIP Code
Student Objective	Selection of student's primary objective for participating in selected TEDS program.	Alphanumeric, 2 characters	TEDSKY.tedsStudent Objective	Student Information > General > TEDS > Student Objective
Disadvantaged	Indicates the student is considered to be disadvantaged. If student's SES is 4103 or 4104 at any time during the year, this field will report as 1; otherwise this field will report as 0.	Numeric, 3 characters	Enrollment. disadvantaged	Student Information > General > Enrollments > State Reporting Fields > Disadvantaged
Disability	Indicates the student is considered disabled. This is pulled from the student's current locked IEP and the student must also have a Special Education State of A: Active. See the Disability Status for available options.	Alphanumeric, 3 characters	Enrollment.disability	Student Information > General > Enrollments > State Reporting Fields > Disability Student Information > Special Education > Documents > IEP (locked)
Sponsored By	Indicates the student's program is supported by a specific organization. This will report as blank.	Alphanumeric, 3 characters	Not dynamically stored	Not dynamically stored
Special Population	Designation of special circumstances for TEDS programming. Options are: 1 - Single Parent 2 - Single Pregnant Woman	Numeric, 2 characters	TEDSKY. tedsSpecialPopulation	Student Information > General > TEDS > Special Populations
Tech Prep	This field is no longer used.	N/A	N/A	N/A
LEP	Indicates the student is considered to be an English Learners (EL). Y = An EL record with a Program Status of “EL". (Student Information > Program Participation > English Learners (EL) > EL > Program Status) AND The student must have at least one valid EL Service at any point during the reporting year. (Student Information > Program Participation > English Learners (EL) > EL Services) AND The student must have at least one valid Instructional EL Accommodation at any point during the reporting year. (Student Information > Program Participation > English Learners (EL) > EL Accommodations). N = Students who have a Program Status of EL but do not have a valid EL Service and EL Accommodation at any point during the reporting year OR the student has an EL Program Status of “NEL (NLEP)”, "Pending", "Exited EL", or “NULL”. Student Information > Program Participation > English Learners (EL) > EL > Program Status.	Alphanumeric, 1 character	Enrollment.LEP	Student Information > Program Participation > English Learners (EL)
Special Ed Status	Indicates the student is receiving special education programming.	Alphanumeric, 2 characters	Enrollment.spedStatus	Student Information > General > Enrollments > Special Education Fields > Special Education Status Student Information > Special Education > Documents > IEP (locked)
GPA	Lists the student's grade point average as displayed on the student's Transcript.	Numeric, 6 digits 9.9999999	Transcriptscore.GPA	Student Information > General > Grades
Termination Date	Date on which student ends enrollment in TEDS programming.	Date field, 10 characters MM/DD/YYYY	TEDSKY.endDate	Student Information > General > TEDS > End Date
ONET Code	Reports blank.	32 characters	N/A	N/A
ONET Date	Reports blank.	10 characters	N/A	N/A
Plan 504	Indicates student has a 504 Plan on record with the school.	Alphanumeric, 1 character	enrollment.504	Student Information > General > Enrollment > State Reporting Fields > 504 Plan
Work-Based Learning	List of possible learning the student is receiving through work experience. See list of Work-Based Learning Options.	Numeric, 2 digits	TEDSKY. tedsWorkBasedLearning	Student Information > General > TEDS > Worked Based Learning
Report Type	Indicates the type of report being submitted. Will report as IC.	Alphanumeric, 2 characters	Not dynamically stored	Not dynamically stored
School of Accountability	Reports the school number and district number in which the student is enrolled.	Numeric, 6 digits	District.number School.number	System Administration > Resources > District Information > State District Number System Administration > Resources > School > Number
Pell Grant	Not stored in Infinite Campus.	N/A	N/A	N/A
WIA	Not stored in Infinite Campus.	N/A	N/A	N/A
Credit Hours	Number of credits the student receives for participating in the program.	Numeric, 5 digits XXX.X	TEDSKY. tedsCreditHours	Student Information > General > TEDS > Credit Hours
Attendance Hours 2	Total hours of daily attendance hours the student is enrolled in TEDS programming in Term 2.	Numeric, 5 digits X.XX	TEDSKY. tedsDailyAttHours2	Student Information > General > TEDS > Term 2
Attendance Hours 3	Total hours of daily attendance hours the student is enrolled in TEDS programming in Term 3. If value of this field in GUI is null (user has checked semesters on the TEDS tab) then populate with the same value as AttendanceHours2 field.	Numeric, 5 digits X.XX	TEDSKY. tedsDailyAttHours3	Student Information > General > TEDS > Term 3
Homeless Status	The reporting student's homeless status. Report Y, if any homeless record from the same district exists during the school year, (July 1 – June 30). Else report N.	Alpha, 1 characters		Student Information > Program Participation > Homeless
Foster Care	The reporting student's foster care status. Report Y, if any foster care record from the same district exists during the school year, (July 1 – June 30). Else report N.	Alpha, 1 characters		Student Information > Program Participation > Foster Care
Migrant	Indicates if the student is considered a migrant. Report Y, if any migrant record from the same district exists during the school year, (July 1 – June 30). Else report N.	Alpha, 1 characters		Student Information > Program Participation > Migrant
Military Connected	Indicates if the student has a contact who is active in the military. Report 1 if the student has at least one record in the v_StudentMilitaryConnectedSummary view with startdate before 6/30 of the end year and a null end date or end date after 7/1 of the start year of reporting school year and has a status of ‘Active Duty, deployed’ or ‘Active duty, not deployed’. Example for 2017-2018 school year startdate < 06/30/2018 and enddate > 07/01/2017 Else, report 0	Numeric, 1 digit		Census > People > Military Connections

Disability Status

The following disability statuses report in the TEDS Extract:

Code	Description
A	01: Mild Mental Disability
B	02: Functional Mental Disability
C	04: Hearing Impairment
D	13: Autism
E	05: Speech/Language Impairment
F	06: Visual Impairment
G	07: Emotional Behavior Disability
H	08: Orthopedic Impairment or Physical
I	09: Other Health Impairment
J	11: Deaf Blind
K	12: Multiple Disabilities
L	10: Specific Learning Disability
M	15: Developmental Delay
N	14: Traumatic Brain Injury

TEDS Report (Kentucky)