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
|
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
|
|
|
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
|
|
|
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 |
|