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: You may sync data from both systems without overwriting the data for this entity as long as the primary key is different in each system. In this case, the Primary Key is Staff (UniqueID), Education Organization, Staff Classification and Begin Date. This option allows District staff to sync from your HR/Finance vendor and School staff from Aeries.
Risk: It is possible data could be entered into both HR and SIS for a unique employee and StaffClassification. The record that is sent last will remain in the IODS. It would be the responsibility of the LEA to ensure there is not invalid duplication causing overwriting.
(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 |
StaffServiceSet
multiple allowed
E3072 (C343) | StaffService | Staff (Job Assignments (STJ) tab) | Service ID STJ.SVC |
E3059 (C342) SPEDStudentAgeRange | Staff (Job Assignments (STJ) tab) | Grade Level STJ.GR | |
Staff (Job Assignments (STJ) tab) | Population Served STJ.PSV | ||
If STJ.PSV is blank or <> 06 = 00 Not Providing Services to SPED Students If STJ.PSV = 06 AND STJ.GR is EE or PK* = 01 Otherwise 02. *Based on grades mapped in the Grade Level Descriptor (STU.GR) | |||
E0747 (C030) | PopulationServed | Staff (Job Assignments (STJ) tab) | Population Served STJ.PSV |
E1067 | MonthlyMinutes | Staff (Job Assignments (STJ) tab) | Monthly Minutes STJ.MMN Do not send if = 0 |
E0170 | NumberOfStudentsInClass | Staff (Job Assignments (STJ) tab) | Number of Students STJ.NOS Defaults to 0 |
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. |