Tool Search: Ed-Fi

This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

A Staff Education Organization Assignment Association or a Staff Education Organization Employment Association record must be sent in order to see / access a Staff Record in the ODS. This is the security protocol set by Ed-Fi. Staff records are not visible until they are associated to a District or School through the Staff Education Organization Assignment Association or Staff Education Organization Employment Association records.

Action	Trigger
Post	When a person has a District Employment or District Assignment record that overlaps the configured year and they have an Ed-Fi ID. Does NOT report a record when any of the following scenarios are true: There is not an Ed-FI ID for the staff person. The staff records are not active based on the Scope Year logic listed below. When the record is being triggered from a District Assignment record and it is marked as Exclude. When the record is being triggered from a District Assignment record and the School is marked as Exclude.
Put	When any data is changed/edited on the person’s identity record. When any of the following are changed: The person’s employment assignment record. One of the person’s employment records. One of the person's employment credentials. One of the person’s section staff history records.
Delete	Staff records are a shared resource among all districts, this record does not delete.

Action

Trigger

Post

When a person has a District Employment or District Assignment record that overlaps the configured year and they have an Ed-Fi ID.

Does NOT report a record when any of the following scenarios are true:

There is not an Ed-FI ID for the staff person.
The staff records are not active based on the Scope Year logic listed below.
When the record is being triggered from a District Assignment record and it is marked as Exclude.
When the record is being triggered from a District Assignment record and the School is marked as Exclude.

Put

When any data is changed/edited on the person’s identity record.

When any of the following are changed:

The person’s employment assignment record.
One of the person’s employment records.
One of the person's employment credentials.
One of the person’s section staff history records.

Delete

Staff records are a shared resource among all districts, this record does not delete.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

Action	Trigger
None	When a resource is toggled to off after data has sent, all sent data remains in the ODS but no new data sends.
Resync	When a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table.
Resync	When a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS.
Resync	When a mapping is changed in Resource Preferences, a resync needs 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	Trigger
Delete/Post	Cascading Deletes: The logic for an Ed-FI ID change updates all resources impacted by this change.
Dependent Resources	Staff Education Organization Assignment Associations, Staff Education Organization Employment Associations, Staff School Associations, Staff Section Associations, Staff Cohort Associations

Scope Year Logic

This table describes scope year logic of this object.

Logic
A record reports when a person has a District Assignment or District Employment record that is aligned to a scoped year. Reports when a staff has an active District Assignment or District Employment record that overlaps with the School year Start and End Dates. When School Year Start Date is NULL, 7/1/xxxx is the default start date used. When School Year End Date is NULL, 6/30/xxxx is the default end date used. Data only sends for the years that have valid configuration.
When using data in Campus that has an effective date, the following logic is applied to determine the scope year(s) to report the data to. Current Year: Records are compared to today's date to determine the eligibility of the record to report. Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. When blank, the default date of 6/30/xxxx is used. Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. When blank, the default date of 7/01/xxxx is used.

Logic

A record reports when a person has a District Assignment or District Employment record that is aligned to a scoped year.

Reports when a staff has an active District Assignment or District Employment record that overlaps with the School year Start and End Dates.
- When School Year Start Date is NULL, 7/1/xxxx is the default start date used.
- When School Year End Date is NULL, 6/30/xxxx is the default end date used.
Data only sends for the years that have valid configuration.

When using data in Campus that has an effective date, the following logic is applied to determine the scope year(s) to report the data to.

Current Year: Records are compared to today's date to determine the eligibility of the record to report.
Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. When blank, the default date of 6/30/xxxx is used.
Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. When blank, the default date of 7/01/xxxx is used.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Race/Ethnicity	Race Descriptor
EmploymentCredential Degree Type and Employment Education	Highest Completed Level Of Education Descriptors

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
employment	Post/Put/Delete	The primary table used for sending data for this resource.
employmentassignment	Post/Put/Delete	The primary table used for sending data for this resource.
identity	Put	Hispanic or Latino, Gender, First Name, Suffix, Last Surname, Middle Name
person	Put	Ed-Fi ID, Staff Number
contact	Put	Email
raceethnicity	Put	Races
employmentCredential	Put	Highest Completed Level of Education, Highly Qualified Teacher, License Number
employment	Put	Highest Completed Level of Education, License Number

Object Data Elements

This table describes data elements sent within the Staff resource. 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	Description	M, C, or O	Database Location
id	The unique identifier of the resource.	M
staffUniqueId	A unique alpha-numeric code assigned to a staff. Reports the value tied to the Primary Teacher last active as of the end date of the school year. When no Primary Teacher exists at any time on the section staff history, reports the value tied to the Teacher last active as of the end date of the school year.	M	Demographics > Person Information > Soc Sec Number person.edFiID
electronicMails	An unordered collection of staffElectronicMails. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. See the Arrays section below.	M
firstName	A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change. NEDM First Name First looks to Legal First Name on the the Protected Identities tool. When blank, reports from the Demographics First Name field.	M	Legal First Name on the Identities > Protected Identity Information area for reporting Demographics > First Name identity.firstName
identificationCodes	An unordered collection of staffIdentificationCodes. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. See the Arrays section below.	M
lastSurname	The name borne in common by members of a family. NEDM Last Name/Surname First looks to Legal Last Name on the the Protected Identities tool. When blank, reports from the Demographics Last Name field.	M	Legal Last Name on the Identities > Protected Identity Information area for reporting Demographics > Last Name identity.lastName
races	An unordered collection of staffRaces. This entity represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. See the Arrays section below.	M

Arrays

Click here to expand...

Electronic Mail

Data Element Label	Description	M, C, or O	Database Location
electronicMailTypeDesccriptor	The type of email listed for an individual or organization. Such as Home, Personal, Work, etc.	M
electronicMailAddress	The electronic mail (e-mail) address listed for an individual or organization.	M	Demographics > Email contact.email

Identification Codes

Data Element Label	Description	M, C, or O	Database Location
IdentificationCode	A unique number or alphanumeric code assigned to a student by a school, school system, a state, or other agency or entity.	M	Demographics > Person Information > Soc Sec Number person.studentNumber

Races

Data Element Label	Description	M,C or O	Database Location
raceDescriptor	The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies. H reports for Hispanic. A reports for Asian. P reports for Native Hawaiian or Other Pacific Islander. I reports for American Indian or Alaskan Native. B reports for Black or African American. W reports for White. M reports for Multiracial.	M	Identities > Race/Ethnicity IdentityRaceEthnicity and racethnicity.raceid

Data Element Label

Description

M,C or O

Database Location

raceDescriptor

The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies.

H reports for Hispanic.
A reports for Asian.
P reports for Native Hawaiian or Other Pacific Islander.
I reports for American Indian or Alaskan Native.
B reports for Black or African American.
W reports for White.
M reports for Multiracial.

Identities > Race/Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

Type/Descriptor