Student Early Learning Program Associations (Nebraska v3.5)

Classic View: System Administration > Ed-Fi 

Search Terms: Ed-Fi

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.

ActionTrigger
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.

  • Reports a record based on the student having an overlapping enrollment record in the calendar to which the Program Fact record is aligned.
  • Do not send a student record for an enrollment that is marked as State Exclude or No Show.
  • Do not send a record if enrollment is in a calendar marked as State Exclude.
  • Do not report any Program Facts records without a Start Date.
  • If there are multiple qualifying early childhood Program Records of either 'ECHEADST' or 'ERLYCHLD', report the one with the latest Start Date.
  • If there are multiple qualifying early childhood Program Records of either 'ECHEADST' or 'ERLYCHLD', with the same Start Date, report the one with the highest record ID..
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.

  • Enrollment start date must be after Program Fact start date.
  • Program Fact end date must be NULL or after enrollment start date.
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.

  • If the student is scheduled into a single section with the Early Childhood value that is not NULL, report out based on that record.
  • If the student is scheduled into more than one section with the Early Childhood value that is not NULL, report out based on the section with the most recent Roster Start Date.
  • If the student is scheduled into more than one section with the Early Childhood value that is not NULL, and they all have the same Roster Start Date, or the Roster Start Dates are all NULL, report out based on the highest sectionID.
  • If the student has an active Programs Fact record and is scheduled in a section with the Early Childhood value that is not NULL, report the record from the Program Fact record only.
  • The course must have a state course code to report
Post

When the Program Name or the Start Date values are changed, the old record is deleted, and the new record is posted.

  • The start date can change either from the Programs Fact record or the Roster start date being changed.
  • The Program Name can change either from the Programs Name field on the Programs Fact record or the Early Childhood dropdown list on the section editor.
Delete/PostUpdate 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/PostUpdate the record if the endDate value in this resource is changed.
Delete/PostUpdate 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.

  • The start date can change either from the Programs Fact record or the Roster start date being changed.
  • The Program Name can change either from the Programs Name field on the Programs Fact record or the Early Childhood dropdown list on the section editor.
DeleteWhen all enrollments for a calendar that the Program Fact record is aligned to are deleted.
DeleteWhen the Programs Fact record is deleted.
DeleteWhen the roster record is deleted.
DeleteWhen 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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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 LabelBusiness RequirementBusiness RulesM, C or O

Data Source GUI Path

Database Field
id The unique identifier of the resource.
O

educationOrganizaion
Reference 
The education organization where the student is participating in or receiving the program services.
  1. Reports the School Number based on the School selected on the School of Assignment on the reporting enrollment.
    • Use the default value if populated.
  2. 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. 
  1. Report Programs Fact Start Date for reporting record if pulled from Programs Fact tab
  2. Report Course > Section Roster Start date if pulling from Course > Section.
    • Report Earliest term start date if Roster Start date is NULL.
  3. Use enrollment Start Date if if is after Roster Start Date or Programs Fact Start date.
    • If the student has more than 1 overlapping enrollment in the same calendar with different start dates, use the earliest start date.
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. 
  1. Report Programs Fact End Date for reporting record if pulled from Programs Fact tab
  2. Report Course > Section Roster End date if pulling from Course > Section.
    • Report latest term end date if Roster End date is NULL.
  3. Report Enrollment End Date if enrollment is ended prior to the Roster End Date or Program Fact End date.
    • All overlapping enrollments in that calendar must be ended to report.
    • If more than 1 enrollment and end dates are not the same, use the highest end date.
C

Student Information > General > Programs Fact > End Date


Course > Section > Roster End Date


Term > 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.,
  1. Report the following when reporting from Programs Fact tab:
    • Reports the Ed-Fi Code from the Participation Info Code selected.
    • Only report values from codes with the 'EC...' prefix; otherwise do not report.
  2. Report the following when reporting from the Course Section:
    • Reports the Ed-Fi Code from the Early Childhood Code selected.
CStudent Information > General > Programs Fact > Participation Info Code

Type/Descriptor

Click here to expand...

This table describes the Ed-Fi Value mapped and reported for Early Learning Setting Descriptors:

Ed-Fi Code ValueEd-Fi Short DescriptionEd-Fi Description
01NDE Grant Funded Early Childhood Education Program.Students in state grant funded center- based early childhood education program that has not yet been funded for three consecutive years; not eligible for state aid.
02Qualified NDE Grant Funded Early Childhood Education Program.Students in a state grant funded center- based early childhood education program that has been funded for three consecutive years; therefore, four year old students as of July 31 are eligible for state aid.
03NDE Approved Early Childhood Education Program.Students in a center-based Rule 11 approved early childhood education program that is not state grant funded and has not been approved for three consecutive years; not eligible for state aid.
04Qualified NDE Approved Early Childhood Education Program.Students in a center-based Rule 11 approved early childhood education program that is not state grant funded and has been approved for three consecutive years; therefore, four year old students as of July 31 are eligible for state aid.
05Early Childhood Birth to Age 3 Endowment Grant Program.Students age birth to age 3 served in a center-based program or a home visitation program or a combination of the two programs. Applies only to public school districts receiving an Early Childhood Birth to Age 3 Endowment Grant.
06Home-based Early Childhood Education Program.Students age birth to kindergarten entrance age served in a home visitation program.