Tool Search: Ed-Fi
This association represents student information that is specific to a student’s relationship with an Education Organization.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | Reports a record when an enrollment is created for a person and the enrollment overlaps the configured year.
|
| Delete/Post/Put | A DELETE/POST is performed if the data element being altered is part of the resource's natural key. A PUT is performed otherwise.
|
| Delete |
|
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. |
| 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 Change: If the District Number/Ed-Fi District Number changes, a delete/post will occur with the cascading deletes from the LEA ID Change triggers. If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger. |
| Delete | Cascading Deletes: N/A - no dependent resources |
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.
|
When using data in Campus that has a single date, the following logic will be applied to determine the scope year(s) to report the data to.
|
When using data in Campus that have start and end dates, the following logic will be applied to determine the scope year(s) to report the data to.
|
Resource Preferences
This table describes the Resource Preferences of this object.
Data Element Label | Mapping Needed |
|---|---|
| Digital Equity | Primary Learning Device Away from School |
| Primary Learning Device Provider | |
| Primary Learning Device Access | |
| Internet Access Type in Residence | |
| Internet Performance in Residence | |
| Race Descriptor | Race/Ethnicity |
| Student Languages Override | Home Primary Language |
| Student Characteristic Descriptor | Parental Status Code |
| Economic Disadvantaged | |
| Tribal Affiliation Descriptors | Identity Tribe |
| Military Family Descriptors | Enrollment Military Family Code |
| Gender Identity Descriptors | Identity Gender Identity |
Identity Mapping Object Key
This table describes the Identity Mapping Object Key of this object.
campusObjectType | Object Key Data Source |
|---|---|
| Person | personID |
Event Queue Detail
This table describes the Event Queue Detail of this object.
Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| enrollment | Post/Put/Delete Put | The primary table used for sending data for this resource. Reports Disabilities |
| identity | Put | Reports Hispanic or Latino, Gender, Home Primary Language, US Entry Type. |
| person | Put | Reports the Ed-FI ID. |
| contact | Put | Reports the Telephone and Email information. |
| householdlocation | Put | Determines if address is marked as Mailing or Private. |
| householdmember | Put | Determines household membership with Start Date, End Date, Private. |
| address | Put | PO Box, Number, Prefix, Street, Tag, Direction, Apt, City, State, Zip |
| raceethnicity | Put | Reports Races. |
| plantype | Put | Reports Indicators. |
| plan | Put | Reports Disabilities, Indicators. |
| planstate | Put | Reports Disabilities. |
| programs | Put | Reports any Characteristic created in Flags. |
| programparticipation | Put | Reports any Characteristic created in Flags. |
| Title1 | Put | Reports Neglected or Delinquent. |
| ImpactAidEmployment | Put | Reports Parent in Military. |
| relatedpair | Put | Guardian checkbox for contact information and Parent in Military. |
| section504 | Put | Reports Section 504 Handicapped. |
| homeless | Put | Reports Homeless, Unaccompanied Youth, Runaway. |
Object Data Elements
This table describes data elements sent within the Student Education Organization Association resource.
| Data Element Label | Business Requirement and Business Rules | M, C or O | Data Source GUI Path | Database Field | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| educationOrganizationId | Report State District Number. Reports the fields that are part of the Natural Key for the Local Education Agencies resource.
| M | System Administration > Resources > District Information > District Ed-Fi Number | District.entityID | ||||||||||||||||||||||||||||||||||||||||
| studentReference | A unique alphanumeric code assigned to a student. Reports the fields that are part of the Natural Key for the Students resource. | M | N/A | N/A | ||||||||||||||||||||||||||||||||||||||||
| addresses | The set of elements that describes an address, including the street address, city, state, and ZIP code. Reports the below data elements in an array for the address marked as "Mailing" with the earliest membership start date. Do not report addresses marked as "Private":
| Household Addresses > Mailing Household Membership > Start Date Household Addresses > Start Date Households > Address Info > State, Apt, City, Zip Code, PO Box, Number, Street, Tag, Prefix, Dir | HouseholdLocation.mailing HouseholdMember.startDate HouseholdLocation.startDate Address.state Address.apt Address.city Address.zip Address.postOfficeBox Address.number Address.street Address.tag Address.prefix Address.dir | |||||||||||||||||||||||||||||||||||||||||
| disabilities | The disability condition(s) that best describes an individual’s impairment, as determined by evaluation(s) conducted by the education organization. Reports the following data elements in an array:
| C | Enrollment > Area of Exceptionality | enrollment.disability1 | ||||||||||||||||||||||||||||||||||||||||
| hispanicLatinoEthnicity | An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. The term, "Spanish origin," can be used in addition to "Hispanic or Latino."
| M | Census > People > Identities > Is the Individual Hispanic or Latino? | identity.hispanicEthnicity | ||||||||||||||||||||||||||||||||||||||||
| languages | The language(s) the individual uses to communicate. It is strongly recommended that entries use only ISO 639-3 language codes.
| M | Census > People > Identity > Home Primary Language | Identity.homePrimaryLanguage | ||||||||||||||||||||||||||||||||||||||||
| races | The general racial category which most clearly reflects the individual’s recognition of his or her community or with which the individual most identifies. The data model allows for multiple entries so that each individual can specify all appropriate races. Reports the below data elements in an array:
| M | Census > People > Identities > Race/Ethnicity | IdentityRaceEthnicity and racethnicity.raceid | ||||||||||||||||||||||||||||||||||||||||
| sexDescriptor | A person's gender.
| M | Census > People > Identities > Gender | identity.Gender | ||||||||||||||||||||||||||||||||||||||||
| studentCharacteristics | Reflects important characteristics of the student’s home situation: Displaced Homemaker, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, and Unaccompanied Youth. Report a studentCharacteristicDescriptor for every area that satisfies reporting logic in the table below:
| C | Parent in Military: Student Support Team Participant: Single Parent: Extended School Year Services: Parent in Reserves: Instructed using ACS: ESOL Student Served with Title III Funds: Dual Immersion: Dexter Mosely Homeschooled: US School Less Than 3 Years: Migrant Priority For Services: Immigrant Program Participant: SB2 - Dual Enrollment: 21st Century Served: Bi-Literacy Diploma Seal: Civic Engagement Diploma Seal: Fine Arts Diploma Seal: International Skills Diploma Seal: Child Find: | Parent in Military: Student Support Team Participant: Single Parent: Extended School Year Services: Parent in Reserves: Instructed using ACS: ESOL Student Served with Title III Funds: Dual Immersion: Dexter Mosely Homeschooled: US School Less Than 3 Years: Migrant Priority For Services: Immigrant Program Participant: SB2 - Dual Enrollment: 21st Century Served: Bi-Literacy Diploma Seal: Civic Engagement Diploma Seal: Fine Arts Diploma Seal: International Skills Diploma Seal: Child Find: | ||||||||||||||||||||||||||||||||||||||||
| indicators | Indicator(s) or metric(s) computed for the student (e.g., at risk) to influence more effective education or direct specific interventions. Report an indicatorName and indicator value for all rows of the table below:
| C | Capstone Project: Alternate Math Sequence: CCAE Participant: Career Technical Instruction: STEM/STEAM Participant: Migrant Program Participant: Environment Code: Pre-K Program: CTAE Employability / Soft Skills Seal: CTAE Pathway Skills Seal: CTAE Leadership Skills Seal: Diploma Type: Report Type: IEP Services: | Capstone Project: Alternate Math Sequence: CCAE Participant: Career Technical Instruction: STEM/STEAM Participant: Migrant Program Participant: Environment Code: Pre-K Program: CTAE Employability / Soft Skills Seal: CTAE Pathway Skills Seal: CTAE Leadership Skills Seal: Diploma Type: Report Type: IEP Services: | ||||||||||||||||||||||||||||||||||||||||
| Biliteracy1LanguageDescriptor | Indicates the first language in which the student has demonstrated proficiency for the BI-LITERACY LANGUAGE SEAL.
| C | Enrollment > Bi-Lit Language 1 | EnrollmentGA.biLitLanguage1 | ||||||||||||||||||||||||||||||||||||||||
| Biliteracy2LanguageDescriptor | Indicates the second language in which the student has demonstrated proficiency for the BI-LITERACY LANGUAGE SEAL.
| C | Enrollment > Bi-Lit Language 2 | EnrollmentGA.biLitLanguage2 | ||||||||||||||||||||||||||||||||||||||||
| Biliteracy3LanguageDescriptor | Indicates the third language in which the student has demonstrated proficiency for the BI-LITERACY LANGUAGE SEAL.
| C | Enrollment > Bi-Lit Language 3 | EnrollmentGA.biLitLanguage3 | ||||||||||||||||||||||||||||||||||||||||
| countyOfResidenceDescriptor | Indicates Code for the Georgia county the student resides in while attending public school.
| M | Enrollment > Resident County | EnrollmentGA.residentCounty | ||||||||||||||||||||||||||||||||||||||||
| nonESOLStatusDescriptor | Indicates the status of an EL student who is not in ESOL program.
| C | Program Participation > English Learners (EL) > EL Services > Service Type | LepService.lepServiceTypeID | ||||||||||||||||||||||||||||||||||||||||
| parentCommunicationLanguageDescriptor | Indicates the language preference of the parent for communication between the school and the student's parent. Blank is not allowed.
| M | Census > People > Relationships > Guardian, Emergency Priority Census > People > Demographics > Home Primary Language | RelatedPair.seq Identity.homePrimaryLanguage | ||||||||||||||||||||||||||||||||||||||||
| dateStudentEligibleForACS | This indicates the date the student was identified as a student needing an alternate assessment for the ALTERNATE CONTENT STANDARDS (ACS).
| C | Special Ed > General > State Reporting > Start Date, GAA (ACS) | SpecialEdState.startDate SpecialEdState.assessment | ||||||||||||||||||||||||||||||||||||||||
| dateStudentNoLongerACS | Indicates the date the student no longer qualifies for the ALTERNATE CONTENT STANDARDS (ACS).
| C | Special Ed > General > State Reporting > End Date, GAA (ACS) | SpecialEdState.endDate | ||||||||||||||||||||||||||||||||||||||||
| systemOfResidencyDescriptor | Code for the Georgia system where the student resides while attending public school. Or the SYSTEM CODE from the district or state the student was displaced due to natural disaster.
| M | Enrollment > Resident District | Enrollment.residentDistrict |
