Student School Associations (Georgia v3.6.1)

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, and 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. Do not send a record if any of the following exclusions are present: Enrollment State Exclude Enrollment Grade Exclude from State Reporting Calendar Exclude School Exclude
Delete/Post/Put	A Delete/Post is performed when the natural key of the record is changed. A Put is performed otherwise: When the following information is changed on the Enrollment: Enrollment ID (New Enrollment) Start Date End Date Grade Start Status End Status End Action Resident Status Date First Entered the 9th Grade Prior Ten Days Override Immigrant Participation Program Title III Served When the following information is changed on the FTE Heads Up tab (Custom tab created by K-12): FTE Program Code Override IEP Inclusion Type Override Inclusion Personnel Override Itinerant Teacher Override Received Supplemental Speech Services Override Transported for Section Override
Delete	When an enrollment is deleted. When an enrollment is now excluded in some way (State Exclude, No Show, etc.).

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, and 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.
Do not send a record if any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment Grade Exclude from State Reporting
- Calendar Exclude
- School Exclude

Delete/Post/Put

A Delete/Post is performed when the natural key of the record is changed. A Put is performed otherwise:

When the following information is changed on the Enrollment:
- Enrollment ID (New Enrollment)
- Start Date
- End Date
- Grade
- Start Status
- End Status
- End Action
- Resident Status
- Date First Entered the 9th Grade
- Prior Ten Days Override
- Immigrant Participation Program
- Title III Served
When the following information is changed on the FTE Heads Up tab (Custom tab created by K-12):
- FTE Program Code Override
- IEP Inclusion Type Override
- Inclusion Personnel Override
- Itinerant Teacher Override
- Received Supplemental Speech Services Override
- Transported for Section Override

Delete

When an enrollment is deleted.
When an enrollment is now excluded in some way (State Exclude, No Show, etc.).

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 reposted. If a dependent resource is turned off, all dependent resources will be deleted and not reposted.
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 reposted. If a dependent resource is turned off, all dependent resources will be deleted and not reposted.

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 and Business Rules

M, C or O

Data Source GUI Path

Database
Field

entryDate

The month, day, and year on which an individual enters and begins to receive instructional services in a campus.

Report the Start Date.

Reports 06/16/StartYear if the No Show checkbox is checked AND the End Status is U: Unknown.

Student Information > General > Enrollment > Start Date

enrollment.startdate

calendarReference

A reference related to the Calendar resource

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

N/A

schoolReference

A reference to the related School resource.

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

educationOrganizationId = Ed-Fi School ID

System Administration > Resources > School > Ed-Fi School ID

School.entityID

schoolYearTypeReference

The school year in which the student is being reported.

Reports the End Year of the associated calendar.

N/A

studentReference

A reference to the related Student resource.

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

N/A

entryGradeLevelDescriptor

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 mapped to the value selected for Grade.

Student Information > General > Enrollment > Grade

Enrollment.grade

entryTypeDescriptor

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 mapped to the value selected for Start Status

Student Information > General > Enrollment > Start Status

enrollment.startstatus

exitWithdrawDate

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.

Report the End Date.

Reports 06/16/StartYear if the No Show checkbox is checked AND the End Status is U: Unknown.

Student Information > General > Enrollments > End Date

enrollment.enddate

exitWithdrawTypeDescriptor

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 mapped to the value selected for End Status.

Student Information > General > Enrollments > End Status

enrollment.endstatus

repeatGradeIndicator

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 True when the student's last enrollment record prior to the current enrollment has an End Action of "R: Retain."
Report False in all other situations.

Student Information > General > Enrollments > End Action

enrollment. endAction

residencyStatusDescriptor

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 the Ed-Fi Code mapped to the selected Resident Status value.

Student Information > General > Enrollments > Resident Status

EnrollmentGA.residentStatus

dateEntered9thGrade

Date the student enrolled in the 9th grade for the first time. Required to report for 9th grade and beyond.

Report the date entered on Date First Entered the 9th Grade.

This only reports for enrollments where the grade is mapped to the state grade level of 09, 10, 11, or 12.
Do NOT report for enrollments that do not map to the above state grade levels, even if the Date First Entered the 9th Grade field is populated due to a future-dated enrollment.

Student Information > General > Graduation > Date First Entered the 9th Grade

Graduation.grade9Date

priorTenDays

Look at the "Prior 10 Days Override" field on Enrollment first:
- Report True if set to "Y: Yes - Present"
- Report False if set to "N: No - Not Present"
If "Prior 10 Days Override" is NULL:
- Report True if the current date has not yet reached the first Tuesday of October.
- If the current date is greater than or equal to the first Tuesday of October AND less than the first Thursday of March:
  - Report True if at least one period in the 10 instructional days prior to the first Tuesday of October has no "Absent" attendance code.
  - Report False otherwise.
- If the current date is greater than or equal to the first Thursday of March:
  - Report True if at least one period in the 10 instructional days prior to the first Thursday of March has no "Absent" attendance code.
  - Report False otherwise.

Student Information > General > Enrollment > Prior 10 Days Override

EnrollmentGA.priorDaysOverride

summerImmigrantProgramParticipation

Report True if the code selected on Immigrant Participation Program (on Enrollment) is "B" or "S".
Else report False.

Student Information > General > Enrollment > Immigrant Participation Program

EnrollmentGA.immigrantProgram

summerTitleIIIServed

Report True if the code selected on Title III Served (on Enrollment) is "B" or "S".
Else report False.

Student Information > General > Enrollment > Title III Served

EnrollmentGA.titleIIIServed

fteSegments

Reports an array with 6 distinct records within it (One per segment). The database fields are named the same but distinguished with the segment number as the last character. Logic will remain the same across all 6 distinct records, but they will use their respective database fields.

fteProgramCodeDescriptor
- Report the value entered in fteProgramCode1 first if present (override).
- Report the value entered in fteProgramCalc1 otherwise.
- Default to O if both database fields are NULL.
iepInclusionTypeDescriptor
- N
inclusionPersonnelDescriptor
- Report the value entered in inclusion1 first if present (override).
- Report the value entered in inclusionCalc1 otherwise.
- Default to N if both database fields are NULL.
itinerantTeacherSpecialEducationServices
- Report the value entered in itinerant.
receivedSupplementalSpeechServices
- Report the value entered in supplementalSpeech.
segmentNumber
- Report the number of the segment being reported.
- "1" for Segment 1, "2" for Segment 2, etc.
transportedForSection
- Report the value entered in transported.

FTE Heads Up (Custom K-12 tab)

Student Information > General > FTE Heads Up

Replace "1" with "2, 3, 4, 5, or 6" to get the respective segment values:

EnrollmentGA.fteProgramCode1

EnrollmentGA.fteProgramCalc1

EnrollmentGA.enrollmentLocation1

EnrollmentGA.enrollmentLocCalc1

EnrollmentGA.inclusion1

EnrollmentGA.inclusionCalc1

EnrollmentGA.itinerant

EnrollmentGA.supplementalSpeech

EnrollmentGA.transported

esolSegments

Reports based on the EL Service Type of ESOL0 - ESOL5 if that service overlaps the dates of the student's enrollment.

The student must have Program Status = EL.

EL Service Type	Reports
ESOL0	0
ESOL1	1
ESOL2	2
ESOL3	3
ESOL4	4
ESOL5	5

English Learners (EL)

N/A

Type/Descriptor1

Click here to expand...

entryTypeDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
V	Admitted under SB10	uri://gadoe.org/EntryTypeDescriptor	Admitted under SB10
W	Admitted under School Choice	uri://gadoe.org/EntryTypeDescriptor	Admitted under School Choice
X	Admitted under USCO	uri://gadoe.org/EntryTypeDescriptor	Admitted under USCO
C	Continue in same school	uri://gadoe.org/EntryTypeDescriptor	Continue in same school
T	Transfer from other GA public school	uri://gadoe.org/EntryTypeDescriptor	Transfer from other GA public school
U	Transfer within same school system	uri://gadoe.org/EntryTypeDescriptor	Transfer within same school system
P	Transfer from a private school	uri://gadoe.org/EntryTypeDescriptor	Transfer from a private school
A	Admitted from home school	uri://gadoe.org/EntryTypeDescriptor	Admitted from home school
N	Never attended school before	uri://gadoe.org/EntryTypeDescriptor	Never attended school before
S	Re-enter after illness	uri://gadoe.org/EntryTypeDescriptor	Re-enter after illness
I	Re-enter after incarceration	uri://gadoe.org/EntryTypeDescriptor	Re-enter after incarceration
B	Re-enter after prior withdrawal this year	uri://gadoe.org/EntryTypeDescriptor	Re-enter after prior withdrawal this year
R	Re-enter - other	uri://gadoe.org/EntryTypeDescriptor	Re-enter - other
D	Entered from a Department of Defense School	uri://gadoe.org/EntryTypeDescriptor	Entered from a Department of Defense School
6	Displaced due to natural disaster	uri://gadoe.org/EntryTypeDescriptor	Displaced due to natural disaster
J	Entered from another state or U.S. territory	uri://gadoe.org/EntryTypeDescriptor	Entered from another state or U.S. territory
K	Enter from another country.	uri://gadoe.org/EntryTypeDescriptor	Enter from another country.

exitWithdrawTypeDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
J	Transferred out of country	uri://gadoe.org/ExitWithdrawTypeDescriptor	Transferred out of country
K	Transferred to private school	uri://gadoe.org/ExitWithdrawTypeDescriptor	Transferred to private school
Y	SB10 Transfer to State Schools	uri://gadoe.org/ExitWithdrawTypeDescriptor	SB10 Transfer to State Schools
Z	SB10 Transfer to Private School	uri://gadoe.org/ExitWithdrawTypeDescriptor	SB10 Transfer to Private School
1	SB10 Transfer to Public School	uri://gadoe.org/ExitWithdrawTypeDescriptor	SB10 Transfer to Public School
2	School Choice	uri://gadoe.org/ExitWithdrawTypeDescriptor	School Choice
3	USCO	uri://gadoe.org/ExitWithdrawTypeDescriptor	USCO
C	Court Order or Legal Requirement	uri://gadoe.org/ExitWithdrawTypeDescriptor	Court Order or Legal Requirement
X	Transferred out of State	uri://gadoe.org/ExitWithdrawTypeDescriptor	Transferred out of State
B	Marriage	uri://gadoe.org/ExitWithdrawTypeDescriptor	Marriage
D	Death	uri://gadoe.org/ExitWithdrawTypeDescriptor	Death
E	Expelled	uri://gadoe.org/ExitWithdrawTypeDescriptor	Expelled
F	Financial Hardship / Job	uri://gadoe.org/ExitWithdrawTypeDescriptor	Financial Hardship / Job
G	High School Graduation	uri://gadoe.org/ExitWithdrawTypeDescriptor	High School Graduation
H	Attend Home Study	uri://gadoe.org/ExitWithdrawTypeDescriptor	Attend Home Study
I	Incarcerated	uri://gadoe.org/ExitWithdrawTypeDescriptor	Incarcerated
L	Low Grades / School Failure	uri://gadoe.org/ExitWithdrawTypeDescriptor	Low Grades / School Failure
M	Military	uri://gadoe.org/ExitWithdrawTypeDescriptor	Military
O	Adult Education / Post Secondary	uri://gadoe.org/ExitWithdrawTypeDescriptor	Adult Education / Post Secondary
P	Pregnant / Parent	uri://gadoe.org/ExitWithdrawTypeDescriptor	Pregnant / Parent
R	Removed for Lack of Attendance	uri://gadoe.org/ExitWithdrawTypeDescriptor	Removed for Lack of Attendance
S	Serious Illness / Accident	uri://gadoe.org/ExitWithdrawTypeDescriptor	Serious Illness / Accident
T	Transferred to another public school system in Georgia (does not include DJJ)	uri://gadoe.org/ExitWithdrawTypeDescriptor	Transferred to another public school system in Georgia
U	Unknown	uri://gadoe.org/ExitWithdrawTypeDescriptor	Unknown
V	Advanced to another school within system	uri://gadoe.org/ExitWithdrawTypeDescriptor	Advanced to another school within system
W	Transferred to another school within system	uri://gadoe.org/ExitWithdrawTypeDescriptor	Transferred to another school within system
4	Transferred Under Jurisdiction of DJJ	uri://gadoe.org/ExitWithdrawTypeDescriptor	Transferred Under Jurisdiction of DJJ
5	Not Subject to compulsory school attendance	uri://gadoe.org/ExitWithdrawTypeDescriptor	Not Subject to compulsory school attendance
N	Transferred to a Department of Defense School	uri://gadoe.org/ExitWithdrawTypeDescriptor	Transferred to a Department of Defense School
6	Displaced due to natural disaster	uri://gadoe.org/ExitWithdrawTypeDescriptor	Displaced due to natural disaster
7	Withdrew to TCSG Dual Achieve Program	uri://gadoe.org/ExitWithdrawTypeDescriptor	Withdrew to TCSG Dual Achieve Program

residencyStatusDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
1	Resident	uri://gadoe.org/ResidencyStatusDescriptor	Resident
2	In-State, Consent	uri://gadoe.org/ResidencyStatusDescriptor	In-State, Consent
3	In-State, Contract	uri://gadoe.org/ResidencyStatusDescriptor	In-State, Contract
4	In-State, Court Ordered	uri://gadoe.org/ResidencyStatusDescriptor	In-State, Court Ordered
5	Out-of-State	uri://gadoe.org/ResidencyStatusDescriptor	Out-of-State
6	In-State, O.C.G.A. 20-2-294	uri://gadoe.org/ResidencyStatusDescriptor	In-State, O.C.G.A. 20-2-294
7	Consent-International Exchange Student	uri://gadoe.org/ResidencyStatusDescriptor	Consent-International Exchange Student
8	Displaced due to a natural disaster	uri://gadoe.org/ResidencyStatusDescriptor	Displaced due to a natural disaster

entryGradeLevelDescriptor (gradeLevelDescriptor)

Ed-Fi Code Value	Description	Namespace	Short Description
PK	Pre-Kindergarten	uri://gadoe.org/GradeLevelDescriptor	Pre-Kindergarten
UK	Underage Kindergarten	uri://gadoe.org/GradeLevelDescriptor	Underage Kindergarten
KK	Kindergarten	uri://gadoe.org/GradeLevelDescriptor	Kindergarten
U1	Underage Grade 1	uri://gadoe.org/GradeLevelDescriptor	Underage Grade 1
1	Grade 1	uri://gadoe.org/GradeLevelDescriptor	Grade 1
2	Grade 2	uri://gadoe.org/GradeLevelDescriptor	Grade 2
3	Grade 3	uri://gadoe.org/GradeLevelDescriptor	Grade 3
4	Grade 4	uri://gadoe.org/GradeLevelDescriptor	Grade 4
5	Grade 5	uri://gadoe.org/GradeLevelDescriptor	Grade 5
6	Grade 6	uri://gadoe.org/GradeLevelDescriptor	Grade 6
7	Grade 7	uri://gadoe.org/GradeLevelDescriptor	Grade 7
8	Grade 8	uri://gadoe.org/GradeLevelDescriptor	Grade 8
9	Grade 9	uri://gadoe.org/GradeLevelDescriptor	Grade 9
10	Grade 10	uri://gadoe.org/GradeLevelDescriptor	Grade 10
11	Grade 11	uri://gadoe.org/GradeLevelDescriptor	Grade 11
12	Grade 12	uri://gadoe.org/GradeLevelDescriptor	Grade 12