The Staff domain development is on hold, pending a decision by the TEA regarding syncing of data where third-party HR system data is also extracted. 


 

The following entities are included in the Staff domain:


Entity: Staff

Entity: StaffEducationOrganizationAssignmentAssociation

Entity: StaffEducationOrganizationEmploymentAssociation

Entity: StaffSchoolAssociation


Level 1 Errors - Staff


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 NameAeries PageLabel & 
Aeries Table.Field
E1524StaffUniqueId    
E0006BirthDate   
E0730 (C015)HighestCompletedLevelOfEducation

E1064HispanicLatinoEthnicity

E3050 (C304)Race (multiple allowed)

E0004 (C013)Sex

E0706 (C012)GenerationCode

E0130TotalYearsProfExperience

E1377TotalYearsPriorTeachingExperience

E1721CreditableYearOfService

E0161YearsExperienceInDistrict

E1581 (C207)PKTeacherRequirement

E0505StaffId

E1722 (C322)TeacherIncentiveAllotmentDesignation (multiple allowed)

E1673AdditionalDaysProgramTeacher

E3069StaffDoNotReportTSDS

.StaffTypeSet (multiple allowed)
E1073 (C181)StaffType

E3010BeginDate

E3020EndDate

.ParaprofessionalCertificationSet
E1670

ParaprofessionalCertification



E3010BeginDate

E3020EndDate

.Name
E0703FirstName

E0704MiddleName

E0705LastSurname



Entity: StaffEducationOrganizationAssignmentAssociation

(multiple allowed)

Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Fiel
ReferenceStaff  
ReferenceEducationOrganization  
E0721 (C021)StaffClassification

E3010BeginDate

E3020EndDate

E1015 (C169)SharedServiceArrangementStaff



multiple allowed

E3072 (C343)StaffService  
E0017 (C050)

GradeLevel




E0747 (C030)

PopulationServed



E1067MonthlyMinutes

E0170NumberOfStudentsInClassStaffNumber of Students field (STJ.NOS) on the Staff Job Assignments (STJ)
E3060StaffServiceBeginDate

E3061StaffServiceEndDate


Entity: StaffEducationOrganizationEmploymentAssociation

Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceStaff  
ReferenceEducationOrganization  
E0760PercentDayEmployed

E0160NumberDaysEmployed

.AuxiliaryRoleIdSet (multiple allowed)
E1594 (C213)AuxiliaryRoleId

E3010BeginDate

E3020EndDate

.EmploymentPeriod
E3032HireDate

E3020EndDate


Entity: StaffSchoolAssociation

(multiple allowed)

Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceStaff  
Reference

School

  
E3045 (C338)

ProgramAssignment







Level 1 Errors - Staff


See Also: Ed-Fi - Troubleshooting Errors.


TSDS ErrorRecommendation

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.