Tool Search: Ed-Fi

Foreign Exchange

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when the Foreign Exchange checkbox is marked on an enrollment that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following information on the student's associated enrollment changes: Foreign Exchange Enrollment Start Date Enrollment End Date
DELETE	When the Foreign Exchange checkbox is unchecked. When the Enrollment Start/End Dates are changed so that the enrollment no longer overlaps the configured year. When the Enrollment is deleted.

Action

Trigger

POST

Reports a record when the Foreign Exchange checkbox is marked on an enrollment that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following information on the student's associated enrollment changes:
- Foreign Exchange
- Enrollment Start Date
- Enrollment End Date

DELETE

When the Foreign Exchange checkbox is unchecked.
When the Enrollment Start/End Dates are changed so that the enrollment no longer overlaps the configured year.
When the Enrollment is deleted.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label	Business Rules	Mandatory (M), Conditional (C), or Optional (O)	Data Source Path Database Field
educationOrganization Reference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = 10 + State District Number + State School Number	M	District Information > State District Number School Information > State School Number District.number School.number
programReference	Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationID = 1088000000 (Hard-coded) IDOE is the owner of all programs. programName = Foreign Exchange (Hard-coded) programType = Foreign Exchange (Hard-coded)	M	N/A
studentReference	Reports the fields that are part of the Natural Key for the Students resource.	M	N/A
beginDate	Reports the Enrollment Start Date.	M	Enrollments > Start Date Enrollment.startDate
endDate	Reports the Enrollment End Date.	C	Enrollments > End Date Enrollment.endDate

Foster Care

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when the student has a Foster Care record that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following information on the student's associated Foster Care record changes: Foster Care Start Date Foster Care End Date
DELETE	When the Foster Care record is deleted. When the Foster Care record Start/End dates are changed to no longer overlap the configured year. When the student no longer has any reportable enrollments in the configured year.

Action

Trigger

POST

Reports a record when the student has a Foster Care record that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following information on the student's associated Foster Care record changes:
- Foster Care Start Date
- Foster Care End Date

DELETE

When the Foster Care record is deleted.
When the Foster Care record Start/End dates are changed to no longer overlap the configured year.
When the student no longer has any reportable enrollments in the configured year.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label	Business Rules	Mandatory (M), Conditional (C), or Optional (O)	Data Source Path Database Field
educationOrganization Reference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = 10 + State District Number + State School Number	M	District Information > State District Number School Information > State School Number District.number School.number
programReference	Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationID = 1088000000 (Hard-coded) IDOE is the owner of all programs. programName = Foster Care (Hard-coded) programType = Foster Care (Hard-coded)	M	N/A
studentReference	Reports the fields that are part of the Natural Key for the Students resource.	M	N/A
beginDate	Reports the Foster Care Start Date.	M	Program Participation > Foster Care > Start Date FosterCare.startDate
endDate	Reports to Foster Care End Date.	C	Program Participation > Foster Care > End Date FosterCare.endDate

High Ability

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when the High Ability dropdown is set to Code 1, 2, 3, or 4 on an enrollment that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT will be performed otherwise. When the following information on the student's associated enrollment changes: High Ability Enrollment Start Date Enrollment End Date
DELETE	When the High Ability dropdown is set to NULL / Blank or Code 0. When the Enrollment Start/End Dates are changed so that the enrollment no longer overlaps the configured year. When the Enrollment is deleted.

Action

Trigger

POST

Reports a record when the High Ability dropdown is set to Code 1, 2, 3, or 4 on an enrollment that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT will be performed otherwise.

When the following information on the student's associated enrollment changes:
- High Ability
- Enrollment Start Date
- Enrollment End Date

DELETE

When the High Ability dropdown is set to NULL / Blank or Code 0.
When the Enrollment Start/End Dates are changed so that the enrollment no longer overlaps the configured year.
When the Enrollment is deleted.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label

Business Rules

Mandatory (M), Conditional (C), or Optional (O)

Data Source Path
Database Field

educationOrganization
Reference

Reports the fields that are part of the Natural Key for the Schools resource.

educationOrganizationId = 10 + State District Number + State School Number

District Information > State District Number

School Information > State School Number

District.number

School.number

programReference

Reports the fields that are part of the Natural Key for the Programs resource.

educationOrganizationID = 1088000000 (Hard-coded)
- IDOE is the owner of all programs.
programName = Reports based on the table below:

Infinite Campus High Ability Code	Program Name
1: General Intellectual	General Intellectual
2: Math (M-HA)	High Ability Math
3: Language Arts (L-HA)	High Ability Language Arts
4: Other	High Ability Other

programType = High Ability (Hard-coded)

N/A

studentReference

Reports the fields that are part of the Natural Key for the Students resource.

N/A

beginDate

Reports the Enrollment Start Date.

Enrollments > Start Date
Enrollment.startDate
Enrollment.startDate

endDate

Reports the Enrollment End Date.

Enrollments > End Date
Enrollment.endDate
Enrollment.endDate

Homebound (Hospitalized)

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when the student has a Homebound/Hospitalized Program record that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude The Homebound/Hospitalized Program must be set up by the school/district in Program Admin > Programs > Programs. This can be set up by ensuring the Program has a Code of HH and a Program Category of HH: Homebound/Hospitalized.
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT will be performed otherwise. When the following information on the student's associated Program record changes: Program Start Date Program Care End Date
DELETE	When the Program record is deleted. When the Program record Start/End dates are changed to no longer overlap the configured year. When the student no longer has any reportable enrollments in the configured year.

Action

Trigger

POST

Reports a record when the student has a Homebound/Hospitalized Program record that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
The Homebound/Hospitalized Program must be set up by the school/district in Program Admin > Programs > Programs. This can be set up by ensuring the Program has a Code of HH and a Program Category of HH: Homebound/Hospitalized.

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT will be performed otherwise.

When the following information on the student's associated Program record changes:
- Program Start Date
- Program Care End Date

DELETE

When the Program record is deleted.
When the Program record Start/End dates are changed to no longer overlap the configured year.
When the student no longer has any reportable enrollments in the configured year.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label	Business Rules	Mandatory (M), Conditional (C), or Optional (O)	Data Source Path Database Field
educationOrganization Reference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = 10 + State District Number + State School Number	M	District Information > State District Number School Information > State School Number District.number School.number
programReference	Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationID = 1088000000 (Hard-coded) IDOE is the owner of all programs. programName = Homebound/Hospitalized (Hard-coded) programType = Homebound (Hard-coded)	M	N/A
studentReference	Reports the fields that are part of the Natural Key for the Students resource.	M	N/A
beginDate	Reports the Homebound Start Date.	M	Programs > Homebound > Start Date ProgramParticipation.startDate
endDate	Reports the Homebound End Date.	C	Programs > Homebound > End Date ProgramParticipation.endDate

Homeless

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when the student has a Homeless record that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following information on the student's associated Homeless record changes: Homeless Start Date Homeless End Date Primary Night Time Residence
DELETE	When the Homeless record is deleted. When the Homeless record Start/End dates are changed to no longer overlap the configured year. When the student no longer has any reportable enrollments in the configured year.

Action

Trigger

POST

Reports a record when the student has a Homeless record that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following information on the student's associated Homeless record changes:
- Homeless Start Date
- Homeless End Date
- Primary Night Time Residence

DELETE

When the Homeless record is deleted.
When the Homeless record Start/End dates are changed to no longer overlap the configured year.
When the student no longer has any reportable enrollments in the configured year.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label

Business Rules

Mandatory (M), Conditional (C), or Optional (O)

Data Source Path
Database Field

educationOrganization
Reference

Reports the fields that are part of the Natural Key for the Schools resource.

educationOrganizationId = 10 + State District Number + State School Number

District Information > State District Number

School Information > State School Number

District.number

School.number

programReference

Reports the fields that are part of the Natural Key for the Programs resource.

educationOrganizationID = 1088000000 (Hard-coded)
- IDOE is the owner of all programs.
programName = Reports based on the table below:

Infinite Campus Primary Night Time Residence Code	Program Name
1: Doubled-up	Homeless Doubled-up
2: Shelters and Traditional Housing	Homeless Shelters and Transitional Housing
3: Unsheltered	Homeless Unsheltered
4: Hotels / Motels	Homeless Hotels/Motels

programType = Homeless (Hard-coded)

N/A

studentReference

Reports the fields that are part of the Natural Key for the Students resource.

N/A

beginDate

Reports the Homeless Start Date.

Program Participation > Homeless > Start Date

Homeless.startDate

endDate

Reports the Homeless End Date.

Program Participation > Homeless > End Date

Homeless.endDate

Multilingual Learners

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when the student has an EL Services record that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude Program association records will report even if the EL tab is not filled out (i.e. EL tab can have a blank Program Status - As long as there is a valid EL Services record the program record will send).
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following information on the student's associated EL Services record changes: Service Type EL Services Start Date EL Services End Date
DELETE	When the EL Services record is deleted. When the EL Services record Start/End dates are changed to no longer overlap the configured year. When the student no longer has any reportable enrollments in the configured year.

Action

Trigger

POST

Reports a record when the student has an EL Services record that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
Program association records will report even if the EL tab is not filled out (i.e. EL tab can have a blank Program Status - As long as there is a valid EL Services record the program record will send).

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following information on the student's associated EL Services record changes:
- Service Type
- EL Services Start Date
- EL Services End Date

DELETE

When the EL Services record is deleted.
When the EL Services record Start/End dates are changed to no longer overlap the configured year.
When the student no longer has any reportable enrollments in the configured year.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label

Business Rules

Mandatory (M), Conditional (C), or Optional (O)

Data Source Path
Database Field

educationOrganization
Reference

Reports the fields that are part of the Natural Key for the Schools resource.

educationOrganizationId = 10 + State District Number + State School Number

District Information > State District Number

School Information > State School Number

District.number

School.number

programReference

Reports the fields that are part of the Natural Key for the Programs resource.

educationOrganizationID = 1088000000 (Hard-coded)
- IDOE is the owner of all programs.
programName = Reports based on the table below:

Infinite Campus Service Type Code	Program Name
1: Transitional Bilingual Education (TBE)	Homeless Doubled-up
2: ESL Program	ESL
3: Pull-out ESL	Pull-out ESL
4: Content-based ELD	Content-based ELD
5: Regular Education-Non-EL	Regular Education-Non-EL
7: Sheltered Instruction-ELs Only	Sheltered Instruction-ELs Only
8: Structured Immersion	Structured Immersion
9: Heritage Language	Heritage Language
10: Dual Language/Immersion	Dual Language/Immersion
11: Newcomer	Newcomer
12: El-Parent Refusal	El-Parent Refusal

programType = Multilingual Learners (Hard-coded)

N/A

studentReference

Reports the fields that are part of the Natural Key for the Students resource.

N/A

beginDate

Reports the EL Services Start Date.

Program Participation > English Learners (EL) > EL Services > Start Date

LEPService .startDate

endDate

Reports the EL Services End Date.

Program Participation > English Learners (EL) > EL Services > End Date

LEPService .endDate

reasonExitedDescriptor

If there is an EL Services End Date, report 99 (Hard-coded).
Otherwise, do not report.

N/A

Parent in Military

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when one of the student's guardians has a Military Connection of Code Active Duty, Deployed or Active Duty, Not Deployed that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude If both the student and their guardian(s) have a reportable Military Connection, report from the student. If multiple guardians have a reportable Military Connection, report from the guardian with the lowest personID. Report a maximum of one record for this program.
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following information on the student's or their guardian's associated Military Connection details change: Status Military Connections Start Date Military Connections End Date
DELETE	When the Military Connections record is deleted. When the Military Connections record Start/End dates are changed to no longer overlap the configured year. When the Military Connections record Status is changed on the currently reported record to a Code other than Active Duty, Deployed or Active Duty, Not Deployed When the individual is no longer a guardian for the student. When the student no longer has any reportable enrollments in the configured year.

Action

Trigger

POST

Reports a record when one of the student's guardians has a Military Connection of Code Active Duty, Deployed or Active Duty, Not Deployed that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
If both the student and their guardian(s) have a reportable Military Connection, report from the student.
If multiple guardians have a reportable Military Connection, report from the guardian with the lowest personID.
Report a maximum of one record for this program.

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following information on the student's or their guardian's associated Military Connection details change:
- Status
- Military Connections Start Date
- Military Connections End Date

DELETE

When the Military Connections record is deleted.
When the Military Connections record Start/End dates are changed to no longer overlap the configured year.
When the Military Connections record Status is changed on the currently reported record to a Code other than Active Duty, Deployed or Active Duty, Not Deployed
When the individual is no longer a guardian for the student.
When the student no longer has any reportable enrollments in the configured year.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label	Business Rules	Mandatory (M), Conditional (C), or Optional (O)	Data Source Path Database Field
educationOrganization Reference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = 10 + State District Number + State School Number	M	District Information > State District Number School Information > State School Number District.number School.number
programReference	Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationID = 1088000000 (Hard-coded) IDOE is the owner of all programs. programName = Parent in Military programType = Parent in Military (Hard-coded)	M	N/A
studentReference	Reports the fields that are part of the Natural Key for the Students resource.	M	N/A
beginDate	Reports the Military ConnectionStart Date.	M	People > Military Connections > Start Date v_MilitaryConnections.startDate
endDate	Reports the Military ConnectionEnd Date.	C	People > Military Connections > End Date v_MilitaryConnections.endDate

Refugee

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when the student has a Refugee record that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following information on the student's associated Refugee record changes: Reason Exited Refugee Start Date Refugee End Date
DELETE	When the Refugee record is deleted. When the Refugee record Start/End dates are changed to no longer overlap the configured year. When the student no longer has any reportable enrollments in the configured year.

Action

Trigger

POST

Reports a record when the student has a Refugee record that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following information on the student's associated Refugee record changes:
- Reason Exited
- Refugee Start Date
- Refugee End Date

DELETE

When the Refugee record is deleted.
When the Refugee record Start/End dates are changed to no longer overlap the configured year.
When the student no longer has any reportable enrollments in the configured year.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label	Business Rules	Mandatory (M), Conditional (C), or Optional (O)	Data Source Path Database Field
educationOrganization Reference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = 10 + State District Number + State School Number	M	District Information > State District Number School Information > State School Number District.number School.number
programReference	Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationID = 1088000000 (Hard-coded) IDOE is the owner of all programs. programName = Refugee (Hard-coded) programType = Refugee (Hard-coded)	M	N/A
studentReference	Reports the fields that are part of the Natural Key for the Students resource.	M	N/A
beginDate	Reports the Refugee Start Date.	M	State Programs > Refugee > Start Date Refugee.startDate
endDate	Reports the Refugee End Date.	C	State Programs > Refugee > End Date Refugee.endDate
reasonExitedDescriptor	Reports the Ed-Fi Code mapped to the value selected for Reason Exited.	C	State Programs > Refugee > Reason Exited Refugee.exitStatus

School Food Service

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when the student has a FRAM record with a State Eligibility Code of Free or Reduced that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following information on the student's associated FRAM record changes: Eligibility FRAM Start Date FRAM End Date When the following information on the student's associated enrollment changes: Enrollment End Date
DELETE	When the FRAM record is deleted. When the FRAM record Start/End dates are changed to no longer overlap the configured year. When the FRAM record no longer has a Status of Free or Reduced. When the student no longer has any reportable enrollments in the configured year.

Action

Trigger

POST

Reports a record when the student has a FRAM record with a State Eligibility Code of Free or Reduced that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following information on the student's associated FRAM record changes:
- Eligibility
- FRAM Start Date
- FRAM End Date
When the following information on the student's associated enrollment changes:
- Enrollment End Date

DELETE

When the FRAM record is deleted.
When the FRAM record Start/End dates are changed to no longer overlap the configured year.
When the FRAM record no longer has a Status of Free or Reduced.
When the student no longer has any reportable enrollments in the configured year.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label

Business Rules

Mandatory (M), Conditional (C), or Optional (O)

Data Source Path
Database Field

educationOrganization
Reference

Reports the fields that are part of the Natural Key for the Schools resource.

educationOrganizationId = 10 + State District Number + State School Number

District Information > State District Number

School Information > State School Number

District.number

School.number

programReference

Reports the fields that are part of the Natural Key for the Programs resource.

educationOrganizationID = 1088000000 (Hard-coded)
- IDOE is the owner of all programs.
programName = Report based on the table below:

Infinite Campus State Eligibility Code	Program Name
F: Free	School Food Services Free Lunch
R: Reduced	School Food Services Reduced Price Meals

programType = School Food Services (Hard-coded)

N/A

studentReference

Reports the fields that are part of the Natural Key for the Students resource.

N/A

beginDate

Reports the FRAM Start Date.

FRAM > Eligibility > Start Date

FreeReducedApplication.startDate

endDate

Reports the earliest of the FRAM End Date, Enrollment End Date, or the Last Instructional Day of the Calendar.

FRAM > Eligibility > End Date

FreeReducedApplication.endDate

Enrollment.endDate

Day.date

Section 504

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when the student has a Section 504 record that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following information on the student's associated Foster Care record changes: Section 504 Start Date Section 504 End Date
DELETE	When the Section 504 record is deleted. When the Section 504 record Start/End dates are changed to no longer overlap the configured year. When the student no longer has any reportable enrollments in the configured year.

Action

Trigger

POST

Reports a record when the student has a Section 504 record that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following information on the student's associated Foster Care record changes:
- Section 504 Start Date
- Section 504 End Date

DELETE

When the Section 504 record is deleted.
When the Section 504 record Start/End dates are changed to no longer overlap the configured year.
When the student no longer has any reportable enrollments in the configured year.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label	Business Rules	Mandatory (M), Conditional (C), or Optional (O)	Data Source Path Database Field
educationOrganization Reference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = 10 + State District Number + State School Number	M	District Information > State District Number School Information > State School Number District.number School.number
programReference	Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationID = 1088000000 (Hard-coded) IDOE is the owner of all programs. programName = Section 504 Placement (Hard-coded) programType = Section 504 Placement (Hard-coded)	M	N/A
studentReference	Reports the fields that are part of the Natural Key for the Students resource.	M	N/A
beginDate	Reports the Section 504 Start Date.	M	Program Participation > Section 504 > Start Date Section504.startDate
endDate	Reports the Section 504 End Date.	C	Program Participation > Section 504 > End Date Section504 .endDate

Unaccompanied Youth

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when the student has a Homeless record with Unaccompanied Youth = Yes that overlaps the configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following information on the student's associated Foster Care record changes: Unaccompanied Youth Homeless Start Date Homeless End Date
DELETE	When the Homeless record is deleted. When the Homeless record Start/End dates are changed to no longer overlap the configured year. When the Homeless record has the Unaccompanied Youth change to a value other than Yes. When the student no longer has any reportable enrollments in the configured year.

Action

Trigger

POST

Reports a record when the student has a Homeless record with Unaccompanied Youth = Yes that overlaps the configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following information on the student's associated Foster Care record changes:
- Unaccompanied Youth
- Homeless Start Date
- Homeless End Date

DELETE

When the Homeless record is deleted.
When the Homeless record Start/End dates are changed to no longer overlap the configured year.
When the Homeless record has the Unaccompanied Youth change to a value other than Yes.
When the student no longer has any reportable enrollments in the configured year.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label	Business Rules	Mandatory (M), Conditional (C), or Optional (O)	Data Source Path Database Field
educationOrganization Reference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = 10 + State District Number + State School Number	M	District Information > State District Number School Information > State School Number District.number School.number
programReference	Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationID = 1088000000 (Hard-coded) IDOE is the owner of all programs. programName = Unaccompanied Youth (Hard-coded) programType = Unaccompanied Youth (Hard-coded)	M	N/A
studentReference	Reports the fields that are part of the Natural Key for the Students resource.	M	N/A
beginDate	Reports the Homeless Start Date.	M	Program Participation > Homeless > Start Date Homeless.startDate
endDate	Reports the Homeless End Date.	C	Program Participation > Homeless > End Date Homeless.endDate

Virtual Education

Click here to expand...

Object Triggering Logic

Action	Trigger
POST	Reports a record when the student has a Virtual Education State Program with an Instruction Type of 03: Remote OR with 02: Hybrid and Percent Virtual of 50 or more AND the Virtual Education State Program dates overlap an enrollment in the current configured year. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude A maximum of one record for this program will report per student-school combination.
DELETE / POST PUT	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise. When the following information on the student's associated Virtual Education State Program changes: Start Date End Date Instruction Type Percent Virtual Reason Exited
DELETE	When the Virtual Education State Program no longer has an Instruction Type that is reportable. When the Virtual Education State Program has Percent Virtual changes to a value that is no longer reportable (only applicable for Instruction Type of 02: Hybrid). When the Virtual Education State Program no longer overlaps the configured year. When the Virtual Education State Program is deleted. When all reportable Enrollments are deleted or no longer in the configured year.

Action

Trigger

POST

Reports a record when the student has a Virtual Education State Program with an Instruction Type of 03: Remote OR with 02: Hybrid and Percent Virtual of 50 or more AND the Virtual Education State Program dates overlap an enrollment in the current configured year.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude
A maximum of one record for this program will report per student-school combination.

DELETE / POST

PUT

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.

When the following information on the student's associated Virtual Education State Program changes:
- Start Date
- End Date
- Instruction Type
- Percent Virtual
- Reason Exited

DELETE

When the Virtual Education State Program no longer has an Instruction Type that is reportable.
When the Virtual Education State Program has Percent Virtual changes to a value that is no longer reportable (only applicable for Instruction Type of 02: Hybrid).
When the Virtual Education State Program no longer overlaps the configured year.
When the Virtual Education State Program is deleted.
When all reportable Enrollments are deleted or no longer in the configured year.

Object Data Elements

Any data elements not listed here are not sent with the Ed-Fi record in Indiana. Data elements in bold are part of the natural key.

Data Element Label	Business Rules	Mandatory (M), Conditional (C), or Optional (O)	Data Source Path Database Field
educationOrganization Reference	Reports the fields that are part of the Natural Key for the Schools resource. educationOrganizationId = 10 + State District Number + State School Number	M	District Information > State District Number School Information > State School Number District.number School.number
programReference	Reports the fields that are part of the Natural Key for the Programs resource. educationOrganizationID = 1088000000 (Hard-coded) IDOE is the owner of all programs. programName = Virtual Education (Hard-coded) programType = Virtual Education (Hard-coded)	M	N/A
studentReference	Reports the fields that are part of the Natural Key for the Students resource.	M	N/A
beginDate	Reports the Virtual Education Start Date.	M	State Programs > Virtual Education > Start Date instructionMode.startDate
endDate	Reports the Virtual Education End Date.	C	State Programs > Virtual Education > End Date instructionMode.endDate
reasonExitedDescriptor	Reports the Ed-Fi Code mapped to the value selected for Reason Exited.	C	State Programs > Virtual Education > Reason Exited instructionMode.exitReason

Descriptors

Click here to expand...

Program Type Descriptors

Ed-Fi Code	Description	Namespace
Foreign Exchange	Foreign Exchange	uri://ed-fi.org/ProgramTypeDescriptor
Foster Care	Foster Care	uri://ed-fi.org/ProgramTypeDescriptor
High Ability	High Ability	uri://ed-fi.org/ProgramTypeDescriptor
Homebound	Homebound	uri://ed-fi.org/ProgramTypeDescriptor
Homeless	Homeless	uri://ed-fi.org/ProgramTypeDescriptor
Multilingual Learners	Multilingual Learners	uri://ed-fi.org/ProgramTypeDescriptor
Parent in Military	Parent in Military	uri://ed-fi.org/ProgramTypeDescriptor
Refugee	Refugee	uri://ed-fi.org/ProgramTypeDescriptor
School Food Services	School Food Services	uri://ed-fi.org/ProgramTypeDescriptor
Section 504 Placement	Section 504 Placement	uri://ed-fi.org/ProgramTypeDescriptor
Unaccompanied Youth	Unaccompanied Youth	uri://ed-fi.org/ProgramTypeDescriptor
Virtual Education	Virtual Education	uri://ed-fi.org/ProgramTypeDescriptor

Reason Exited Descriptor

Code	Description	namespace	short description
1	Transferred to Regular Education (no longer eligible or parent revoked consent)	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Transferred to regular education
2	Attained the goals identified in the students individual service plan (ISP)	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Attained Goals identified in the students ISP
3	Made satisfactory progress toward goals identified in the ISP	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Made satisfactory progress toward goals identified in the ISP
4	Did not make satisfactory progress toward goals in their ISP but remained in the program	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Did not make satisfactory progress toward goals in their ISP but remained in the program
5	Transferred / returned to other school setting prior to completing the alternative education program	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Transferred/returned to other school setting prior to completing program
6	Dropped out of alternative education program, not returning to any educational setting	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Dropped out of program, not returning to any educational setting
7	Expelled from alternative education program, not returned to any educational setting	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Expelled from program, not returned to any educational setting
10	Incarcerated	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Incarcerated
11	Earned High School Diploma	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Earned High School Diploma
12	Received Certificate	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Received Certificate
13	Reached Maximum Age of 22	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Reached Maximum Age of 22
14	Deceased	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Deceased
15	Dropout	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Dropout
16	Moved, Known to be continuing in an Educational Program Only	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Moved, Known to be continuing in an Educational Program Only
17	Moved, but continuing Special Education services under IDEA in Indiana	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	Moved, but continuing Special Education services under IDEA in Indiana
99	No Longer Qualifies	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	No Longer Qualifies
End Of Year (EOY)	End of Year (EOY)	http://doe.in.gov/Descriptor/ReasonExitedDescriptor.xml	End of Year (EOY)

Student Program Associations (Indiana v3.6)

Foreign Exchange

Object Triggering Logic

Object Data Elements

Foster Care

Object Triggering Logic

Object Data Elements

High Ability

Object Triggering Logic

Object Data Elements

Homebound (Hospitalized)

Object Triggering Logic

Object Data Elements

Homeless

Object Triggering Logic

Object Data Elements

Multilingual Learners

Object Triggering Logic

Object Data Elements

Parent in Military

Object Triggering Logic

Object Data Elements

Refugee

Object Triggering Logic

Object Data Elements

School Food Service

Object Triggering Logic

Object Data Elements

Section 504

Object Triggering Logic

Object Data Elements

Unaccompanied Youth

Object Triggering Logic

Object Data Elements

Virtual Education

Object Triggering Logic

Object Data Elements

Descriptors

Program Type Descriptors

Reason Exited Descriptor

Related Articles