This association represents the Early Learning program that a student participates in or from which the student receives services.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When a Programs Fact tab record is created with a Program Name of either 'ECHEADST' or 'ERLYCHLD', and the record Start Date is not after the students enrollment End Date in the current calendar.
|
| Post | When a new enrollment is created for a student that has a Program Fact record in the calendar in which the student is enrolled.
|
| Post | If the student does not have any Programs Fact ERLYCHLD or ECHEADST record (either because it is not active, or it is nonexistent) look at the student's active course roster in the current calendar to see if any Early Childhood value that is not NULL in a section.
|
| Post | When the Program Name or the Start Date values are changed, the old record is deleted, and the new record is posted.
|
| Delete/Post | Update the endDate if the student's enrollment record is ended prior to the End Date of the Program Fact record, or if the Program Fact record's end date is NULL. |
| Delete/Post | Update the record if the endDate value in this resource is changed. |
| Delete/Post | Update the record if the roster end date value for the section associated with this record is added or changed. |
| Delete | When the Program Name or the Start Date values are changed, the old record is deleted, and the new record is posted.
|
| Delete | When all enrollments for a calendar that the Program Fact record is aligned to are deleted. |
| Delete | When the Programs Fact record is deleted. |
| Delete | When the roster record is deleted. |
| Delete | When the Early Childhood value is set to null and saved on the section editor |
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. |
Scope Year Logic
This table describes scope year logic of this object.
| Logic |
|---|
| When a new Program Fact record is created, the record will report in the Scope Year for which the record Start Date overlaps. |
| Data only sends for the years that have valid configuration. |
| When the record is triggered from Course Sections, the record sends to the scope year for the school year for which the Course/Section's calendar is aligned. |
Object Data Elements
This table describes data elements sent within the Student Early Learning Program Association resource.
| Data Element Label | Business Requirement | M, C or O | Data Source GUI Path Database Field |
|---|---|---|---|
| id | The unique identifier of the resource. | O | |
| educationOrganizaionReference | The education organization where the student is participating in or receiving the program services. Reports the School Number based on the School selected on the School of Assignment on the reporting enrollment.
If this field is blank, report the School Number the enrollment is associated with. | M | |
| programReference | The program associated with the student. Reports the Natural Key of the Programs resource. | M | |
| studentReference | A unique alpha-numeric code assigned to a student. Reports the Natural Key of the Students resource. | M | |
| beginDate | The month, day, and year on which the student first received services. Report Programs Fact Start Date for reporting record if pulled from Programs Fact tab Report Course > Section Roster Start date if pulling from Course > Section.
| M | Student Information > General > Programs Fact > Start Date Course > Section > Roster Start Date Term > Start Date |
| endDate | The month, day, and year on which the student exited the program or stopped receiving services. Report Programs Fact End Date for reporting record if pulled from Programs Fact tab
| C | Student Information > General > Programs Fact > End Date Course > Section > Roster End Date |
| reasonExitedDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. This is optional, do not report. | C | |
| servedOutsideOfRegular Session | Indicates whether the student received services during the summer session or between sessions. This is optional, do not report. | O | |
| earlyLearningSetting Descriptor | The setting of the student's participation in the program. Report the following when reporting from Programs Fact tab:
| C | Student Information > General > Programs Fact > Participation Info Code |
