Student Curricular Material Program Associations (Indiana v3.6)
Last Modified on 07/29/2024 2:13 pm CDT
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. |
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. | 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. | 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.
|
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 |
