Michigan Ed-Fi Data v3.1 - Student Title 1 TAS Program Association

Classic View: System Administration > Ed-Fi

Search Terms: Ed-Fi

This association represents the Title I TAS program(s) that a student participates in or received services from.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	Title 1: When a student is associated with one or more programs that have: State Reported = selected Code = 6011, 6012, 6013, 6014, 6015, 6016, 6017, 6021, 6022, 6023, 6024, 6025, 6026, 6027, or 6028 If the student has Title 1 program records with a Location = NOT NULL for a School in which they are enrolled, report a record. If the student has Title 1 program records with a Location = NOT NULL for a School in which they are not enrolled, do not report a record. If the student has Title 1 program records with a Location = NULL, report a record for each school they are enrolled. 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 Exclude. Do not send a record if enrollment is in a School marked as Exclude.
Delete/Post	When any part of the natural key is changed: Start Date is changed for a Title 1 program.
Delete	When Location is changed from NULL to a school, delete any school records not associated with the selected school.
Delete	When Location is changed from one school to another school, delete any school records not associated with the selected school.
Post	When Location is changed from a school to NULL, post records for any enrollment not associated with the changed school.
Put	When any field that is not part of the natural key is changed, including the following: services programSupports
Delete	When Title 1 program is deleted.
Delete	All overlapping enrollments are deleted for a school

Scope Year Logic

This table describes scope year logic of this object.

Logic
Title 1: Record will report for each year where an active Title 1 program record exists. Student program must be associated with a school. Student program must be active within the Scope Year. If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX.

Logic

Title 1: Record will report for each year where an active Title 1 program record exists.

Student program must be associated with a school.
Student program must be active within the Scope Year.
If the school year Start and End Date = Null, then report 07/01/XXXX as the Start Date and an End Date of 06/30/XXXX.

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.

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path
id	The unique identifier of the resource		M
educationOrganization Reference	A reference to the related EducationOrganization resource.	Report the State School Number from the school the student is enrolled and the title 1 record is associated.	M
programReference	A reference to the related Program resource.	Report Title I Program reference.	M
studentReference	A reference to the related Student resource.	Reports the data that is part of the Natural Key for the Student resource.	M
beginDate	The month, day, and year on which the Student first received services.	Report earliest enrollment Start Date for the school year	M	Student Information > General > Enrollments > Start Date
endDate	The month, day, and year on which the Student exited the Program or stopped receiving services.	Optional, do not report.	O
reasonExited Descriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	Optional, do not report.	O
servedOutsideOf RegularSession	Indicates whether the student received services during the summer session or between sessions.	Optional, do not report.	O
enrollmentStatus		Optional, do not report.	O
services	An unordered collection of studentProgramAssociationServices. Indicatesthe services being provided to the student by the program.	Reports Title I Instructional Services See array for field logic.	O
programSupports	An unordered collection of studentTitleITASProgram AssociationProgramSupports.	Reports Title I Support Services See array for field logic.	O

Arrays

Services

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path
serviceDescriptor	The ID of the Service Descriptor.	Reports Code from program. State Reported must be selected. Code must be 6011, 6012, 6013, 6014, 6015, 6016, or 6017.	M	Student Information > Program Participation > Programs > Program Code
primaryIndicator	True if service is a primary service.	Optional, does not report.	O
serviceBeginDate	First date the Student was in this option for the current school year.	Report the program Start Date.	M	Student Information > Program Participation > Programs > Start Date
serviceEndDate	Last date the Student was in this option for the current school year.	Report the program End Date.	O	Student Information > Program Participation > Programs >End Date

Program Supports

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
programSupportDescriptor	The ID of the Service Descriptor.	Reports Code from program. State Reported must be selected. Code must be 6021, 6022, 6023, 6024, 6025, 6026, 6027, or 6028.	M	Student Information > Program Participation > Programs > Program Code

Type/Descriptors

Service Descriptor

Ed-Fi Code Value	Short Description	Description
6011	Reading/Language Arts	Supplemental instruction provided to the student in reading or language arts and funded by Title I.
6012	English (ESL) for LEP Students	Supplemental instruction provided to an English-language learner (ESL, LEP) to improve his/her English-language skills and funded by Title I.
6013	Mathematics	Supplemental instruction provided to the student in mathematics and funded by Title I.
6014	Science	Supplemental instruction provided to the student in science and funded by Title I.
6015	Social Studies	Supplemental instruction provided to the student in social studies and funded by Title I.
6016	Vocational/Career	Supplemental instruction provided to the student in vocational or career development and funded by Title I.
6017	Other	Supplemental instruction provided to the student in an academic area not covered by another category and funded by Title I.

Program Support Descriptor

Ed-Fi Code Value	Short Description	Description
6021	Supporting Guidance/Counseling	A certified school counselor providing additional supplementary guidance and counseling to eligible students.
6022	Social Work, Outreach/Advocacy	A certified school social worker hired to provide one-on-one or small group supplementary support.
6023	Prevention Education	A supplementary support program approved in the Consolidated Application.
6024	Health	A school nurse hired to provide supplemental health services; does not include immunization, medication or health checks.
6025	Dental	Only as all other resources are exhausted.
6026	Eye Care	Only as all other resources are exhausted.
6027	Pupil Transportation	Only for Title I program and services.
6028	Other	TAS service that does not fall within one of the other categories.