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: Value will publish regardless of the staff status and 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 Note: Value will publish regardless of the staff status and position codes.	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 Note: Value will publish regardless of the staff status and position codes.	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. The updated logic ensures that the staff at the District Office will be published with the correct EducationOrganizationID (the last three digits will be 000).	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 summed across all Staff Development Fact records, with the same Activity Code, that are for the current reporting year. The Activity Hours sum will be rounded up (to the next whole number) if the summed value is 0.5 or greater or the value will be rounded down if the summed value is 0.4 or less. This change will prevent values with decimals from being published and triggering an error. If the Activity Hour fields are blank, a 0 will be published rather than a null value.	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