Indiana Ed-Fi Data v2.4/3.1 - Student Curricular Material Program Associations
Last Modified on 10/22/2022 10:19 am CDT
Classic View: System Administration > Ed-Fi
Search Terms: Curricular Material Program
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.
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 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
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 will only send 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.
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.
Report the Start Date when reporting from
FRAM
FRAM record must overlap current school year dates.
If FRAM record starts in the previous School year and the end date of that record is after September 30 of the current school year, we must report 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, the reporting of a Curricular record is not needed.
M
endDate
The month, day, and year on which the Student exited the Program or stopped receiving services.
Report 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
If 'livesWithParentReference' reports a Unique ID, report as false.
If 'livesWithParentReferen' reports with no unique ID, report true.
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
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, do not report.
If the student has an enrollment start date after the report date, do not report.
If no active FRAM record is available as of 10/01/startYear, do not report.
DO NOT report if a student has a Textbook Opt-Out state program with a start date and the Opt-Out box is checked.
If start date is within the current school year
Previous school year programs are for those school years only
Reason Exited Descriptor
Code
Description
namespace
short description
1
Transferred to Regular Education (no longer eligible or parent revoked consent)
