Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.