Staffs (Georgia v3.6.1)

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 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.

ActionTrigger
Post

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

  • Do NOT report a record if any one of the following scenarios are true:  
    1. There is not a Social Security Number for the staff person.
    2. The staff records are not active based on the Core Scope Year logic.
    3. If the record is being triggered from a District Assignment record and it is marked as Exclude

    4. If the record is being triggered from a District Assignment record and the School is marked as Exclude

Put

When any reportable information below is changed:

  • When the following information is changed on Identity:
    • New Identity Record
    • First Name
    • Legal First Name
    • Last Name
    • Legal Last Name
    • Middle Name
    • Legal Middle Name
    • Suffix
    • Birth Date
    • Is the individual Hispanic/Latino?
    • Is the individual from one or more of these races?
      (check all that apply)
    • Social Security Number
  • When the following information is changed on District Employment:
    • New District Employment
    • Education
    • Start Date
    • End Date
  • When the following information is changed on Credentials:
    • New Credential
    • Education Level
  • When the following information is changed on District Assignment:
    • Exclude
  • When the following information is changed on Demographics:
    • Email
DeleteStaff 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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
Delete/Post

Cascading Deletes: The logic for an Ed-FI ID change will update all resources impacted by this change.

Dependent ResourcesStaff 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.


Resource Preferences

This table describes the Resource Preferences of this object.

Data Element LabelMapping Needed
Race DescriptorsRace/Ethnicity
Highest Completed Level Of Education Descriptors

Employment Highest Degree Earned

Tribal Affiliation DescriptorsIdentity Tribe
Visa Type DescriptorsIdentity Visa Types
Staff Languages OverrideHome Primary Language


Identity Mapping Object Key

This table describes the Identity Mapping Object Key of this object.

campusObjectTypeObject Key Data Source
PersonpersonID


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.

identityPutHispanic or Latino, Gender, First Name, Suffix, Last Surname, Middle Name
personPutEd-FI ID, Staff Number
contactPutEmail
raceethnicityPutRaces
employmentCredentialPutHighest Completed Level of Education, Highly Qualified Teacher, License Number
employmentPutHighest Completed Level of Education, License Number

Object Data Elements

This table describes data elements sent within the Staff resource.

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Data Source GUI Path

Database Field
idThe unique identifier of the resource.
M

staffUniqueId  A unique alpha-numeric code assigned to a staff.

Report the full 9-digit Social Security Number from the person's most recent Identity record.

MCensus > People > Demographics > EdFi ID person.edFiID
addressesReport the person's address(es)

Do not report, this is optional.

O






birthDateThe month, day, and year on which an individual was born.
  1. Report the Birth Date from the person's current identity record.
  2. If blank, do not report.
OCensus > People > Identities > Birth Dateidentity.birthdate
citizenshipStatus
Descriptor
A unique identifier used as Primary Key, not derived from business logic, when acting as Foreign Key, references the parent table.

Do not report, this is optional.

O

credentialsAn 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.

Do not report, this is optional.

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. 
  • Report the Email (Primary) as electronicMailAddress
  • Report Work for electronicMailTypeDescriptor (Hard-coded)
O

firstNameA name given to an individual at birth, baptism, or during another naming ceremony, or through legal change. NEDM First Name
  1. Report the first name from the person's current identity record.
MCensus>People>Identities>First Nameidentity.firstName
generationCodeSuffixAn appendage, if any, used to denote an individual's generation in his family (e.g., Jr., Sr., III).
  1. Report the suffix from the person's current identity record.
  2. If blank, do not report.
CCensus>People>Identities>Suffixidentity.suffix
highestCompleted
LevelOfEducation
Descriptor 
The highest level of education completed for a staff member
  1. Report if the staff member has a Credential record that overlaps the configured year with a Credential Type = ED:  Education and
    Education Level selected is mapped to a valid Ed-Fi code in Resource Preferences
  2. If the staff does not have a valid credential record, report from the Education droplist on the person's District Employment record that overlaps the configured year and the Education is mapped to a valid Ed-Fi Code in Resource Preferences
  3. If there is no Education record or the Ed-Fi code value is NULL, do not report.
O

Census > People > Credentials

OR

Census > People > District Employment


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,

Do not report, this is optional.


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.""
  1. Report from "Is the individual Hispanic/Latino?" from the person's current identity:
    1. If droplist is = Yes, report "true".
    2. If droplist is = No or NULL, report "false".
OCensus>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. 

Do not report, this is optional.

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.,

Do not report, this is optional.

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. 

Do not report, this is optional.

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.Do not report, this is optional.


O

lastSurnameThe name borne in common by members of a family. NEDM Last Name/Surname

Report the last name from the person's current identity record.

MCensus>People>Identities>Last Nameidentity.lastName
loginIdThe login ID for the user; used for security access control interface.

Do not report, this is optional.

O

maidenNameThe person''s maiden name, if applicable.

Do not report, this is optional.

O

middleNameA secondary name given to an individual at birth, baptism, or during another naming ceremony. NEDM Middle Name
  1. Report the middle name from the person's current identity record
  2. If blank, do not report.
CCensus > People > Identities > Middle Nameidentity.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

Do not report, this is optional.

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. 

Do not report, this is optional.

O

personalIdentification
Documents
The documents presented as evident to verify one’s personal identity; for example: drivers license, passport, birth certificate, etc.

Do not report, this is optional.

O

personalTitlePrefixA prefix used to denote the title, degree, position or seniority of the person.

Do not report, this is optional.

C

racesAn 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
  1. See Array section below for logic.
O


recognitionsRecognitions given to the staff for accomplishments in a co-curricular or extracurricular activity.

Do not report, this is optional.

O

sexDescriptorA person's gender.
  1. Report the following based on the value selected in the droplist
    1. Female report 'Female'
    2. Male report 'Male'
    3. If blank or Non-binary, report 'Not Selected'
OCensus > People > Identities >   Identity Information > Genderidentity.Gender
telephonesAn 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.

Do not report, this is optional.

O

tribalAffiliationsAn American Indian tribe with which the staff member is affiliated.

Do not report, this is optional.

O
.tribalName
visasAn 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.

Do not report, this is optional.

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

Do not report, this is optional.

O

yearsOfPrior
Teaching
Experience 
The total number of years that an individual has previously held a teaching position in one or more education institutions.,

Do not report, this is optional.

O

employeeTypeDescriptorIndicates Employee TypeDo not report, this is optional.O

Arrays

Click here to expand...


Race

Data Element LabelBusiness RequirementBusiness RulesM,C or OData Source GUI PathDatabase 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.

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

IdentityRaceEthnicity

and

racethnicity.raceid


Type/Descriptor

Click here to expand...

sexDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
MMaleuri://gadoe.org/SexDescriptorMale
FFemaleuri://gadoe.org/SexDescriptorFemale


highestCompletedLevelOfEducationDescriptor (levelOfEducationDescriptor)

Ed-Fi Code ValueDescriptionNamespaceShort Description
1Vocational-High School GEDuri://gadoe.org/LevelOfEducationDescriptorVocational-High School GED
2Vocational-Associateuri://gadoe.org/LevelOfEducationDescriptorVocational-Associate
4Bacheloruri://gadoe.org/LevelOfEducationDescriptorBachelor
5Mastersuri://gadoe.org/LevelOfEducationDescriptorMasters
6Education Specialisturi://gadoe.org/LevelOfEducationDescriptorEducation Specialist
7Doctorateuri://gadoe.org/LevelOfEducationDescriptorDoctorate

raceDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
WWhiteuri://gadoe.org/RaceDescriptorWhite
PNative Hawaiianuri://gadoe.org/RaceDescriptorNative Hawaiian
SAsianuri://gadoe.org/RaceDescriptorAsian
IIndian Americanuri://gadoe.org/RaceDescriptorIndian American
BBlackuri://gadoe.org/RaceDescriptorBlack

electronicMailTypeDescriptor

Ed-Fi CodeDescriptionNamespaceShort Description
WorkWorkuri://gadoe.org/ElectronicMailTypeDescriptorWork