Tennessee Ed-Fi Data v3.1 - Student Education Organization Associations

Last Modified on 10/22/2022 10:37 am CDT

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This association represents student information that is specific to a student’s relationship with an Education Organization.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Note: An enrollment record should send for each specific enrollment in the scope year. This resource will match StudentSchoolAssociation.

Action	Trigger
Post	When an enrollment is created and saved for a person and the enrollment overlaps a configured year. Do not send a record if enrollment is in a calendar marked as State Exclude. Do not send a record if enrollment is in a School marked as State Exclude. Do not send a record if the No Show checkbox is checked on the enrollment. Do not send a record if the Service Type is N. Do not send records if the student is tied to a calendar grade level that is marked as excluded from state reporting.
Post	When the start date for an enrollment is changed.
Put	When any student data is edited for the person in the Data Elements fields below: When the person’s identity record is changed: Race/Ethnicity, Gender, Home Primary Language. When a student's EL information is changed: Program Status, Identified Date, EL Exit Date, Parent Refused. When any of the Student Characteristics change. When a student's homeless record is changed. When a student's identification codes are changed (State ID, Student PIN, or Local Student Number).
Delete	This record will delete if the student no longer has an eligible enrollment in the District.
Delete	If the enrollment is marked as a No Show.
Delete	When the start date of an enrollment is changed.

Resource Toggle and Resync Logic

This table describes the Resource Toggle and Trigger logic of this object.

Action	Business Rule
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Resync	If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
Resync	If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
Resync	If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

Action	Business Rule
Post/Delete	Natural Key Change: If the District Number/Ed-Fi District Number changes, a delete/post will occur with the cascading deletes from the LEA ID Change triggers. If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
Delete	Cascading Deletes: N/A - no dependent resources

Scope Year Logic

This table describes scope year logic of this object.

Logic
The record will send to the scope year for the school year the enrollment is associated with. The enrollment must overlap with the scope year to report. Data will only send for the years that have valid configuration.
When using data in Campus that has a single date, the following logic will be applied to determine the scope year(s) to report the data to. Current Year: Records will be compared to today's date to determine if the record is eligible to report. Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used. Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.
When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to. Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date. Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used. Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Logic

The record will send to the scope year for the school year the enrollment is associated with.

The enrollment must overlap with the scope year to report.
Data will only send for the years that have valid configuration.

When using data in Campus that has a single date, the following logic will be applied to determine the scope year(s) to report the data to.

Current Year: Records will be compared to today's date to determine if the record is eligible to report.
Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.
Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.

Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date.
Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.
Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Limited English Proficiency Descriptor	EL Program Status
Disability Descriptor	Disability
Language Descriptor	Home Primary Language
Race Descriptor	Race/Ethnicity
Student Characteristic Descriptor	Career Tech Special Populations
	Economic Disadvantaged
	Foster Care
	Homeless
	Parent in Military
	US Entry Type
	Flags

Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectType	Object Key Data Source
Person	personID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
enrollment	Post/Put/Delete Put	The primary table used for sending data for this resource. Reports Disabilities
identity	Put	Reports Hispanic or Latino, Gender, Home Primary Language, US Entry Type.
person	Put	Reports the Ed-FI ID.
contact	Put	Reports the Telephone and Email information.
householdlocation	Put	Determines if address is marked as Mailing or Private.
householdmember	Put	Determines household membership with Start Date, End Date, Private.
address	Put	PO Box, Number, Prefix, Street, Tag, Direction, Apt, City, State, Zip
raceethnicity	Put	Reports Races.
plantype	Put	Reports Indicators.
plan	Put	Reports Disabilities, Indicators.
planstate	Put	Reports Disabilities.
programs	Put	Reports any Characteristic created in Flags.
programparticipation	Put	Reports any Characteristic created in Flags.
Title1	Put	Reports Neglected or Delinquent.
ImpactAidEmployment	Put	Reports Parent in Military.
relatedpair	Put	Guardian checkbox for contact information and Parent in Military.
section504	Put	Reports Section 504 Handicapped.
homeless	Put	Reports Homeless, Unaccompanied Youth, Runaway.

Object Data Elements

This table describes data elements sent within the Student Education Organization Association resource.

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

The unique identifier of the resource.

education
OrganizationId

The identifier assigned to an education organization.

Reports the District Number + School Number.

studentReference

A unique alphanumeric code assigned to a student.

Reports the natural key of the Students resource.

addresses

The set of elements that describes an address, including the street address, city, state, and ZIP code.

This is optional, does not report.

Household Addresses> Mailing

Household Membership> Start Date

Household Addresses> Start Date

HouseholdLocation.

mailing

HouseholdMember.

startDate

Householdlocation.

StartDate

cohortYears

The type and year of a cohort (e.g., 9th grade) the student belongs to as determined by the year that student entered a specific grade.

See array section for specific logic.

Student Information > General > Graduation

disabilities

The disability condition(s) that best describes an individual’s impairment, as determined by evaluation(s) conducted by the education organization.

This is optional, does not report.

electronicMails

The numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the individual or organization belongs.

This is optional, does not report.

Census> People> Demographics> Email

contact.email

hispanicLatino
Ethnicity

An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. The term, "Spanish origin," can be used in addition to "Hispanic or Latino."

Report "Is the individual Hispanic/Latino?" from the student's current identity:
- If droplist is = Yes, report "true".
- If droplist is = No, report "false".

Census>People>Identities> Is the Individual Hispanic or Latino?

identity.hispanicEthnicity

international
Addresses

The set of elements that describes an international address.

This is optional, does not report.

languages

The language(s) the individual uses to communicate. It is strongly recommended that entries use only ISO 639-3 language codes.

See Array section for specific logic.

limitedEnglish
ProficiencyDescriptor

An indication that the student has been identified as limited English proficient by the Language Proficiency Assessment Committee (LPAC), or English proficient.

ode	Logic
L	If EL Program Status equals “EL” AND Parent Declined check box IS NOT checked.
N	If EL Program Status equals "Not EL". OR If Census > People > Demographics > Home Primary Language does not equal “ENG: English” AND the student does NOT have history of an EL record.
E	If Census > People > Demographics > Home Primary Language equals “ENG: English”. OR If Census > People > Demographics > Home Primary Language equals Null or Blank AND the student does NOT have history of an EL record.
W	If EL Program Status equals “EL” AND Parent Declined check box IS checked.
1	If EL Program Status equals "Exited EL" AND the current calendar date is on OR between the Program Exit Date and First Year monitoring Date.
2	If EL Program Status equals "Exited EL" AND the current calendar date is between the First Year monitoring Date and Second Year monitoring Date.
3	If EL Program Status equals "Exited EL" AND the current calendar date is between the Second Year monitoring Date and Third Year monitoring Date.
4	If EL Program Status equals "Exited EL" AND the current calendar date is between the Third Year monitoring Date and Fourth Year monitoring Date.
F	If EL Program Status equals "Exited EL" AND the current calendar date is AFTER the Fourth Year monitoring Date.

Student Information> Program Participation> English Learners (EL)

lep.programStatus

lep.identifieddate

lep.exitDate

lep.parentDeclined

loginId

The login ID for the user; used for security access control interface.

This is optional, does not report.

oldEthnicityDescriptor

Previous definition of Ethnicity combining Hispanic/latino and race 1 - American Indian or Alaskan Native 2 - Asian or Pacific Islander 3 - Black, not of Hispanic origin 4 - Hispanic 5 - White, not of Hispanic origin.

This is optional, does not report.

N/A

profileThumbnail

File name for the ProfileThumbnail photograph.

This is optional, does not report.

N/A

programParticipations

Key programs the student is participating in or receives services from.

See Array section for specific logic.

races

The general racial category which most clearly reflects the individual’s recognition of his or her community or with which the individual most identifies. The data model allows for multiple entries so that each individual can specify all appropriate races.

See Array section below for data logic for each field.

Census> People> Identities> Race/Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

sexDescriptor

A person's gender.

Reports Gender:

Male reports 'M'
Female reports 'F'

Census>People>Identities>Gender

identity.Gender

characteristics

Reflects important characteristics of the student’s home situation: Displaced Homemaker, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, and Unaccompanied Youth.

See Array below for logic.

identificationCodes

A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student.

Report Student State ID, Student PIN, and/or Local Student Number if NOT NULL.
See array for field specific logic.

indicators

Indicator(s) or metric(s) computed for the student (e.g., at risk) to influence more effective education or direct specific interventions.

See Array section for reporting logic.

telephones

The 10-digit telephone number, including the area code, for the person.

See Array section for reporting logic.

tribalAffiliations

An American Indian tribe with which the student is affiliated.

This is optional, does not report.

Student Information > General > Enrollments

_ext.tdoe.entryDate

The month, day, and year on which an individual enters and begins to receive instructional services in a campus.

Report the enrollment start date.

_ext.tdoe.exitWithdrawDate

The month, day, and year of the first day after the date of an individual''s last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school. NEDM: Exit/Withdraw Date.

Report the enrollment end date.

Student Information > General > Enrollments

submittedforSchool
YearTypeReference

Key for School Year

Use the End Date tied to the calendar of the student's enrollment, report the year .

System Administration > Calendar > Calendar > End Date

submittedByEducation
OrganizationReference
.educationOgranizationID

The identifier assigned to an education organization.

Populate the State District Number + State School Number of the student's enrollment.

System Administration > Resources > District Info, School

_etag

A unique system-generated value that identifies the version of the resource.

Array Data Elements

Click here to expand...

Cohort Years

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
cohortYearTypeDescriptor		Reports 'Ninth Grade'.	O
schoolYearTypeReference		Report the year from Date First Entered 9th Grade	O	Studetn Information > General > Graduation > Date First Entered 9th Grade

Student Languages

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
uses	An unordered collection of student Education Organization Association Language Uses. A description of how the language is used (e.g. Home Language, Native Language, Spoken Language).	See the Uses Array section for specific logic.	O

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

languageDescriptor

The language(s) the individual uses to communicate. It is strongly recommended that entries use only ISO 639-3 language codes.

Report the Code from the Home Primary Language saved on the student's current identity record.

If blank, do not report this field.
If the code does not match an Ed-Fi code, do not report a record.
Report the default value if saved on the Attribute and the code matches an Ed-Fi code.

Census > People > Demographics

uses

An unordered collection of student Education Organization Association Language Uses. A description of how the language is used (e.g. Home Language, Native Language, Spoken Language).

See the Uses Array section for specific logic.

Uses

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
languageUseDescriptor	A specification of which written or spoken communication is being used.	Reports 'Native Language'.	O

Races

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
raceDescriptor	The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.	Determine the Race/Ethnicity(s) that are checked on the student's current identity record. Use the Identity Race Ethnicity table to determine all of the check boxes checked for the students current identity id. Report the Ed-Fi Code mapped to the corresponding Race Ethnicity. Report all races if the student has more than 1 selected. Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.	M	Census> People> Identities> Race/Ethnicity	IdentityRaceEthnicity and racethnicity.raceid

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

raceDescriptor

The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.

Determine the Race/Ethnicity(s) that are checked on the student's current identity record.
1. Use the Identity Race Ethnicity table to determine all of the check boxes checked for the students current identity id.
Report the Ed-Fi Code mapped to the corresponding Race Ethnicity.
1. Report all races if the student has more than 1 selected.
Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.

Census> People> Identities> Race/Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

Program Participations

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path
programTypeDescriptor	The type of program.	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, otherwise continue: Compare the Homeless Start Date to the Enrollment Start Date If the Homeless Start Date is ON OR AFTER the Enrollment Start Date, populate beginDate with the Homeless Start Date Otherwise Populate beginDate with the student’s Enrollment Start Date: Additionally, report the following: Populate programTypeDescriptor with "Homeless".	O	Student Information > General > Program Participation > Homeless > Homeless Nighttime Residence Student Information > General > Program Participation > Homeless > Unaccompanied Youth
beginDate		See above logic.
endDate		Populate endDate with the Homeless End Date

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

programTypeDescriptor

The type of program.

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, otherwise continue:
Compare the Homeless Start Date to the Enrollment Start Date
If the Homeless Start Date is ON OR AFTER the Enrollment Start Date, populate beginDate with the Homeless Start Date

Otherwise

Populate beginDate with the student’s Enrollment Start Date:

Additionally, report the following:

Populate programTypeDescriptor with "Homeless".

Student Information > General > Program Participation > Homeless > Homeless Nighttime Residence

Student Information > General > Program Participation > Homeless > Unaccompanied Youth

beginDate

See above logic.

endDate

Populate endDate with the Homeless End Date

Student Characteristics

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
studentCharacteristic Descriptor		Report each characteristic based on the requirements below. Student must have a Student School Association in the configured year to report a characteristic.	O
codeValue = 1	LEAPs Participant Business Definition: Lottery for Education of After-School Programs, TN Grant	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 Based on the student enrollment, complete the following logic: If the student is participating in a program OR flag AND the associated Code = "1", 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: If the classification is a program, complete the following logic: If Program Start date is NOT equal to null, populate beginDate with Program Start Date ELSE populate beginDate with Program Session Start Date. If Program End date is NOT equal to null, populate endDate with Program End Date ELSE populate endDate with Program Session End Date. Otherwise, If the classification is a flag, report the following: Populate beginDate with Flag Start Date. Populate endDate with Flag End Date.	O	System Administration > Calendar > Calendar > Days > Day Event Type Student Information > Program Participation > Programs > Program (Code) Student Information > General > Flags > Flag (Code) Program Admin > Programs > Programs > State Reported Program Admin > Flags > State Reported Student Information > Program Participation > Programs > Start Date Student Information > General > Flags > Start Date	ProgramParticipation. code ProgramParticipation. startDate ProgramSessiom. startDate ProgramParticipation. endDate ProgramSessiom. endDate
codeValue = 2	21st CCL Participant Business Definition: 21st Century Community Learning Centers, ESSA	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 Based on the student enrollment, complete the following logic: If the student is participating in a program OR flag AND the associated code = "2", 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: If the classification is a program, complete the following logic: If Program Start date is NOT equal to null, populate beginDate with Program Start Date ELSE populate beginDate with Program Session Start Date. If Program End date is NOT equal to null, populate endDate with Program End Date ELSE populate endDate with Program Session End Date. Otherwise, If the classification is a flag, report the following: Populate beginDate with Flag Start Date. Populate endDate with Flag End Date.	O	System Administration > Calendar > Calendar > Days > Day Event Type Student Information > Program Participation > Programs > Program (Code) Student Information > General > Flags > Flag (Code) Program Admin > Programs > Programs > State Reported Program Admin > Flags > State Reported Student Information > Program Participation > Programs > Start Date Student Information > General > Flags > Start Date Student Information > Program Participation > Programs > End Date Student Information > General > Flags > End Date	ProgramParticipation. code ProgramParticipation. startDate ProgramSessiom. startDate ProgramParticipation. endDate ProgramSessiom. endDate
codeValue = 4	Active 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 beginDate 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 beginDate with the Military Connection Start Date ELSE, populate beginDate with the student’s Enrollment Start Date Populate endDate 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 Otherwise, If the End Date is AFTER the AE date populate zeros Otherwise, 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 Otherwisepopulate End Date	O	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	militaryConnections. startDate militaryConnections. endDate
codeValue = 5	National 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 beginDate 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 beginDate with the Military Connection Start Date ELSE, populate beginDate 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	O	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	militaryConnections. startDate militaryConnections. endDate
codeValue = 504	Section 504 Business Definition: Section 504 of the Rehabilitation Act of 1973 (29 U.S.C. § 701) which provides protections for individuals with disabilities. The definition for "individuals with disabilities" under Section 504 is more broad than the disability definition for IEPs and the IEP governing process.	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 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: 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 beginDate with Enrollment Start Date ELSE If the Enrollment Start Date is AFTER the 504 Record Start Date, Populate Enrollment Start Date ELSE Populate beginDate 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 endDate with the 504 record End Date ELSE Populate the date of the earliest instance of Day Event Type "AE	O	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	Section504. startDate Section504. endDate
codeValue = 6	Reserve 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 beginDate 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 beginDate with the Military Connection Start Date ELSE, populate beginDate with the student’s Enrollment Start Date Populate endDate 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	O	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	militaryConnections. startDate militaryConnections. endDate
codeValue = 7	Juvenile Court Referral	Based on the enrollment, if Juvenile Court Referral is checked, report the following: Populate studentCharacteristicDescriptor with "7" Populate beginDate with Enrollment Start Date Populate endDate with Enrollment End Date	O	Student Information > General > Enrollment > State Reporting Fields > Juvenile Court Referral Student Information > General > Enrollment > Start Date Student Information > General > Enrollment > End Date	Calculated based on EnrollmentTN. juvenileCourtReferral Enrollment.startDate Enrollment.endDate
codeValue = 8	IEA Program Business Definition: Individual Education Account, TN State funded program for individuals with special needs	Based on the enrollment, if IEA Program is checked, report the following: Populate studentCharacteristicDescriptor with "8" Populate beginDate with Enrollment Start Date Populate endDate with Enrollment End Date	O	Student Information > General > Enrollment > State Reporting Fields > IEA Program Student Information > General > Enrollment > Start Date Student Information > General > Enrollment > End Date	EnrollmentTN. ieaProgram Enrollment. startDate Enrollment. endDate
codeValue = A	Alternative	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 beginDate with Enrollment Start Date Populate endDate with Enrollment End Date	O	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	Calculated based on School.type and EnrollmentTN. alternative Enrollment. startDate Enrollment. endDate
codeValue = B	Fee Based P3, P4 Business Definition: TN State Grant	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 Edit 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 studentCharacteristicDescriptor with "B" Populate beginDate using the following logic: If Roster Start Date is not equal to null or blank, populate beginDate using the Roster Start Date ELSE report earliest scheduled term start date. Populate endDate using the following logic: If the Roster End Date is NOT NULL populate endDate with Roster End Date ELSE populate the latest Term End Date	O	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	Calculated based on: Roster.state UseFlag Roster.startDate Term.startDate Roster.endDate Term.endDate
codeValue = D	Adult	Based on the school tied to the student enrollment, if School Org Type = "01", report the following: Populate studentCharacteristicDescriptor with "D" Populate beginDate with Enrollment Start Date Populate endDate with Enrollment End Date	O	System Administration > Resources > School > School Org Type Student Information > General > Enrollment > Start Date Student Information > General > Enrollment > End Date	Calculated based on: School.type Enrollment. startDate Enrollment. endDate
codeValue = DYS01	Dyslexia Specific	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. 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 studentCharacteristicDescriptor with "DYS01" 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 beginDate with Enrollment Start Date ELSE If the Enrollment Start Date is AFTER the Dyslexia Record Start Date, Populate Enrollment Start Date ELSE Populate beginDate 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 endDate with Dyslexia End Date ELSE Populate zeros	O	System Administration > Calendar > Calendar > Days > Day Event Type Student Information > Program Participation > State Programs > Dyslexia > Start Date Student Information > Program Participation > State Programs > Dyslexia > End Date Student Information > General > Enrollment > Start Date	dyslexia. startDate dysleixa. endDate
codeValue = E	Head Start Funded P3, P4 Business Definition: TN State Grant	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 studentCharacteristicDescriptor with "E" Populate beginDate using the following logic: If Roster Start Date is not equal to null or blank, populate beginDate using the Roster Start Date ELSE report earliest scheduled term start date. Populate endDate using the following logic: If the Roster End Date is NOT NULL populate endDate with Roster End Date ELSE populate the latest Term End Date	O	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	roster. specialCode
codeValue = F	Locally Funded P3, P4 Business Definition: TN State Grant	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 studentCharacteristicDescriptor with "F" Populate beginDate using the following logic: If Roster Start Date is not equal to null or blank, populate beginDate using the Roster Start Date ELSE report earliest scheduled term start date. Populate endDate 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	O	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	roster. specialCode
codeValue = FSO01	Foster 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 beginDate with the Foster Care Start Date ELSE Populate beginDate with the student’s Enrollment Start Date Additionally, report the following: Populate studentCharacteristicDescriptor with "FOS01" Populate endDate with the Foster Care End Date	O	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	fostercare. startDate fostercare. endDate
codeValue = H	Homeless Business Definition: Classification to represent a federal designation of a Student who is Homeless	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 beginDate with the Homeless Start Date ELSE Populate beginDate with the student’s Enrollment Start Date Additionally, report the following: Populate studentCharacteristicDescriptor with "H" Populate endDate with the Homeless End Date	O	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
codeValue = I	Migrant	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: If the classification is a program, complete the following logic: If Program Start date is NOT equal to null, populate beginDate with Program Start Date ELSE populate beginDate with Program Session Start Date If Program End date is NOT equal to null, populate endDate with Program End Date ELSE populate endDate with Program Session End Date Else, If the classification is a flag, report the following: Populate beginDate with Flag Start Date Populate endDate with Flag End Date	O	System Administration > Calendar > Calendar > Days > Day Event Type Student Information > Program Participation > Programs > Program (Code) Student Information > General > Flags > Flag (Code) Program Admin > Programs > Programs > State Reported Program Admin > Flags > State Reported Student Information > Program Participation > Programs > Start Date Student Information > General > Flags > Start Date	ProgramParticipation. code ProgramParticipation. startDate ProgramSessiom. startDate ProgramParticipation. endDate ProgramSessiom. endDate
codeValue = J	Direct Certified Economically Disadvantaged Business Definition: Classification to represent K - 12 economically disadvantaged students	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 FRAM Eligibility Source is marked as Direct AND the Student's Certified Type is equal to one of the following values the student is considered eligibile for reporting: SNAP TANF FDPIR Foster Head Start Homeless Medicaid Migrant Runaway Report the following: Populate studentCharacteristicDescriptor with "J" Populate beginDate with the student's Enrollment Start Date Populate endDate with the FRAM Eligibility End Date	O	Student Information > General > Enrollments > Grade Student Information > General > Enrollments > Start Date FRAM > Eligibility > Source FRAM > Eligibility > Certified Type	Calculated based on POSEligibility. type and POSEligibility. directType POSEligibility. startDate POSEligibility. endDate
codeValue = JDC01 - 17	Juvenile Detention Center Business Definition: The Juvenile Detention Center where the student was remanded	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, use the record with the LATEST start date to report the classification Report the Detention Center classification record using the following logic: Populate studentCharacteristicDescriptor with the code of the Detention Center Report Start Date using the following logic: If the Detention Center Start Date is BEFORE the Start Date of the enrollment and calendar event AS, Populate beginDate with Enrollment Start Date ELSE Populate beginDate with Detention Center Start Date Report End Date using the following logic: If the Detention Center End Date is BEFORE or matches the Enrollment End Date, Populate endDate with the Detention Center End Date If Detention Center End Date is AFTER the Enrollment End Date Populate endDate with the Enrollment End Date If Detention Center End Date is AFTER the calendar event AE and Enrollment End Date is NULL, Populate the date of the earliest instance of Day Event Type "AE"	O	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	detentionCenter. detentionCenterID detentionCenter. startDate detentionCenter. endDate
codeValue = K	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 code = "K" 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: If the classification is a program, complete the following logic: If Program Start date is NOT equal to null, populate beginDate with Program Start Date ELSE populate beginDate with Program Session Start Date If Program End date is NOT equal to null, populate endDate with Program End Date ELSE populate endDate with Program Session End Date Else, If the classification is a flag, report the following: Populate beginDate with Flag Start Date Populate endDate with Flag End Date	O	System Administration > Calendar > Calendar > Days > Day Event Type Student Information > Program Participation > Programs > State Classification Student Information > General > Flags > State Classification Program Admin > Programs > Programs > State Reported Program Admin > Flags > State Reported Student Information > Program Participation > Programs > Start Date Student Information > General > Flags > Start Date	ProgramParticipation. code ProgramParticipation. startDate ProgramSessiom. startDate ProgramParticipation. endDate ProgramSessiom. endDate
codeValue = L	Pre-K EconDis Business Definition: P3/P4 version of Direct Certified Economically Disadvantaged	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 studentCharacteristicDescriptor with "L" Populate beginDate with Enrollment Start Date Populate endDate with Enrollment End Date	O	Student Information > General > Enrollment > State Reporting Fields > Pre-K EconDis Student Information > General > Enrollments > Start Date Student Information > General > Enrollments > End Date	Calculated based on EnrollmentTN. preKEconDis Enrollment.startDate Enrollment.endDate
codeValue = O	Lottery Funded, P4 Only Business Definition: TN State Grant	The Lottery Funded, P4 Only 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 Lottery Funded, P4 Only is checked on one or more of the of the section(s), complete the following logic: If the state grade tide to grade on the enrollment is equal to P4 continue, else exit logic Populate studentCharacteristicDescriptor with "F" Populate beginDate using the following logic: If Roster Start Date is not equal to null or blank, populate beginDate using the Roster Start Date ELSE report earliest scheduled term start date. Populate endDate using the following logic: If the Roster End Date is NOT NULL populate endDate with Roster End Date ELSE populate the latest Term End Date	O	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	roster. specialCode
codeValue = P	Private School	Based on the enrollment, if Private School is checked complete the following logic: Populate studentCharacteristicDescriptor with "P" Populate beginDate with Enrollment Start Date Populate endDate with Enrollment End Date	O	Student Information > General > Enrollment > State Reporting Fields > Private School Student Information > General > Enrollment > Start Date Student Information > General > Enrollment > End Date	Calculated based on Enrollment. privateSchooled Enrollment.startDate Enrollment.endDate
codeValue = PDG01	PDG Expansion Business Definition: Pre-K students funded by PDG expansion with no funding from the VPK grant.	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 studentCharacteristicDescriptor with "PDG01" Populate beginDate using the following logic: If Roster Start Date is not equal to null or blank, populate beginDate using the Roster Start Date ELSE report earliest scheduled term start date. Populate endDate using the following logic: If the Roster End Date is NOT NULL populate endDate with Roster End Date ELSE populate the latest Term End Date	O	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	roster. specialCode
codeValue = PDG02	VPK Grant Business Definition: Pre-K students funded by the VPK grant and PDG grant enhancement.	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 studentCharacteristicDescriptor with "PDG02" Populate beginDate using the following logic: If Roster Start Date is not equal to null or blank, populate beginDate using the Roster Start Date ELSE report earliest scheduled term start date. Populate endDate using the following logic: If the Roster End Date is NOT NULL populate endDate with Roster End Date ELSE populate the latest Term End Date	O	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	roster. specialCode
codeValue = Q	State Funded: Expansion/Pilot Business Definition: TN State Grant	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 studentCharacteristicDescriptor with "Q" Populate beginDate using the following logic: If Roster Start Date is not equal to null or blank, populate beginDate using the Roster Start Date ELSE report earliest scheduled term start date. Populate endDate using the following logic: If the Roster End Date is NOT NULL populate endDate with Roster End Date ELSE populate the latest Term End Date	O	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	roster. specialCode
codeValue = R, T	Title 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 studentCharacteristicDescriptor with "T" else populate "R" and report the following: Populate beginDate with Enrollment Start Date Populate endDate with Enrollment End Date ELSE Based on the school tied to the student enrollment; If Title 1 is equal to "Schoolwide Program" populate studentCharacteristicDescriptor with "T" else populate "R" and report the following values: Populate beginDate with Enrollment Start Date Populate endDate with Enrollment End Date	O	Student Information > General > Enrollments > Grade Course > Section > Title 1 System Administration > Resources > School > Program Participation > Title 1 Student Information > General > Enrollment > Start Date Student Information > General > Enrollment > End Date	Calculated based on CustomSection. value SchoolAttribute.title1 Enrollment.startDate Enrollment.endDate
codeValue = W	Imagination Library Business Definition: TN specifc fund, founded by Dolly Parton	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 studentCharacteristicDescriptor with State Classification Code If the classification is a program, complete the following logic: If Program Start date is NOT equal to null, populate beginDate with Program Start Date ELSE populate beginDate with Program Session Start Date If Program End date is NOT equal to null, populate endDate with Program End Date ELSE populate endDate with Program Session End Date Else, If the classification is a flag, report the following: Populate beginDate with Flag Start Date Populate endDate with Flag End Date	O	System Administration > Calendar > Calendar > Days > Day Event Type Student Information > General > Enrollments > Grade Student Information > Program Participation > Programs > Program (Code) Student Information > General > Flags > Flag (Code) Program Admin > Programs > Programs > State Reported Program Admin > Flags > State Reported Student Information > Program Participation > Programs > Start Date Student Information > General > Flags > Start Date	ProgramParticipation. code ProgramParticipation. startDate ProgramSessiom. startDate ProgramParticipation. endDate ProgramSessiom. endDate
designatedBy		Does not report.	O
periods		Does not report.	O
beginDate		See above for each type's beginDate logic.	M
endDate		See above for each type's endDate logic.	O

Student Identification Codes

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
studentIdentification SystemDescriptor	A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student.	If reporting Student State ID, report 'EIS State ID'. If reporting Student PIN, report 'PIN'. If reporting Local Student Number, report 'Local Student Key'.	M	Census > People > Demographics > Local Student Number and/or Student State ID, Student PIN	person.studentnumber person.stateID
AssigningOrganization IdentificationCode	The organization code or name assigning the assessment identification code.	If reporting Student State ID, report 'State'. If reporting Student PIN, report 'District'. If reporting Local Student Number, report 'District'.	O	Student Information > General> Resource > District Information> Number	district.number
IdentificationCode	A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.	Report the Student State ID. Report the Student PIN. Report the Local Student Number.	M	Census>People>Demographics> Local Student Number	person.studentNumber

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

studentIdentification

SystemDescriptor

A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student.

If reporting Student State ID, report 'EIS State ID'.
If reporting Student PIN, report 'PIN'.
If reporting Local Student Number, report 'Local Student Key'.

Census > People > Demographics > Local Student Number and/or Student State ID, Student PIN

person.studentnumber

person.stateID

AssigningOrganization
IdentificationCode

The organization code or name assigning the assessment identification code.

If reporting Student State ID, report 'State'.
If reporting Student PIN, report 'District'.
If reporting Local Student Number, report 'District'.

Student Information > General> Resource > District Information> Number

district.number

IdentificationCode

A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.

Report the Student State ID.
Report the Student PIN.
Report the Local Student Number.

Census>People>Demographics> Local Student Number

person.studentNumber

Indicators

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
indicatorName	Indicator(s) or metric(s) computed for the student (e.g., at risk) to influence more effective education or direct specific interventions.	Report the name from the RTI plan when the student has a locked plan that overlaps the reporting year If the plan name changes, a resync will need to be done to update. If the student has more than 1 plan in the same school year with the same name, report the plan with the most recent start date.	M	Student Information> Response to Intervention> General> Documents > Plan	PlanType.name Plan.startDate Plan.endDate
designatedBy	The person, organization, or department that made a student designation.	This is optional, does not report.	O
indicator	Indicator or metric computed for the student (e.g., at risk) to influence more effective education or direct specific interventions.	Report the name from the RTI plan.	M	Student Information> Response to Intervention> General> Documents > Plan	PlanType.Name
indicatorGroup	The name for a group of indicators.	This is optional, does not report.	O
periods	The time periods for which the indicator was effective.	This is optional, does not report.
beginDate	The date when the indicator was assigned or computed.	Report the Plan Start Date.	O
endDate	The date the indicator or metric was sunset or removed.	Report the Plan End Date.	O

Telephones

Data Element Label

Business Requirement

Business Rules

M, C, or O

Data Source GUI Path

Database Field

telephoneNumberTypeDescriptor

The type of communication number listed for an individual or organization.

Reports based on the Phone Number type entered in Campus based on the chart below.

Campus Phone	Ed-FI Code
Cell Phone	Mobile
Other Phone	Home
Work Phone	Work
Pager	Other

Census> People> Demographics> Personal Contact Information> Other Phone, Work Phone, Cell Phone, Pager

doNotPublishIndicator

An indication that the telephone number should not be published.

This is optional, does not report.

orderOfPriority

The order of priority assigned to telephone numbers to define which number to attempt first, second, etc.

This is optional, does not report.

telephoneNumber

The telephone number including the area code, and extension, if applicable.

Reports the Phone numbers entered in the Personal Contact Information for that person.
do not report Phone Number is marked as "Private"
If blank, does not report.

Census> People> Demographics> Personal Contact Information> Other Phone, Work Phone, Cell Phone, Pager

contact.otherPhone

contact.workPhone

contact.cellPhone

contact.pager

textMessageCapabilityIndicator

An indication that the telephone number is technically capable of sending and receiving Short Message Service (SMS) text messages.

This is optional, does not report.

Descriptors

Click here to expand...

Limited English Proficiency Descriptors

Code Value	Description	Namespace	Short Description
Limited	Limited	uri://ed-fi.org/LimitedEnglishProficiencyDescriptor	Limited
Limited Monitored 1	Limited Monitored 1	uri://ed-fi.org/LimitedEnglishProficiencyDescriptor	Limited Monitored 1
Limited Monitored 2	Limited Monitored 2	uri://ed-fi.org/LimitedEnglishProficiencyDescriptor	Limited Monitored 2
NotLimited	NotLimited	uri://ed-fi.org/LimitedEnglishProficiencyDescriptor	NotLimited

Race Descriptors

Code Value	Description	Namespace	Short Description
American Indian - Alaska Native	American Indian - Alaska Native	uri://ed-fi.org/RaceDescriptor	American Indian - Alaska Native
Asian	Asian	uri://ed-fi.org/RaceDescriptor	Asian
Black - African American	Black - African American	uri://ed-fi.org/RaceDescriptor	Black - African American
Choose Not to Respond	Choose Not to Respond	uri://ed-fi.org/RaceDescriptor	Choose Not to Respond
Native Hawaiian - Pacific Islander	Native Hawaiian - Pacific Islander	uri://ed-fi.org/RaceDescriptor	Native Hawaiian - Pacific Islander
Other	Other	uri://ed-fi.org/RaceDescriptor	Other
White	White	uri://ed-fi.org/RaceDescriptor	White

Student Characteristic Descriptors

Code Value	Description	Namespace	Short Description
Asylee	Asylee	uri://ed-fi.org/StudentCharacteristicDescriptor	Asylee
Displaced	Displaced	uri://ed-fi.org/StudentCharacteristicDescriptor	Displaced
Displaced Homemaker	Displaced Homemaker	uri://ed-fi.org/StudentCharacteristicDescriptor	Displaced Homemaker
Economic Disadvantaged	Economic Disadvantaged	uri://ed-fi.org/StudentCharacteristicDescriptor	Economic Disadvantaged
Foster Care	Foster Care	uri://ed-fi.org/StudentCharacteristicDescriptor	Foster Care
Homeless	Homeless	uri://ed-fi.org/StudentCharacteristicDescriptor	Homeless
Immigrant	Immigrant	uri://ed-fi.org/StudentCharacteristicDescriptor	Immigrant
Other	Other	uri://ed-fi.org/StudentCharacteristicDescriptor	Other
Parent in Military	Parent in Military	uri://ed-fi.org/StudentCharacteristicDescriptor	Parent in Military
Pregnant	Pregnant	uri://ed-fi.org/StudentCharacteristicDescriptor	Pregnant
Refugee	Refugee	uri://ed-fi.org/StudentCharacteristicDescriptor	Refugee
Runaway	Runaway	uri://ed-fi.org/StudentCharacteristicDescriptor	Runaway
Single Parent	Single Parent	uri://ed-fi.org/StudentCharacteristicDescriptor	Single Parent
Unaccompanied Youth	Unaccompanied Youth	uri://ed-fi.org/StudentCharacteristicDescriptor	Unaccompanied Youth

Student Identification System Descriptors

Code Value	Description	Namespace	Short Description
Canadian SIN	Canadian SIN	uri://ed-fi.org/StudentIdentificationSystemDescriptor	Canadian SIN
District	District	uri://ed-fi.org/StudentIdentificationSystemDescriptor	District
Family	Family	uri://ed-fi.org/StudentIdentificationSystemDescriptor	Family
Federal	Federal	uri://ed-fi.org/StudentIdentificationSystemDescriptor	Federal
Local	Local	uri://ed-fi.org/StudentIdentificationSystemDescriptor	Local
National Migrant	National Migrant	uri://ed-fi.org/StudentIdentificationSystemDescriptor	National Migrant
Other	Other	uri://ed-fi.org/StudentIdentificationSystemDescriptor	Other
School	School	uri://ed-fi.org/StudentIdentificationSystemDescriptor	School
SSN	SSN	uri://ed-fi.org/StudentIdentificationSystemDescriptor	SSN
State	State	uri://ed-fi.org/StudentIdentificationSystemDescriptor	State
State Migrant	State Migrant	uri://ed-fi.org/StudentIdentificationSystemDescriptor	State Migrant

Telephone Type Descriptors

Code Value	Description	Namespace	Short Description
Emergency 1	Emergency 1	uri://ed-fi.org/TelephoneNumberTypeDescriptor	Emergency 1
Emergency 2	Emergency 2	uri://ed-fi.org/TelephoneNumberTypeDescriptor	Emergency 2
Fax	Fax	uri://ed-fi.org/TelephoneNumberTypeDescriptor	Fax
Home	Home	uri://ed-fi.org/TelephoneNumberTypeDescriptor	Home
Mobile	Mobile	uri://ed-fi.org/TelephoneNumberTypeDescriptor	Mobile
Other	Other	uri://ed-fi.org/TelephoneNumberTypeDescriptor	Other
Unlisted	Unlisted	uri://ed-fi.org/TelephoneNumberTypeDescriptor	Unlisted
Work	Work	uri://ed-fi.org/TelephoneNumberTypeDescriptor	Work

Was this helpful?

Tennessee Ed-Fi Data v3.1 - Student Education Organization Associations

Object Triggering Logic

Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Resource Preferences

Identity Mapping Object Key

Event Queue Detail

Object Data Elements

Array Data Elements

Cohort Years

Student Languages

Uses

Races

Program Participations

Student Characteristics

Student Identification Codes

Indicators

Telephones

Descriptors

Limited English Proficiency Descriptors

Race Descriptors

Student Characteristic Descriptors

Student Identification System Descriptors

Telephone Type Descriptors

Related Articles