Skip to main content
Skip table of contents

Staff Associations

This category captures information about school associations and staff assignments. The Staff Associations category includes the following data views and resources:

Staff Employments

This view captures information about a staff member's employment as published in the StaffEducationOrganizationEmploymentAssociation resource within the Staff Association category. The captured details include the school name, staff ID, staff salary, and employment duration information.

staffEducationOrganizationEmploymentAssociation

This association indicates the education organization an employee, contractor, volunteer, or other service provider is formally associated with - typically indicated by which organization the staff member has a services contract with or receives compensation from. This resource is required for all Staff and Teachers.

Primary PowerSchool Source Data

  • [Users]

  • [S_NM_USR_X]

Selection Criteria

Records are published if the following criteria are met:

  • The staff member was published in the staff resource.

  • StaffUniqueId must be populated in PowerSchool.

  • The staff member must not be excluded from state reporting.

  • The staff member was employed during the school year for the term selected in the PowerSchool UI.

Resource Output

  • A separate staffEducationOrganizationEmploymentAssociation is published for each staff member and teacher for each Education Organization at which they are employed.

  • A staff member who is employed at multiple schools will have a record for each school.

  • The Education Organization reported within this resource is either the district (LEAID) or the school (SchoolID).

  • The staffEducationOrganizationEmploymentAssociation resource is dependent on the prior publishing of the Staff resource.

  • LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Data Element

Description

Data Type

Stored in [Table]Field

Req'd

educationOrganizationReference

A reference to the LEA of the staff

educationOrganizationId

The school associated with this student. This is an eight-digit number comprising of:

35+[LEA Number - 3 digit]+[School Number - 3 digit]

String

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number

R

staffReference

A reference to the unique ID of the staff

staffUniqueId

The ID of the staff employed by the education organization.

String

[Users]SSN

R

employmentStatusDescriptor

Indicates the type of employment that the staff has with the education organization.

Employment Status Descriptor Set

String

[S_NM_USR_X]StaffStatus

R

hireDate

The month, day, and year on which a contract between an individual and a governing authority specifies that employment is to begin (or the date on which the agreement is made valid).

Datetime

[S_NM_USR_X]OrigHireDate

R

hourlyWage

Indicates the annual compensation that the staff receives from the education organization.

Number

[USERS.S_NM_USR_X]Salary

O

endDate

The month, day, and year on which a contract between an individual and a governing authority ends or is terminated under the provisions of the contract (or the date on which the agreement is made invalid). If applicable, this element is required.

Note: This is only reported for staff with teaching position codes.

When a staff member exits a district, then this data element is populated with the exit date captured as part of staff details.

Note: To ensure that this data element is populated correctly, the following condition must be met:

  • The staff must be active during the current reporting year based on the Exit Date value and the start of school.

Datetime

[S_NM_USR_X]ExitDate

C

separationReasonDescriptor

Reason for terminating the employment.

Note: This is only reported for staff with teaching position codes.

Separation Reason Descriptor Set

When a staff member exits a district, then this data element is populated with the exit code captured as part of staff details.

Note: To ensure that this data element is populated correctly, the following conditions must be met:

  • The staff must be active during the current reporting year based on the Exit Date value and the start of school.

String

[S_NM_USR_X]ExitCode



teacherOrPrincipalYearsInDistrict

The total number of years that an individual has previously held a Teacher or Principal position in the current district.

Integer

[S_NM_USR_X]YearsOfExp

R

teacherOrPrincipalYearsOverall

The total number of years that an individual has previously held a Teacher or Principal position overall.

Integer

[S_NM_USR_X]YearsOfExp + [S_NM_USR_X]YearsOfExpOutsideDistrict

C

nationalcertified

The data is used to determine if a Staff Member is a National Board Certified Teacher.


[S_NM_USR_X]NationalCertified

N

highestCompletedLevelOfEducationInstitutionDescriptor

Indicates the Insitution or State that conferred Highest Degree.

Level Of Education Institution Descriptor Set

String

[S_NM_USR_X]HighestDegreeInstitution

Y

baccalaureateLevelOfEducationInstitutionDescriptor

Baccalaureate Degree Institution of staff member. Where they earned their Bachelor's degree.

Baccalaureate Level Of Education Institution Descriptor Set

String

[S_NM_USR_X]BaccalaureateDegreeInstitution


Staff Assignments

This view captures details about staff assignments as published in the StaffEducationOrganizationAssignmentAssociation within the Staff Association category. 

staffEducationOrganizationAssignmentAssociations

This association indicates the education organization to which a staff member provides services; also known as school of service. This resource is required for all Staff and Teachers.

Primary PowerSchool Source Data

  • [Users]

  • [S_NM_USR_Assignments_C]

Selection Criteria

Records are published if the following criteria are met:

  • The staff member was published in the staff resource.

  • StaffUniqueId must be populated in PowerSchool.

  • The staff member must not be excluded from state reporting.

  • The staff member's assigned organization must be either the district office or a school that is not excluded from state reporting.

  • The assignment must be during the school year for the term selected in the PowerSchool UI.

Resource Output

  • A separate staffEducationOrganizationAssignmentAssociation record is published for each school assignment for each staff member and teacher who meets the selection criteria.

  • A staff member who works at multiple schools will have a record for each school.

  • The Education Organization reported within this resource is either the district (LEAID) or the school (SchoolID).

  • The staffEducationOrganizationAssignmentAssociation resource is dependent on the prior publishing of the following resources: staff and staffEducationOrganizationEmploymentAssociation.

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

Data Element

Description

Data Type

Stored in [Table]Field

Req'd

educationOrganizationReference

A reference to the LEA of the assignment


educationOrganizationId

The school associated with this session. This is an eight-digit number comprising of:

35+[LEA Number - 3 digit]+[School Number - 3 digit]


Note: If the assignment record has a location, that value will determine the school number that's reported. If the assignment record has no Location value, the staff's school number of the staff's Home School is reported.

Integer

[S_NM_USR_Assignments_C]Location

[Users]HomeSchoolID

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number

Y

staffUniqueId

The unique ID of the staff.

String

[Users]SSN


beginDate

The date the assignment became effective.

Datetime

[S_NM_USR_Assignments]StartDate


endDate

The month, day, and year on which a contract between an individual and a governing authority ends or is terminated under the provisions of the contract (or the date on which the agreement is made invalid). If applicable, this element is required.

Note: This is only reported for staff with teaching position codes.

When a staff member exits a district, then this data element is populated with the assignment end date captured as part of staff details. If the assignment end date is blank, the staff exit date is populated.

Note: To ensure that this data element is populated correctly, the following conditions must be met:

  • The staff must be active during the current reporting year based on the Exit Date value and the start of school.

  • The staff’s assignment record must be active during the current reporting year, based on the assignment Start Date and End Date.

    • Both of the above conditions MUST be true for a staff’s assignment records to be published.

Datetime

[S_NM_USR_X]ExitDate

Y

staffClassificationDescriptor

The titles of employment, official status, or rank of education staff.

Staff Classification Descriptor Set

String

[S_NM_USR_Assignments]PositionCode

Y

fullTimeEquivalency

The percentage of time the staff spends on this position.

String

[S_NM_USR_Assignments_C]FTE

N



Staff Development

This view captures staff dvelopment data and is published in the nmped_staffDevelopments resource within the Staff Association category. The layout includes the School Name, Teacher Number (PowerSchool ID), Staff Name, and PIC.

nmped_staffDevelopments

This association indicates the education organization to which a teacher provides services; also known as the school of service. This resource is required for all Teachers.

Primary PowerSchool Source Data

  • [USERS]

  • [S_NM_USR_DevFact_C]

Selection Criteria

Records are published if the following criteria are met:

  • The teacher was published in the preceding Staff resource.

  • StaffUniqueId must be populated in PowerSchool.

  • The teacher must not be excluded from state reporting.

  • The teacher's school must not be excluded from state reporting.

Resource Output
  • A separate nmped_staffDevelopment record is published for each distinct Activity Code.

  • The nmped_staffDevelopment resource is dependent on the prior publishing of the following resources: Staff.

  • LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand ("Run Now" button).


Data Element

Description

Data Type

Stored in [Table]Field

Req'd

educationOrganizationReference

A reference to the LEA and school of the staff.

educationOrganizationId

The school associated with this session. This is an eight-digit number comprising of:

35+[LEA Number - 3 digit]+[School Number - 3 digit]

Integer

[Users]HomeSchoolID

LEA Number - [Prefs]Value [Prefs]Name where = districtnumber

School Number - [Schools]Alternate_School_Number if the value greater is than zero else the [Schools]School_Number







staffReference

   /staffUniqueId

The unique ID of the staff.

String

[Users]SSN


/startDate

The date the staff development started.

Datetime

Derived from:
[SchoolStaff]SchoolID

R

/activityHours

The hours the activity took.

Note: The published value is a sum of the saved activity hour values across all records for the current reporting year, and the applicable activity code.

Integer

[S_NM_USR_DevFact_C]ActivityHours


     /staffDevelopmentActivityCodeDescriptor

The staff development activity code.

String

[S_NM_USR_DevFact_C]ActivityCode


/MentorUniqueID

A unique ID assigned to a mentorid.

String

[S_NM_USR_DevFact_C]MentorDCID


/staffCreditsEarned

The credits earned by the staff.

Integer

[S_NM_USR_DevFact_C]CreditsEarned


/mentorTraining

Indicates the Mentor has completed a Mentor Training.

String

[S_NM_USR_DevFact_C]MentorTraining


/staffDevelopmentPurposeCodeDescriptor

The staff development purpose code.

String

[S_NM_USR_DevFact_C]PurposeCode



Back to top

JavaScript errors detected

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

If this problem persists, please contact our support.