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	1 = Works For ESC Not Part Of SSA 2 = ESC Part of SSA And ESC is Fiscal Agent	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	00 = Not Providing Services to SPED Students 01 = Providing Services to SPED Students Ages 3 - 5 (not in KG) 02 = Providing Services to SPED Students Ages 5 (in KG) - 21	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