Student Program Associations (Arizona 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

Flags and Programs

This reports from BOTH Programs and Flags. Districts should choose only ONE method and stay consistent. When a need is created in both areas, two records are sent.

Click here to expand...
ActionTrigger
Post

Reports a record based on the student's enrollment record: Service Type = P.

  • When a student has multiple enrollments with a Local Service Type of P: Primary in the same school and start date, reports from the earliest created enrollment.  
  • When a student has multiple enrollments with a Local Service Type of P: Primary in the same school with different start dates, reports with the following logic:
    • Reports a record from the enrollment with the earliest start date and sets the end date to one day prior to the start date of the next enrollment.
    • Reports a second record from the enrollment with the later start date and sets the start date to the enrollment start date and the end date to the enrollment end date. When the enrollment end date is blank, set end date to the calendar end date.
  • Only sends a recrd for enrollments that have a Local Service Type OTHER than P: Primary when they are the only enrollment in a given time frame.This means the enrollment does not overlap with any other enrollment from the same school or any other school.
  • A record is not sent for enrollments that have a Local Service Type OTHER than P:Primary OR T:AOI AND the enrollment Resident District does not match the District Information > State District Number.
    • When enrollment Resident District does not match the State District Number, loops through all of the credentials and compare to the District Number.
  • A record is not sent for an enrollment that is marked as State Exclude or No Show.
  • A record is not sent when an enrollment is in a calendar marked as State Exclude.
  • A record is not sent when the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
  • A record is not sent when the Grade Level Exclude checkbox is marked in the grade level record tied to the calendar in which the student is enrolled.
Post

When a Flag/Program record is created and saved for a student that is mapped to a state program code.

  • Flag/Program start date must be on or after enrollment start date.
Put

When a Program is changed on an existing Flag/Program for a student mapped to a state program code. 

  • When the state program code is changed from one mapped code to another, the updated code is posted.
PostWhen a new enrollment is created for a student that has an active Flag/Program mapped to a state program code. 
  • Enrollment start date must be after the Flag/Program start date.
  • Flag/Program end date must be null or after the enrollment start date.
  • When the enrollment overlaps an existing enrollment within the same school, follow the Post requirements above; otherwise, post a new record.
Delete/PostWhen a start or end date is entered or changed for an existing record.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status of W1-W13.
DeleteWhen a program is changed on an existing Flag/Program. 
Delete

When Flag and Program record is deleted for a student.

  • When the student has two flag/programs with the same Program Name and Start Date, the record is not deleted unless all programs associated with the record are deleted.
DeleteWhen a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
DeleteWhen an existing enrollment is marked as State Exclude or No Show.

Gifted

Click here to expand...

ActionTrigger
Post

Reports a record based on a Gifted record being saved and overlapping the students enrollment record:  Service Type = P:

  • When a student has multiple enrollments with a Local Service Type of P:Primary in the same school and start date, report from the earliest created enrollment.  
  • When a student has multiple enrollments with a Local Service Type of P:Primary in the same school with different start dates, report with the following logic:
    • Reports a record from the enrollment with the earliest start date and set the end date to one day prior to the start date of the next enrollment.
    • Reports a second record from the enrollment with the later start date and set the start date to the enrollment start date and the end date to the enrollment end date. When enrollment end date is blank, set end date to the calendar end date.
  • A record is sent only when the enrollment has a Local Service Type other than P:Primary when they are the only enrollment in a given time frame. This means the enrollment does not overlap with any other enrollment from the same school or any other school.
  • A record is not sent for enrollments that have a Local Service Type OTHER than P:Primary OR T:AOI AND the enrollment Resident District does not match the following:
    • District Information > State District Number
    • When enrollment Resident District does not match the District Information > State District Number, loop through all of the credentials and compare to the District Number.
  • A record is not sent when the enrollment that is marked as State Exclude or No Show.
  • A record is not sent when the enrollment is in a calendar marked as State Exclude.
  • A record is not sent when the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
  • Records are not sent when the Grade Level Exclude check box is marked in the grade level record tied to the calendar in which the student is enrolled.
  • When a student has multiple overlapping gifted records, only one program association reports with the following logic:
    • Reports the start date based on the record with the earliest start date.
    • Reports the end date based on the record with the latest end date. When one record has an end date and the second record does not, the null end date is considered the latest end date.
  • A record is not sent when the No Gifted Program checkbox is marked.
Post

When a Gifted record is created and saved for a student.

  • Gifted start date must be on or after enrollment start date and the Gifted record end date is either null or after the enrollment start date.
Post

When a new enrollment is created for a student that has an active Gifted record:

  • Enrollment start date must be after Gifted start date.
  • Gifted end date must be NULL or after enrollment start date.
  • When the enrollment overlaps an existing enrollment within the same school, follow the post requirements based on the student's enrollment record, otherwise post a new record.
Delete/PostWhen a start or end date is entered or changed for an existing record.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status:  W1-W13.
Delete/PostWhen the enrollment tied to the Gifted record is deleted or made ineligible, and there is another eligible enrollment in the student's record (another overlapping one with perhaps a lower ranked Status value, non-excluded).
Delete

Gifted record is deleted for a student.

  • When the student has two Gifted records with the same Start Date, do not delete this record unless all Gifted records associated with the record are deleted.
DeleteWhen a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
DeleteWhen an existing enrollment is marked as State Exclude or No Show.
DeleteGifted record's start date or end date is changed, such that it no longer overlaps an eligible enrollment
DeleteWhen there is a delete/edit to the eligible enrollment reporting is based on, such that there are no longer any eligible enrollments.
DeleteWhen the 'No Gifted Program' checkbox is checked.

21 CCLC

Click here to expand...

ActionTrigger
Post

Reports a record based on a 21st CCLC record being saved and overlapping the students enrollment record: Local Service Type = O: Program Only

  • When a student has multiple enrollments with a Local Service Type of O: Program Only in the same school and start date, reports from the earliest created enrollment.
  • When a student has multiple enrollments with a Local Service Type of O: Program Only in the same school with different start dates that both overlap the 21st CCLC record, report from the enrollment with the oldest end date (a null end date is the oldest end date).
  • Only reports when the Resident District matches one of the following:
    • District Info > State District Number
    • When enrollment Resident District does not match the District Info > State District Number, loop through all of the credentials and compare to the District Number.
  • A record is not sent when the enrollment is in a calendar marked as State Exclude.
  • A record is not sent when the Grade Level Exclude checkbox is marked in the grade level record tied to the calendar in which the student is enrolled.
Post

When a 21st CCLC record is created and saved for a student.

  • 21st CCLC start date must be on or after enrollment start date and the 21st CCLC record end date is either null or after the enrollment start date.
PutWhen a Program is changed on the 21st CCLC record for a student mapped to a program code.
  • When he program code is changed from one mapped code to another, post the updated code.
Post

When a new enrollment is created for a student that has an active 21st CCLC record.

  • Enrollment start date must be after 21st CCLC start date.
  • 21st CCLC end date must be NULL or after enrollment start date.
  • When the enrollment overlaps an existing enrollment within the same school, follow the post requirements based on the student's enrollment record, otherwise post a new record.
Delete/PostWhen a start or end date is entered or changed for an existing record.
Delete/PostWhen an enrollment end date is entered for a student with a valid enrollment end status: W1-W51.
Delete/PostWhen the enrollment tied to the 21st CCLC record is deleted or made ineligible, and there is another eligible enrollment in the student's record (another overlapping one).
DeleteThe existing record is deleted when a Program is changed on an existing 21st CCLC record.
Delete

21st CCLC record is deleted for a student when:

  • The student has two 21st CCLC records with the same Program Name and Start Date, do not delete this record unless all programs associated with the record are deleted.
Delete21st CCLC record's start date or end date is changed, such that it no longer overlaps an eligible enrollment.
DeleteWhen there is a delete/edit to the eligible enrollment reporting is based on, such that there are no longer any eligible enrollments.

Title 1

Title 1 Schoolwide logic reports based on the most recent School History record for the school. One record for each reportable student in the school reports for each of the marked Title 1 programs (for example, when Title 1 Match and Title 1 Reading are marked, two records report for each reportable student). 

Click here to expand...
ActionTrigger
Post

When a school's School History has Title 1 set to Schoolwide Program. OR


When a student has an individual Title 1 record that overlaps an Enrollment that overlaps the configured year.


  • When a student has an individual Title 1 record in a school that has a Title 1 Schoolwide Program, reports only the individual Title 1 record.
  • When a student has multiple enrollments with a Local Service Type of P: Primary in the same school and start date, reports from the earliest created enrollment.
  • When a student has multiple enrollments with a Local Service Type of P: Primary in the same school with different start dates, reports with the following logic:
    • Reports a need from the enrollment with the earliest start date and sets the end date to one day prior to the start date of the next enrollment.
    • Reports a second need from the enrollment with the later start date and sets the start date to the enrollment start date and the end date to the enrollment end date. When the enrollment end date is blank, sets the end date to the calendar end date.
  • Does not send a record for enrollments that have a Local Service Type OTHER than P: Primary or T: AOI AND the enrollment Resident District does not match the following:
    • District Information > State District Number
    • When the Enrollment Resident District does not match the District Information > State District Number, loops through all of the credentials and compares it to the District Number.
  • Does not send a record when any of the exclusions apply:
    • Enrollment State Exclude
    • Enrollment No Show
    • Grade Level Exclude
    • Calendar State Exclude
    • School Exclude
    • Enrollment Start Status of E: NON-SAIS DISTRICT USE ONLY!
Delete/Post/PutA Delete/Post is performed when the natural key is changed. Otherwise, a Put is performed.

When the following information on an individual Title 1 record is changed:
  • Title 1 Record ID (New Title 1 Record)
  • School
  • Start Date
  • End Date
  • Instructional Services

When the following information on an Enrollment is changed:

  • State Exclude
  • No Show
  • Start Status
  • Start Date
  • End Date
DeleteWhen the Title 1 individual record is deleted.
DeleteWhen the associated enrollment is deleted.
DeleteWhen the Title 1 individual record dates are changed so they no longer overlap the associated enrollment.
DeleteWhen the enrollment dates are changed so they no longer overlap the configured year.

EL

Click here to expand...
ActionTrigger
Post

Reports a record based on the students enrollment record: Service Type = P.

  • When a student has multiple enrollments with a Local Service Type of P:Primary in the same school and start date, report from the earliest created enrollment.  
  • When a student has multiple enrollments with a Local Service Type of P:Primary in the same school with different start dates, report with the following logic:
    • Reports a record from the enrollment with the earliest start date and set the end date to one day prior to the start date of the next enrollment.
    • Reports a second record from the enrollment with the later start date and set the start date to the enrollment start date and the end date to the enrollment end date. When enrollment end date is blank, set end date to the calendar end date.
  • A record is only sent for enrollments that have a Local Service Type other than P:Primary when they are the only enrollment in a given time frame. This means the enrollment does not overlap with any other enrollment from the same school or any other school.
  • A record is not sent for enrollments that have a Local Service Type OTHER than P:Primary OR T:AOI AND the enrollment Resident District does not match the following:
    • District Information > State District Number
    • When enrollment Resident District does not match the District Information > State District Number, loop through all of the credentials and compare to the District Number.
  • A record is not sent for an enrollment that is marked as State Exclude or No Show.
  • A record is not sent when the enrollment is in a calendar marked as State Exclude.
  • A record is not sent when the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!.
PostWhen a LEP Service is created and saved for a student that is mapped to a state program code.
PostWhen a Service is changed on an existing Service for a student with a state program code.
Post

When a new enrollment is created for a student that has an active Service.

  • Enrollment start date must be after Service start date.
  • Service end date must be NULL or after enrollment start date.
  • When the enrollment overlaps an existing enrollment within the same school, follow the post requirements based on the student's enrollment record, otherwise post a new record.
Put

When a start or end date is entered or changed for an existing record.

  • When an enrollment end date is entered for a student with a valid enrollment end status:  W1-W13.
  • When an EL Service Type is updated.
DeleteDelete the existing Service when the Service is changed.
Delete

A Service is Deleted.

  • When the student has two services with the same start date, do not delete this record unless all services with the same start date are deleted.
DeleteWhen a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
DeleteWhen an existing enrollment is marked as State Exclude or No Show.

Section 504

Click here to expand...
ActionTrigger
Post

Reports a record based on a Section 504 record being saved with any disability being populated and overlapping the student's enrollment record: Service Type = P.

  • When a student has multiple enrollments with a Local Service Type of P:Primary in the same school and start date, reports from the earliest created enrollment.  
  • When a student has multiple enrollments with a Local Service Type of P:Primary in the same school with different start dates, reports with the following logic:
    • Reports a program association record from the enrollment with the earliest start date and sets the end date to one day prior to the start date of the next enrollment.
    • Reports a second program association record from the enrollment with the later start date and sets the start date to the enrollment start date and the end date to the enrollment end date. When enrollment end date is blank, sets the end date to the calendar end date.
  • A program association record is only sent for enrollments that have a Local Service Type other than P:Primary when they are the only enrollment in a given time frame. This means the enrollment does not overlap with any other enrollment from the same school or any other school.
  • A record is not sent for enrollments that have a Local Service Type OTHER than P:Primary OR T:AOI AND the enrollment Resident District does not the District Information > State District Number.
    • When the enrollment Resident District does not match the District Information > State District Number, loops through all of the credentials and compares it to the District Number.
  • A record is not sent for an enrollment that is marked as State Exclude or No Show.
  • A record is not sent when the enrollment is in a calendar marked as State Exclude.
  • A record is not sent when the enrollment Start Status = E: NON-SAIS DISTRICT USE ONLY!
  • A record is not sent when the Grade Level Exclude checkbox is marked on the grade level record tied to the calendar in which the student is enrolled.
PostWhen a Section 504 Service is created and saved for a student that has any disability populated. 
  • The Section 504 start date must be on or after the enrollment start date and the Section 504 record end date is either null or after the enrollment start date.
Post

When a new enrollment is created for a student that has an active Section 504 record with any disability populated.

  • Enrollment start date must be after the Section 504 start date.
  • Section 504 end date must be NULL or after enrollment start date.
  • When the enrollment overlaps an existing enrollment within the same school, follow the post requirements based on the student's enrollment record, otherwise post a new record.
Post

When a Section 504 record is updated to have a disability field populated when no disability previously existed. 

Delete/PostWhen a start or end date is entered or changed for an existing record. 
Delete/PostWhen a start or end date is entered for a student with a valid enrollment end status of W1-W13. 
Delete/Post

When the enrollment tied to the Section 504 record is deleted or made ineligible, and there is another eligible enrollment in the student's record (another overlapping one with perhaps a lower ranked status value, non-excluded).

DeleteWhen the Section 504 record is deleted for a student. 
DeleteWhen a student's enrollment Start Status is changed from a valid code to E: NON-SAIS DISTRICT USE ONLY! and saved.
DeleteWhen an existing enrollment is marked as State Exclude or No Show.
DeleteWhen the Section 504 record's start date or end date is changed, such that it no longer overlaps an eligible enrollment. 
DeleteWhen there is a deliete/edit to the eligible enrollment reporting based on, such that there are no longer any eligible enrollments. 
DeleteWhen all disabilities are removed and the record is saved. 

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
NoneWhen a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncWhen 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.
ResyncWhen 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.
ResyncWhen 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.

ActionTrigger
Post/Delete

Natural Key changes:

  • When the Flag Start Date or Flag Name changes, all Student Program Associations are deleted and then re-posted. 
DeleteCascading Deletes: N/A - No resources exist under 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.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label

Mapping Needed

Program Type Descriptors - FlagsProgram State Program Code
Reason Exited DescriptorsProgram Participation Exit Reason
Lep Service Exit Reason
Twenty First CCLC Exit Reason

Identity Mapping Object Key

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

campusObjectTypeObject Key Data Source
ProgramParticipationparticipationID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
programsPutThe primary table used for sending data for this resource.
programparticipationPutThe primary table used for sending data for this resource.

Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Flags and Programs

Click here to expand...

Data Element Label

Business Requirement and Rules

Mandatory,

Conditional, or Optional

Location

educationOrganization
Reference

The identifier assigned to an education organization.


Reports the School Entity ID.

MSchool Information > School Detail > Entity ID

school.entityid
programReference

The identifier assigned to an education organization.


  • Program Type: Reports Support Program when the Ed-Fi Code of the mapped dictionary value is any of the following (program  type ID = 60): 28-33, 36, 38, 40-41.
  • Reports Grand Canyon Diploma when the Ed-Fi Code of the mapped dictionary value is Grand Canyon Diploma (program type ID = 60).
  • Reports Dropout Recovery Program when the Ed-Fi Code of the mapped dictionary value is Dropout Recovery Program (program Type ID = 61).

Program Education Organization ID reports the district entity ID form the school editor when populated. When null, the District Entity ID reports. 


Program Name reports the Program Code plus the Program Name.

M

School Information > School Editor > District Entity ID


program.code

customschool.

districtentityid


District Information > District Detail > Entity ID


customdistrict.entityid

studentReferenceA reference to the related Student resource.

Reports the Student Reference


The Ed-Fi ID reports from the Student State ID field.

MDemographics > Student State ID

Person.stateID
beginDate

The month, day, and year on which the Student first received services. 


  1. Reports the start date from the Flag when: 
    • The Flag Start Date must be after the enrollment start date.
    • Enrollment End Date must be null or after the Flags start date.
  2. Reports the Enrollment Start Date when:
    • Enrollment Start Date is after the Flag start date.
    • Flag End Date is NULL or after Enrollment Start Date.

When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combines the enrollments and reports the earliest start date (where the start status is NOT ZZZ) for the enrollment start date.

  • The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
MFlags > Start Date

programparticipation.StartDate

Enrollment Start Date
endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.


  1. Reports the end date from the Flags record when populated.
    • The End Date must be before Enrollment End Date or before last instructional day of the calendar.
  2. Reports the Enrollment End Date when populated.

    • Enrollment End date must be after the Flag Start Date and before the Flag End Date and before last instructional day.

  3. Otherwise, reports the last instructional date from the calendar where the student is enrolled.
When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date.
  • The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
CProgram Participation

programparticipation.EndDate

Enrollments > End Date

enrollment.endDate

reasonExitedDescriptor

The reason the child left the Program within a school or district.


Reports from the Flag Exit Reason when populated, and the dictionary value is mapped in the Ed-Fi Resource Preferences area. Otherwise, does not report.


CFlags > Exit Reason

ProgramParticipation.exitReason

Type/Descriptors

Program Type
36 Johnson-O'Malley Indian Education
Coordinated Early Intervening Services- Behavior
Coordinated Early Intervening Services- Math
Coordinated Early Intervening Services- Other
Coordinated Early Intervening Services- Reading

Gifted

Click here to expand...

Data Element Label

Business Requirement and Rules

Mandatory, Conditional, or Optional

Location

educationOrganization
Reference
The identifier assigned to an education organization.

Reports the School Entity ID.
MSchool Information > School Detail > Entity ID

school.entityid
programReference

The identifier assigned to an education organization.


  1. Program Type: Reports Gifted and Talented.
  2. Program Education Organization Id: Reports the District Entity ID from the School Editor when  populated.
    • When NULL, report the District Entity ID.
  3. Program Name: Reports '35 Gifted Program'.
M

School Information > School Detail > District Entity ID


OR


District Information > District Detail > Entity ID



customschool.

districtentityid

or

customdistrict.entityid

studentReferenceA reference to the related Student resource.

Reports the Student Reference.


The Ed-Fi ID reports from the Student State ID field.

M
beginDate

The month, day, and year on which the Student first received services.


  1. Reports the start date from the Gifted record when:
    • Gifted Start Date must be after enrollment Start Date.
    • Enrollment End Date must be NULL or after Gifted start date.
  2. Reports the Enrollment Start Date when:
    • Enrollment Start Date is after the Gifted Start Date.
    • Gifted End Date is NULL or after Enrollment Start Date.
Note:

When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combines the enrollments and reports the earliest start date (where the start status is NOT ZZZ) for the enrollment start date.


The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.


When there are multiple gifted records, combines the records and reports the earliest start date for the Gifted Start Date.

MGifted > Start Date
gifted.startDate
endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.


Reports the end date from Gifted record when populated:
  • Gifted record End Date must be before Enrollment End Date or before last instructional day of the calendar.

Report Enrollment End Date when populated:

  • Enrollment End date must be after Gifted record Start Date and before Gifted record End Date and before last instructional day.



  • Otherwise, reports the last instructional date from the calendar where the student is enrolled.

Noes:

When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date.


The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.


When there are multiple gifted records, combine the gifted records and report the latest end date for the Gifted End Date.

CGifted > End Date

gifted.endDate
reasonExitedDescriptor

The reason the child left the Program within a school or district.


Do Not Report.



21 CCLC

Click here to expand...

Data Element Label

Business Requirement and Rules

Mandatory, Conditional, or Optional

Location

educationOrganization
Reference
The identifier assigned to an education organization.

Reports the School Entity ID.
MSchool Information > School Detail > Entity ID

school.entityid
programReference

The identifier assigned to an education organization.


  • Program Type: Reports Support Program.
  • Program Education Organization ID: Reports the District Entity ID from the School Editor when populated.
    • When NULL, reports the District Entity ID.
  • Program Name: Reports 21st CCLC.
M

School Information > School Detail > District Entity ID


OR


District Information > District Detail > Entity ID



customschool.

districtentityid

or

customdistrict.entityid

studentReferenceA reference to the related Student resource.

Reports the Student Reference.


The Ed-Fi ID reports from the Student State ID field.

M
beginDate

The month, day, and year on which the Student first received services.


Reports the start date from the 21st CCLC record.

M21st CCLC > Start Date
endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.


Reports the lesser of the 3 following dates:
  • 21st CCLC program record end date
  • 21st CCLC enrollment end date
    • Identified by an enrollment with a Local Service type of O: Program Only that overlaps the 21st CCLC program record.
  • Last Instructional Date from the calendar where the student's 21st CCLC enrollment is.
C21st CCLC > End Date
reasonExitedDescriptor

The reason the child left the Program within a school or district.


  1. Reports from Exit Reason when not  NULL, and dictionary value is mapped in the EdFi Resource Preferences area.
  2. Otherwise, does not report.

21st CCLC > Exit Reason

Title 1

Click here to expand...

Data Element Label

Business Requirement and Rules

Mandatory, Conditional, or Optional

Location


educationOrganization
Reference
The identifier assigned to an education organization.

Reports the fields that part of the Natural Key for the Local Education Agency resource:
  • educationOrganizationID = School Entity ID
MSchool Information > School Detail > Entity ID

school.entityid
programReference

The identifier assigned to an education organization.


Individual:

Reports the fields that are part of the Natural Key for the Programs resource.


  • educationOrganizationID = District Entity ID
    • Reports first from the School editor when populated; then defaults to the school associated with the enrollment.
  • programName = Reports the Program Code + Program Name (hard coded) 
    • Example: 28 Title 1 Mathematics
  • programTypeDescriptopr = Support Program (hard coded)

Schoolwide:


  • educationOrganizationID = District Entity ID
  • programName = 20: Title 1 Other (hard coded)
  • programType Description = Support Program (hard coded)
M

Title 1 > Instructional Services


School Information > School Detail >  District Entity ID


OR


District Information > District Detail > Entity ID


program.code

customschool.

districtentityid


or

customdistrict.

entityid

studentReference

A reference to the related Student Resource. 


Reports the fields that are part of the Natural Key for the Students resource:

  • studentUniqueID = Student State ID
MDemographics > Student State ID
beginDate

The month, day, and year on which the Student first received services.


Individual:

Reports the latest of the following dates:

  • Title 1 Start Date
  • Enrollment Start Date

Reports the future nearest instructional date when the calculated date is not an instructional day. 

  • Example:
    • 10/13/2023 is the calculated date. This is not an instructional day.
    • 10/14/2023 is not an instructional day.
    • 10/15/2023 IS an instructional day.
    • 10/15/2023 reports.


Schoolwide:

Reports the Enrollment Start Date.

Reports the future nearest instructional date when the calculated date is not an instructional day. 
  • Example:
    • 10/13/2023 is the calculated date. This is not an instructional day.
    • 10/14/2023 is not an instructional day.
    • 10/15/2023 IS an instructional day.
    • 10/15/2023 reports.

When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, the enrollments are combined and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date.

  • The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status or be before or equal to the ZZZ end status.
MTitle 1 > Start Date

programparticipation.StartDate
endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.


Individual:

Reports the earliest of the following dates:

  • Title 1 End Date
  • Enrollment End Date
  • Last Instructional Day of the Calendar

Reports the past nearest instructional date when the calculated date is not an instructional day. 

  • Example:
    • 2/13/2023 is the calculated date. This is not an instructional day.
    • 2/23/2023 is not an instructional day.
    • 2/11/2023 IS an instructional day.
    • 2/11/2023 reports.


Schoolwide: 

Reports the earlier of:

  • Enrollment End Date
  • Last Instructional Day of the Calendar

Reports the past nearest instructional date when the calculated date is not an instructional day:

  • Example:
    • 2/13/2023 is the calculated date. This is not an instructional day.
    • 2/23/2023 is not an instructional day.
    • 2/11/2023 IS an instructional day.
    • 2/11/2023 reports. 

Notes:

When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, the enrollments are combined and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date.
  • The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
CTitle 1 > End Date

programparticipation.
EndDate
reasonExitedDescriptor

The reason the child left the Program within a school or district.


Does not report. This is optional.

O

EL

Click here to expand...

Data Element Label

Business Requirement and Rules

Mandatory, Conditional, or Optional

Location


educationOrganization
Reference

The identifier assigned to an education organization.


Reports the School Entity ID.

MSchool Information > School Detail > Entity ID

school.entityid
programReference

The identifier assigned to an education organization.


  1. The Program Type = ELL
  2. Program Type ID = 1
  3. Program Education Organization Id: Reports the District Entity ID from the School Editor when populated.
    • When NULL, report the District Entity ID.
  4. Program Name: Reports the Program Code + Program Name


studentReference

Reports the Student Reference.


Note: The Ed-Fi ID reports from the Student State ID field.




beginDate

The month, day, and year on which the Student first received services.


  1. Reports the start date from the EL Service when:
    • EL Service Start Date is after enrollment Start Date.
    • Enrollment End Date must be NULL or after EL Service start date.
  2. Report the Enrollment Start Date when:
    • Enrollment Start Date is after the EL Service Start Date.
    • EL Service End Date is after the Enrollment Start Date.
  3. When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date.
    • The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
M

EL Services > Start Date


lepservice.StartDate



Enrollments > Start Date


enrollment.startdate

endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.


  1. Reports the end date from EL Service when populated
    • EL Service End Date must be before Enrollment End Date or before last instructional day of the calendar.
  2. Reports Enrollment End Date when populated.
    • Enrollment End date must be after EL Service Start Date and before EL Service End Date and before last instructional day.

  3. Else, reports the last instructional date from the calendar where the student is enrolled.
  4. When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date.
    • The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
C

EL Services > End Date


lepservice.EndDate



Enrollments > End Date


enrollment.EndDate

reasonExitedDescriptor

The reason the child left the Program within a school or district.


  1. Reports the mapped Ed-Fi Code from the Exit Reason selected on the EL Service when populated.
  2. Reports ELL02 when the Enrollment End Date is populated and End Status is W1-13, W21-22, W41, or W51.
    • Program End Date must be null or on or after the Enrollment End Date.
  3. Report ELL08 when Enrollment End Date is populated and End Status is 'WK'.
    • Program End Date must be null or on or after the Enrollment End Date.
  4. Else, report ELL06.

EL Services > Exit Reason

Section 504

Click here to expand...

Data Element Label

Business Requirement and Rules

Mandatory, Conditional, or Optional

Location


educationOrganization
Reference

The identifier assigned to an education organization.


Reports the School Entity ID.

MSchool Information > School Detail > Entity ID

school.entityid
programReference

The identifier assigned to an education organization.


  • The Program Type reports Special Education.
  • Program Education Organization ID reports the District Entity ID from the School Editor when populated. When NULL, report the District Entity ID.
  • Program Name reports L Group B Disability services for Students no on an IEP.


studentReference

Reports the Student Reference.


The Ed-Fi ID reports from the Student State ID field.



beginDate

The month, day, and year on which the Student first received services.


  • Reports the start date from the Section 504 record when:
    • Section 504 Start Date is after enrollment Start Date.
    • Enrollment End Date must be NULL or after the Section 504 start date.
  • Reports the Enrollment Start Date when:
    • Enrollment Start Date is after the Section 504 Start Date.
    • Section 504 End Date is after the Enrollment Start Date.
  • When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the earliest start date (where the start status is NOT ZZZ) for the enrollment start date.
    • The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
M

Section 504 > Start Date


Section504. StartDate


Enrollments > Start Date


enrollment.startdate

endDate

The month, day, and year on which the Student exited the Program or stopped receiving services.


  • Reports the end date from the Section 504 record when populated.
    • Section 504 End Date must be before Enrollment End Date or before last instructional day of the calendar.
  • Reports Enrollment End Date when populated.
    • Enrollment End date must be afterthe Section 504 record Start Date and before the Section 504 End Date and before last instructional day.

  • Otherwise reports the last instructional date from the calendar where the student is enrolled.
  • When there are enrollments with an end status of ZZZ and a subsequent enrollment with a start status of ZZZ, combine the enrollments and report the latest end date (where the end status is NOT ZZZ) for the enrollment end date.
    • The enrollments must be in the same school, grade, and local service type. Also, the enrollment start date must be the next instructional day after the ZZZ end status, or be before or equal to the ZZZ end status.
C

Section 504 > End Date


Section504.endDate


Enrollments > End Date


enrollment.EndDate

reasonExitedDescriptor

The reason the child left the Program within a school or district.


Does not report for Section 504.

ON/A