Skip to main content
Skip table of contents

Entity: StaffSchoolAssociation

The following table lists the Element ID, Element Name, Source field, TX PEIMS field, Valid values, and Additional Information for the Ed-Fi StaffSchoolAssociation entity.

Element ID

Element Name

Source field

TX PEIMS field

Valid values

Data type

Additional Information

Not applicable

Staff 

Staff ID field on the Demographic tab of the Staff Information page.

Database field:

tx_staff_assignment.staff_id

Not applicable

Not applicable

char(9)

StaffSchoolAssociation records are created by DEX for employees with a Staff Classification of 087 and who have at least one TIA designation.

Not applicable

School

School ID field on the TEA Staff Responsibilities page.

Database field:

tx_staff_assignment.school_id

Not applicable

The valid values are stored on the PEIMS School Table page.

char(9)

Not applicable

E3045

ProgramAssignment

The following fields on the Defined Page 32002 - State Required III page:

  • Board Cert

  • TIA Design

  • TIA LEA Pend

Database fields:

  • empuser.ftext4

  • empuser.ftext5

  • empuser.ftext6

where

page_no = '32002'

Not applicable

01 = TIA Teacher

bit

Not applicable

JavaScript errors detected

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

If this problem persists, please contact our support.