The following entities are included in the Staff domain:
Entity: StaffEducationOrganizationAssignmentAssociation
Entity: StaffEducationOrganizationEmploymentAssociation
Entity: StaffSchoolAssociation
Most TEA Ed-Fi codes are hard-coded in Aeries and do not need to be mapped.
* An asterisk in the Label & Aeries Table.Field column indicates a code set where local codes can be used. Any local codes used by the district must be mapped to TEA Ed-Fi codes on School Info > Imports and Exports > Ed-Fi Code Mappings.
Entity: Staff
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| E1524 | StaffUniqueId | ||
| E0006 | BirthDate | ||
| E0730 (C015) | HighestCompletedLevelOfEducation | ||
| E1064 | HispanicLatinoEthnicity | ||
| E3050 (C304) | Race (multiple allowed) | Staff (Staff Data tab) | Race - Race5 STF.RC1 * -STF.RC5 |
| Ed-Fi Descriptor Code Set Mapping: Race Descriptor (STU.RC1) * | |||
| E0004 (C013) | Sex | ||
| E0706 (C012) | GenerationCode | Staff (Staff Data tab) | Suffix Staff.SF * |
| Ed-Fi Descriptor Code Set Mapping: TX Generation Code Descriptor (STU.SF) * | |||
| E0130 | TotalYearsProfExperience | ||
| E1377 | TotalYearsPriorTeachingExperience | Staff (Staff Data tab) | Years of Education Service STF.TYS |
| E1721 | CreditableYearOfService | ||
| E0161 | YearsExperienceInDistrict | ||
| E1581 (C207) | PKTeacherRequirement | Staff (Staff Data tab) | Early Childhood Cert STF.ECC |
| omitted if blank | |||
| E0505 | StaffId | ||
| E1722 (C322) | TeacherIncentiveAllotmentDesignation (multiple allowed) | Staff (Staff Data tab) | TIA Designation STF.TIA |
| E1673 | AdditionalDaysProgramTeacher | ||
| E3069 | StaffDoNotReportTSDS | ||
| .StaffTypeSet (multiple allowed) | |||
| E1073 (C181) | StaffType | ||
| E3010 | BeginDate | ||
| E3020 | EndDate | ||
| .ParaprofessionalCertificationSet | |||
| E1670 | ParaprofessionalCertification | ||
| E3010 | BeginDate | ||
| E3020 | EndDate | ||
| .Name | |||
| E0703 | FirstName | ||
| E0704 | MiddleName | ||
| E0705 | LastSurname | ||
Entity: StaffEducationOrganizationAssignmentAssociation ↑
(multiple allowed)
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Fiel |
| Reference | Staff | ||
| Reference | EducationOrganization | See... | |
| Staff (Job Assignments (STJ) tab) | School (if other than NNN) STJ.SCL | ||
| Staff (Staff Data (STF) tab) | Schl STF.PSC | ||
| STJ.SCL if populated; otherwise STF.PSC | |||
| E0721 (C021) | StaffClassification | Staff (Job Assignments (STJ) tab) | STJ.JC* |
| Ed-Fi Descriptor Code Set Mapping: Staff Classification Descriptor (STJ.JC)* | |||
| E3010 | BeginDate | Staff (Job Assignments (STJ) tab) | STJ.SD |
| E3020 | EndDate | Staff (Job Assignments (STJ) tab) | STJ.ED |
| E1015 (C169) | SharedServiceArrangementStaff | Not extracted from Aeries | |
multiple allowed
| E3072 (C343) | StaffService | ||
| E0017 (C050) | GradeLevel | ||
| E0747 (C030) | PopulationServed | ||
| E1067 | MonthlyMinutes | ||
| E0170 | NumberOfStudentsInClass | Staff | Number of Students field (STJ.NOS) on the Staff Job Assignments (STJ) |
| E3060 | StaffServiceBeginDate | ||
| E3061 | StaffServiceEndDate |
Entity: StaffEducationOrganizationEmploymentAssociation ↑
This entity must sync from HR/Finance Vendor.
Entity: StaffSchoolAssociation ↑
(multiple allowed)
| Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
| Reference | Staff | ||
| Reference | School | See... | |
| Staff (Job Assignments (STJ) tab) | School (if other than NNN) STJ.SCL | ||
| Staff (Staff Data (STF) tab) | Schl STF.PSC | ||
| STJ.SCL if populated; otherwise STF.PSC | |||
| E3045 (C338) | ProgramAssignment | Staff (Staff Data tab) | TIA Designations STF.TIA |
| 01 for Teacher Incentive Allotment (TIA) staff Only staff with a TIA designation are included. | |||
Level 1 Errors - Staff ↑
See Also: Ed-Fi - Troubleshooting Errors.
| TSDS Error | Recommendation |
| {message: “Validation of 'StaffEducationOrganizationAssignmentAssociationStaffServiceSets(TX)' requires at least one object in the collection} | Verify Population Served is populated on the Staff Job Assignments page (STJ.PSV). |
400 BAD_REQUEST {message: “Validation of 'Staff' failed. Validation of 'StaffAddresses' failed. StaffAddress[0]: StreetNumberName property is part of the primary key and therefore its value cannot contain leading or trailing whitespace.”} | Verify that Staff address does not have leading or trailing blank space. |
00 BAD_REQUEST {message: “Validation of 'StaffEducationOrganizationEmploymentAssociation' failed. Staff reference could not be resolved.”} | Verify that staff member was loaded to ODS. |
00 BAD_REQUEST {message: “Validation of 'StaffEducationOrganizationEmploymentAssociation' failed. Validation of 'Extensions' failed. StaffEducationOrganizationEmploymentAssociationExtension (TX): The field NumberDaysEmployed must be between 1 and 3. | Verify that Number of Days Employed is greater than 0. |