REV Detail Report

LEA ID

The system displays the student's LEA ID.

Profile: LEA Entry/Exit Part B, LEA Code

{EnrollmentDistrict} LEA ID {ID}

LEA Name

The system displays the LEA name that the student is attending

Profile: LEA Entry/Exit Part B, Attending LEA

{EnrollmentDistrict} Name {NAME}

School Code

The system displays the school code that the student is attending.

Profile: LEA Entry/Exit Part B, Attending School ID

{EnrollmentSchool} ID

School Name

The system displays the school name that the student is attending.

Profile: LEA Entry/Exit Part B, Attending School

{EnrollmentSchool}

Local ID

Contains the student's ID number.

Demographics Part B and Demographics Part C

{ID}
{ChildUSI}

Student USI

The system displays the student's USI number.

Profile: Student Info/Demo Part B, Child USI

{StateID}

Student Name

The system displays the student's full name.
The system displays the Student's LastName, Middle Name, and FirstName fields.
If there is no middle name, it will not display the extra comma between LastName and FirstName.

Profile: Student Info/Demo Part B, Student's Name

{@CHARACTER(FirstName+" "+MiddleName+" "+LastName+" ")}

Student Date of Birth

The system displays the student's birth date.

Profile: Student Info/Demo Part B, Date of Birth

{BirthDate}

Student age as of due date

This calculates the student’s age in years at the time of their most recent evaluation due date, which falls within the report’s start and end dates.

Calculated field based on Date of birth and Evaluation Due (that falls within the reporting period)

Not Applicable as this is not a database field.

Original Eligibility Date

This retrieves the evaluation history date associated with the most recent evaluation due date within the report's start and end dates.

Eligibility History Profile

{EvalDtHist}

Due Date

This retrieves the most recent evaluation due date from the eligibility history that falls within the report start and end dates.

Eligibility History Profile

{EvalDtDue}

Eligibility Date

This expression finds the earliest evaluation date that occurred after the most recent due date within the reporting period.

Eligibility History Profile

{EvalDtHist}

Event Type

If the student's special education exit reason is code 04, the outcome is "Revocation of Services."

If there is a referral where the eligibility outcome is either 1 or 4 and the referral reason is 2, the outcome is "Referral Discontinuation."

If there is an eligibility history record where the evaluation history date is after the most recent evaluation due date within the report window, then use the initial eligibility outcome to determine the outcome as follows:

• 2 = "Eligibility Determination"

• 3 = "Non-Eligibility Determination"

• 1 = "Referral Discontinuation"

• 4 = "Parental Consent Denial"

• Spcial Edcuation Part B Profile

• Referral Profile

• Eligibility History Profile

• {SpecialEdExitReason}

• {ElibilityOutcome}

• {ReferralReason}

• {EvalDtHist}

• {InitialElibilityOutcome}

Timeliness

This report checks whether evaluations were held on time based on their due dates during the reporting period.

• If there is no record of an evaluation being held, it is marked as Untimely – Not Held.

• If the evaluation was held on or before the due date, it is marked as Timely.

• If the evaluation was held after the due date, it is marked as Untimely – Held Late.

Calculated field based on the Eligibility History Profile.

• {EvalDtHist}

• {EvalDtDue}

Exit Date

The date when the student has exited the LEA.

NA

{EnrollmentExitDate}

Exclusion Type

• If the student has an eligibility record where the due date is within the selected date range, and the next eligibility meeting was held on or before the due date, then mark the student as "Included".

• Otherwise, if there is no earlier evaluation history than the latest one in the date range, or the eligibility due date in that range occurred before the next eligibility meeting, and the student was not actively enrolled on the due date, then mark them as "Exclude: Untimely and not active on due date".

• If the student exited special education on or before the eligibility due date and the exit reason was "04" (likely a valid exclusion reason), then mark them as "Exclude: Timely negation event".

• Otherwise, if the next eligibility meeting date is missing, or the due date occurred before the next eligibility meeting, and one of the following is true:

  • The student exited between 60 days before and the eligibility due date, and did not re-enroll in the same district the next day,

  • The student was not enrolled at all on the eligibility due date,

  • The student was not enrolled at all during the 60 days before the due date,

  then mark them as "Exclude: Insufficient Enrollment".

• If none of the above conditions apply, then mark the student as "Included".

Calculation for this field is done within the report. The following fields are required.

Eligibility History Profile:

• {EvalDtHist}

• {EvalDtDue}

• {NextEligibilityHeldDate}

Enrollment Entry/Exit Profile

• (EnrollmentExitDate}

• {EnrollmentStartDate}

• {EnrollmentDistrict}

Special Education Profile Part B

• {SpEDExitReason}

Not Applicable.

Special Ed Exit Date

The date when the student exited the IEP or SpED program.

Special Education Profile Part B

{SpecialEducationExitDate}