Entity: StaffEducationOrganizationAssignmentAssociation
The following table lists the Element ID, Element Name, Source field, TX PEIMS field, Valid values, and Additional Information for the Ed-Fi StaffEducationOrganizationAssignmentAssociation entity.
Element ID | Element Name | Source field | TX PEIMS field | Valid values | Data type | Additional Information |
|---|---|---|---|---|---|---|
Not applicable | Staff | Staff ID field on the TEA Staff Responsibilities page. Database field: tx_staff_assignment.staff_id | Staff ID field on the Demographic tab of the Staff Information page. Database field: tx_staff_assignment.staff_id | Not applicable | char(9) | Not applicable |
Not applicable | School | School ID field on the TEA Staff Responsibilities page. Database field: tx_staff_assignment.school_id | School ID field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_assignment.school_id | The valid values are stored on the PEIMS School Table page. | char(9) | Not applicable |
E0721 | StaffClassification | Staff Classification field on the TEA Staff Responsibilities page. Database field: tx_staff_assignment.staff_classification | Staff Classification field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_assignment.staff_classification | The valid values are stored on the PEIMS Staff Classification Table page. | char(300) | Not applicable |
E3010 | BeginDate | Assignment Begin Date field on the TEA Staff Responsibilities page. Database field: tx_staff_assignment.begin_date | Assignment Begin Date field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_assignment.begin_date | Not applicable | smalldatetime | Not applicable |
E3020 | EndDate | Assignment End Date field on the TEA Staff Responsibilities page. Database field: tx_staff_assignment.end_date | Assignment End Date field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_assignment.end_date | Not applicable | smalldatetime | Not applicable |
E1015 | SharedServiceArrangementStaff | Shared Service field on the TEA Staff Responsibilities page. Database field: tx_staff_assignment.shared_service | Shared Service field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_assignment.shared_service |
| SMALLINT | Not applicable |
E3072 | StaffService (StaffServiceSet) | Staff Service field on the TEA Staff Responsibilities page. Database field: tx_staff_service.service_id where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | Staff Service field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_service.service_id where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | The valid values are stored on the PEIMS Staff Service Table page. | char(300) | Not applicable |
E3059 | SPEDStudentAgeRange (StaffServiceSet) | SPED Student Age Range field on the TEA Staff Responsibilities page. Database field: tx_staff_service.sped_age_range where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | SPED Student Age Range field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_service.sped_age_range where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id |
| char(300) | Not applicable |
E0747 | PopulationServed (StaffServiceSet) | Population field on the TEA Staff Responsibilities page. Database field: tx_staff_service.population_served where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | Population field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_service.population_served where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | The valid values are stored on the PEIMS Population Table page. Values contained in PEIMS > Reference Tables > Population | char(300) | Not applicable |
E1057 | MonthlyMinutes (StaffServiceSet) | Monthly Minutes field on the TEA Staff Responsibilities page. Database field: tx_staff_service.monthly_minutes where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | Monthly Minutes field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_service.monthly_minutes where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | Not applicable | int | Not applicable |
E0170 | NumberOfStudentsInClass (StaffServiceSet) | Number of Students field on the TEA Staff Responsibilities page. Database field: tx_staff_service.numb_students where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | Number of Students field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_service.numb_students where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | Not applicable | char(3) | Not applicable |
E3060 | StaffServiceBeginDate (StaffServiceSet) | Service Begin Date field on the TEA Staff Responsibilities page. Database field: tx_staff_service.begin_date where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | Service Begin Date field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_service.begin_date where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | Not applicable | smalldatetime | Not applicable |
E3061 | StaffServiceEndDate (StaffServiceSet) | Service End Date field on the TEA Staff Responsibilities page. Database field: tx_staff_service.end_date where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | Service End Date field on the Staff Responsibilities tab of the Staff Information page. Database field: tx_staff_service.end_date where tx_staff_assignment.tx_staff_assign_id = tx_staff_service.tx_staff_assign_id | Not applicable | smalldatetime | Not applicable |