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

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 NameAeries PageLabel & 
Aeries Table.Field
E1524StaffUniqueId  Staff Unique ID
STF.SID
E0006BirthDate N/A - from HR/Finance system 
E0730 (C015)HighestCompletedLevelOfEducationN/A - from HR/Finance system
E1064HispanicLatinoEthnicityN/A - from HR/Finance system
E3050 (C304)Race (multiple allowed)N/A - from HR/Finance system
E0004 (C013)SexN/A - from HR/Finance system
E0706 (C012)GenerationCodeN/A - from HR/Finance system
E0130TotalYearsProfExperienceN/A - from HR/Finance system
E1377TotalYearsPriorTeachingExperienceN/A - from HR/Finance system
E1721CreditableYearOfServiceStaff (Staff Data tab)
TIA Cred Yr
STF.TICY
E0161YearsExperienceInDistrictN/A - from HR/Finance system
E1581 (C207)PKTeacherRequirementStaff (Staff Data tab)Early Childhood Cert
STF.ECC
omitted if blank
E0505StaffIdN/A - from HR/Finance system
E1722 (C322)TeacherIncentiveAllotmentDesignation (multiple allowed)Staff (Staff Data tab)TIA Designation
STF.TIA
E3069StaffDoNotReportTSDSN/A - from HR/Finance system
.StaffTypeSet (multiple allowed)
E1073 (C181)StaffTypeN/A - from HR/Finance system


E3010BeginDate
E3020EndDate
.ParaprofessionalCertificationSet
E1670

ParaprofessionalCertification

N/A - from HR/Finance system
E3010BeginDate
E3020EndDate
.Name
E0703FirstNameN/A - from HR/Finance system
E0704MiddleName
E0705LastSurname



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 NameAeries PageLabel & 
Aeries Table.Fiel
ReferenceStaffSee Staff domain > Staff entity (StaffUniqueID element) 
Reference EducationOrganizationSee 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)StaffClassificationStaff (Job Assignments (STJ) tab)
STJ.JC*

Ed-Fi Descriptor Code Set Mapping:  Staff Classification Descriptor (STJ.JC)*
E3010BeginDateStaff (Job Assignments (STJ) tab)
STJ.SD
E3020EndDateStaff (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
*This is a required data element


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
E1067MonthlyMinutesStaff (Job Assignments (STJ) tab)
Monthly Minutes
STJ.MMN

Do not send if = 0
E0170NumberOfStudentsInClassStaff (Job Assignments (STJ) tab)Number of Students
STJ.NOS

Defaults to 0
E3060StaffServiceBeginDateStaff (Job Assignments (STJ) tab)
Start Date
STJ.SD
E3061StaffServiceEndDateStaff (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 NameAeries PageLabel & 
Aeries Table.Field
ReferenceStaff 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 ErrorRecommendation
{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.