Classic View: System Administration > Ed-Fi
Search Terms: Ed-Fi
This article defines all of the elements of data sent per entity between Campus and the Ed-Fi system.
- Future data is suppressed when syncing data from Campus to Ed-Fi. Only past and present data is synced.
- Data in calendars marked as Exclude will not send data to Ed-Fi.
- Person-related records do not trigger a send of data to Ed-Fi if the person does not have an Ed-Fi ID value assigned.
- Ed-Fi ignores custom field data entered in Campus.
See the following articles for more information about setting up Ed-Fi within Campus:
An entity is a collection of related data which is sent in a cluster of data elements from Campus to Ed-Fi. Select the following links to view what data elements are contained and sent within that entity:
Understand Object Triggering Tables
The Object Triggering Logic Tables describe what actions within Campus result in data being triggered to sync to Ed-Fi.
Image 1: Example of an Object Triggering Logic Table
The following table lists the definition of each potential Action:
Action | Definition |
---|---|
Post | This will insert new records and data within Ed-Fi. |
Put | This action will update existing information within Ed-Fi. |
Get | This action is used for items that are pre-loaded by ADE. For example, Courses and Programs. |
Delete | This will delete records and data within Ed-Fi. |
Understand Object Data Element Tables
The Object Data Element tables describe all of the elements contained within a reporting entity. Each element is given a description of what it is and any potential logic used to calculate the element, if the element is mandatory for reporting to Ed-Fi (indicated by an M), where the data is pulled from the Campus database and where the pulled information is entered within the Campus UI.
Elements marked as M are mandatory elements which must report data to Ed-Fi in order to meet reporting requirements. Elements marked as O are optional elements which are not mandatory for the Ed-Fi requirement but can be populated and report data for additional state-specific reporting purposes. Elements listed as C are conditional elements which are not required to report but will report data if the data is present within Campus.
Image 2: Example of a Object Data Elements Table
UnderstandType/Descriptor Tables
The Type/Descriptor section describes each element and their corresponding Campus to Ed-Fi value translation that is occurring.
If the element is reporting a Descriptor, the Ed-Fi Code Value is reported.
If the element is reporting a Type, the Ed-Fi Short Description is reported.
Image 3: Example of a Type/Descriptor Table
Entities and Elements
The following lists all the currently available and syncing entities and their respective elements.
Local Education Agencies
This entity represents an administrative unit at the local level, which exists primarily to operate schools or to contract for educational services. It includes school districts, charter schools, charter management organizations or other local administrative organizations.
Reports the District Information for a school.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
Action | Trigger |
---|---|
Post | Post all Districts populated in the District table.
|
Put | When fields not part of the natural key are changed: District Name, Phone or Physical Address is changed. |
Delete | Records are never deleted once they are sent. |
Scope Year Logic
This table describes scope year logic of this object.
Logic |
---|
Districts are not aligned to a year so all Districts will send to each scoped year.
|
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 | Descritpion | M, C or O | Data Source GUI Path | Database Field |
---|---|---|---|---|
localEducationAgencyId | Report ttddddsssmmm where:
| M | tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number SSS: System Administration > Resources > School > school record > State School Number mmm: '000' | District.type District.number School.number |
stateOrganizationId | The identifier assigned to an education agency by the State Education Agency (SEA). Also known as the State LEP ID. NEDM: IdentificationCode, LEA Identifie. Report ttddddsssmmm where:
| M | tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number SSS: System Administration > Resources > School > school record > State School Number mmm: '000' | District.type District.number School.number |
nameOfInstitution | M | System Administration > Resources > District Information > district record > Name | ||
educationOrganization Category | Report 'Local Education Agency'. | M | n/a | n/a |
localEducationAgency Category | Report 'Independent'. | M | n/a | n/a |
districtType | Report Type If number is not 2-digits long, add leading zero(s). | M | System Administration > Resources > District Info > Type | district.type |
identificationCodes | IdentificationCode - A unique number or alphanumeric code that is assigned to an education organization by a school, school system, state, or other agency or entity. The value loaded for LocalEducationAgencyId / StateOrganizationId should also be loaded into this structure to provide additional context to users. EducationOrganizationIdentificationSystem -The school system, state, or agency assigning the identification code. For the LocalEducationAgencyId / State OrganizationId, the value should be “SEA”. For educationOrganizationIdentificationSystem, report 'SEA' for identificationCode, report: ttddddsss where
| M | tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number SSS: System Administration > Resources > School > school record > State School Number | District.type District.number School.number |
addresses |
| M |
| district.address district.city district.state district.zip |
Array
Education Organization Address
Data Element | Business Requirement | M, C or O | Data Source GUI Path | Database Field |
---|---|---|---|---|
addressType | Key for Address.
| M | ||
streetNumberName | The street number and street name or post office box number of an address.
| M | System Administration> Resources> District Information | district.physicaladdress |
apartmentRoomSuiteNumber | The apartment, room, or suite number of an address. This element is currently not reported or collected. | O | ||
buildingSiteNumber | The number of the building on the site, if more than one building shares the same address This element is currently not reported or collected. | O | ||
city | The name of the city in which an address is located.
| M | System Administration> Resources> District Information | district.physicalcity |
stateAbbreviationType | The abbreviation for the state (within the United States) or outlying area in which an address is located.
| M | System Administration> Resources> District Information | district.physicalstate |
postalCode | The five or nine digit zip code portion of an address.
| M | System Administration> Resources> District Information | district.physicalzip |
nameOfCounty | The name of the county, parish, borough, or comparable unit (within a state) in which an address is located. This element is currently not reported or collected. | O | ||
countyFIPSCode | 5 digit code consisting of the two digit state code followed by the three digit FIPS code for the county. This element is currently not reported or collected. | O | ||
latitude | The geographic latitude of the physical address. This element is currently not reported or collected. | O | ||
longitude | The geographic longitude of the physical address. This element is currently not reported or collected. | O | ||
beginDate | The first date the address is valid. For physical addresses, the date the person moved to that address. This element is currently not reported or collected. | O | ||
endDate | The last date the address is valid. For physical addresses, this would be the date the person moved from that address. This element is currently not reported or collected. | O |
Education Organization Institution Telephone
Data Element Label | Business Requirement | Business Rules | M,C,O | Data Source GUI Path | Database Field |
---|---|---|---|---|---|
institutionTelephoneNumberType | Type of Phone Number |
| |||
telephoneNumber | The telephone number including the area code, and extension, if applicable. |
| System Administration> Resources> District Information | district.phone |
Type/Descriptor
Institution Telephone Number Type
Ed-Fi Code Value | Short Description | Description |
---|---|---|
Main | Main | Main |
Administrative | Administrative | Administrative |
Health Clinic | Health Clinic | Health Clinic |
Attendance | Attendance | Attendance |
Other | Other | Other |
Fax | Fax | Fax |
Food Service | Food Service | Food Service |
Local Education Agency Category Type
Ed-Fi Code Value | Short Description | Description |
---|---|---|
Independent | Independent | Independent |
Charter | Charter | Charter |
Institution Telephone Number Type
Ed-Fi Code Value | Short Description | Description |
---|---|---|
Main | Main | Main |
Administrative | Administrative | Administrative |
Health Clinic | Health Clinic | Health Clinic |
Attendance | Attendance | Attendance |
Other | Other | Other |
Fax | Fax | Fax |
Food Service | Food Service | Food Service |
Local Education Agency Category Type
Ed-Fi Code Value | Short Description | Description |
---|---|---|
Independent | Independent | Independent |
Charter | Charter | Charter |
Schools
This entity represents an educational organization that includes staff and students who participate in classes and educational activity groups. This field only accepts numeric values for the School ID so some states may implement a different State School Number for Ed-Fi. See state specific logic for more information.Object Triggering Logic
This table describes logic for triggering syncing of this object.
Action | Trigger |
---|---|
Post | When a new School is created and saved OR the Ed-Fi School Number or State School Number Changes.
|
Put | When any of the fields not part of the Natural Key change::
|
Delete | Deletes are not sent for Schools. |
**Data will not send for any of the Resources if they reference a school that is marked as 'Exclude' on the School Editor.
Scope Year Logic
This table describes scope year logic of this object.
Logic |
---|
Schools are not aligned to a year so all Schools will send to each scoped year.
|
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 | Descritpion | M, C or O | Data Source GUI Path | Database Field |
---|---|---|---|---|
schoolId | MN State Organization ID with last 3 digits removed. Report ttddddsss where:
| M | tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number SSS: System Administration > Resources > School > school record > State School Number | District.type District.number School.number |
stateOrganizationId | districtType + districtNumber + schoolNumber + Unit Minor Report ttddddsssmmm where:
| M | tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number SSS: System Administration > Resources > School > school record > State School Number mmm: '000' | District.type District.number School.number |
educationOrganization Category | An unordered collection of educationOrganizationCategories. The classification of the education agency within the geographic boundaries of a state according to the level of administrative and operational control granted by the state. Report 'School'. | M | n/a | n/a |
schoolClassification | The numeric code representing the MARSS school classification. Report the Code value from the selected value. | M | System Administration > Resources > School > school record > | School.type |
Student
Provide a summary of what the report/function will cover and the logistics around the data collection or reporting.
**NOTE: The Student Resource is a shared record among all districts. If two districts have the same student in the same year, the last district to trigger data to Ed-Fi "wins". For example, if one district put in a first name of "Robert" and the second district put in a first name of "Rob" the last district to update the student record is what will appear in Ed-Fi and on both District's reports. This is true for all field logic in the Student Resource except the Identification Code in which the array reports for each district.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
Action | Trigger |
---|---|
Post | When an enrollment is created and saved for a person.
|
Put | When any student data is edited for the person in the Data Elements fields below:
|
Delete | Student records are never deleted because Student records are a shared resource among all districts. |
Scope Year Logic
This table describes scope year logic of this object.
Logic |
---|
A record will report when an enrollment is created and saved that is aligned to a scoped year.
|
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.
|
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 | Business Requirement | M, C or O | Data Source GUI Path | Database Field |
---|---|---|---|---|
id | The unique identifier of the resource. | M | none | none |
birthCity | The set of elements that capture relevant data regarding a person's birth, including birth date and place of birth. This element is currently not reported or collected. | O | none | none |
birthCountryDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. This element is currently not reported or collected. | O | none | none |
birthDate | The month, day, and year on which an individual was born. Report the value from the most recent identities record. | M | Census > People > Identities > identities record > Birth Date | Identity.birthdate |
birthInternationalProvince | For students born outside of the US, the Province or jurisdiction in which an individual is born. This element is currently not reported or collected. | O | none | none |
birthStateAbbreviationType | The abbreviation for the name of the state (within the United States) or extra-state jurisdiction in which an individual was born. This element is currently not reported or collected. | O | none | none |
citizenshipStatusType | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. This element is currently not reported or collected. | O | none | none |
dateEnteredUS | For students born outside of the U.S., the date the student entered the U.S. This element is currently not reported or collected. | O | none | none |
displacementStatus | Indicates a state health or weather related event that displaces a group of students, and may require additional funding, educational, or social services. This element is currently not reported or collected. | O | none | none |
economicDisadvantaged | An indication of inadequate financial condition of an individual's family, as determined by family income, number of family members/dependents, participation in public assistance programs, and/or other characteristics considered relevant by federal, state, and local policy | O | ||
firstName | A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.
| M | Census > People > Identities > Protected Identity Information > Legal First Name Census > People > Demographics > First Name | Identity.legalFirstName Identity.firstName |
generationCodeSuffix | An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III).
| C | Census > People > Identities > Protected Identity Information > Suffix | Identity.legalSuffix Identity.suffix |
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 > Demographics > Is the individual Hispanic/Latino? | Identity.hispanicEthnicity |
lastSurname | The name borne in common by members of a family.
| M | Census > People > Identities > Protected Identity Information > Legal Last Name | Identity.legalLastName Identity.lastName |
limitedEnglishProficiencyDescriptor | An indication that the student has sufficient difficulty speaking, reading, writing, or understanding the English language, as to require special English Language services. | O | ||
loginId | The login ID for the user; used for security access control interface | O | ||
maidenName | The person's maiden name. | O | ||
middleName | A secondary name given to an individual at birth, baptism, or during another naming ceremony.
| C | Census > People > Identities > Protected Identity Information > Legal Middle Name | Identity.legalMiddleName Identity.middleName |
multipleBirthStatus | Indicator of whether the student was born with other siblings (i.e., twins, triplets, etc.). | O | ||
oldEthnicityType | Previous definition of Ethnicity combining Hispanic/latino and race: 1 - American Indian or Alaskan Native 2 - Asian or Pacific Islander 3 - Black, not of Hispanic origin 4 - Hispanic 5 - White, not of Hispanic origin | O | ||
personalTitlePrefix | A prefix used to denote the title, degree, position, or seniority of the person. This element is currently not reported or collected. | O | none | |
profileThumbnail | ProfileThumbnail. This element is currently not reported or collected. | O | none | none |
schoolFoodServicesEligibilityDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. This element is currently not reported or collected. | O | none | none |
sex | A person's gender.
| M | Census > People > Identities > Protected Identity Information > Legal Gender | Identity.legalGender Identity.gender |
studentUniqueId | A unique alphanumeric code assigned to a student. Report the value. | M | Census > People > Demographics > State ID | |
learningStyle | This element is currently not reported or collected. | O | none | none |
addresses | An unordered collection of studentAddresses. The set of elements that describes an address, including the street address, city, state, and ZIP code. This element is currently not reported or collected. | O | none | none |
characteristics | An unordered collection of studentCharacteristics. Reflects important characteristics of the student's home situation: Displaced Homemaker, Homeless, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, Unaccompanied Youth. | O | ||
cohortYears | An unordered collection of studentCohortYears. The type and year of a cohort (e.g., 9th grade) the student belongs to as determined by the year that student entered a specific grade. This element is currently not reported or collected. | O | none | none |
disabilities | An unordered collection of studentDisabilities. This type represents an impairment of body structure or function, a limitation in activities or a restriction in participation, as ordered by severity of impairment. This element is currently not reported or collected. | O | none | none |
electronicMails | An unordered collection of studentElectronicMails. This element is currently not reported or collected. | O | none | none |
identificationCodes | An unordered collection of studentIdentificationCodes. A coding scheme that is used for identification and record-keeping purposes by schools, social services or other agencies to refer to a student. See Array below. | R | See Array Below | See Array Below |
identificationDocuments | An unordered collection of studentIdentificationDocuments. Represents the valid document that a person uses for identification. This element is currently not reported or collected. | O | none | none |
indicators | An unordered collection of studentIndicators. An indicator or metric computed for the student (e.g., at risk) to influence more effective education or direct specific interventions. This element is currently not reported or collected. | O | none | none |
internationalAddresses | An unordered collection of studentInternationalAddresses. The set of elements that describes an address, including the street address and country for international students. This element is currently not reported or collected. | O | none | none |
languages | An unordered collection of studentLanguages. Language(s) the individual uses to communicate. This element is currently not reported or collected. | O | none | none |
otherNames | An unordered collection of studentOtherNames. Other names (e.g., alias, nickname, previous legal name) associated with a person. This element is currently not reported or collected. | O | none | none |
programParticipations | An unordered collection of studentProgramParticipations. Key programs the student is participating in or receives services from. This element is currently not reported or collected. | O | none | none |
races | An unordered collection of studentRaces. 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. This element is currently not reported or collected. | O | none | none |
telephones | An unordered collection of studentTelephones. The 10-digit telephone number, including the area code, for the person. This element is currently not reported or collected. | O | none | none |
visas | An unordered collection of studentVisas. Describe the types of Visa that a non-U.S. citizen student holds. This element is currently not reported or collected. | O | none | none |
_etag | A unique system-generated value that identifies the version of the resource. This element is currently not reported or collected. | O | none | none |
Array
studentIdentificationCodes
Data Element | Business Rules | M, C or O | Data Source GUI Path | Database Field |
---|---|---|---|---|
IdentificationCode | Report the value. | M | Census > People > Demographics > State ID | |
studentIdentificationSystem | Report 'State'. | M | N/A | N/A |
assigningOrganizationIdentificationCode | Report 'MARSS'. | M | N/A | N/A |
Student Education Organization Association
This association indicates any relationship between a student and an education organization other than however the state views enrollment. Enrollment relationship semantics are covered by Student School Association.
Resident District on Enrollment
This value uses the enrollment table. See information below on how to determine what values to report from:
- The first Resident District value saved for a student will populate the resident district field on the enrollment table
- Any additional resident district values saved for a student, will populate the custom student table in the Resident District Campus Attribute
Object Triggering Logic
This table describes logic for triggering syncing of this object.
Action | Trigger |
---|---|
Post | When an enrollment is saved in a school.
|
Put | When the student's Identity record is edited. |
Delete/Post | When a new Identities record is created and saved (or deleted) for a student that overlaps a reportable Enrollment record - report data from the Identities record with the latest "Effective Date" that is on or before the Student School Association end date. |
Delete | When the enrollment is deleted |
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.
|
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 | Description | M, C or O | Data Source GUI Path | Database Field | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | The unique identifier of the resource. | M | N/A | N/A | ||||||||||||
educationOrganizationReference | A reference to the related EducationOrganization resource. Report the reference from the educationOrganization resource; report the schoolID Report ttddddsss where:
| M | tt: System Administration > Resources > District Information > district record > Type dddd: System Administration > Resources > District Information > district record > State District Number SSS: System Administration > Resources > School > school record > State School Number | District.type District.number School.number | ||||||||||||
studentReference | A reference to the related Student resource. Report the reference from the Student record for the student being reported. | M | ||||||||||||||
birthCity | The city the student was born in. This element is currently not reported or collected. | O | N/A | N/A | ||||||||||||
birthCountryDescriptor | The country in which an individual is born. This element is currently not reported or collected. | O | N/A | N/A | ||||||||||||
birthDate | The month, day, and year on which an individual was born. Report the value from the most recent identities record. | M | Census > People > Identities > identities record > Birth Date | N/A | ||||||||||||
birthInternationalProvince | For students born outside of the U.S., the Province or jurisdiction in which an individual is born. This element is currently not reported or collected. | O | N/A | N/A | ||||||||||||
birthStateAbbreviationType | The abbreviation for the name of the state (within the United States) or extra-state jurisdiction in which an individual was born. This element is currently not reported or collected. | O | N/A | N/A | ||||||||||||
dateEnteredUS | For students born outside of the U.S., the date the student entered the U.S. This element is currently not reported or collected. | O | N/A | N/A | ||||||||||||
firstName | A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change.
| M | Census > People > Identities > Protected Identity Information > Legal First Name Census > People > Identities > First Name | N/A | ||||||||||||
generationCodeSuffix | An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III).
| C | Census > People > Identities > Protected Identity Information > Suffix | N/A | ||||||||||||
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 > Race/Ethnicity | Identity.hispanicEthnicity | ||||||||||||
lastSurname | The name borne in common by members of a family.
| M | Census > People > Identities > Protected Identity Information > Legal Last Name Census > People > Identities > Last Name | N/A | ||||||||||||
limitedEnglishProficiencyDescriptor | An indication that the student has been identified as limited English proficient by the Language Proficiency Assessment Committee (LPAC), or English proficient.
| M | Student Information > Program Participation > LEP > LEP > Program Status, Identified Date, Program Exit Date | Lep.identifiedDate Lep.exitDate | ||||||||||||
middleName | A secondary name given to an individual at birth, baptism, or during another naming ceremony.
| M | Census > People > Identities > Protected Identity Information > Legal Middle Name Census > People > Identities > Middle Name | N/A | ||||||||||||
multipleBirthStatus | Indicator of whether the student was born with other siblings (i.e., twins, triplets, etc.). This element is currently not reported or collected. | O | N/A | N/A | ||||||||||||
responsibilityDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. Report 'Demographic'. | M | N/A | N/A | ||||||||||||
sexType | A person's gender.
| M | Census > People > Identities > Protected Identity Information > Legal Gender | N/A | ||||||||||||
ancestryEthnicOrigins | An unordered collection of studentEducationOrganizationAssociationAncestryEthnicOrigins. The ancestry ethnic origins that pertain to the general racial categories with which the individual identifies.
| M | Census > People > Identities > Race Subcategory Census > People > Identities > Hispanic Subcategory | Identity.raceSubcategory Identity.hispanicSubcategory | ||||||||||||
languages | An unordered collection of studentEducationOrganizationAssociationLanguages. The language(s) the individual uses to communicate. | M | ||||||||||||||
races | An unordered collection of studentEducationOrganizationAssociationRaces. The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.
| M | Census > People > Identities > Race | Identity.federalRaces | ||||||||||||
studentCharacteristics | An unordered collection of studentEducationOrganizationAssociationStudentCharacteristics. Reflects important characteristics of the student's home situation: Displaced Homemaker, Immigrant, Migratory, Military Parent, Pregnant Teen, Single Parent, and Unaccompanied Youth. Also includes:
| M | N/A | N/A | ||||||||||||
studentIdentificationCodes | An unordered collection of studentEducationOrganizationAssociationStudentIdentificationCodes. A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student. Report the value - see Array logic below. | C | N/A | N/A | ||||||||||||
_etag | A unique system-generated value that identifies the version of the resource. | O | N/A | N/A |
Array
studentCharacteristics
Data Element Label | Description | M, C or O | Data Source GUI Path | Database Field | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Race/Ethnicity (ethnicCode) |
| C | Census > People > Demographics > State Race/Ethnicity | Identity.raceEthnicity | ||||||||||||||||||
(Homeless Student Flag) | Report 'Homeless' | C | Student Information > Enrollments > State Reporting Fields > Homeless | Enrollment.homeless | ||||||||||||||||||
(Active Duty Parent (ADP) Indicator) | Report values where
...then report 'Active Duty Parent (ADP)'. | C | Census > Person > Military Connection | ImpactAidEmployment.militaryBranch ImpactAidEmployment.militaryStatus ImpactAidEmployment.startDate | ||||||||||||||||||
(Immigrant Indicator) |
| C | Student Information > General > Enrollments > Immigrant | Enrollment.immigrant | ||||||||||||||||||
(Recently Arrived English Learner (RAEL)) |
| C | Student Information > Program Participation > EL > RAEL (date & checkbox) (Still need to get approval from Ann/Jon on this) | Unsure | ||||||||||||||||||
(Student with Limited or Interrupted Formal Education (SLIFE)) |
| C | Student Information > Program Participation > EL > SLIFE (date & checkbox) | Lep.slife |
studentIdentificationCodes
Data Element Label | Business Requirement | M, C or O | Data Source GUI Path | Database Field | Format |
---|---|---|---|---|---|
identificationCode | A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.
| C | Census > People > Demographics > Local Student Number | string | |
studentIdentificationSystem | A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a student. Report 'Local'. | M | n/a | n/a | string |
assigningOrganizationIdentificationCode | The organization code or name assigning the StudentIdentificationCode.
| C | Census > People > Demographics > Student State ID | string |
Student School Association
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 or the No Show or State Exclude check box is unchecked.
|
Post | When the start date for an enrollment is changed.
|
Post | If a Transportation record is saved, and the Start Date overlaps the enrollment record, post a unique record based on the start date of the transportation record. |
Put | When an enrollment is updated for a student. |
Put | When a change is made to Graduation > Grad Year. |
Delete | When an enrollment is deleted or the State Exclude check boxes are checked.
|
Delete | When the start date of an enrollment is changed. |
Delete | When a Transportation record, which previously had a start date that took place during an enrollment and thus created a unique SSA record, is updated so that the Transportation start date no longer takes place during an enrollment. |
Delete | When a Transportation record, which previously had a start date that took place during an enrollment and thus created a unique SSA record, is deleted. |
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.
|
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 | Description | M, C or O | Data Source GUI Path | Database Field |
---|---|---|---|---|
id | The unique identifier of the resource. | M | ||
graduationPlanReference | A reference to the related GraduationPlan resource. This element is currently not reported or collected. | O | ||
schoolReference | A reference to the related School resource. Report the School resource for the school tied to the enrollment Should contain:
| M | N/A | N/A |
classOfSchoolYearTypeReference | A reference to the related schoolYearType resource. This element is currently not reported or collected. | O | ||
schoolYearTypeReference | A reference to the related schoolYearType resource. Report the end year associated with the calendar (i.e., 2019-2020 calendars would report out '2020') | M | System Administration > Calendar > Calendar > End Date | |
studentReference | A reference to the related Student resource. Report the Student resource for the related student. | M | N/A | N/A |
residentLocalEducationAgencyReference | A reference to the related localAgency resource. Report ttdddd Where:
| M | Student Information > General > Enrollments > Resident District System Administration > Resources > District Information > Type System Administration > Resources > District Information > State District Number | Enrollment.residentDistrict District.type District.number |
employedWhileEnrolled | 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. | O | ||
entryDate | The month, day, and year on which an individual enters and begins to receive instructional services in a school.
| M | Student Information > General > Enrollments > Start Date or Student Information > General > Transportation > Start Date | enrollment.startDate transportation.startDate |
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 value from the state grade level associated with the enrollment grade level selected. | M | Student Information > General > Enrollment > Grade Level | |
entryGradeLevelReasonType | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. | O | ||
entryTypeDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.
| M | Student Information > General > Enrollments > Enrollments > 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 school (if known), the day on which an individual graduated, or the date on which it becomes known officially that an individual left school.
| M | Student Information > General > Enrollments > End Date OR Student Information > General > Transportation > Start Date | enrollment.endDate transportation.startDate |
exitWithdrawTypeDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.
| M | Student Information > General > Enrollments > End Status OR sys admin > calendar > End Code Override | |
homeboundServiceIndicator | The Homebound Service Indicator is used to validate Membership Days for students who have no Attendance Days. It is an indication of whether students were medically confined to their home and received instruction in the home during the enrollment period.
| M | Student Information > General > Enrollments > State Reporting Fields > Homebound | |
primarySchool | Indicates if a given enrollment record should be considered the primary record for a student. If omitted, the default is true. | O | ||
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. | O | ||
residencyStatusDescriptor | A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table. | O | ||
schoolChoiceTransfer | 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. | O | ||
schoolFoodServicesEligibilityDescriptor | An indication of a student's level of eligibility for breakfast, lunch, snack, supper, and milk programs.
| M | FRAM > Eligibility > Eligibility, School Year | POSEligibility.eligibility POSEligibility.endYear |
specialEducationEvaluationStatusDescriptor | An indicator of the students' need for and participation in special education programs during this enrollment period.
| M | Student Information > General > Enrollments > Special Ed Fields > Special Ed Status | Enrollment.specialEdStatus |
educationPlans | An unordered collection of studentSchoolAssociationEducationPlans. Indicates the type of Education Plan(s) the student is following, if appropriate; for example: Special Education IEP or Vocational/CTE, etc. See Array below. | O | ||
studentProgramParticipations | An unordered collection of studentSchoolAssociationStudentProgramParticipations. Key programs the student is participating in or receives services from. , _etag (string, optional): A unique system-generated value that identifies the version of the resource. See Array below. | C |
Array
studentProgramParticipations
Data Element Label | Description | M, C or O | Data Source GUI Path | Database Field |
---|---|---|---|---|
StudentProgramParticipation (Independent Study) | An unordered collection of studentSchoolAssociationStudentProgramParticipations. Key programs the student is participating in or receives services from. , _etag (string, optional): A unique system-generated value that identifies the version of the resource.
Report beginDate from the Enrollment Start Date. | M | Student Information > General > Enrollments > State Reporting Fields > Independent Study | CustomStudent.value (attribute: Enrollment.independentStudy) Enrollment.startDate |
StudentProgramParticipation (Section 504 Placement) |
Report beginDate from the Enrollment Start Date. | M | Student Information > General > Enrollments > Special Ed > Primary Disability | Enrollment.disability1 Enrollment.startDate |
StudentProgramParticipation (Title I Part A) |
Report beginDate from the Enrollment Start Date (for both reporting locations). | M | Sys admin > resources > school > school history > Title 1 OR Student Information > General > Enrollments > State Reporting Fields > Title 1 | SchoolAttribute.title1 Enrollment.startDate |
StudentProgramParticipation (English Learner) |
Note: in the MARSS B report,
| M | Student Information > Program Participation > English Learners (EL) > EL AND Student Information > Program Participation > English Learners (EL) > EL > EL Services | Lep.programStatus Lep.identifiedDate LepService.startDate |
Additional Logic and Considerations
The following describes additional logic and considerations to be aware of when working with Ed-Fi.
No Show/Excludes | If the State Exclude or No Show buttons are marked or unmarked on an enrollment the record, they will be deleted/added from Ed-Fi. |