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
This entity is NOT included in the TEA pre-defined SIS Vendor claim set. You must use the SIS Vendor with Staff Profiles claim set to sync the elements from Aeries. See TEA API Profiles Resource Guide.pdf
NOTE: If you sync the Staff entity from Aeries, the Staff MUST exists in your IODS from you HR/Finance system before these elements will sync.
Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
E1524 | StaffUniqueId | Staff | Unique ID STF.SID |
E0006 | BirthDate | N/A - from HR/Finance system | |
E0730 (C015) | HighestCompletedLevelOfEducation | N/A - from HR/Finance system | |
E1064 | HispanicLatinoEthnicity | N/A - from HR/Finance system | |
E3050 (C304) | Race (multiple allowed) | N/A - from HR/Finance system | |
E0004 (C013) | Sex | N/A - from HR/Finance system | |
E0706 (C012) | GenerationCode | N/A - from HR/Finance system | |
E0130 | TotalYearsProfExperience | N/A - from HR/Finance system | |
E1377 | TotalYearsPriorTeachingExperience | N/A - from HR/Finance system | |
E1721 | CreditableYearOfService | Staff (Staff Data tab) | TIA Cred Yr STF.TICY |
E0161 | YearsExperienceInDistrict | N/A - from HR/Finance system | |
E1581 (C207) | PKTeacherRequirement | Staff (Staff Data tab) | Early Childhood Cert STF.ECC |
omitted if blank | |||
E0505 | StaffId | N/A - from HR/Finance system | |
E1722 (C322) | TeacherIncentiveAllotmentDesignation (multiple allowed) | Staff (Staff Data tab) | TIA Designation STF.TIA |
E3069 | StaffDoNotReportTSDS | N/A - from HR/Finance system | |
.StaffTypeSet (multiple allowed) | |||
E1073 (C181) | StaffType | N/A - from HR/Finance system | |
E3010 | BeginDate | ||
E3020 | EndDate | ||
.ParaprofessionalCertificationSet | |||
E1670 | ParaprofessionalCertification | N/A - from HR/Finance system | |
E3010 | BeginDate | ||
E3020 | EndDate | ||
.Name | |||
E0703 | FirstName | N/A - from HR/Finance system | |
E0704 | MiddleName | ||
E0705 | LastSurname |
Entity: StaffEducationOrganizationAssignmentAssociation ↑
This entity is NOT included in the TEA pre-defined claims sets: SIS Vendor or SIS Vendor with Staff Profiles. To sync this entity from Aeries you will need to create a custom claim set. See Texas State Reporting Ed-Fi.
Note: If you sync this entity from both Aeries and your HR/Finance system, the data must be exactly the same for each Staff referencing the same Education Organization and Staff Unique ID as the last sync will overwrite the data.
(multiple allowed)
Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Fiel |
Reference | Staff | See Staff domain > Staff entity (StaffUniqueID element) | |
Reference | EducationOrganization | See Education Organization domain > School entity (SchoolID element) | |
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 | Staff (Job Assignments (STJ) tab) | Service ID STJ.SVC |
E0017 (C050) | GradeLevel | Staff (Job Assignments (STJ) tab) | Grade Level STJ.GR |
E0747 (C030) | PopulationServed | Staff (Job Assignments (STJ) tab) | Population Served STJ.PSV |
E1067 | MonthlyMinutes | Staff (Job Assignments (STJ) tab) | Monthly Minutes STJ.MMN |
E0170 | NumberOfStudentsInClass | Staff (Job Assignments (STJ) tab) | Number of Students STJ.NOS |
E3060 | StaffServiceBeginDate | Staff (Job Assignments (STJ) tab) | Start Date STJ.SD |
E3061 | StaffServiceEndDate | Staff (Job Assignments (STJ) tab) | End Date STJ.ED |
Entity: StaffEducationOrganizationEmploymentAssociation ↑
This entity must sync from HR/Finance Vendor.
Entity: StaffSchoolAssociation ↑
Only staff with a TIA designation are included.
This entity is NOT included in the TEA pre-defined claims sets: SIS Vendor or SIS Vendor with Staff Profiles. To sync this entity from Aeries you will need to create a custom claim set. See Texas State Reporting Ed-Fi.
Note: If you sync this entity from both Aeries and your HR/Finance system, the data must be exactly the same for each Staff referencing the same EducationOrganization and Staff Unique ID as the last sync will overwrite the data.
(multiple allowed)
Element ID (Code Table) | Data Element Name | Aeries Page | Label & Aeries Table.Field |
Reference | Staff | See Staff domain > Staff entity (StaffUniqueID element) | |
Reference | School | See Education Organization domain > School entity (SchoolID element) | |
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. |