Student School Associations (New Mexico v3.5)

Tool Search: Ed-Fi

This association represents the school in which a student is enrolled.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a new enrollment is saved for a student. A record will report for each distinct enrollment in a School and Enrollment Start Date. When a student has two enrollments in the same School, Calendar & Schedule Structure with the same start date, report from the enrollment service type in the following order: P: Primary Enrollment S: Partial/Ancillary N: Special Ed Services When a student has two Primary enrollments in the same school with the same start date, post the record with the highest enrollment ID. When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record. Do not send records if the Calendar Exclude check box is checked in the calendar the student is enrolled. Do not send records if the School Exclude check box is checked in the calendar the student is enrolled. Do not send records if Summer School is checked in the calendar the student is enrolled. Do not send a record if the No Show check box is checked. Do not send a record if the Grade Level is state excluded for the calendar of the enrollment.
Post	When the start date for an enrollment is changed. When an enrollment with a lower priority is changed, data will not send.
Post	When the State Exclude is unchecked for the enrollment.
Put	When an enrollment is updated for a student. When a student's start status is changed. When a student's end status is changed. When a student's grade level is changed. When a student's Resident District or Service District fields are changed. When a students Service Type is changed. When the Calendar reference is changed due to a Natural Key update on the Calendars resource. When the student's Diploma Date is entered or changed for an enrollment with Exit Type= G
Delete	When an enrollment is deleted. When a student has two enrollments in the same school for the same start date, records with lower priority will not trigger a delete.
Delete	When the start date of an enrollment is changed.
Delete	When the No Show check box is checked.
Delete	When the State Exclude box is checked.

Resource Toggle and Resync Logic

This table describes the Resource Toggle and Trigger logic of this object.

Action	Business Rule
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.
Put	If the natural key of the Calendar Reference is changed, a put will be done to update the Calendar Reference even if the Student School Association resource is turned 'OFF'.
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.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

Action	Business Rule
Post/Delete	Natural Key changes: If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID Change triggers. If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger. If the enrollment start date changes, all dependent resources will be deleted and re-posted. If a dependent resource is turned off, all dependent resources will be deleted and not re-posted.
Delete	Cascading Deletes: If the Student School Association is deleted, all dependent resources will be deleted. Student Parent Associations, Student Education Organization Associations, Student Section Associations, Graduation Plans, Student Program Associations, Student CTE Program Associations, Student Special Education Program Associations, Student Title 1 Part A Program Associations, Student Academic Records, Course Transcripts, Grades, Student Discipline Incident Associations, Discipline Actions, Student Cohort Associations, Student School Attendance Events, Student Section Attendance Events

Action

Business Rule

Post/Delete

Natural Key changes:

If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID Change triggers.
If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
If the enrollment start date changes, all dependent resources will be deleted and re-posted. If a dependent resource is turned off, all dependent resources will be deleted and not re-posted.

Delete

Cascading Deletes: If the Student School Association is deleted, all dependent resources will be deleted.

Student Parent Associations, Student Education Organization Associations, Student Section Associations, Graduation Plans, Student Program Associations, Student CTE Program Associations, Student Special Education Program Associations, Student Title 1 Part A Program Associations, Student Academic Records, Course Transcripts, Grades, Student Discipline Incident Associations, Discipline Actions, Student Cohort Associations, Student School Attendance Events, Student Section Attendance Events

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 enrollment 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
Entry Type Descriptors	Enrollment Start Status
Exit Withdraw Type Descriptors	Enrollment End Status

Identity Mapping Object Key

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

campusObjectType	Object Key Data Source
Enrollment	enrollmentID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
enrollment	Post/Put/Delete	The primary table used for sending data for this resource.
person	Post/Delete	Student ID in Student Reference
graduation	Put	Class of School Year Type Reference
programs	Put	Graduation Plan Reference
programparticipation	Put	Graduation Plan Reference

Object Data Elements

This table describes data elements sent within the Student School Association resource.

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
entryDate	The month, day, and year on which an individual enters and begins to receive instructional services in a campus.	Report the enrollment start date.	M	Student Information> General> Enrollments> Start Date	enrollment.startdate
calendar Reference	A reference related to the Calendar resource.	Report the Calendar reference for the calendar in which the student is enrolled that is being reported.	M
classOfSchool YearType Reference	The year the student is expected to graduate.	Report the year selected in Student Info > General > Graduation > NCLB Cohort End Year. If NCLB Cohort End Year = Null, do not report.	C
graduationPlan Reference	A reference to the related GraduationPlan resource.	Report the associated Graduation Plan when a student is assigned to a Graduation Program or Career Tech Program that is eligible to report to Ed-Fi. The Program Participation record must overlap the enrollment(s) that are aligned to the Student School Association record(s) being reported. Report the Graduation Plan School year that is aligned to the student's NCLB Cohort End Year. If the student does not have a NCLB Cohort End Year, do not report a record. If the student has both a CTE & Graduation Plan, report the Graduation Plan. If the student has more than 1 Graduation Plan, report the plan with the most recent start date.	O
school Reference	A reference to the related School resource.	Report Ed-Fi School ID.	M	System Administration > Resources> School > Ed-Fi School ID
schoolYearType Reference	The school year in which the student is being reported.	Reports the end year of the calendar.	O
student Reference	A reference to the related Student resource.	Report the reference for the student being reported.	M	Census > Demographics > Ed-Fi ID
educationPlans	An unordered collection of student School Association Education Plans. This association represents the school in which a student is enrolled.	This is optional, does not report.	O
employedWhile Enrolled	An individual who is a paid employee or works in his or her own business, profession, or farm and at the same time is enrolled in secondary, postsecondary, or adult education.	This is optional, does not report.	O
entryGradeLevel Descriptor	The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.	Report the Ed-Fi Code from the Grade Level mapping for the grade selected on the student's enrollment. If a mapping is not available, the record will error.	M	Student Information> General> Enrollments> Grade
entryGradeLevel ReasonDescriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	This is optional, does not report.	O
entryType Descriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	Report the Ed-Fi code value mapped to the Start Status selected for the student's enrollment.	M	Student Information> General> Enrollments> Start Status	enrollment.startstatus
exitWithdraw Date	The month, day, and year of the first day after the date of an individual''s last attendance at a campus (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school. NEDM: Exit/Withdraw Date	Reports the date, if exitWithdrawTypeDescriptor value is populated: If exitWithdrawType = WG, report the Diploma Date from Student Information > General > Graduation > Diploma Date If Diploma Date is null, the record will error. Else leave blank/null	C	Student Information> General> Graduation > Diploma Date Student Information > General > Enrollment >Local End Status	Graduation.diplomaDate enrollment.endStatus
exitWithdrawType Descriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	Report the Ed-Fi Code Value from the End Status selected. Else, leave blank.	C	Student Information> General> Enrollments> End Status Student Information> General> Graduation > Diploma Date	Graduation.diplomaDate enrollment.endStatus
primarySchool	Indicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true.	Report 'True' if Service Type = P: Primary. Else, report 'False'.	O	Student Information> General> Enrollments> Service Type	enrollment.type
repeatGrade Indicator	An indicator of whether the student is enrolling to repeat a grade level, either by failure or an agreement to hold the student back.	Report "Y" if Repeating Last Year is checked. Else, report "N".	C	Student Information> General> Enrollment > Repeating Last Year	enrollment.repeating LastYear
residencyStatus Descriptor	An indication of the location of a persons legal residence relative to (within or outside of) the boundaries of the public school attended and its administrative unit.	Report 'Resident of admin unit and school area' if the Resident and Serving District fields are either NULL or = to the reporting district. This can be any combination of NULL or populated (ex. Serving District can be NULL and Resident District = to reporting District). Report 'Resident of admin unit, but other school area' when the Serving District is not = to Reporting District. The Resident District must be NULL or = to the reporting district to report. If not, then report blank. Report 'Resident of this state, but not of this admin unit' when the Resident District is not = Reporting District. The Serving District must be NULL or = to the reporting district to report. If not, then report blank.		Student Information> General> Enrollments	enrollment.resident district and/or enrollment.serving district
schoolChoice Transfer	An indication of whether students transferred in or out of the school did so during the school year under the provisions for public school choice in accordance with Title I, Part A, Section 1116	Reports 'True' when the checkbox is checked Reports 'False' when the checkbox is not checked.	O	Student Information> General> Enrollments> School Choice	enrollment. schoolChoiceProgram
fullTime Equivalency	The full-time equivalent ratio for the student s assignment to a school for services or instruction. For example, a full-time student would have an FTE value of 1 while a half-time student would have an FTE value of 0.5.	This is optional, does not report	O

Type/Descriptor

Click here to expand...

Entry Grade Level Descriptors

Code Value	Description	Name Space	Short Description
Adult Education	Adult Education	uri://ed-fi.org/GradeLevelDescriptor	Adult Education
Early Education	Early Education	uri://ed-fi.org/GradeLevelDescriptor	Early Education
Eighth grade	Eighth grade	uri://ed-fi.org/GradeLevelDescriptor	Eighth grade
Eleventh grade	Eleventh grade	uri://ed-fi.org/GradeLevelDescriptor	Eleventh grade
Fifth grade	Fifth grade	uri://ed-fi.org/GradeLevelDescriptor	Fifth grade
First grade	First grade	uri://ed-fi.org/GradeLevelDescriptor	First grade
Fourth grade	Fourth grade	uri://ed-fi.org/GradeLevelDescriptor	Fourth grade
Grade 13	Grade 13	uri://ed-fi.org/GradeLevelDescriptor	Grade 13
Infant/toddler	Infant/toddler	uri://ed-fi.org/GradeLevelDescriptor	Infant/toddler
Kindergarten	Kindergarten	uri://ed-fi.org/GradeLevelDescriptor	Kindergarten
Ninth grade	Ninth grade	uri://ed-fi.org/GradeLevelDescriptor	Ninth grade
No grade level	No grade level	uri://ed-fi.org/GradeLevelDescriptor	No grade level
Other	Other	uri://ed-fi.org/GradeLevelDescriptor	Other
Postsecondary	Postsecondary	uri://ed-fi.org/GradeLevelDescriptor	Postsecondary
Preschool/Prekindergarten	Preschool/Prekindergarten	uri://ed-fi.org/GradeLevelDescriptor	Preschool/Prekindergarten
Second grade	Second grade	uri://ed-fi.org/GradeLevelDescriptor	Second grade
Seventh grade	Seventh grade	uri://ed-fi.org/GradeLevelDescriptor	Seventh grade
Sixth grade	Sixth grade	uri://ed-fi.org/GradeLevelDescriptor	Sixth grade
Tenth grade	Tenth grade	uri://ed-fi.org/GradeLevelDescriptor	Tenth grade
Third grade	Third grade	uri://ed-fi.org/GradeLevelDescriptor	Third grade
Twelfth grade	Twelfth grade	uri://ed-fi.org/GradeLevelDescriptor	Twelfth grade
Ungraded	Ungraded	uri://ed-fi.org/GradeLevelDescriptor	Ungraded

Entry Type Descriptors

Ed-Fi Code Value	NameSpace	Ed-Fi Short Description	Ed-Fi Description
E1	uri://nmped.org/EntryTypeDescriptor	E1	Initial enrollment in New Mexico Public Schools during the for current school year AND no prior enrollment outside of New Mexico Public Schools in the same school year. Example: The student enrolls in the same school that they attended last year
E2	uri://nmped.org/EntryTypeDescriptor	E2	Initial enrollment in New Mexico Public Schools during the current school year AND the student was previously enrolled in the same school year in one or more locations outside of New Mexico Public Schools other than Bureau of Indian Education (BIE) schools and Tribally Controlled Schools (TCS)
E3	uri://nmped.org/EntryTypeDescriptor	E3	Initial enrollment in New Mexico Public Schools during the current school year AND the student was previously enrolled in the same school year in a Bureau of Indian Education (BIE) or Tribally Controlled School (TCS) school.
I	uri://nmped.org/EntryTypeDescriptor	Secondary or Invalid Enrollment/Withdraw	This code can be used as an enrollment or a withdrawal code. The code should be used for students who should not be counted for primary SEG Membership funding but require data be submitted to STARS.
R1	uri://nmped.org/EntryTypeDescriptor	R1	After an initial enrollment in New Mexico Public School during the current school year, use R1 to enroll the student who either transferred to a new location within the same NM Public School District (includes District Charters), or who was withdrawn from the District during the current school year and returns to the same District in the same school year without being enrolled in a different New Mexico Public School District including State Charters, or other school in between.
R2	uri://nmped.org/EntryTypeDescriptor	R2	After an initial enrollment in New Mexico Public School during the current school year, use R2 to enroll a student who transfers into the district from another New Mexico Public School District (including State Charters) in the same school year or who transfers into the District from another school.

Exit Withdraw Type Descriptors

Ed-Fi Code Value	NameSpace	Ed-Fi Short Description	Ed-Fi Description
D1	uri://nmped.org/ExitWithdrawTypeDescriptor	D1	Disregard: Submitted in error - Student Template record was submitted in error. Must be submitted prior to student’s inactivation.
D2	uri://nmped.org/ExitWithdrawTypeDescriptor	D2	Disregard: Incorrect Student ID - Student is enrolled under a different STATE ID. Must be submitted prior to student’s inactivation.
D3	uri://nmped.org/ExitWithdrawTypeDescriptor	D3	Disregard - Invalid Enrollment Record (E1) – related to Pre-Enrollment as part of a Rollover Process - The student was pre-enrolled as part of a pre-registration process and is known to have changed their mind in between school years and to have enrolled in a different location instead. Example: Student was preregistered in school for the current school year as part of the rollover process, and over the summer the family decided to enroll the student in a new school (or district) instead, and the new school contacted the school that pre-enrolled the student for their records. Note: Report the E1 record (pre-enrollment) and date (e.g., first day of class or first day of school) in this template AND a D3 record and date (e.g., first day of class or first day of school) in this template. Do not withdraw this student.
G	uri://nmped.org/ExitWithdrawTypeDescriptor	Graduated	Graduated
I	uri://nmped.org/ExitWithdrawTypeDescriptor	Secondary or Invalid Enrollment/Withdraw	This code can be used as an enrollment or a withdrawal code. The code should be used for students who should not be counted for primary SEG Membership funding but require data be submitted to STARS.
W1	uri://nmped.org/ExitWithdrawTypeDescriptor	W1	Transfer out to a different New Mexico Public School District - The student has transferred out to another New Mexico Public School District (includes State Charters).
W10	uri://nmped.org/ExitWithdrawTypeDescriptor	W10	Moved out of state, foreign exchange study, or attend online learning in an out-of-state school. The student moved out of New Mexico, is attending online schooling in another state, or is studying abroad as U.S. exchange student or studying in New Mexico Public Schools as a foreign exchange student and returning to their country. Does not include Registered Home Schooled. (Use W81)
W19	uri://nmped.org/ExitWithdrawTypeDescriptor	W19	Transfer out to a different location within the same Public School District - Student withdrew from one location (public school) and enrolled in another PED location to transfer out to a different location within the same New Mexico Public School District including District Charters.
W2	uri://nmped.org/ExitWithdrawTypeDescriptor	W2	Absent 10 days - A student that has been absent for ten (10) consecutive days must be dropped from the rolls. These may include truants and habitual truants provided the school district has intervened according to their retention and truancy policy as provided in Section 22-12-9 NMSA 1978 and the Attendance for Success Act.
W20	uri://nmped.org/ExitWithdrawTypeDescriptor	W20	Transfer out to a Tribally Controlled School (TCS) within New Mexico. - The student transferred out to a TCS that grants a standard diploma recognized by the State of New Mexico. Does not include TCS in another state (use W10). Does not include Registered Home School (use W81).
W4	uri://nmped.org/ExitWithdrawTypeDescriptor	W4	GED - Student exits to a non-diploma granting education setting such as vocational or GED program.
W5	uri://nmped.org/ExitWithdrawTypeDescriptor	W5	Detained, Long-Term Suspension (out-of-school), or Expulsion – Student is detained in a court-ordered facility, including jail, expulsion, or long-term out-of-school suspension.
W6	uri://nmped.org/ExitWithdrawTypeDescriptor	W6	Left U.S. – Student emigrated or moved outside of US or US territories; does not include temporary military assignment. Does not include studying abroad as a US exchange student or foreign exchange student (use W10).
W7	uri://nmped.org/ExitWithdrawTypeDescriptor	W7	Pregnancy - Student exited school due to pregnancy, which applies to female or male student).
W8	uri://nmped.org/ExitWithdrawTypeDescriptor	W8	Transfer out to a Bureau of Indian Education (BIE) school or other non-public school in New Mexico. - Student who withdraws to a diploma-granting, non-public school within New Mexico. This includes a private school or BIE school that grants a standard diploma recognized by the State of New Mexico. Does not include Registered Home School (use W81). Does not include a BIE school outside New Mexico (use W10).
W81	uri://nmped.org/ExitWithdrawTypeDescriptor	W81	Registered Home Schooled – Student withdraws to be home schooled in a registered home school. Does not include students enrolled in a school that provides remote instruction. Home School - Use this code for students withdrawing to be Home-Schooled
W9	uri://nmped.org/ExitWithdrawTypeDescriptor	W9	Immunization - Student dis-enrolled due to failure to provide satisfactory evidence of 1) commencement of immunization OR 2) completion of immunization.
WC	uri://nmped.org/ExitWithdrawTypeDescriptor	WC	Completion – Student in regular education only who completed coursework required to graduate but did not pass the HSCE. Required for early completers and optional for EOY completers. Diploma type code must equal 2. Includes regular education only, and not Special Education.
WD	uri://nmped.org/ExitWithdrawTypeDescriptor	WD	Death – Student has died.
WDO	uri://nmped.org/ExitWithdrawTypeDescriptor	WDO	Drop-out – Student is known to have dropped out of school. A drop out may include a family who disenrolled a student to keep them home because of illnesses or due to hospitalizations. Does not include students who just stop attending (see W2).
WG	uri://nmped.org/ExitWithdrawTypeDescriptor	WG	Graduation - Student graduated with a standard diploma (required for early graduates and optional for EOY graduates). Does not include certificates of completion. Diploma Type Code must equal 1.

Residency Status Descriptors

Code Value	Description	Namespace	Short Description
Resident of admin unit and school area	Resident of administrative unit and usual school attendance area.	uri://ed-fi.org/ResidencyStatusDescriptor	Resident of administrative unit and usual school attendance area.
Resident of admin unit that crosses states	Resident of an administrative unit that crosses state boundaries.	uri://ed-fi.org/ResidencyStatusDescriptor	Resident of an administrative unit that crosses state boundaries.
Resident of admin unit, but other school area	Resident of administrative unit, but of other school attendance area.	uri://ed-fi.org/ResidencyStatusDescriptor	Resident of administrative unit, but of other school attendance area.
Resident of another state	Resident of another state.	uri://ed-fi.org/ResidencyStatusDescriptor	Resident of another state.
Resident of this state, but not of this admin unit	Resident of this state, but not of this administrative unit.	uri://ed-fi.org/ResidencyStatusDescriptor	Resident of this state, but not of this administrative unit.