EIS 044 Student Classification Extract (Tennessee)

Tool Search: TN State Reporting > EIS Batch Transmission File

The 044 Student Classification extract reports Program, FRAM, and other student classification details to EIS.

See the EIS Batch Transmission article for an overview of the EIS Batch Transmission File, logic that applies to all extracts, and generation instructions.

Report Logic

A record reports for each Primary or Partial enrollment in the calendar(s) selected. Only one record is reported per student for each classification type. The following classifications types are not reported:

  • U: Runaway
  • V: Even Start Funded P3, P4

Records are not reported in advance for enrollments that become active in the future. Students can have multiple classifications; a 044 record is uploaded for each classification type.

Enrollments in Calendars or Grade Levels marked as Exclude and students with no State Student ID are not reported. Additionally, records are not reported for the following students. These students are included in the warning report. 

  • Students without PINs. 
  • Students with multiple active Primary enrollments.
  • Students with multiple enrollments in the same school.
  • Students with an enrollment marked as N: Special Ed Services
  • Enrollments marked as No Show or Exclude, or in Calendars or Grade Levels marked as Exclude.

The following sections are not included in the extract. Those marked with an ( * ) are included the warning report:

  • Sections whose Course has a Type but no a State Code.*
  • Sections with a Type Override in a Course without a State Code.*
  • Sections whose Course noes not have a State Code.
  • Sections in a Course or Calendar marked as Exclude.
  • Students with a Homeless record with a start date on or within the active year with no Homeless Nighttime Residence or Unaccompanied Youth values selected. 

Multiple records report in the warning report for the 044 extract for excluded students who are tied to a course and other classifications to show what would have been reported to EIS had the student not met the exclude criteria.

If a record was previously reported and then marked as exclude, a delete record will be sent to EIS for each record.

The Record Key, which helps determine the Type of record sent (New, Edit, or Delete), is comprised of the Record ID, Record Version, District ID,  School ID, School Year, Instructional Program Number, State Assigned Student ID, Student Classification Type, and Student Classify Begin Date.

Recommended District Setup

Districts and Schools who track student classifications via Flags or Programs must create flag and program Types in the Program Admin tool.

For a Flag or Program to be state reported, a Code of the EIS Student Classification Type Code must be entered and the State Reported checkbox must be marked. Districts can create multiple flag or program instances with the same EIS Student Classification Type Code and different flag or program Names.

Programs that are not marked as Active are excluded. Students classified as Alternative are those enrolled in a School with a School Org Type of Alternative or those who have Alternative marked on their Enrollment.

Also, note that Homeless Student records are not automatically end dated when a student enrollment is ended. Campus recommends using Ad hoc Reporting to identify these records and enter End Dates as needed.

Districts can enable the Impact Aid and Military Connections tabs through System Administration > Preferences > System Preferences > Turn on Federal Impact Aid Tracking. The Military Connections tab is populated based on Relationships in the student's Households who are marked as Military. Data is reported for relationships marked as Guardian.

044 Student Classification Extract Layout

Element Name

Description

Campus Application

Record ID

Identifies the extract - reports as "044"


Numeric (3)

N/A

Record VersionIdentifies the extract version - reports as "02"

Numeric (2)
N/A
Record Type

Identifies the type of extract:

  • N: New
  • E: Edit
  • D: Delete

Character (1)

N/A
FillerN/A. Reports as 00.
N/A
District IDReports the TN Department of Education assigned District Number.

Numeric (3)
System Administration > Resources > District Information > State District Number

District.number
School IDReports the TN Department of Education assigned School Number

Numeric (4)
System Administration > Resources > School > State School Number

School.number
School YearReports the start year of the school calendar.

Date (4) CCYY

System Administration > Calendar > School Years > Start Year

SchoolYear.startYear
Instructional Program NumberReports the unique Instructional Program Number of the school, or as 99 if blank.

Numeric (2)
System Administration > Calendar > Calendar > Instructional Program Number

Calendar.instructionalProgramNumber
Student Social Security NumberReports the student's social security number. Currently reports as 000000000.

Numeric (9)
Census > People > Identities > Current Identity > Soc Sec Number

Identity.ssn
Student PINReports the unique student identifier provided by the school.

Numeric (9)
Census > People > Demographics > Person Identifiers > Student PIN

Person.additionalID
Local Student KeyReports the locally-generated student identifier.

Numeric (10)
Census > People > Demographics > Person Identifiers > Local Student Number

Person.studentNumber
Student Classification TypeThe student's classification Type. See the

State Classification Types table following for more information.


Alphanumeric (5)

See below
Student Classify Begin DateThe date the student's classification began. See the State Classification Types table following for more information.

Date (8) CCYYMMDD
See below
Student Classify End DateThe date the student's classification ended. See the State Classification Types table following for more information.

Date (8) CCYYMMDD

See below
State Assigned Student IDReports the unique state-assigned student ID generated in EIS.

Numeric (9)
Census > People > Demographics > Person Identifiers > Student State ID

Person.stateID
FillerN/AN/A

State Classification Types

Reporting Window Logic: The reporting window is defined as follows: In the calendar in which the student is enrolled, the window is the earliest day with a Day Event of AS and the earliest day with a Day Event of AE. (System Administration > Calendar > Calendar > Days > Day Event)

State CodeState Classification TypeBusiness RuleCampus DatabaseCampus Application
ID619ID619 PreSchool Classroom

The ID619 classification is given to a sub-set of students within a section. Based on the student enrollment query all sections the student is rostered in. 

If ID619 is selected from P3/P4 Classifications on Roster Batch Editon one or more of the of the section(s), complete the following logic:

If the state grade tied to grade on the enrollment is equal to P3 OR P4 continue, else exit logic

  • Populate Student Classification Type with "ID619"
  • Populate Student Classify Begin Date using the following logic:
    • If Roster Start Date is not equal to null or blank, populate Student Classify Start Date using the Roster Start Date ELSE report earliest scheduled term start date.
  • Populate Student Classify End Date using the following logic:
    • If the Roster End Date is NOT NULL populate Student Classify End Date with Roster End Date ELSE populate the latest Term End Date

Calculated based on Roster.stateUseFlag

Roster.startDate

Term.startDate

Roster.endDate

Term.endDate


  • Student Information > General > Enrollments > Grade
  • Course > Section > Roster Batch Edit > P3/P4 Classifications
  • Student Information > General > Schedule > Start Date

  • System Administration > Calendar > Terms > Start Date

  • Student Information > General > Enrollment > Start Date
  • Student Information > General > Enrollment > End Date
  • Student Information > General > Schedule > End Date

  • System Administration > Calendar > Terms > End Date


1LEAPs Participant

If the student is participating in a state reported program or flag with a Code of 1 and a Start Date on or within the Reporting Window, reports the State Classification Code from the most recent record.

ProgramParticipation.code

ProgramParticipation.startDate

ProgramSessiom.startDate

ProgramParticipation.endDate

ProgramSessiom.endDate

Student Information > Program Participation > Programs > Program (Code), Start Date; Student Information > General > Flags > Flag (Code), Start Date; Program Admin > Programs > Programs > State Reported; Program Admin > Flags > State Reported

221st CCL Participant

If the student is  participating in a state reported program or flag with a Code of 2, and a Start Date on or within the Reporting Window, reports the State Classification Code from the most recent record.

ProgramParticipation.code

ProgramParticipation.startDate

ProgramSessiom.startDate

ProgramParticipation.endDate

ProgramSessiom.endDate

Student Information > Program Participation > Programs > Program (Code), Start Date; Student Information > General > Flags > Flag (Code), Start Date; Program Admin > Programs > Programs > State Reported; Program Admin > Flags > State Reported

4Active Duty Military

Identify ALL eligible Guardian Relationships with Status of 4: Active Duty Military linked to the student via the Military Connections tab.

An eligible Guardian relationship is one where the the End date on the relationship is such that the relationship is considered active as of the effective date on the state reporting editor. If the End Date is ON or BEFORE the effective date the relationship is considered ended and is NOT an eligible guardian relationship.

If no relationships exist, do NOT create a record and EXIT Active Duty Military classification logic ELSE continue:

Using the calendar tied to the student enrollment, identify a reporting window using the Calendar Start and End Dates

A student is considered eligible for reporting if one or more of the Guardian Military Connection record(s) OVERLAPS the reporting window. If the student is NOT eligible do NOT create a record and EXIT Active Duty Military classification logic ELSE continue

Using the LATEST Military Connection Start Date, compare the Military Connection Start Date to the Enrollment Start Date and Populate Student Classify Begin Date using the following conditions:

  • If the Military Connection Start Date is AFTER the Student’s Enrollment End Date do NOT create a record and EXIT Active Duty Military classification logic
  • If the Military Connection Start Date is AFTER the Enrollment Start Date, populate Student Classify Begin Date with the Military Connection Start Date
  • ELSE, populate Student Classify Begin Date with the student’s Enrollment Start Date

Populate End Date using the following logic:

Using the calendar tied to the student's enrollment, identify the date of the AE Day Event Type

Using all records whose start date falls within the reporting window, find the LATEST Military Connection End Date and complete the following logic:

If the End Date is Null or Blank populate Zeros

ELSE

If the End Date is AFTER the AE date populate zeros

ELSE

If the End Date is BEFORE or ON the AE Date complete the following logic:

If the End Date is AFTER the Student's Enrollment End date, populate the Student's Enrollment End Date

Else populate End Date

Additionally, report the following:

  • Populate Student Classification Type with "4"


militaryConnections.startDate

militaryConnections.endDate


System Administration > Calendar > Start Date
System Administration > Calendar > Calendar > End Date
Census > People >  Military Connections > Start Date
Census > People >  Military Connections > End Date
Census > People > Relationships > End Date
5National Guard Military

Identify ALL eligible Guardian Relationships with Status of 5: National Guard Military linked to the student via the Military Connections tab.

An eligible Guardian relationship is one where the the End date on the relationship is such that the relationship is considered active as of the effective date on the state reporting editor. If the End Date is ON or BEFORE the effective date the relationship is considered ended and is NOT an eligible guardian relationship.

If no relationships exist, do NOT create a record and EXIT National Guard Military classification logic ELSE continue:

Using the calendar tied to the student enrollment, identify a reporting window using the Calendar Start and End Dates

A student is considered eligible for reporting if one or more of the Guardian Military Connection record(s) OVERLAPS the reporting window. If the student is NOT eligible do NOT create a record and EXIT National Guard Military classification logic ELSE continue

Using the LATEST Military Connection Start Date, compare the Military Connection Start Date to the Enrollment Start Date and Populate Student Classify Begin Date using the following conditions:

  • If the Military Connection Start Date is AFTER the Student’s Enrollment End Date do NOT create a record and EXIT National Guard Military classification logic
  • If the Military Connection Start Date is AFTER the Enrollment Start Date, populate Student Classify Begin Date with the Military Connection Start Date
  • ELSE, populate Student Classify Begin Date with the student’s Enrollment Start Date

Populate End Date using the following logic:

Using the calendar tied to the student's enrollment, identify the date of the AE Day Event Type

Using all records whose start date falls within the reporting window, find the LATEST Military Connection End Date and complete the following logic:

If the End Date is Null or Blank populate Zeros

ELSE

If the End Date is AFTER the AE date populate zeros

ELSE

If the End Date is BEFORE or ON the AE Date complete the following logic:

If the End Date is AFTER the Student's Enrollment End date, populate the Student's Enrollment End Date

Else populate End Date

Additionally, report the following:

  • Populate Student Classification Type with "5"

militaryConnections.startDate

militaryConnections.endDate


System Administration > Calendar > Start Date
System Administration > Calendar > Calendar > End Date
Census > People >  Military Connections > Start Date
Census > People >  Military Connections > End Date
Census > People > Relationships > End Date
504Section 504Using the calendar tied to the student enrollment, identify a reporting window using the dates of the following Day Event Types. If more than one instance of these Day Event Types exist, use the earliest instance.
  • 'AS' - the start of the reporting window
  • 'AE' - the end of the reporting window

Review the students 504 records

504 records whose End Dates are BEFORE the reporting window are not eligible for reporting.

ELSE

A student is considered eligible for reporting if one or more 504 record(s) has a Start Date equal to NOT NULL AND is NOT AFTER the reporting window.

In other words students may report a 504 record if one or more 504 records have a Start Date equal to NOT NULL AND is BEFORE, ON OR WITHIN the reporting window.

If the Student has more than one record that is considered eligible for reporting 504, use the record with the LATEST start date to report the classification

Report the 504 classification record using the following logic:

Populate Student Classification Type with '504'

Report Start Date using the following logic:

If the 504 record Start Date is BEFORE the date of the earliest instance of Day Event Type "AS"

Populate Student Classify Begin Date with Enrollment Start Date

ELSE

If the Enrollment Start Date is AFTER the 504 Record Start Date, Populate Enrollment Start Date

ELSE

Populate Student Classify Begin Date with the 504 record Start Date

Report End Date using the following logic:

If the 504 record End Date is BEFORE the date of the earliest instance of Day Event Type "AE"

Populate Student Classify End Date with the 504 record End Date

ELSE

Populate the date of the earliest instance of Day Event Type "AE

Section504.startDate

Section504.endDate


System Administration > Calendar > Calendar > Days > Day Event Type
Student Information > Program Participation > Section 504 > Start Date
Student Information > Program Participation > Section 504 > End Date
Student Information > General > Enrollment > Start Date


6Reserve Military Dependent

Identify ALL eligible Guardian Relationships with Status of 6: Reserve Military Dependent linked to the student via the Military Connections tab.

An eligible Guardian relationship is one where the the End date on the relationship is such that the relationship is considered active as of the effective date on the state reporting editor. If the End Date is ON or BEFORE the effective date the relationship is considered ended and is NOT an eligible guardian relationship.

If no relationships exist, do NOT create a record and EXIT Reserve Military Dependent classification logic ELSE continue:

Using the calendar tied to the student enrollment, identify a reporting window using the Calendar Start and End Dates

A student is considered eligible for reporting if one or more of the Guardian Military Connection record(s) OVERLAPS the reporting window. If the student is NOT eligible do NOT create a record and EXIT Reserve Military Dependent classification logic ELSE continue

Using the LATEST Military Connection Start Date, compare the Military Connection Start Date to the Enrollment Start Date and Populate Student Classify Begin Date using the following conditions:

  • If the Military Connection Start Date is AFTER the Student’s Enrollment End Date do NOT create a record and EXIT Reserve Military Dependent classification logic
  • If the Military Connection Start Date is AFTER the Enrollment Start Date, populate Student Classify Begin Date with the Military Connection Start Date
  • ELSE, populate Student Classify Begin Date with the student’s Enrollment Start Date

Populate End Date using the following logic:

Using the calendar tied to the student's enrollment, identify the date of the AE Day Event Type

Using all records whose start date falls within the reporting window, find the LATEST Military Connection End Date and complete the following logic:

If the End Date is Null or Blank populate Zeros

ELSE

If the End Date is AFTER the AE date populate zeros

ELSE

If the End Date is BEFORE or ON the AE Date complete the following logic:

If the End Date is AFTER the Student's Enrollment End date, populate the Student's Enrollment End Dat

Else populate End Date

Additionally, report the following:

  • Populate Student Classification Type with "6"

militaryConnections.startDate

militaryConnections.endDate


System Administration > Calendar > Start Date
System Administration > Calendar > Calendar > End Date
Census > People >  Military Connections > Start Date
Census > People >  Military Connections > End Date
Census > People > Relationships > End Date
7Juvenile Court Referral

Based on the enrollment, if Juvenile Court Referral is checked, report the following:

  • Populate Student Classification Type with "7"
  • Populate Student Classify Begin Date with Enrollment Start Date
  • Populate Student Classify End Date with Enrollment End Date

Calculated based on EnrollmentTN.juvenileCourtReferral

Enrollment.startDate

Enrollment.endDate


Student Information > General > Enrollment > State Reporting Fields > Juvenile Court Referral
Student Information > General > Enrollment > Start Date
Student Information > General > Enrollment > End Date

8IEA Program

Based on the enrollment, if IEA Program is checked, report the following:

  • Populate Student Classification Type with "8"
  • Populate Student Classify Begin Date with Enrollment Start Date
  • Populate Student Classify End Date with Enrollment End Date

EnrollmentTN.ieaProgram

Enrollment.startDate

Enrollment.endDate


Student Information > General > Enrollment > State Reporting Fields > IEA Program
Student Information > General > Enrollment > Start Date
Student Information > General > Enrollment > End Date

AAlternative

Based on the school tied to the student enrollment,

If School Org Type equals "02"

OR

If School Org Type NOT equal "02" AND Alternative is checked

  • Populate Student Classification Type with "A"
  • Populate Student Classify Begin Date with Enrollment Start Date
  • Populate Student Classify End Date with Enrollment End Date

Calculated based on School.type and EnrollmentTN.alternative

Enrollment.startDate

Enrollment.endDate


System Administration > Resources > School > School Org Type
Student Information > General > Enrollment > State Reporting Fields > Alternative
Student Information > General > Enrollment > Start Date
Student Information > General > Enrollment > End Date
BFee Based P3, P4

The Fee Based P3, P4 classification is given to a sub-set of students within a section. Based on the student enrollment query all sections the student is rostered in. 

If Fee Based P3, P4 is selected from P3/P4 Classifications on Roster Batch Editon one or more of the of the section(s), complete the following logic:

If the state grade tied to grade on the enrollment is equal to P3 OR P4 continue, else exit logic

  • Populate Student Classification Type with "B"
  • Populate Student Classify Begin Date using the following logic:
    • If Roster Start Date is not equal to null or blank, populate Student Classify Start Date using the Roster Start Date ELSE report earliest scheduled term start date.
  • Populate Student Classify End Date using the following logic:
    • If the Roster End Date is NOT NULL populate Student Classify End Date with Roster End Date ELSE populate the latest Term End Date

Calculated based on Roster.stateUseFlag

Roster.startDate

Term.startDate

Roster.endDate

Term.endDate


Student Information > General > Enrollments > Grade
Course > Section > Roster Batch Edit > P3/P4 Classifications

Student Information > General > Schedule > Start Date

System Administration > Calendar > Terms > Start Date

Student Information > General > Enrollment > Start Date
Student Information > General > Enrollment > End Date

Student Information > General > Schedule > End Date

System Administration > Calendar > Terms > End Date


DAdult

Based on the school tied to the student enrollment, if School Org Type = "01", report the following:

  • Populate Student Classification Type with "D"
  • Populate Student Classify Begin Date with Enrollment Start Date
  • Populate Student Classify End Date with Enrollment End Date

Calculated based on School.type

Enrollment.startDate

Enrollment.endDate


System Administration > Resources > School > School Org Type; Student Information > General > Enrollment > Start Date, End Date

DYS02Screened for Dyslexia

Using the calendar tied to the student enrollment, identify a reporting window using the dates of the following Day Event Types. If more than one instance of these Day Event Types exist, use the earliest instance.

  • 'AS' - the start of the reporting window
  • 'AE' - the end of the reporting window

Review the students Dyslexia records

Dyslexia records whose End Dates are BEFORE the reporting window are not eligible for reporting.

ELSE

A student is considered eligible for reporting if one or more Dyslexia record(s) has a Start Date equal to NOT NULL AND is NOT AFTER the reporting window and has Screened = Yes.

In other words students may report Dyslexia if one or more Dyslexia records have a Start Date equal to NOT NULL AND is BEFORE, ON OR WITHIN the reporting window.

If the Student has more than one record that is considered eligible for reporting Dyslexia use the record with the LATEST start date to report the classification

Report the Dyslexia classification record using the following logic:

Populate Student Classification Type with "DYS02"

Report Start Date using the following logic:

If the Dyslexia Start Date is BEFORE the date of the earliest instance of Day Event Type "AS"

Populate Student Classify Begin Date with Enrollment Start Date

ELSE

If the Enrollment Start Date is AFTER the Dyslexia Record Start Date, Populate Enrollment Start Date

ELSE

Populate Student Classify Begin Date with Dyslexia Start Date

Report End Date using the following logic:

If the Dyslexia End Date is BEFORE the date of the earliest instance of Day Event Type "AE"

Populate Student Classify End Date with Dyslexia End Date

ELSE

Populate zeros

dyslexia.startDate

dysleixa.endDate


System Administration > Calendar > Calendar > Days > Day Event Type
Student Information > Program Participation > State Programs >  Dyslexia > Receiving Specific Intervention
Student Information > Program Participation > State Programs >  Dyslexia > Start Date
Student Information > Program Participation > State Programs >  Dyslexia > End Date
Student Information > General > Enrollment > Start Date

DYS03Receiving Dyslexia Specific Intervention

Using the calendar tied to the student enrollment, identify a reporting window using the dates of the following Day Event Types. If more than one instance of these Day Event Types exist, use the earliest instance.

  • 'AS' - the start of the reporting window
  • 'AE' - the end of the reporting window

Review the students Dyslexia records

Dyslexia records whose End Dates are BEFORE the reporting window are not eligible for reporting.

ELSE

A student is considered eligible for reporting if one or more Dyslexia record(s) has a Start Date equal to NOT NULL AND is NOT AFTER the reporting window and has Receiving Intervention = Yes.

In other words students may report Dyslexia if one or more Dyslexia records have a Start Date equal to NOT NULL AND is BEFORE, ON OR WITHIN the reporting window.

If the Student has more than one record that is considered eligible for reporting Dyslexia use the record with the LATEST start date to report the classification

Report the Dyslexia classification record using the following logic:

Populate Student Classification Type with "DYS02"

Report Start Date using the following logic:

If the Dyslexia Start Date is BEFORE the date of the earliest instance of Day Event Type "AS"

Populate Student Classify Begin Date with Enrollment Start Date

ELSE

If the Enrollment Start Date is AFTER the Dyslexia Record Start Date, Populate Enrollment Start Date

ELSE

Populate Student Classify Begin Date with Dyslexia Start Date

Report End Date using the following logic:

If the Dyslexia End Date is BEFORE the date of the earliest instance of Day Event Type "AE"

Populate Student Classify End Date with Dyslexia End Date

ELSE

Populate zeros

dyslexia.startDate

dysleixa.endDate


System Administration > Calendar > Calendar > Days > Day Event Type
Student Information > Program Participation > State Programs >  Dyslexia > Screened
Student Information > Program Participation > State Programs >  Dyslexia > Start Date
Student Information > Program Participation > State Programs >  Dyslexia > End Date
Student Information > General > Enrollment > Start Date

EHead Start Funded P3, P4

The Head Start Funded P3, P4 classification is given to a sub-set of students within a section. Based on the student enrollment query all sections the student is rostered in. 

If Head Start Funded P3, P4 is checked on one or more of the of the section(s), complete the following logic:

If the state grade tied to grade on the enrollment is equal to P3 OR P4 continue, else exit logic

  • Populate Student Classification Type with "E"
  • Populate Student Classify Begin Date using the following logic:
    • If Roster Start Date is not equal to null or blank, populate Student Classify Start Date using the Roster Start Date ELSE report earliest scheduled term start date.
  • Populate Student Classify End Date using the following logic:
    • If the Roster End Date is NOT NULL populate Student Classify End Date with Roster End Date ELSE populate the latest Term End Date

Roster.specialCode

Roster.startDate

Term.startDate

Roster.endDate

Term.endDate

Student Information > General > Enrollments > Grade
Course > Section > Roster Batch Edit > Fee Based P3, P4

Student Information > General > Schedule > Start Date

System Administration > Calendar > Terms > Start Date

Student Information > General > Enrollment > Start Date
Student Information > General > Enrollment > End Date

Student Information > General > Schedule > End Date

System Administration > Calendar > Terms > End Date

FLocally Funded P3, P4

The Locally Funded P3, P4 classification is given to a sub-set of students within a section. Based on the student enrollment query all sections the student is rostered in. 

If Locally Funded P3, P4 is checked on one or more of the of the section(s), complete the following logic:

If the state grade tied to grade on the enrollment is equal to P3 OR P4 continue, else exit logic

  • Populate Student Classification Type with "F"
  • Populate Student Classify Begin Date using the following logic:
    • If Roster Start Date is not equal to null or blank, populate Student Classify Start Date using the Roster Start Date ELSE report earliest scheduled term start date.
  • Populate Student Classify End Date using the following logic:
    • If the Roster End Date is NOT NULL populate Student Classify End Date with Roster End Date ELSE populate the latest Term End Date

Roster.specialCode

Roster.startDate

Term.startDate

Roster.endDate

Term.endDate

Student Information > General > Enrollments > Grade
Course > Section > Roster Batch Edit > Fee Based P3, P4

Student Information > General > Schedule > Start Date

System Administration > Calendar > Terms > Start Date

Student Information > General > Enrollment > Start Date
Student Information > General > Enrollment > End Date

Student Information > General > Schedule > End Date

System Administration > Calendar > Terms > End Date

FOS01Foster Care

Using the calendar tied to the student enrollment, identify a reporting window using the dates of the following Day Event Types. If more than one instance of these Day Event Types exist, use the earliest instance.

  • 'AS' - the start of the reporting window
  • 'AE' - the end of the reporting window

If the student has one or more Foster Care records, use the LATEST record to determine the student's reporting eligibility:

A student is considered eligible for reporting if the Foster Care record start date is on or within the reporting window

If the student is eligible, Compare the Foster Care Date to the Enrollment Start Date:

If the Foster Care Start Date is AFTER the Student’s Enrollment End Date do not create a record and exit Foster Care classification logic ELSE continue:

If the Foster Care Start Date is AFTER the Enrollment Start Date, populate Student Classify Begin Date with the Foster Care Start Date

ELSE

Populate Student Classify Begin Date with the student’s Enrollment Start Date

Additionally, report the following:

  • Populate Student Classification Type with "FOS01"
  • Populate Student Classify End Date with the Foster Care End Date

fostercare.startDate

fostercare.endDate


System Administration > Calendar > Calendar > Days > Day Event Type
System Administration > Calendar > Calendar > End Date
Student Information > General > Program Participation > Foster Care > Start Date
Student Information > General > Program Participation > Foster Care > End Date
Student Information > General > Enrollment > Start Date


HHomeless 

Using the calendar tied to the student enrollment, identify a reporting window using the dates of the following Day Event Types. If more than one instance of these Day Event Types exist, use the earliest instance.

  • 'CS' - the start of the reporting window
  • 'CE' - the end of the reporting window

If the student has one or more homeless records, use the LATEST record to determine the student's reporting eligibility:

A student is considered eligible for reporting if the Homeless record start date is on or within the reporting window AND If Homeless Nighttime Residence is not equal to null or blank AND/OR Unaccompanied Youth is not equal to null or blank

If the student is eligible, complete the following logic:

If the Homeless Start Date is AFTER the Student’s Enrollment End Date do not create a record and exit Homeless classification logic ELSE continue:

Compare the Homeless Start Date to the Enrollment Start Date

If the Homeless Start Date is BEFORE, ON OR AFTER the Enrollment Start Date, populate Student Classify Begin Date with the Homeless Start Date

ELSE

Populate Student Classify Begin Date with the student’s Enrollment Start Date

Additionally, report the following:

  • Populate Student Classification Type with "H"
  • Populate Student Classify End Date with the Homeless End Date


Homeless.primary NightTimeResidence

Homeless.unaccompaniedYouth

Homeless.startDate

Homeless.endDate

System Administration > Calendar > Calendar > Days > Day Event Type
Student Information > General > Program Participation > Homeless > Homeless Nighttime Residence
Student Information > General > Program Participation > Homeless > Unaccompanied Youth
Student Information > General > Program Participation > Homeless > Start Date
Student Information > General > Program Participation > Homeless > End Date
Student Information > General > Enrollments > Start Date
Student Information > General > Enrollments > End Date

IMigrant

Using the calendar tied to the student enrollment, identify a reporting window using the dates of the following Day Event Types. If more than one instance of these Day Event Types exist, use the earliest instance.

  • 'AS' - the start of the reporting window
  • 'AE' - the end of the reporting window

If the student is participating in a program OR flag AND the associated code = "i" OR "I" AND the program or flag is marked as State Reported AND the program or flag Start Date is on or within the Reporting Window, use the LATEST record to complete the following logic:

  • Populate Student Classification Type with State Classification Code

If the classification is a program, complete the following logic:

  • If Program Start date is NOT equal to null, populate Student Classify Begin Date with Program Start Date ELSE populate Student Classify Begin Date with Program Session Start Date
  • If Program End date is NOT equal to null, populate Student Classify End Date with Program End Date ELSE populate Student Classify End Date with Program Session End Date

Else, If the classification is a flag, report the following:

  • Populate Student Classify Begin Date with Flag Start Date
  • Populate Student Classify End Date with Flag End Date

ProgramParticipation.code

ProgramParticipation.startDate

ProgramSessiom.startDate

ProgramParticipation.endDate

ProgramSessiom.endDate

Student Information > General > Program participation > Programs > Program (Code), Start Date; Student Information > General > Flags > Flag (Code), Start Date; Program Admin > Programs > Programs > State Reported; Program Admin > Flags > State Reported

JDC01-18Juvenile Detention Center

Using the calendar tied to the student enrollment, identify a reporting window using the dates of the following Day Event Types. If more than one instance of these Day Event Types exist, use the earliest instance.

  • 'AS' - the start of the reporting window
  • 'AE' - the end of the reporting window

Review the students Detention Center records

Detention Center records whose End Dates are BEFORE the reporting window are not eligible for reporting.

ELSE

A student is considered eligible for reporting if one or more Detention Center record(s) has a Start Date equal to NOT NULL AND is NOT AFTER the reporting window.

In other words students may report a Detention Center record if one or more Detention Center records have a Start Date equal to NOT NULL AND is BEFORE, ON OR WITHIN the reporting window.

If the Student has more than one record that is considered eligible for reporting a Detention Center, report period begin and end dates for each.

Report the Detention Center classification record using the following logic:

Populate Student Classification Type with the code of the Detention Center

Report Start Date using the following logic:

  1. If the Detention Center Start Date is BEFORE the Start Date of the enrollment and calendar event AS,
    1. Populate Student Classify Begin Date with Enrollment Start Date
  2. ELSE
    1. Populate Student Classify Begin Date with Detention Center Start Date

Report End Date using the following logic:

  1. If the Detention Center End Date is BEFORE or matches the Enrollment End Date,
    1. Populate Student Classify End Date with the Detention Center End Date
  2. If Detention Center End Date is AFTER the Enrollment End Date
    1. Populate Student Classify End Date with the Enrollment End Date
  3. If Detention Center End Date is AFTER the calendar event AE and Enrollment End Date is NULL,
    1. Populate the date of the earliest instance of Day Event Type "AE"

DetentionCenter. detentionCenterID

DetentionCenter.startDate

DetentionCenter.endDate

System Administration > Calendar > Calendar > Days > Day Event Type
Student Information > Program Participation > State Programs > Detention Center > Start Date
Student Information > Program Participation > State Programs > Detention Center > End Date
Student Information > Program Participation > State Programs > Detention Center > Detention Center
Student Information > General > Enrollment > Start Date

K-IN
K-OUT
Residential Mental Health

Using the calendar tied to the student enrollment, identify a reporting window using the dates of the following Day Event Types. If more than one instance of these Day Event Types exist, use the earliest instance.

  • 'AS' - the start of the reporting window
  • 'AE' - the end of the reporting window

If the student is participating in a program(s) OR flag(s) AND the State Classification code = "K-IN" OR "K-OUT" AND the program or flag is marked as State Reported AND the program or flag Start Date is on or within the Reporting Window, use the LATEST record to complete the following logic:

  • Populate Student Classification Type with State Classification Code

If the classification is a program, complete the following logic:

  • If Program Start date is NOT equal to null, populate Student Classify Begin Date with Program Start Date ELSE populate Student Classify Begin Date with Program Session Start Date
  • If Program End date is NOT equal to null, populate Student Classify End Date with Program End Date ELSE populate Student Classify End Date with Program Session End Date

Else, If the classification is a flag, report the following:

  • Populate Student Classify Begin Date with Flag Start Date
  • Populate Student Classify End Date with Flag End Date

ProgramParticipation.code

ProgramParticipation.startDate

ProgramSessiom.startDate

ProgramParticipation.endDate

ProgramSessiom.endDate

Student Information > Program Participation > Programs > State Classification, Start Date; Student Information > General > Flags > State Classification, Start Date; Program Admin > Programs > Programs > State Reported; Program Admin > Flags > State Reported

LPre-K EconDis

If the state grade tied to grade on the enrollment is equal to P3 OR P4, complete the following logic:

If Pre-K EconDis is checked, report the following:

  • Populate Student Classification Type with "L"
  • Populate Student Classify Begin Date with Enrollment Start Date
  • Populate Student Classify End Date with Enrollment End Date

EnrollmentTN.preKEcondDis

Enrollment.startDate

Enrollment.endDate

Student Information > General > Enrollment > State Reporting Fields > Pre-K EconDis
MFMedicaod Free

If the state grade tied to grade on the student enrollment is not equal to P3 OR P4, complete the following logic:

Using the latest FRAM record dated within the Active Year associated to the enrollment

If the Student's Source = Direct or Non-Direct, FRAM Eligibility = Free AND the Student's Certified Type is = Medicaid

Report the following:

  • Populate Student Classification Type with "MF" 
  • Populate Student Classify Begin Date with the student's Enrollment Start Date
  • Populate Student Classify End Date with the FRAM Eligibility End Date

POSEligibility.startDate

POSEligibility.endDate


Student Information > General > Enrollments > Grade
Student Information > General > Enrollments > Start Date

FRAM > Eligibility > Eligibility
FRAM > Eligibility > Certified Type

MRMedicaid Reduced

If the state grade tied to grade on the student enrollment is not equal to P3 OR P4, complete the following logic:

Using the latest FRAM record dated within the Active Year associated to the enrollment

If the Student's Source = Direct or Non-Direct, FRAM Eligibility = Reduced AND the Student's Certified Type is = Medicaid

Report the following:

  • Populate Student Classification Type with "MR" 
  • Populate Student Classify Begin Date with the student's Enrollment Start Date
  • Populate Student Classify End Date with the FRAM Eligibility End Date

POSEligibility.startDate

POSEligibility.endDate


Student Information > General > Enrollments > Grade
Student Information > General > Enrollments > Start Date

FRAM > Eligibility > Eligibility
FRAM > Eligibility > Certified Type

PPrivate School

Based on the enrollment, if Private School is checked complete the following logic:

  • Populate Student Classification Type with "P"
  • Populate Student Classify Begin Date with Enrollment Start Date
  • Populate Student Classify End Date with Enrollment End Date

Enrollment.privateSchooled

Enrollment.startDate

Enrollment.endDate

Student Information > General > Enrollment > State Reporting Fields > Private School
PDG01PDG Expansion

The PDG Expansion classification is given to a sub-set of students within a section. Based on the student enrollment query all sections the student is rostered in.

If PDG Expansion is checked on one or more of the of the section(s), complete the following logic:

If the state grade tied to grade on the enrollment is equal to P3 OR P4 continue, else exit logic

  • Populate Student Classification Type with "PDG01"
  • Populate Student Classify Begin Date using the following logic:
    • If Roster Start Date is not equal to null or blank, populate Student Classify Start Date using the Roster Start Date ELSE report earliest scheduled term start date.
  • Populate Student Classify End Date using the following logic:
    • If the Roster End Date is NOT NULL populate Student Classify End Date with Roster End Date ELSE populate the latest Term End Date
roster.specialCode

Student Information > General > Enrollments > Grade
Course > Section > Roster Batch Edit > Fee Based P3, P4

Student Information > General > Schedule > Start Date

System Administration > Calendar > Terms > Start Date

Student Information > General > Enrollment > Start Date
Student Information > General > Enrollment > End Date

Student Information > General > Schedule > End Date

System Administration > Calendar > Terms > End Date


PDG02VPK Grant

The VPK Grant classification is given to a sub-set of students within a section. Based on the student enrollment query all sections the student is rostered in.

If VPK Grant is checked on one or more of the of the section(s), complete the following logic:

If the state grade tied to grade on the enrollment is equal to P3 OR P4 continue, else exit logic

  • Populate Student Classification Type with "PDG02"
  • Populate Student Classify Begin Date using the following logic:
    • If Roster Start Date is not equal to null or blank, populate Student Classify Start Date using the Roster Start Date ELSE report earliest scheduled term start date.
  • Populate Student Classify End Date using the following logic:
    • If the Roster End Date is NOT NULL populate Student Classify End Date with Roster End Date ELSE populate the latest Term End Date
roster.specialCode

Student Information > General > Enrollments > Grade

Course > Section > Roster Batch Edit > Fee Based P3, P4

Student Information > General > Schedule > Start Date

System Administration > Calendar > Terms > Start Date

Student Information > General > Enrollment > Start Date
Student Information > General > Enrollment > End Date

Student Information > General > Schedule > End Date

System Administration > Calendar > Terms > End Date


QState Funded: Expansion/Pilot

The State Funded: Expansion/Pilot classification is given to a sub-set of students within a section. Based on the student enrollment query all sections the student is rostered in.

If State Funded: Expansion/Pilot is checked on one or more of the of the section(s), complete the following logic:

If the state grade tied to grade on the enrollment is equal to P3 OR P4 continue, else exit logic

  • Populate Student Classification Type with "Q"
  • Populate Student Classify Begin Date using the following logic:
    • If Roster Start Date is not equal to null or blank, populate Student Classify Start Date using the Roster Start Date ELSE report earliest scheduled term start date.
  • Populate Student Classify End Date using the following logic:
    • If the Roster End Date is NOT NULL populate Student Classify End Date with Roster End Date ELSE populate the latest Term End Date

Roster.specialCode

Roster.startDate

Term.startDate

Roster.endDate

Term.endDate

Course > Section > Roster Batch Edit > P3/P4 Classification  > Locally Funded P3, P4; Student Information > General > Enrollment > Start Date, End Date Student Information > General > Schedule > Start Date, End Date; System Administration > Calendar > Terms > Start Date, End Date

R, TTitle 1, Regular

If the state grade tied to grade on the student enrollment is equal to P3 OR P4, complete the following logic: 

Based on the student enrollment query all sections the student is rostered in. If Title 1 is is checked on one ore more of the section(s), populate Student Classification Type with "T" else populate "R" and report the following:

  • Populate Student Classify Begin Date with Enrollment Start Date
    • Populate Student Classify End Date with Enrollment End Date

ELSE

Based on the school tied to the student enrollment; If Title 1 is equal to "Schoolwide Program" populate Student Classification Type with "T" else populate "R" and report the following values:

  • Populate Student Classify Begin Date with Enrollment Start Date
  • Populate Student Classify End Date with Enrollment End Date

Section.title1

SchoolAttribute.title1

Enrollment.startDate

Enrollment.endDate

Student Information > General > Enrollments > Grade; Scheduling > Course > Section > Title 1; System Administration > Resources > School > Program Participation > Title 1

WImagination Library

Using the calendar tied to the student enrollment, identify a reporting window using the dates of the following Day Event Types. If more than one instance of these Day Event Types exist, use the earliest instance.

  • 'AS' - the start of the reporting window
  • 'AE' - the end of the reporting window

If the state grade tied to grade on the student enrollment is equal to P3 OR P4 OR K, complete the following logic:

If the student is participating in a program OR flag AND the associated code = "w" OR "W" AND the program or flag is marked as State Reported AND the program or flag Start Date is on or within the Reporting Window, use the LATEST record to complete the following logic:

  • Populate Student Classification Type with State Classification Code

If the classification is a program, complete the following logic:

  • If Program Start date is NOT equal to null, populate Student Classify Begin Date with Program Start Date ELSE populate Student Classify Begin Date with Program Session Start Date
  • If Program End date is NOT equal to null, populate Student Classify End Date with Program End Date ELSE populate Student Classify End Date with Program Session End Date

Else, If the classification is a flag, report the following:

  • Populate Student Classify Begin Date with Flag Start Date
  • Populate Student Classify End Date with Flag End Date

ProgramParticipation.code

ProgramParticipation.startDate

ProgramSessiom.startDate

ProgramParticipation.endDate

ProgramSessiom.endDate

Student Information > General > Enrollments > Grade; Student Information > Program Participation > Programs > Program (Code), Start Date; Student Information > General > Flags > Flag (Code), Start Date; Program Admin > Programs > Programs > State Reported; Program Admin > Flags > State Reported

SNSnap Recipient
  1. If the state grade tied to grade on the student enrollment is not equal to P3 OR P4, complete the following logic:
  2. Using the latest FRAM record dated within the Active Year associated to the enrollment
    1. If the Student's FRAM Eligibility Source is marked as Direct AND the Student's Certified Type is equal to SNAP, report the following:
      1. Populate Student Classification Type with "SN" 
      2. Populate Student Classification Begin Date with the student's Enrollment Start Date
      3. Populate Student Classification End Date with the FRAM Eligibility End Date

Student Information > General > Enrollments > Grade
Student Information > General > Enrollments > Start Date

FRAM > Eligibility > Source
FRAM > Eligibility > Certified Type

TOTANF Recipient
  1. If the state grade tied to grade on the student enrollment is not equal to P3 OR P4, complete the following logic:
  2. Using the latest FRAM record dated within the Active Year associated to the enrollment
    1. If the Student's FRAM Eligibility Source is marked as Direct AND the Student's Certified Type is equal to TANF, report the following:
      1. Populate the Student Classification Type with "TO"
      2. Populate the Student Classification Begin Date with the student's Enrollment Start Date
      3. Populate the Student Classification End Date with the FRAM Eligibility End Date

Student Information > General > Enrollments > Grade
Student Information > General > Enrollments > Start Date

FRAM > Eligibility > Source
FRAM > Eligibility > Certified Type

XFree Lunch by Application
  1. If the state grade tied to grade on the student enrollment is not equal to P3 OR P4, complete the following logic:
  2. Using the latest FRAM record dated within the Active Year associated to the enrollment
    1. If the Student's FRAM Eligibility = Free, report the following:
      1. Populate Student Classification Type with "X" 
      2. Populate Student Classification Begin Date with the student's Enrollment Start Date
      3. Populate Student Classification End Date with the FRAM Eligibility End Date


Student Information > General > Enrollments > Grade
Student Information > General > Enrollments > Start Date

FRAM > Eligibility

Reduced Lunch by Application
  1. If the state grade tied to grade on the student enrollment is not equal to P3 OR P4, complete the following logic:
  2. Using the latest FRAM record dated within the Active Year associated to the enrollment
    1. If the Student's FRAM Eligibility = Reduced, report the following
      1. Populate Student Classification Type with "Y" 
      2. Populate Student Classification Begin Date with the student's Enrollment Start Date
      3. Populate Student Classification End Date with the FRAM Eligibility End Date

Student Information > General > Enrollments > Grade
Student Information > General > Enrollments > Start Date

FRAM > Eligibility


Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Sav

Save