Tool Search: Transition Report

The Transition Report produces a list of all students who have graduated or otherwise completed their secondary education in the prior school year. The report will review the summer enrollment or the current school year to determine if that status has changed based upon credits earned at a summer school program.

Transition Report Editor

Student Selection Criteria

The Transition Report includes the following two populations of students:

Population 1: Students who graduated during the prior school year with diploma types other than GED.
- State Standard Code for Diploma type must be 1, 2 3 or 5 AND
- End Status of students final prior enrollment must equal one of the following: G01, G02, G03, G04, AND
- Diploma date must be on or after the first instructional day of the prior calendar year corresponding to the final enrollment of the prior year and prior to the first instructional day of the current year calendar of the same school. Logic then finds the calendar with earliest instructional day excluding summer school calendars. In cases where the school no longer exists in the current year, use 08/01.
Population 2: Students who graduated during the prior school year with GED diploma types:
- State Standard Code for Diploma type must be 4 or 6 AND
- End Status of students final prior enrollment must equal one of the following W26 or W27 AND
- Student has a Diploma Date on the Graduation Tab;
  - Diploma Date must be prior to 10/01 of the current year.

Students meeting the following criteria will not report:

Has an enrollment record(s) for grades other than 07-14.
Students with enrollment marked State Exclude, in grade levels marked State Exclude or in a calendar marked State Exclude.
Students marked as foreign Exchange on their enrollment record.
Students marked Service Type S: Partial and N: Special Ed on their enrollment record.
- If a student has only S or N enrollments, he/she will not report.
- If a student has both P: Primary AND S or N enrollments, only the P: Primary enrollments will be considered in report logic.
Students with an NCO Attendance Group activity at any time during enrollment.
No Show enrollments are not considered by this report.

In State Edition, students will pull for each district in which they meet the criteria. When run from district edition, the report focuses only on activity within the given district.

The State Standard Code for Diploma Type is found in the Attribute Dictionary as a column (StandardCode) under Student Information > General > Graduation > Diploma Type. The report should be based on the Standard Code which is associated with the diploma type selected for the student.

Generate the Transition Report

Select an Extract Type:
- Transition - A list of students who have graduated or otherwise completed their secondary education.
- Aggregate Transition - A report detailing the state or district sum of aggregated data for all selected schools.
- Validation Report - A report detailing any errors or warnings in relation to data generated on the Transition Report.
Select the appropriate Format for the selected extract type.
Select the appropriate calendar(s) to include in the report.
- If all calendars should be selected, mark the All Calendars checkbox.
- If you would like to report data from an inactive school, mark the Show Inactive Schools checkbox and select the school.
Click the Submit to Batch button. The report will be sent to the Batch Queue List found at the bottom of the editor.
Once the report has been generated, select the blue Get report text found the in the Download column. The report will appear in a separate window in the designated format.
If errors or warnings are found in the data, that information will appear first. To continue generation of the actual report, select the Click Here button at the top of the errors/warnings page to generate the report.

Transition Report Layout

Element Name	Description	Campus Interface
District Assigned Student Number	Unique number assigned to the student by the district. Numeric	Demographics > Person Identifiers > Student Number Identity.studentNumber
State Student ID	Unique number assigned to a student by the Department of Education. Numeric, 10 digits	Demographics > Person Identifiers > Student State ID Identity.stateID
Last Name	Student's last name. Alphanumeric, 50 characters	Demographics > Person Information > Last Name Identity.lastName
First Name	Student's first name. Alphanumeric, 50 characters	Demographics > Person Information > First Name Identity.firstName
Middle Name	Student's middle name. Alphanumeric, 50 characters	Demographics > Person Information > Middle Name Identity.middleName
Date of Birth	Student's date of birth. Date field, 10 digits, MM/DD/YYYY	Demographics > Person Information > Birth Date Identity.birthdate
District Number	The District Number tied to the enrollment in which the graduation occurred (in the -1 year). Numeric, 3 digits	District Information > State District Number District.Number
School Number	The school number tied to the enrollment in which the graduation occurred (in the -1 year). Numeric, 3 digits	School Information > Location Number School.Number
Accountable District Number	School district responsible for the student. If the most recent primary enrollment in the -1 year is a non-A1 school, and District of Accountability is selected on that Enrollment, that value is reported. Otherwise, report district of most recent primary enrollment in the -1 year. Numeric, 3 digits	Enrollments > District of Accountability Enrollment.residentDistrict
Accountable School Number	School building responsible for the student. If the most recent primary enrollment in the -1 year is a non-A1 school, and School of Accountability is selected on that Enrollment, that value is reported. Otherwise, report district of most recent primary enrollment in the -1 year. Numeric, 3 digits	Enrollment > State Reporting Fields > School of Accountability Resident.School
Race/Ethnicity	Student's federal designation of racial makeup. Reported values include: Hispanic American Indian or Alaska Native Asian Black or African American Native Hawaiian or Other Pacific Islander White 2 or more Numeric, 1 digit	Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity
Hispanic	Individual race field. Indication of student being of Hispanic/Latino descent. Alphanumeric, 3 characters Reports Yes or No	Demographics > Person Information > Race/Ethnicity > Hispanic/Latino Identity.raceEthnicity
Indian or Alaskan Native	Individual race field. Indication of student being of Indian or Alaskan native descent. Alphanumeric, 3 characters Reports Yes or No	Demographics > Person Information > Race/Ethnicity > Indian or Alaskan Native Identity.raceEthnicity
Asian	Individual race field. Indication of student being of Asian descent. Alphanumeric, 3 characters Reports Yes or No	Demographics > Person Information > Race/Ethnicity > Asian Identity.raceEthnicity
Black or African American	Individual race field. Indication of student being of Black or African American descent. Alphanumeric, 3 characters Reports Yes or No	Demographics > Person Information > Race/Ethnicity > Black or African American Identity.raceEthnicity
Native Hawaiian or Other Pacific Islander	Individual race field. Indication of student being of Native Hawaiian or Other Pacific Islander descent. Alphanumeric, 3 characters Reports Yes or No	Demographics > Person Information > Race/Ethnicity > Native Hawaiian or Other Pacific Islander Identity.raceEthnicity
White	Individual race field. Indication of student being of European or Caucasian descent. Alphanumeric, 3 characters Reports Yes or No	Demographics > Person Information > Race/Ethnicity > White Identity.raceEthnicity
Gender	Classification of student being either male or female. Alphanumeric, 1 character M or F	Demographics > Person Information > Gender Identity.gender
Grade	Grade level of the student. Alphanumeric, 2 characters	Enrollments > Grade Enrollment.grade
SES	Indicates the student receives free or reduced meals based on economic status. Logic pulls the FRAM State Eligibility code which is active as of last day of final enrollment of -1 year. Reported values are as follows: 4198: Paid Lunch 4103: Free Lunch Eligible 4104: Reduced Lunch Eligible No FRAM record = 4198 Paid Lunch Numeric, 4 digits	FRAM > Eligibility > State Code FRAM.eligibility
LEP	Indicates the student is in an English Learners (EL) program. A value of "1" is reported if the student has at least 1 EL Service AND 1 Accommodation with a date range which overlaps the last instructional day of the -1 Year. Otherwise, a value of 0 is reported. Alphanumeric, 4 characters	Program Participation > English Learners (EL) LepService.startDate LepService.endDate LepAccommodation.startDate LepAccommodation.endDate
Disability Status	Student's disability status. Field reports ‘1’ if IEP end date is greater than or equal to the end date of the last enrollment of the -1 year. If Enrollment end date is blank, logic uses the last instructional day of the -1 year. IEP must be locked. PlanType.module must equal 'SpecialEd' Only the IEP with dates that overlap the end date of the last enrollment of the -1 year is used. Later or earlier IEPs are not considered. Otherwise, a value of 0 is reported. Numeric, 1 digit	Special Education Documents > IEP > Enrollment Status > Special Ed Status PlanType.module = ‘specialEd’ Plan.locked = ‘1’ Plan.startDate Plan.endDate Plan.specialEdStatus
Primary Disability	Lists the student's primary disability. If the student's Primary Disability is null, a 16 will populate this field. See list of options in the Primary Disability table. Numeric, 2 digits	Special Education Documents > IEP > Enrollment Status > Primary Disability Enrollment.disability
Homeless	Indicates student meets federal guidelines for homelessness. Will report as follows: Reports ‘1’ if the student is homeless at any point during their enrollment. Otherwise, report ‘0’. Numeric, 1 digit	Program Participation > Homeless Enrollment.homeless
Migrant	Indicates student meets federal guidelines for migrant. Reports ‘1’ if the student is an Active Migrant at any point during the reported school year. A student is considered migrant if any district enrollment dates overlap a migrant record that is active for the migrant education year (9/1-8/31). Else, report ‘0’ Prior to the 2019-2020 school year: ‘1’, report ‘1’ ‘2’ OR blank/null, report ‘0’ Numeric, 1 digit	Program Participation > Migrant Prior to 2019-2020 school year: Student Information > General > Enrollments > State Reporting Fields > Migrant migrant.lastQualifyingArrivalDate <= 08/31 of endYear AND migrant.eligibilityExpirationDate >= 09/01 of endYear - 1 enrollment.endDate >= migrant.lastQualifyingArrivalDate AND enrollment.startDate <= migrant.eligibilityExpirationDate If enrollment.enddate is null, use the earliest of last instructional day or current date
Gifted and Talented 1	Indicates student is enrolled in Creative Divergent Thinking Ability programming (01). Numeric, 2 digits	Gifted & Talented > Gifted Category GiftedStatusKY.category
Gifted and Talented 2	Indicates student is enrolled in General Intellectual Ability programming (02). Numeric, 2 digits	Gifted & Talented > Gifted Category GiftedStatusKY.category
Gifted and Talented 3	Indicates student is enrolled in Psychosocial or Leadership Skills programming (03). Numeric, 2 digits	Gifted & Talented > Gifted Category GiftedStatusKY.category
Gifted and Talented 4	Indicates student is enrolled in Specific Academic Aptitude - Language Arts programming (04). Numeric, 2 digits	Gifted & Talented > Gifted Category GiftedStatusKY.category
Gifted and Talented 5	Indicates student is enrolled in Specific Academic Aptitude - Math programming (05). Numeric, 2 digits	Gifted & Talented > Gifted Category GiftedStatusKY.category
Gifted and Talented 6	Indicates student is enrolled in Specific Academic Aptitude - Science programming (06). Numeric, 2 digits	Gifted & Talented > Gifted Category GiftedStatusKY.category
Gifted and Talented 7	Indicates student is enrolled in Specific Academic Aptitude - Social Studies programming (07). Numeric, 2 digits	Gifted & Talented > Gifted Category GiftedStatusKY.category
Gifted and Talented 8	Indicates student is enrolled in Visual or Performing Arts Ability - Art programming (08). Numeric, 2 digits	Gifted & Talented > Gifted Category GiftedStatusKY.category
Gifted and Talented 9	Indicates student is enrolled in Visual or Performing Arts Ability - Dance programming (09). Numeric, 2 digits	Gifted & Talented > Gifted Category GiftedStatusKY.category
Gifted and Talented 10	Indicates student is enrolled in Visual or Performing Arts Ability - Drama programming (10). Numeric, 2 digits	Gifted & Talented > Gifted Category GiftedStatusKY.category
Gifted and Talented 11	Indicates student is enrolled in Visual or Performing Arts Ability - Music programming (11). Numeric, 2 digits	Gifted & Talented > Gifted Category GiftedStatusKY.category
Transition Status	Code indicating the student's transition status. If the Transition Status is blank, but all other selection criteria is met, this field is defaulted to 7 and will be included on the Warning Report. Possible active values: 1: College in KY 2: College out of KY 3: Vocational / Technical / Special School (full-time) 4: Military Service (full-time) 5: Employment (at least 30 hours/week) 6: Work-school combination 7: Unsuccessful 8: Deceased 9: Continuing HS Education Alphanumeric, 1 character	Graduation > Transition Status Graduation.postGradPlans
Diploma Date	Date the student received the diploma. Date field, 10 characters, MM/DD/YYYY	Graduation > Diploma Date Graduation.diplomaDate
Diploma Type	Type of diploma student received. If a student has a Diploma Type field of 2: Commonwealth Diploma, the Transition to Adult Life record will populate with a 3 in the Diploma Type field See list of options in the Diploma Type table. Numeric, 1 digit	Graduation > Diploma Type Graduation.diplomaType
Diploma Period	Period in which the student received the diploma. 1 = Early Graduate 2 = Spring Graduate 3 = Summer Graduate Numeric, 1 digit	General > Graduation > Diploma Period Graduation.diplomaPeriod
NCLB Cohort End Year	Indicates the student's end year as defined by NCLB rules. Date Field, 4 characters, YYYY	Calculated
End Status	The end status of the reporting student's most recent Primary enrollment record. Alphanumeric, 3 characters	Enrollments > End Status Enrollment.endStatus

Element Name

Description

Campus Interface

District Assigned Student Number

Unique number assigned to the student by the district.

Numeric

Demographics > Person Identifiers > Student Number

Identity.studentNumber

State Student ID

Unique number assigned to a student by the Department of Education.

Numeric, 10 digits

Demographics > Person Identifiers > Student State ID

Identity.stateID

Last Name

Student's last name.

Alphanumeric, 50 characters

Demographics > Person Information > Last Name

Identity.lastName

First Name

Student's first name.

Alphanumeric, 50 characters

Demographics > Person Information > First Name

Identity.firstName

Middle Name

Student's middle name.

Alphanumeric, 50 characters

Demographics > Person Information > Middle Name

Identity.middleName

Date of Birth

Student's date of birth.

Date field, 10 digits, MM/DD/YYYY

Demographics > Person Information > Birth Date

Identity.birthdate

District Number

The District Number tied to the enrollment in which the graduation occurred (in the -1 year).

Numeric, 3 digits

District Information > State District Number

District.Number

School Number

The school number tied to the enrollment in which the graduation occurred (in the -1 year).

Numeric, 3 digits

School Information > Location Number

School.Number

Accountable District Number

School district responsible for the student.

If the most recent primary enrollment in the -1 year is a non-A1 school, and District of Accountability is selected on that Enrollment, that value is reported. Otherwise, report district of most recent primary enrollment in the -1 year.

Numeric, 3 digits

Enrollments > District of Accountability

Enrollment.residentDistrict

Accountable School Number

School building responsible for the student.

If the most recent primary enrollment in the -1 year is a non-A1 school, and School of Accountability is selected on that Enrollment, that value is reported. Otherwise, report district of most recent primary enrollment in the -1 year.

Numeric, 3 digits

Enrollment > State Reporting Fields > School of Accountability

Resident.School

Race/Ethnicity

Student's federal designation of racial makeup.

Reported values include:

Hispanic
American Indian or Alaska Native
Asian
Black or African American
Native Hawaiian or Other Pacific Islander
White
2 or more

Numeric, 1 digit

Demographics > Person Information > Race/Ethnicity

Identity.raceEthnicity

Hispanic

Individual race field. Indication of student being of Hispanic/Latino descent.

Alphanumeric, 3 characters

Reports Yes or No

Demographics > Person Information > Race/Ethnicity > Hispanic/Latino

Identity.raceEthnicity

Indian or Alaskan Native

Individual race field. Indication of student being of Indian or Alaskan native descent.

Alphanumeric, 3 characters

Reports Yes or No

Demographics > Person Information > Race/Ethnicity > Indian or Alaskan Native

Identity.raceEthnicity

Asian

Individual race field. Indication of student being of Asian descent.

Alphanumeric, 3 characters

Reports Yes or No

Demographics > Person Information > Race/Ethnicity > Asian

Identity.raceEthnicity

Black or African American

Individual race field. Indication of student being of Black or African American descent.

Alphanumeric, 3 characters

Reports Yes or No

Demographics > Person Information > Race/Ethnicity > Black or African American

Identity.raceEthnicity

Native Hawaiian or Other Pacific Islander

Individual race field. Indication of student being of Native Hawaiian or Other Pacific Islander descent.

Alphanumeric, 3 characters

Reports Yes or No

Demographics > Person Information > Race/Ethnicity > Native Hawaiian or Other Pacific Islander

Identity.raceEthnicity

White

Individual race field. Indication of student being of European or Caucasian descent.

Alphanumeric, 3 characters

Reports Yes or No

Demographics > Person Information > Race/Ethnicity > White

Identity.raceEthnicity

Gender

Classification of student being either male or female.

Alphanumeric, 1 character

M or F

Demographics > Person Information > Gender

Identity.gender

Grade

Grade level of the student.

Alphanumeric, 2 characters

Enrollments > Grade

Enrollment.grade

SES

Indicates the student receives free or reduced meals based on economic status.

Logic pulls the FRAM State Eligibility code which is active as of last day of final enrollment of -1 year.

Reported values are as follows:

4198: Paid Lunch
4103: Free Lunch Eligible
4104: Reduced Lunch Eligible
No FRAM record = 4198 Paid Lunch

Numeric, 4 digits

FRAM > Eligibility > State Code

FRAM.eligibility

LEP

Indicates the student is in an English Learners (EL) program.

A value of "1" is reported if the student has at least 1 EL Service AND 1

Accommodation with a date range which overlaps the last instructional day of the -1 Year.

Otherwise, a value of 0 is reported.

Alphanumeric, 4 characters

Program Participation > English Learners (EL)

LepService.startDate

LepService.endDate

LepAccommodation.startDate

LepAccommodation.endDate

Disability Status

Student's disability status.

Field reports ‘1’ if IEP end date is greater than or equal to the end date of the last enrollment of the -1 year.

If Enrollment end date is blank, logic uses the last instructional day of the -1 year.
IEP must be locked.
PlanType.module must equal 'SpecialEd'
Only the IEP with dates that overlap the end date of the last enrollment of the -1 year is used. Later or earlier IEPs are not considered.
Otherwise, a value of 0 is reported.

Numeric, 1 digit

Special Education Documents > IEP > Enrollment Status > Special Ed Status

PlanType.module = ‘specialEd’

Plan.locked = ‘1’

Plan.startDate

Plan.endDate

Plan.specialEdStatus

Primary Disability

Lists the student's primary disability.

If the student's Primary Disability is null, a 16 will populate this field.

See list of options in the Primary Disability table.

Numeric, 2 digits

Special Education Documents > IEP > Enrollment Status > Primary Disability

Enrollment.disability

Homeless

Indicates student meets federal guidelines for homelessness. Will report as follows:

Reports ‘1’ if the student is homeless at any point during their enrollment.
Otherwise, report ‘0’.

Numeric, 1 digit

Program Participation > Homeless

Enrollment.homeless

Migrant

Indicates student meets federal guidelines for migrant.

Reports ‘1’ if the student is an Active Migrant at any point during the reported school year.
- A student is considered migrant if any district enrollment dates overlap a migrant record that is active for the migrant education year (9/1-8/31).
Else, report ‘0’

Prior to the 2019-2020 school year:

‘1’, report ‘1’
‘2’ OR blank/null, report ‘0’

Numeric, 1 digit

Program Participation > Migrant

Prior to 2019-2020 school year:

Student Information > General > Enrollments > State Reporting Fields > Migrant

migrant.lastQualifyingArrivalDate <= 08/31 of endYear AND migrant.eligibilityExpirationDate >= 09/01 of endYear - 1

enrollment.endDate >= migrant.lastQualifyingArrivalDate AND enrollment.startDate <= migrant.eligibilityExpirationDate

If enrollment.enddate is null, use the earliest of last instructional day or current date

Gifted and Talented 1

Indicates student is enrolled in Creative Divergent Thinking Ability programming (01).

Numeric, 2 digits