Student Special Education Program Associations (Texas v4.0)

Tool Search Terms: Ed-Fi

Reports the Special Education data for a student.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When an IEP is created and locked and overlaps the configured year and the student has an enrollment in the configured year. Do not send a record if enrollment is in a calendar marked as Exclude. Do not send a record if enrollment is in a school marked as Exclude. The Print Format of the IEP can be either the Campus Default IEP or a State IEP. Do not send a record if enrollment is marked as No Show.
Delete/Post	A delete/post is performed when a data element that is part of the natural key is changed.
Put	A put is performed when a data element not part of the natural key is changed.
Delete	The locked IEP is deleted or unlocked for a student.
Delete	All enrollments are deleted for a student.
Delete	If the student's enrollment is marked as No Show.
Delete	If the IEP no longer overlaps the configured year.
Delete	The state reporting record is deleted.
Delete	The state reporting record no longer overlaps the configured year.

Resource Toggle/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.
Resync	If the Student Special Education Program Association is toggled off, do not delete records from this resource in the State ODS when resyncing.

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 IEP Start Date changes the resource will delete/repost.
Delete	Cascading Deletes: N/A there are no dependent resources.

Scope Year Logic

This table describes scope year logic of this object.

Business Rules
The record will send to any year with which the IEP overlaps. Data only sends for the years that have valid configuration.

Resources Preferences

Data Element Label	Mapping Needed
Special Education Setting Descriptors	Enrollment Special Ed Setting
OR
Special Education Setting Descriptors	Plan Special Ed Setting
OR
Special Education Setting Descriptors	State Reporting Special Ed Setting
Select the Program Type Descriptor associated with this Program	Program Type Descriptor

Identity Mapping Object Key

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

campusObjectType	Object Key Data Source
Plan	planID
SpecialEDState	specialEDStateID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
plan	Post/Put/Delete	The primary table used for sending data for this resource.
enrollment	Put	Reports ideaEligibility and specialEducationSettingDescriptor.
specialedstate	Post/Put/Delete	The primary table used for sending data for this resource.

Object Data Elements

This table describes data elements sent within the Student Special Education Program Associations resource.

Click here to expand...

Data Element Label	Business Requirement	Logic	M, C or O	Location
id	The unique identifier of the resource.		M
beginDate	The month, day, and year on which the Student first received services.	Reports the IEP Start Date.	M	Student Information > Special Ed > General > Documents > IEP > Start Date plan.startDate
educationOrganizationReference	The education organization where the student is participating in or receiving the program services.	Reports the State District Number.	M	System Administration > Resources > District Information > State District Number district.number
programReference	A reference to the Program Resource.	Reports the Natural Key for the Special Education Program.	M
studentReference	A unique alpha-numeric code assigned to a student.	Reports the Natural Key for the Student resource.	M
disabilities	The student's disability(-ies).	See the array below for specific logic.	O
endDate	The month, day, and year on which the student exited the program or stopped receiving services.	This is optional, does not report.	O
ideaEligibility	Indicator of the eligibility of the student to receive special education services according to the Individuals with Disabilities Education Act (IDEA).	This is optional, does not report.	O
studentSPEDProgramAssociationSets		See the array below for specific logic.	O
instructionalSettingSets		See the array below for specific logic.	O
languageAcquisitions		See the array below for specific logic.	O
hearingAmplifications		See the array below for specific logic.	O
assessments		See the array below for specific logic.	O
studentResidentialFacilityAssociations		See the array below for specific logic.	O
iepBeginDate	The effective date of the most recent IEP.	This is optional, does not report.	O
iepEndDate	The end date of the most recent IEP.	This is optional, does not report.	O
iepReviewDate	The date of the last IEP review.	This is optional, does not report.	O
lastEvaluationDate	The date of the last special education evaluation.	This is optional, does not report.	O
medicallyFragile	Indicates whether the Student receiving special education and related services: is in the age range of birth to 22 years, and has a serious, ongoing illness or a chronic condition that has lasted or is anticipated to last at least 12 or more months or has required at least one month of hospitalization, and that requires daily, ongoing medical treatments and monitoring by appropriately trained personnel which may include parents or other family members, and requires the routine use of medical device or of assistive technology to compensate for the loss of usefulness of a body function needed to participate in activities of daily living, and lives with ongoing threat to his or her continued well-being. Aligns with federal requirements.	This is optional, does not report.	O
multiplyDisabled	Indicates whether the Student receiving special education and related services has been designated as multiply disabled by the admission, review, and dismissal committee as aligned with federal requirements.	This is optional, does not report.	O
reasonExitedDescriptor	Defines the reason a student exited a program.	This is optional, does not report.	O
schoolHoursPerWeek	Indicates the total number of hours of instructional time per week for the school that the student attends.	This is optional, does not report.	O
servedOutsideOfRegularSession	Indicates whether the Student received services during the summer session or between sessions.	This is optional, does not report.	O
serviceProviders	An unordered collection of student Special Education Program Association Service Providers. The staff providing Special Education services to the student.	This is optional, does not report.	O
specialEducationHoursPerWeek	The number of hours per week for special education instruction and therapy.	This is optional, does not report.	O
specialEducationProgramServices	An unordered collection of studentProgramAssociation Services. This association represents the Special Education program(s) in which a student participates in or from which the receive services.	See the array below for specific logic.	O
specialEducationSettingDescriptor	The Special Education setting for the student.	Reports the Ed-Fi code for the value selected in Special Ed setting from the IEP or State Reporting Record being reported. Does not report if the field is blank or Ed-Fi Code is NULL.	O	Student Information > Special Ed > Documents > Plan > Current Plan > Enrollment Status> Special Ed Setting OR Student Information > Special Ed > Special Ed Setting enrollment.specialEdSetting OR plan.specialEdSetting OR specialedstate.specialEdSetting
preferredHomeCommunicationMethodDescriptor	The preferred unique communication method used by the child at home.	Reports mapped Ed-Fi Code of Preferred Home Communication Method.	C	Student Information > Special Ed > General > Documents > Evaluation > Settings and Disabilities

Arrays

Click here to expand...

Student SPED Program Association Set

Data Element Label	Business Requirement	Logic	M, C or O	Location
medicallyFragile	Indicates whether the student receiving special education and related services is: 1) in the age range of birth to 22 years, and 2) has a serious, ongoing illness or a chronic condition that has lasted or is anticipated to last at least 12 or more months or has required at least one month of hospitalization, and that requires daily, ongoing medical treatments and monitoring by appropriately trained personnel which may include parents or other family members, and 3) requires the routine use of medical device or of assistive technology to compensate for the loss of usefulness of a body function needed to participate in activities of daily living, and 4) lives with ongoing threat to his or her continued well-being.	There is currently no appropriate Ed-Fi mapping for this field.	O	Special Ed > Documents > IEP > SPED Services > Service; Special Ed> Documents > IEP > Related Services > Service
multiplyDisabled	Indicates whether the student receiving special education and related services has been designated as multiply disabled by the admission, review, and dismissal committee. [See 19 TAC §89.1040(c)(6).]	Reports 'True' if Multiply Disabled = selected.	O	Special Ed > Documents > IEP > Enrollment Status > Multiply Disabled
leaOfRDSPDService	Indicates the RDSPD Fiscal Agent district that provides the RDSPD service to a particular RDSPD student	Reports the value in the District of RDSPD Services field.	O	Student Information > Special Ed > Documents > SPED Services > District of RDSPD Services
childCountFunding Descriptor	Indicates under which federal program the student receiving special education and related services is counted.	Does not exist in Infinite Campus.	O
ppcdServiceLocation Descriptor	Indicates whether or not the Preschool Program for Children with Disabilities (PPCD) student received their special education services in a regular early childhood program, which is defined as a program that is designed for typically developing children ages 3-5 and is not specifically or primarily designed for children with disabilities and includes (at the time of the placement decision) a majority of at least 50 percent of nondisabled children (i.e., children without an individualized education program (IEP)).	Reports State Code from the active SPED Service. Defaults to 0 if no PPCD Service Location selected under SPED Services. NOTE: Interpreting Service Codes and PPCD Service Location Codes are the only ones reported for this field from the Service drop list, in SPED Services.	O	Special Ed > Documents > IEP > SPED Services > Service; Special Ed> Documents > IEP > Related Services > Service
programBeginDate		Reports the IEP Start Date.	M	Special Ed > Documents > IEP
programEndDate		Reports the IEP End Date.	O	Special Ed > Documents > IEP

Instructional Setting Set

Data Element Label	Business Requirement	Logic	M, C or O	Location
instructionalSetting Descriptor	Identifies the setting used in providing instruction to students.	Reports mapped Ed-Fi Code of ESY Instructional Setting 1 and ESY Instructional Setting 2. Each field reports its own array.	M	Special Ed > Documents > IEP > ESY Settings and Hours > ESY Instructional Setting 1, ESY Instructional Setting 2
instructionalSetting BeginDate		Reports the IEP Start Date.	M	Special Ed > Documents > IEP
instructionalSettingEndDate		Reports the IEP End Date.	O	Special Ed > Documents > IEP

Disability

Data Element Label	Business Requirement	Logic	M, C or O	Location
disabilityDescriptor	Indicates the disability category that describes a child’s impairment.	Reports mapped Ed-Fi Code of Primary Disability, Secondary Disability, and Tertiary Disability.	M	Special Ed > Documents > IEP > Settings and Disabilities > Primary Disability, Secondary Disability, Tertiary Disability
disabilityDeterminationSource TypeDescriptor, disabilityDiagnosis, orderOfDisability, designations		Does not report.
disabilitySet /orderOfDisability	The OrderOfDisability is the order by severity of student’s disabilities: 1 – Primary 2 – Secondary 3 – Tertiary	Order is hardcoded to the following: 1 – Primary 2 – Secondary 3 – Tertiary	O	Special Ed > Documents > IEP > Settings and Disabilities
disabilitySet / eligibilityDateDisabilities	Indicates the date when a student who is deaf or hard of hearing is eligible for services.	Does not exist in Infinite Campus.	O
disabilitySet /disabilitySetBeginDate		Reports the Settings and Disabilities Start Date.	O	Special Ed > Documents > IEP > Settings and Disabilities
disabilitySet /disabilitySetEndDate		Reports the Settings and Disabilities End Date.	O	Special Ed > Documents > IEP > Settings and Disabilities

Special Education Program Service

Data Element Label	Business Requirement	Logic	M, C or O	Location
specialEducationProgramService Descriptor	Defines the services provided by an education organization to populations of students associated with a special education program.	Reports the mapped Ed-Fi Code of the SPED Service.	M	Special Ed > Documents > IEP > SPED Services
ServiceBeginDate	The first date the student was in the option.	Reports the Service Start Date.	M
ServiceEndDate	The first date the student was no longer in the option.	Reports the Service End Date.	O
ServiceProvider		Does not report.	O
PrimaryIndicator		Does not report.	O

Language Acquisitions

Data Element Label	Business Requirement	Logic	M, C or O	Location
langAcqServicesProvided Descriptor	The specific language acquisition services provided to the student.	Reports the mapped Ed-Fi Code of Services Provided.	M	Special Ed > Documents > IEP > Language Acquisition Services
frequencyOfServicesDescriptor	The frequency a student receives services.	Reports the mapped Ed-Fi Code of Frequency of Services.	M	Special Ed > Documents > IEP > Language Acquisition Services
hoursSpentReceivingServices Descriptor	The amount of time the student receives services.	Reports the mapped Ed-Fi Code of Hours Spent Receiving Services.	M	Special Ed > Documents > IEP > Language Acquisition Services

Hearing Amplifications

Data Element Label	Business Requirement	Logic	M, C or O	Location
hearingAmplificationType Descriptor	The type of hearing amplification device used by the student.	Reports the mapped Ed-Fi Code of Hearing Amplification Type.	M	Special Ed > Documents > IEP > Hearing Amplification
hearingAmplificationAccess	Identifies whether the student has access to the hearing amplification device for the full-day or partial day for each HearingAmpplificationType reported.	Reports mapped Ed-Fi Code of Hearing Amplification Access.	O	Special Ed > Documents > IEP > Hearing Amplification
hearingAmplificationDailyUse	The average amount of time the hearing amplification device is used in a day based on the HearingAmplificationAccess reported.	Reports the mapped Ed-Fi Code of Average Daily Use.	O	Special Ed > Documents > IEP > Hearing Amplification

Assessments

Data Element Label

Business Requirement

Logic

M, C or O

Location

ToolOrAssessmentUsed
Descriptor

The tool or assessment used to assess the student’s language

acquisition.

Reports the mapped Ed-Fi Code of the Tool or Assessment used.

Student Information > SPED > General > Documents > Data Plan > Language Acquisition > Tool or Assessment Used

AssessmentResultsObtained
Descriptor

Identifies the result of tools or assessments used to assess the student’s language acquisition.

Reports the mapped Ed-Fi Code of the Assessment Results Obtained.

Student Information > SPED > General > Documents > Data Plan > Language Acquisition > Assessment Results Obtained

Student Residential Facility Associations

Data Element Label	Business Requirement	Logic
ResidentialFacilityId	The unique residential facility identification number registered with the Texas Education Agency (TEA).	Does not exist in Infinite Campus.
DateEnteredRF	The date the student enters the residential facility.	Does not exist in Infinite Campus.
DateExitedRF	The date the student exits the residential facility.	Does not exist in Infinite Campus.
StudentResFacAssocSe		Does not exist in Infinite Campus.

Student Res Fac Assoc Sets

Data Element Label	Business Requirement	Logic
StudentResFacAssocSetBeginDate	Indicates the first month, day, and year the student enters a residential facility.	Does not exist in Infinite Campus.
StudentResFacAssocSetEndDate	Indicates the first month, day, and year the student is no longer in attendance a residential facility.	Does not exist in Infinite Campus.
AttendanceZoneCampus	Nine-digit identifying number (assigned by the TEA) of the campus the student is expected to attend based on the geographic location (address) of the residential facility in which the student resides. This may or may not be the same as the “SchoolId.”	Does not exist in Infinite Campus.
EducatedAtResidentialFacility	Indicates whether a student is educated at or in the general location of a residential facility.	Does not exist in Infinite Campus.
SurrogateParentAssigned	Indicates whether the student has been assigned a surrogate parent.	Does not exist in Infinite Campus.
NumberOtherStudentsAssignedSame SurrogateParent	Indicates how many other students have been assigned to the same surrogate parent.	Does not exist in Infinite Campus.
ResidentialFacilityStudentSchoolDay Length	Number of minutes the residential facility student receives instruction based on the Individualized Education Plan (IEP).	Does not exist in Infinite Campus.
CampusIdOfEnrollmentSchoolDay Length	Indicates the number of instructional minutes in a school day for a non-disabled peer at the SchoolID of enrollment.	Does not exist in Infinite Campus.