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

Tool Search: 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
Delete	If the student's enrollment is marked as No Show or State Exclude.

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

Click here to expand...

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