Staffs (Tennessee v5.3)

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.

Action	Trigger
Post	Staff must meet the following conditions to report a record: Have a District Assignment record with Assignment Code is not null. Assignment must overlap the configured scope year. Staff member has an Ed-Fi ID is not null. Staff member has an Email Address is not null.
Post	Do not report a record if any one of the following scenarios are true: There is not an Ed-FI ID and Email Address for the staff person.. The staff records are not active based on the Scope Year logic listed below. If the record is being triggered from a District Assignment record and it is marked as Exclude. If the record is being triggered from a District Assignment record and the School is marked as Exclude.
Put	When any data is edited for the person in the Data Elements fields below. When the person’s identity record is changed. When the person’s employment assignment record is changed. When the person’s employment record is changed. When one of the person’s employment credentials is changed.
Delete	Staff records are a shared resource among all districts, this record will 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	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	Trigger
Delete/Post	Cascading Deletes: The logic for an Ed-FI ID change will update 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 will report when a person has a District Assignment or District Employment record that is aligned to a scoped year. Report when a staff has an active District Assignment or District Employment record that overlaps with the School year Start and End Dates. If School Year Start Date is NULL, 7/1/xxxx will be the default start date used. If School Year End Date is NULL, 6/30/xxxx will be the default end date used. Data will only send for the years that have valid configuration.
When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to. Current Year: Records will be compared to today's date to determine if the record is eligible 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. If 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. If blank, the default date of 7/01/xxxx is used.
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. Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date. Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used. Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is use.

Logic

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

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

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

Current Year: Records will be compared to today's date to determine if the record is eligible 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. If 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. If blank, the default date of 7/01/xxxx is used.

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.

Current Year: The records start date must be on or before today's date and the records end date must be on or after today's date.
Previous Years: The record's start date must be on or before the school year's end date and the record's end date must be after the school year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.
Future Years: The record's start date must be on or before the schools year's start date and the record's end date must be on or after the school year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is use.

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 Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
staffUniqueId	A unique alpha-numeric code assigned to a staff.	Report the Ed-Fi ID.	M	Census>People> Demographics> EdFi ID	person.edFiID
addresses	Report the person's address(es).	This is optional, does not report.	O
birthDate	The month, day, and year on which an individual was born.	Report the Birth Date from the person's current identity record. If blank, do not report.	O	Census>People>Identities >Birth Date	identity.birthdate
citizenshipStatus Descriptor	A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.	This is optional, does not report.	O
credentials	The number assigned to the Staff Member when they are entered into the teacher Certification and Licensure system	See array logic below.	O
electronicMails	An unordered collection of Electronic Mail address for Staff Members	Do not report.	O
firstName	A name given to an individual at birth, baptism, or during another naming ceremony, or through legal change. NEDM First Name.	Report the first name from the person's current identity record.	M	Census>People>Identities >First Name	identity.firstName
generationCode Suffix	An appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III).	Report the suffix from the person's current identity record. If blank, do not report.	C	Census>People>Identities >Suffix	identity.suffix
highestCompleted LevelOf EducationDescriptor	The highest level of education completed for a staff member.	Do not report.	O
highlyQualified Teacher	An indication of whether a teacher is classified as highly qualified for his/her assignment according to state definition.	Do not report.	O
hispanicLatino Ethnicity	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."	Report from "Is the individual Hispanic/Latino?" from the person's current identity: If droplist is = Yes, report "true". If droplist is = No or NULL, report "false".	M	Census>People>Identities >Is the individual Hispanic/Latino?	identity.hispanic Ethnicity
identification Codes	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. The following EIS 060 Staff Member definitions apply: Staff Social Security Number - The Staff Member's social security number Staff Previous Social Security Number - The previous EIS social security number for the Staff Member Staff Previous Teacher License Number - The previous EIS Teaching License number for the Staff Member	See array section below for logic.	O
identificationDocuments	An unordered collection of staffIdentificationDocuments. 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.	This is optional, does not report.	O
international Addresses	An unordered collection of staffInternationalAddresses. 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.	This is optional, does not report.	O
languages	An unordered collection of staffLanguages. 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.	This is optional, does not report.	O
lastSurname	The name borne in common by members of a family. NEDM Last Name/Surname	Report the last name from the person's current identity record.	M	Census>People>Identities >Last Name	identity.lastName
loginId	The login ID for the user; used for security access control interface.	This is optional, does not report.	O
maidenName	The person''s maiden name, if applicable.	This is optional, does not report.	O
middleName	A secondary name given to an individual at birth, baptism, or during another naming ceremony. NEDM Middle Name.	Report the middle name from the person's current identity record. If blank, do not report.	C	Census>People>Identities >Middle Name	identity.middleName
oldEthnicity Descriptor	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.	This is optional, does not report.	O
otherNames	An unordered collection of staffOtherNames. 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. The following EIS 060 Staff Member definitions apply: Previous EIS First Name - The previous EIS first name for the Staff Member Previous EIS Middle Name - The previous EIS middle name for the Staff Member Previous EIS First Name - The previous EIS last name for the Staff Member	See array logic below	O
personalIdentification Documents	The documents presented as evident to verify one’s personal identity; for example: drivers license, passport, birth certificate, etc.	This is optional, does not report.	O
personalTitlePrefix	A prefix used to denote the title, degree, position or seniority of the person.	This is optional, does not report.	C	Census > People > Identities
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 Array section below for logic.	O
recognitions	Recognitions given to the staff for accomplishments in a co-curricular or extracurricular activity.	This is optional, does not report.	O
sexDescriptor	A person''s gender.	Report the following based on the value selected in the droplist: Female report 'Female'. Male report 'Male'. If blank or Non-binary, report 'Not Selected'.	M	Census>People>Identities> Gender	identity.Gender
telephones	An unordered collection of staffTelephones. 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.	This is optional, does not report.	O
tribalAffiliations	An American Indian tribe with which the staff member is affiliated.	This is optional, does not report.
visas	An unordered collection of staffVisas. 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.	This is optional, does not report.	O
yearsOfPrior Professional Experience	The total number of years that an individual has previously held a similar professional position in one or more education institutions. NEDM: Years of Prior Teaching Experience.	This is optional, does not report.	O
yearsOfPriorTeaching Experience	The total number of years that an individual has previously held a teaching position in one or more education institutions.	This is optional, does not report.	O
_ext.tdoe.personType Descriptor	Auto assigned, do not submit.	Do not report.	O
_ext.tdoe.submittedFor SchoolYearType Reference .SchoolYear	Key for School Year.	Use the School Year tied to the configured year to identify the End Year.	M	System Administration > Ed-Fi > Ed-Fi Configuration > Connection > School Year	SchoolYear.endYear
_ext.tdoe.submittedBy EducationOrganization Reference.education OgranizationID	The identifier assigned to an education organization.	Populate the State District Number.	M	System Administration > Resources > District Information	district.number

Arrays

Click here to expand...

Credentials

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
credentialReference.credentialIdentifier	The number assigned to the Staff Member when they are entered into the teacher Certification and Licensure system	If Licensure Check IS NOT NULL, populate NULL Else If License Number is NOT NULL, populate License Number Else Populate NULL	M	Student Information > General > District Employment > License Number Census > People > District Employment > Licensure Check	Employment.licenseNumber CustomEmployment.value
stateOfIssueStateAbbreviationDescriptor	State Code Value assigned to Licensed Staff Only.	If Licensure Check is NULL AND License Number is NOT NULL Populate "TN"	M	Student Information > General > District Employment > License Number Census > People > District Employment > Licensure Check	Employment.licenseNumber CustomEmployment.value

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

credentialReference.credentialIdentifier

The number assigned to the Staff Member when they are entered into the teacher Certification and Licensure system

If Licensure Check IS NOT NULL, populate NULL

Else

If License Number is NOT NULL, populate License Number

Else

Populate NULL

Student Information > General > District Employment > License Number

Census > People > District Employment > Licensure Check

Employment.licenseNumber

CustomEmployment.value

stateOfIssueStateAbbreviationDescriptor

State Code Value assigned to Licensed Staff Only.

If Licensure Check is NULL AND License Number is NOT NULL

Populate "TN"

Student Information > General > District Employment > License Number

Census > People > District Employment > Licensure Check

Employment.licenseNumber

CustomEmployment.value

Other Names

Data Element Label	M, C or O	Business Rules
otherNameTypeDescriptor	M	Populate "Previous"
firstName generationCodeSuffix lastSurname middleName	M O M O	If one or more of the following fields are NOT NULL complete the following logic to populate the Other Name array Previous EIS First Name Previous EIS Middle Name Previous EIS Last Name Complete each bullet of logic to properly populate the Other Name Array If Previous EIS First Name is NOT NULL, populate Previous EIS First Name ELSE populate the First Name of the Staff Members current identity If Previous EIS Suffix is NOT NULL, populate Previous EIS Suffix ELSE populate the Suffix of the Staff Members current identity If Previous EIS Middle Name is NOT NULL, populate Previous EIS Middle Name ELSE populate the Middle Name of the Staff Members current identity If Previous EIS Last Name is NOT NULL, populate Previous EIS Last Name ELSE populate the Last Name of the Staff Members current identity
personalTitlePrefix	O	Do not report.

Data Element Label

M, C or O

Business Rules

otherNameTypeDescriptor

Populate "Previous"

firstName
generationCodeSuffix
lastSurname
middleName

M
O
M
O

If one or more of the following fields are NOT NULL complete the following logic to populate the Other Name array

Previous EIS First Name
Previous EIS Middle Name
Previous EIS Last Name

Complete each bullet of logic to properly populate the Other Name Array

If Previous EIS First Name is NOT NULL, populate Previous EIS First Name ELSE populate the First Name of the Staff Members current identity
If Previous EIS Suffix is NOT NULL, populate Previous EIS Suffix ELSE populate the Suffix of the Staff Members current identity
If Previous EIS Middle Name is NOT NULL, populate Previous EIS Middle Name ELSE populate the Middle Name of the Staff Members current identity
If Previous EIS Last Name is NOT NULL, populate Previous EIS Last Name ELSE populate the Last Name of the Staff Members current identity

personalTitlePrefix

Do not report.

Staff Identification Code

Data Element Label

Business Rules

staffIdentificationSystemDescriptor

Report ALL applicable Identification Codes and their related assigning organization detail for Staff Members using the logic associated to the staffIdentificationSystemDescriptor:

staff

identification

System

Descriptor

Business Rules

assigning

Organization

Identification

Code

identificationCode

Data Source GUI Path

Database
Field

SSN

If Licensure Check = "U: University Teacher" DO NOT report Staff Member SSN

Else

Populate the social security number of the Staff Member's current identity

Populate "Federal".

Populate Soc Sec Number from the Staff Member's current identity

Format: 9 character left zero padded

Census > People > District Employment > Licensure Check

Census > People > Identities > Current Identity > Soc Sec Number

Custom

Employment.

value

Identity.ssn

Prev SSN

If NOT NULL, populate Previous EIS SSN

Populate "Federal".

Populate Previous EIS SSN

Format: 9 character left zero padded

Census > People > Demographics > Previous EIS SSN

CustomStudent.
value

Prev TLN

If NOT NULL, populate Previous EIS Teaching License

Populate "TN".

Populate Previous EIS Teaching License

Format: 9 character left zero padded

Census > People > District Employment > Previous EIS Teaching License

Custom
Employment.
value

Race

Data Element Label	Business Requirement	Business Rules	M,C or O	Data Source GUI Path	Database Field
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.	Determine the Race/Ethnicity(s) that are checked on the person's current identity record. Use the Identity Race Ethnicity table to determine all of the check boxes checked for the person's current identity id. Report the Ed-Fi Code mapped in Resource Preferences to the corresponding Race Ethnicity. Report all races if the student has more than 1 selected. Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.	M	Census> People> Identities> Race/Ethnicity	IdentityRaceEthnicity and racethnicity.raceid

Data Element Label

Business Requirement

Business Rules

M,C or O

Data Source GUI Path

Database Field

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.

Determine the Race/Ethnicity(s) that are checked on the person's current identity record.
- Use the Identity Race Ethnicity table to determine all of the check boxes checked for the person's current identity id.
Report the Ed-Fi Code mapped in Resource Preferences to the corresponding Race Ethnicity.
- Report all races if the student has more than 1 selected.
Do not report if the person does not have a Race/Ethnicity checked or there is not a corresponding mapping.

Census> People> Identities> Race/Ethnicity

IdentityRaceEthnicity

and

racethnicity.raceid

Type/Descriptor

Click here to expand...

Staff identification System Descriptor

This descriptor is populated via logic and is NOT required to be mapped via Ed-Fi Configuration Resource Preferences.

Code Value	Namespace	Description	Short Description
SSN	uri://tdoe.edu/StaffIdentificationSystemDescriptor	Social Security Number	Social Security Number
Prev SSN	uri://tdoe.edu/StaffIdentificationSystemDescriptor	Current value in database for Social Security Number, used for validation before allowing update	Previous Social Security Number
Prev TLN	uri://tdoe.edu/StaffIdentificationSystemDescriptor	Current value in database for Teacher License Number, used for validation before allowing update	Previous Te

Race Descriptors

District will be required to be map Race Descriptors to Race/Ethnicity Types via Ed-Fi Configuration Resource Preferences.

Code Value	Namespace	Description	Short Description
A	uri://tdoe.edu/RaceDescriptor	Asian	Asian
I	uri://tdoe.edu/RaceDescriptor	American Indian or Alaskan Native	American Indian or Alaskan Native
P	uri://tdoe.edu/RaceDescriptor	Native Hawaiian or Other Pacific Islander	Native Hawaiian or Other Pacific Islander
B	uri://tdoe.edu/RaceDescriptor	Black or African American	Black or African American
W	uri://tdoe.edu/RaceDescriptor	White	White

Object Triggering Logic

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Identity Mapping Object Key

Event Queue Detail

Object Data Elements

Arrays

Credentials

Other Names

Staff Identification Code

Race

Type/Descriptor

Staff identification System Descriptor

Race Descriptors

Related Articles