Staffs (New Mexico v3.5)

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.

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 is the security protocol set by Ed-Fi, you cannot see the Staff record until they are associated to a District or School through the SEOAA or SEOEA records.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When a person has a District Employment record that overlaps the configured year and the person has a value entered in SSN field. If multiple District Employment records are active, report data from the most recent: If one is exited and a new one begins, report from new. If both are exited, report from the District Employment record with the most recent end date. Do NOT report a record if any one 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.
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. When one of the person’s section staff history records is changed.
Delete	Staff records are a shared resource among all districts, this record will not delete.

Action

Trigger

Post

When a person has a District Employment record that overlaps the configured year and the person has a value entered in SSN field.

If multiple District Employment records are active, report data from the most recent:
- If one is exited and a new one begins, report from new.
- If both are exited, report from the District Employment record with the most recent end date.
Do NOT report a record if any one 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.

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.
When one of the person’s section staff history records 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.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Race Descriptors	Race/Ethnicity
Highest Completed Level Of Education Descriptors	Employment Highest Degree Earned
Tribal Affiliation Descriptors	Identity Tribe
Visa Type Descriptors	Identity Visa Types
Staff Languages Override	Home Primary Language

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	The SSN of the staff member.	Report staff member's SSN. If SSN field is not blank, report the entered value. Else, do not report.	M	Census > People > Identities > Current Identity > Soc Sec Number	Identity.ssn
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	An unordered collection of staffCredentials. 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
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 array section for logic.	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
generationCodeSuffix	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 LevelOfEducation Descriptor	The highest level of education completed for a staff member	If the 'District Staff' checkbox is checked on the District Employment record AND the 'Qualification Status' on the District Employment record = "C: Certified". Report the code selected in "Highest Degree Earned". Else, if the staff has a District Assignment with 'Qualification Status' = NULL AND 'Type' = 'Certified'. Report the code value selected from Highest Degree Earned. Else, do not report.	O	Census>People>District Employment>Highest Degree Earned Census > People> District Assignment> Qualification Status Census > People> District Assignment> Type Census > People> District Employment> Qualification Status
highlyQualified Teacher	An indication of whether a teacher is classified as highly qualified for his/her assignment according to state definition. This attribute indicates the teacher is highly qualified for ALL sections being taught. Section 9101(23) of the ESEA defines the term “highly qualified.” NEDM: HQT Qualification Status,	Report "True" when the person has a Credential record that overlaps the configured year with a Type = HQ: Highly Qualified and has a Staff History record on a Section. Report "False" when person is a teacher on any active course section and does not have a HQ: Highly Qualified Credential. The record will still report if the Staff History or District Assignment record has ended. If person has a HQ Credential but does not have a Staff History record, do not report.	O	Census> People> Credentials	employmentCredential. employmentCredentialType
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".	O	Census>People>Identities>Is the individual Hispanic/Latino?	identity.hispanicEthnicity
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.	See array section below for logic.	O
identification Documents	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.	See Array section below for logic.	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.	This is optional, does not report.	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
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 code value selected in the droplist: Female report 'F' Male report 'M' Else leave null	O	Census>People>Identities> Identity Information> 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.	Reports If any of the Race fields relate to Native American. Report the Ed-Fi code(s) mapped in the config mapping tool if it exists, for any and all values saved in the multi-select tool. Otherwise, do not report.	O	Census > People > Tribal Affiliation	Identity.tribalName
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.	See Array section below for logic.	O	Census > People > Identity > Visa Type	identity.visaType
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
yearsOfPrior Teaching 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

Arrays

Click here to expand...

Electronic Mail

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
electronicMailType Descriptor	The type of email listed for an individual or organization. For example: Home/Personal, Work, etc.)	The Email (primary) address will report as 'Work'. Do not report Personal email.	M
electronicMailAddress	The electronic mail (e-mail) address listed for an individual or organization.	Reports the email address entered for that person.	M	Census> People> Demographics> Emaill	contact.email
primaryEmailAddress Indicator	An indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.	This is optional, does not report.	O

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

electronicMailType
Descriptor

The type of email listed for an individual or organization. For example: Home/Personal, Work, etc.)

The Email (primary) address will report as 'Work'.
Do not report Personal email.

electronicMailAddress

The electronic mail (e-mail) address listed for an individual or organization.

Reports the email address entered for that person.

Census> People> Demographics> Emaill

contact.email

primaryEmailAddress
Indicator

An indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization.

This is optional, does not report.

Staff Identification Code

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
staffIdentification SystemDescriptor	A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a staff member.	Report the code value from the staffIdentificationSystemDescriptor table below for identificationCode reported.	M
assigningOrganization IdentificationCode	The organization code or name assigning the Staff Identification Code.	Do not report, we do not collect the agency name that issues staff state id's or license numbers.	O
identificationCode	A unique number or alphanumeric code assigned to a staff member by a school, school system, a state, or other agency or entity.	Report staff's SSN. Value must be 9 in length, and this alpha-numeric field must contain leading zeros if their SSN is shorter than 9. For staffs who have a license (or licenses) issued by PED, report their unique license number. If null, do not report.	M	Census > People > Identities > Current Identity > Soc Sec Number Census > People > District Employment > License Number	Identity.ssn

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

staffIdentification

SystemDescriptor

A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a staff member.

Report the code value from the staffIdentificationSystemDescriptor table below for identificationCode reported.

assigningOrganization
IdentificationCode

The organization code or name assigning the Staff Identification Code.

Do not report, we do not collect the agency name that issues staff state id's or license numbers.

identificationCode

A unique number or alphanumeric code assigned to a staff member by a school, school system, a state, or other agency or entity.

Report staff's SSN. Value must be 9 in length, and this alpha-numeric field must contain leading zeros if their SSN is shorter than 9.
For staffs who have a license (or licenses) issued by PED, report their unique license number.
1. If null, do not report.

Census > People > Identities >

Current Identity > Soc Sec Number

Census > People > District Employment > License Number

Identity.ssn

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

Languages

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database field
languageDescriptor	A specification of which written or spoken communication is being used	Report the Language code value selected from the Home Primary Language fields saved on the staff current identity record. Look for a mapping saved to the Language Descriptor Override section in preferences. If there is a mapped value, report that mapping. If an override is not there, look to see if the language standard code matches an Ed-Fi code, if yes report that value. Report default value if saved on the Attribute and the standard code matches an Ed-Fi code. Else, report NULL.	M	Census > People> Identities > Home Primary Language	identity.homePrimaryLanguage
uses	An unordered collection of staffLanguageUses. A description of how the language is used (e.g. Home Language, Native Language, Spoken Language).	For a reportable language value saved in "Home Primary Language", report 'Home Language' as languageUseDescriptor.	O	Census > People> Identities > Home Primary Language	identity.homePrimaryLanguage

Staff Tribal Affiliations

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database field
TribalAffiliationDescriptor	An American Indian tribe with which the staff member is affiliated.	Reports the selected Tribal Affiliation code value.	C	Census> People > Demographics > Person Information > Tribe

Visas

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database field	Format
visaDescriptor	An indicator of a non-US citizen's Visa type.	Reports only when Ed-Fi code value for the visa type is either J1 or Temporary work visas	C	Census > People > Identity> Visa Type	identity.visaType	string

Type/Descriptor