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.

ActionTrigger
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

NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
PutIf 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'.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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

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 DescriptorsEnrollment Start Status
Exit Withdraw Type DescriptorsEnrollment End Status

Identity Mapping Object Key

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

campusObjectType

Object Key Data Source

EnrollmentenrollmentID

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.

personPost/DeleteStudent ID in Student Reference
graduationPutClass of School Year Type Reference
programsPutGraduation Plan Reference
programparticipationPutGraduation Plan Reference

Object Data Elements

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

Data Element LabelBusiness Requirement and Business RulesM, 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.
MStudent Information > General > Enrollment > Start Dateenrollment.startdate
calendarReferenceA reference related to the Calendar resource

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

MN/AN/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
MSystem Administration > Resources > School > Ed-Fi School IDSchool.entityID
schoolYearTypeReference  The school year in which the student is being reported.

Reports the End Year of the associated calendar.

MON/AN/A
  studentReference   A reference to the related Student resource.

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

MN/AN/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.

MStudent Information > General > Enrollment > GradeEnrollment.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

MStudent Information > General > Enrollment > Start Statusenrollment.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.
CStudent Information > General > Enrollments > End Dateenrollment.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.

CStudent Information > General > Enrollments > End Statusenrollment.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.
CStudent Information > General > Enrollments > End Actionenrollment. 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.
MStudent 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.
CStudent Information > General > Graduation > Date First Entered the 9th GradeGraduation.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.
MStudent Information > General > Enrollment > Prior 10 Days OverrideEnrollmentGA.priorDaysOverride
summerImmigrantProgramParticipation
  • Report True if the code selected on Immigrant Participation Program (on Enrollment) is "B" or "S".
  • Else report False.

MStudent Information > General > Enrollment > Immigrant Participation ProgramEnrollmentGA.immigrantProgram
summerTitleIIIServed
  • Report True if the code selected on Title III Served (on Enrollment) is "B" or "S".
  • Else report False.
MStudent Information > General > Enrollment > Title III ServedEnrollmentGA.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 if both database fields are NULL.
  • iepInclusionTypeDescriptor
      Report the value entered in enrollmentLocation1 first if present (override).Report the value entered in enrollmentLocCalc1 otherwise.Default to 
    • N
    • if both database fields are NULL.
  • 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.
M

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


esolSegmentsReports 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
CEnglish Learners (EL)N/A

Type/Descriptor1

Click here to expand...

entryTypeDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
VAdmitted under SB10uri://gadoe.org/EntryTypeDescriptorAdmitted under SB10
WAdmitted under School Choiceuri://gadoe.org/EntryTypeDescriptorAdmitted under School Choice
XAdmitted under USCOuri://gadoe.org/EntryTypeDescriptorAdmitted under USCO
CContinue in same schooluri://gadoe.org/EntryTypeDescriptorContinue in same school
TTransfer from other GA public schooluri://gadoe.org/EntryTypeDescriptorTransfer from other GA public school
UTransfer within same school systemuri://gadoe.org/EntryTypeDescriptorTransfer within same school system
PTransfer from a private schooluri://gadoe.org/EntryTypeDescriptorTransfer from a private school
AAdmitted from home schooluri://gadoe.org/EntryTypeDescriptorAdmitted from home school
NNever attended school beforeuri://gadoe.org/EntryTypeDescriptorNever attended school before
SRe-enter after illnessuri://gadoe.org/EntryTypeDescriptorRe-enter after illness
IRe-enter after incarcerationuri://gadoe.org/EntryTypeDescriptorRe-enter after incarceration
BRe-enter after prior withdrawal this yearuri://gadoe.org/EntryTypeDescriptorRe-enter after prior withdrawal this year
RRe-enter - otheruri://gadoe.org/EntryTypeDescriptorRe-enter - other
DEntered from a Department of Defense Schooluri://gadoe.org/EntryTypeDescriptorEntered from a Department of Defense School
6Displaced due to natural disasteruri://gadoe.org/EntryTypeDescriptorDisplaced due to natural disaster
JEntered from another state or U.S. territoryuri://gadoe.org/EntryTypeDescriptorEntered from another state or U.S. territory
KEnter from another country.uri://gadoe.org/EntryTypeDescriptorEnter from another country.

exitWithdrawTypeDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
JTransferred out of countryuri://gadoe.org/ExitWithdrawTypeDescriptorTransferred out of country
KTransferred to private schooluri://gadoe.org/ExitWithdrawTypeDescriptorTransferred to private school
YSB10 Transfer to State Schoolsuri://gadoe.org/ExitWithdrawTypeDescriptorSB10 Transfer to State Schools
ZSB10 Transfer to Private Schooluri://gadoe.org/ExitWithdrawTypeDescriptorSB10 Transfer to Private School
1SB10 Transfer to Public Schooluri://gadoe.org/ExitWithdrawTypeDescriptorSB10 Transfer to Public School
2School Choiceuri://gadoe.org/ExitWithdrawTypeDescriptorSchool Choice
3USCOuri://gadoe.org/ExitWithdrawTypeDescriptorUSCO
CCourt Order or Legal Requirementuri://gadoe.org/ExitWithdrawTypeDescriptorCourt Order or Legal Requirement
XTransferred out of Stateuri://gadoe.org/ExitWithdrawTypeDescriptorTransferred out of State
BMarriageuri://gadoe.org/ExitWithdrawTypeDescriptorMarriage
DDeathuri://gadoe.org/ExitWithdrawTypeDescriptorDeath
EExpelleduri://gadoe.org/ExitWithdrawTypeDescriptorExpelled
FFinancial Hardship / Joburi://gadoe.org/ExitWithdrawTypeDescriptorFinancial Hardship / Job
GHigh School Graduationuri://gadoe.org/ExitWithdrawTypeDescriptorHigh School Graduation
HAttend Home Studyuri://gadoe.org/ExitWithdrawTypeDescriptorAttend Home Study
IIncarcerateduri://gadoe.org/ExitWithdrawTypeDescriptorIncarcerated
LLow Grades / School Failureuri://gadoe.org/ExitWithdrawTypeDescriptorLow Grades / School Failure
MMilitaryuri://gadoe.org/ExitWithdrawTypeDescriptorMilitary
OAdult Education / Post Secondary uri://gadoe.org/ExitWithdrawTypeDescriptorAdult Education / Post Secondary 
PPregnant / Parenturi://gadoe.org/ExitWithdrawTypeDescriptorPregnant / Parent
RRemoved for Lack of Attendanceuri://gadoe.org/ExitWithdrawTypeDescriptorRemoved for Lack of Attendance
SSerious Illness / Accident uri://gadoe.org/ExitWithdrawTypeDescriptorSerious Illness / Accident 
TTransferred to another public school system in Georgia (does not  include DJJ)uri://gadoe.org/ExitWithdrawTypeDescriptorTransferred to another public school system in Georgia 
UUnknownuri://gadoe.org/ExitWithdrawTypeDescriptorUnknown
VAdvanced to another school within systemuri://gadoe.org/ExitWithdrawTypeDescriptorAdvanced to another school within system
WTransferred to another school within systemuri://gadoe.org/ExitWithdrawTypeDescriptorTransferred to another school within system
4Transferred Under Jurisdiction of DJJuri://gadoe.org/ExitWithdrawTypeDescriptorTransferred Under Jurisdiction of DJJ
5Not Subject to compulsory school attendanceuri://gadoe.org/ExitWithdrawTypeDescriptorNot Subject to compulsory school attendance
NTransferred to a Department of Defense Schooluri://gadoe.org/ExitWithdrawTypeDescriptorTransferred to a Department of Defense School
6Displaced due to natural disasteruri://gadoe.org/ExitWithdrawTypeDescriptorDisplaced due to natural disaster
7Withdrew to TCSG Dual Achieve Programuri://gadoe.org/ExitWithdrawTypeDescriptorWithdrew to TCSG Dual Achieve Program


residencyStatusDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
1Residenturi://gadoe.org/ResidencyStatusDescriptorResident
2In-State, Consenturi://gadoe.org/ResidencyStatusDescriptorIn-State, Consent
3In-State, Contracturi://gadoe.org/ResidencyStatusDescriptorIn-State, Contract
4In-State, Court Ordereduri://gadoe.org/ResidencyStatusDescriptorIn-State, Court Ordered
5Out-of-Stateuri://gadoe.org/ResidencyStatusDescriptorOut-of-State
6In-State, O.C.G.A. 20-2-294uri://gadoe.org/ResidencyStatusDescriptorIn-State, O.C.G.A. 20-2-294
7Consent-International Exchange Studenturi://gadoe.org/ResidencyStatusDescriptorConsent-International Exchange Student
8Displaced due to a natural disasteruri://gadoe.org/ResidencyStatusDescriptorDisplaced due to a natural disaster


entryGradeLevelDescriptor (gradeLevelDescriptor)

Ed-Fi Code ValueDescriptionNamespaceShort Description
PKPre-Kindergartenuri://gadoe.org/GradeLevelDescriptorPre-Kindergarten
UKUnderage Kindergartenuri://gadoe.org/GradeLevelDescriptorUnderage Kindergarten
KKKindergartenuri://gadoe.org/GradeLevelDescriptorKindergarten
U1Underage Grade 1uri://gadoe.org/GradeLevelDescriptorUnderage Grade 1
1Grade 1uri://gadoe.org/GradeLevelDescriptorGrade 1
2Grade 2uri://gadoe.org/GradeLevelDescriptorGrade 2
3Grade 3uri://gadoe.org/GradeLevelDescriptorGrade 3
4Grade 4uri://gadoe.org/GradeLevelDescriptorGrade 4
5Grade 5uri://gadoe.org/GradeLevelDescriptorGrade 5
6Grade 6uri://gadoe.org/GradeLevelDescriptorGrade 6
7Grade 7uri://gadoe.org/GradeLevelDescriptorGrade 7
8Grade 8uri://gadoe.org/GradeLevelDescriptorGrade 8
9Grade 9uri://gadoe.org/GradeLevelDescriptorGrade 9
10Grade 10uri://gadoe.org/GradeLevelDescriptorGrade 10
11Grade 11uri://gadoe.org/GradeLevelDescriptorGrade 11
12Grade 12uri://gadoe.org/GradeLevelDescriptorGrade 12