Student Curricular Material Program Associations (Indiana v3.6)

Tool Search: Ed-Fi

This educational entity represents the organization of subject matter and related learning experiences provided for the instruction of students on a regular or systematic basis.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a FRAM Program is created and the record overlaps the configured year. FRAM Program Data is a direct pull and does not have mappings in Student Program Association.
Put	When the student is given an End Date on a reported FRAM Program.
Delete/Post	When part of the records Natural Key changes. When the student has two of the same flags with the same start date and 1 record is deleted, the remaining records data will post. When a student moves to 100% Virtual Education. (Virtual Student = 100 on Enrollment record) When student's start date is after October 01. When student's end date is before October 01.
Delete	When a FRAM Program is deleted or when the record no longer overlaps the configured year. If a Textbook Opt-Out program with a start date and the Opt-Out check box mark is created for the student during the school year.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

Action	Trigger
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 needs 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	Trigger
Post/Delete	Natural Key changes: LEA Reference - District Numbers cannot change after data has been sent. If a district number changes, we would expect an Ed-Fi error and this change would not be supported. If an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers. If the Program Name or Program Type Descriptor mapping changes and a resync is completed. If the FRAM record type changes (i.e. from Free to Reduced).
Delete	Cascading Deletes: N/A - no resources are dependent on this resource.

Action

Trigger

Post/Delete

Natural Key changes:

LEA Reference - District Numbers cannot change after data has been sent. If a district number changes, we would expect an Ed-Fi error and this change would not be supported.
If an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers.
If the Program Name or Program Type Descriptor mapping changes and a resync is completed.
If the FRAM record type changes (i.e. from Free to Reduced).

Delete

Cascading Deletes: N/A - no resources are dependent on this resource.

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 program association record is associated with.
Data only sends for the years that have valid configuration.

Identity Mapping Object Key

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

campusObjectType	Object Key Data Source
ProgramParticipation	participationID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
programs	Put	The primary table used for sending data for this resource.
programparticipation	Put	The primary table used for sending data for this resource.

Object Data Elements

This table describes data elements sent within the Student Curricular Program Associations resource. Data Element Labels in bold are part of the Natural Key and are required for Data to send to Ed-Fi.

Click here to expand...

Data Element Label	Business Requirement	Business Rules	M, C or O
id	The unique identifier of the resource.		M
educationOrganization Reference	A reference to the related EducationOrganization resource.	Reports the District State Number. 10+districtID+School	M
programReference	A reference to the related Program resource.	Additional Logic for TextBook /Curricular Material is below.	M
studentReference	A reference to the related Student resource.	Reports the Student Reference.	M
beginDate	The month, day, and year on which the student first received services.	Reports the Start Date when reporting from FRAM: FRAM record must overlap current school year dates. If the FRAM record starts in the previous School year and the endDate of that record is after September 30 of the current school year, reports that record with the start date. If the record starts in the previous school year and ends before the September 30 of current school year date, a Curricular record does not need to report.	M
endDate	The month, day, and year on which the Student exited the Program or stopped receiving services.	Reports the End Date when reporting from FRAM.	C
reasonExitedDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	Reports only when an exit is selected on a program.	O
servedOutsideOf RegularSession	Indicates whether the student received services during the summer session or between sessions.	This is optional, does not report.	O
enrollmentStatus		This is optional, does not report.	O
services	An unordered collection of studentProgramAssociationServices. Indicates the services being provided to the student by the program.	This is optional, does not report.	O
InstructionalDays	The days on which a student is expected to be instructed.	This is optional, does not report.	O
InstructionalMinutes	The number of minutes that elapse between the class period’s specified start and end times.	This is optional, does not report.	O
livesWithParentReference	Reports the Ed-Fi ID of the parent / guardian the student lives with.	Report the Ed-Fi ID of the parent / guardian who: Is in the same household as the student. Is marked as Guardian for the student. Is marked as 'Emergency Priority = 1' If no 'Emergency Priority' is set, select Guardian in the household with the lowest PersonID.	M
studentDoesNotLiveWithParent	The indicator sent for students with no unique ID in the 'LivesWithParent' reference.	Reports False if 'livesWithParent Reference' reports. Reports True if 'livesWithParent Reference' does NOT report (there are no guardians in the same household as the student).	M

Program Reference

Data Element Label	Business Requirement	Business Rules	M,C, or O
ProgramTypeID	Report the type of Program the student is in.	Reports the type in the programReference. There are several types from several areas of Campus, see Type list below for logic.	C
ProgramName	Reports the name of the program the student is in.	Reports the name in the programreference. See logic below.	C
ProgramEdOrgID	Reports the education organization ID the supporting the program.	Reports the edOrgID that is supporting this program. Must report State EdOrgID 1088000000	C
LivesWithParent	Reports the parentUniqueID of the parent that the student lives with.

Types/Descriptors

Click here to expand...

Program Types

Program Type	Program Name	EdOrg	Logic	Data Source
Curricular Material Reimbursement	Curricular Material Reimbursement	State EdOrgID 1088000000	Report programType as Curricular Material Reimbursement in programReference. Report programName as Curricular Material Reimbursement in programReference. Report the students district+School from their active enrollment In programReference.	Find the active FRAM Eligibility record for the student that is active on the report date of 10/01/startYear: If the Eligibility is Free or Reduced, report student as having a "Curricular Material Reimbursement" program. Note: Look at both Eligibility records with an Eligibility type of Meal OR SES. If the student is a Virtual Student 100% of the day, do not report. 100% Virtual students will have a 100 in the 'Virtual Student' field on enrollment (Student Information> Enrollment> State Reporting Fields> Virtual Student) If the student has an enrollment end date prior to the report date, does not report. If the student has an enrollment start date after the report date, does not report. If no active FRAM record is available as of 10/01/startYear, does not report.

Program Type

Program Name

EdOrg

Logic

Data Source

Curricular Material Reimbursement

State EdOrgID

1088000000

Report programType as Curricular Material Reimbursement in programReference.
Report programName as Curricular Material Reimbursement in programReference.
Report the students district+School from their active enrollment In programReference.

Find the active FRAM Eligibility record for the student that is active on the report date of 10/01/startYear:

If the Eligibility is Free or Reduced, report student as having a "Curricular Material Reimbursement" program.
Note: Look at both Eligibility records with an Eligibility type of Meal OR SES.
If the student is a Virtual Student 100% of the day, do not report.
- 100% Virtual students will have a 100 in the 'Virtual Student' field on enrollment (Student Information> Enrollment> State Reporting Fields> Virtual Student)
If the student has an enrollment end date prior to the report date, does not report.
If the student has an enrollment start date after the report date, does not report.
If no active FRAM record is available as of 10/01/startYear, does not report.

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 student's 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 the 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
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)
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