Staff Associations

staffEducationOrganizationEmploymentAssociations

eSP Source Data

Tables: n/a - not normally sent from eSchoolPlus, sent from eFinance Plus.

Selection Criteria

Not stored in eSP, sent from eFP
Publish default employment record for staff members included in staffs resource if config parameters set:

PublishHRStaffAndAssoications = 1
PublishDefaultStaffEmployment = 1
See Staff selection criteria

Resource Output

The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Resource	Data Element	Description	TX Element	TX Element Name	eSP Source	Required?	Comments
staffEducationOrganizationEmploymentAssociations
	educationOrganizationId		E0212	DISTRICT-ID	reg_district.state_code_equiv where reg_district.validation_only = 'N'	Y
	staffUniqueId		E1524	TX-UNIQUE-STAFF-ID	reg_user_staff.field_value where screen_number = 9995, field_number = 1	Y	State-assigned number for staff
	employmentStatusDescriptor		LZ		default record: full time (TX or Ed-Fi core equivalent)	Y	(TX or Ed-Fi core equivalent)
	hireDate		E3032		Not sent from eSP, sent from eFP.	Y	changed to TX-required Mar 2022; TEA: may be a date in a prior school year
	endDate		E3020		Not sent from eSP, sent from eFP.	TX	Added Mar 2022 - use end of school year if staff is no longer active?
	TX extensions					TX
		PercentDayEmployed	E0760	PERCENT-DAY-EMPLOYED	Not sent from eSP, sent from eFP.	TX
		NumberDaysEmployed	E0160	NUMBER-DAYS-EMPLOYED	Not sent from eSP, sent from eFP.	TX
		auxiliaryRoleIdSets			[Array]	TX
		auxiliaryRoleIdDescriptor	E1594	AUXILIARY-ROLE-ID	Not sent from eSP, sent from eFP.	TX
		beginDate	E3010		Not sent from eSP, sent from eFP.	TX
		endDate	E3020		Not sent from eSP, sent from eFP.	TX

staffEducationOrganizationAssignmentAssociations

eSP Source Data

Tables: REG_STAFF (rs),
TX_090 (reporting table, requires processing before publishing)

Selection Criteria

Used by TEA for Staff Responsibilities.

One record published for each distinct staff_id, campus_id and role_id in TX_090, where:

role_id is valid StaffService descriptor
- valid descriptors begin with 'SA', 'SE', 'SR', or 'SS'
- Instructional staff not generally included
school_year is selected school year
The Staff download table TX_090 must be processed before publishing to have the most recent values

Resource Output

The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Resource	Data Element	Description	TX Element	TX Element Name	eSP Source	Required?	Comments
staffEducationOrganizationAssignmentAssociations
	staffUniqueId		E1524	TX-UNIQUE-STAFF-ID	reg_user_staff.field_value where screen_number = 9995, field_number = 1	Y	State-assigned number for staff
	staffClassificationDescriptor		E0721	ROLE-ID	Teaching staff: tx_090.role_id Non-teaching staff: reg_user_staff_bld.field_value where screen_number = '100' and field_number = '1' for each building assignment. Publish '087' for is_teacher records from reg_staff_bldgs.	TX - key	alternative for teaching staff: schd_ms_staff_user.field_value where screen_number = '1' and field_number = '2' for each course section being taught.
	educationOrganizationId		E0266	CAMPUS-ID	tx_090.building; reg_user_staff_bld.building; reg_staff_bldgs.building	Y
	beginDate		E3010		Not currently stored in eSP - use start of school year	Y	Mar 2022 - collected by TEA; default: July 1 of school year
	endDate		E3020		Not currently stored in eSP - use day after end of school year	TX	Mar 2022 - collected by TEA TEA: First day of non-applicability
	positionTitle				Use classification short description	N
	TX extensions					TX
		staffServiceSets			[Array]	TX	The followinng fields apply to teaching staff
		serviceIdDescriptor	E0724	SERVICE-ID	Tx_090.service_id	TX	Staff can have multiple sevice descriptors for same school
		gradeLevelDescriptor	E0017	GRADE-LEVEL-CODE	tx_090.grade_level	TX
		populationServedDescriptor	E0747	POPULATION-SERVED-CODE	tx_090.population_served	TX
		monthlyMinutes	E1057	MONTHLY-MINUTES	tx_090.monthly_minutes	TX
		staffServiceBeginDate	E3060		Not currently stored in eSP - use start of school year	TX	Default: July 1 of school year
		staffServiceEndDate	E3061		Not currently stored in eSP - use day after end of school year	TX	Mar 2022 - collected by TEA TEA: First day of non-applicability
	additional fields for display only
							district view only

staffSchoolAssociations

eSP Source Data

Tables: REG_STAFF (rs), REG_STAFF_BLDGS (rsb), REG_BUILDING (rb),
REG_USER_STAFF (rus)

Selection Criteria

Used by TEA for Winter submission, not related to Base profile

One record published for each staff member with rsb record where:

Building is not transfer building and not out-of-district
Teacher Incentive Allottment is not null
- rus.field_value, screen 10101 field 2 where field 1 field_value = current reporting year
Staff not teaching any sections at any school
- TEA count: as of last Friday of February
Publish for all schools associated with staff member (rsb.building)

Resource Output

The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Resource	Data Element	Description	TX Element	TX Element Name	eSP Source	Required?	Comments
staffSchoolAssociations
	schoolId				reg_staff_bldgs.building	Y	format schoolid
	staffUniqueId		E1524	TX-UNIQUE-STAFF-ID	reg_user_staff.field_value where screen_number = 9995, field_number = 1	Y	State-assigned number for staff
	programAssignmentDescriptor		New		Hard-coded, '01' TIA Teacher'	Y	only this one descriptor defined for 2022-23, all others removed
	academicSubjectsDescriptor				reg_staff_bldgs.department	N	mapped value - regtb.department mapped to academicSubjectDescriptors for Courses