Staff Associations
This category captures information about staff employment, assignments, schools, and teacher sections. The Staff Associations category includes the following data views and resources:
Staff Assignments
This view captures details about staff assignments as published in the staffEducationOrganizationAssignmentAssociation within the Staff Association category. The layout includes the School Name, Teacher Number, Staff Name, Assignment, Begin Date, End Date, NDE Staff ID, Last Publish Date, and the Publishing ID.
LEAs and Schools can also review pending and published Ed-Fi reporting data for individual staff members from the staff Ed-Fi Publishing page, accessed from Staff > Information > NE State Report Information > Ed-Fi Publishing.
staffEducationOrganizationAssignmentAssociation
This association indicates the education organization to which a staff member provides services; also known as school of service.
Primary PowerSchool Source Data
- [Users]
- [S_NE_USR_ASSIGN_C]
- [RoleDef]
- [RoleDefTeachersMap]
- [Sections]
- [SectionTeacher]
Selection Criteria
Records are published if the following criteria are met:
- StaffUniqueId must be populated in PowerSchool.
- The staff member must not be excluded from Ed-Fi.
- The staff member must have at least one of the following:
- A Staff Assignment record ([S_NE_USR_ASSIGN_C]) for the current year.
- A user access role that has been mapped to a StaffClassification descriptor
- A section record for the current school year
- The course must not be excluded from Ed-Fi ([S_NE_CRS_X]ExcludeFromEdFi).
- The section must not be excluded from Ed-Fi ([S_NE_SEC_X]ExcludeFromEdFi).The staff member's assigned organization must be either the district office or a school that is not excluded from state reporting.
Resource Output
- A separate staffEducationOrganizationAssignmentAssociation record is published for each school assignment for each staff member having a mapped role or a [S_NE_USR_ASSIGN_C] record, or who taught a section during the year for the Term selected in the PowerSchool UI.
- A staff member who works at multiple schools will have a record for each school.
- A staff member may have multiple assignments at the same school.
- The Education Organization reported within this resource is either the district (LEAId) or the school (SchoolId).
- 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 |
|---|---|---|---|---|
staffReference/staffIdentity | StaffUniqueId - The staff employed by the education organization. | Integer | [Teachers]NE_StaffID Derived from: [SchoolStaff]Users_DCID | M |
educationOrganizationReference/educationOrganizationIdentity | EducationOrganizationId - The Education Organization to which the staff member provides services. | Integer | LEAId or SchoolId downloaded from State Derived from: [S_NE_USR_ASSIGN_C]SchoolID or [RoleDefTeachersMap]SchoolID or [Sections]SchoolId | M |
staffClassification | StaffClassificationDescriptor - The titles of employment, official status, or rank of education staff. | Descriptor | Derived from: [S_NE_USR_ASSIGN_C]Staff_Classification or [RoleDefTeachersMap]RoleID or Records derived from [Sections] are always reported as '02' (Teacher). | M |
positionTitle | The descriptive name of an individual's position. If available, this element is required. | Varchar(100) | [CST_PublCodeSet]ShortDescription Derived from: [S_NE_USR_ASSIGN_C]Position_Title or The short description from the StaffClassification Descriptor is output as the Position Title. | C |
beginDate | Month, day, and year of the start or effective date of a staff member's employment, contract, or relationship with the LEA. | Date | [S_NE_USR_ASSIGN_C]Assign_Date or [Teachers]NE_ServiceDate The earliest date from the above two sources is published. If both are blank, or if the date precedes the start of the school year: [Terms]FirstDay for the school year | M |
endDate | Month, day, and year of the end or termination date of a staff member's employment, contract, or relationship with the LEA. If applicable, this element is required. | Date | [S_NE_USR_ASSIGN_C]Complete_Date If blank, or if the date falls after the end of the school year: [Terms]LastDay for the school year | C |
controllingDistrictCode | This field is used to report staff assigned to serve Districts/Systems/ESUs other than the District/System/ESU that holds the contract. | Varchar(10) | [S_NE_USR_ASSIGN_C]Control_District | R |
fullTimeEquivalency | The ratio between the hours of work expected in a position and the hours of work normally expected in a full-time position in the same setting. | Decimal(5,2) | [S_NE_USR_ASSIGN_C]Assign_Percent | |
countyDistrictNumber | The 6-digit number assigned to the school District/System/ESU by NDE. | Varchar(10) | [Prefs]Name=districtnumber Format: 'XX-XXXX' | R |
Staff Schools
This view captures a list of school assignments for each teacher as published in the staffSchoolAssociation resource within the Staff Association category. The layout includes the School Name, Teacher Number, Staff Name, NDE Staff ID, Last Publish Date, and the Publishing ID.
staffSchoolAssociation
This association indicates the education organization to which a teacher provides services; also known as school of service. This resource is required for all Teachers.
Primary PowerSchool Source Data
- [SchoolStaff]
Selection Criteria
Records are published if the following criteria are met:
- StaffUniqueId must be populated in PowerSchool.
- The staff member must not be excluded from Ed-Fi.
- The teacher's school is not excluded from state reporting.
Resource Output
- A separate staffSchoolAssociation record is published for each teacher and for each school to which the teacher is assigned based on the year for the Term selected in the PowerSchool UI.
- A teacher who works at multiple schools will have a record for each school.
- The Education Organization reported within this resource is the School (SchoolId).
- The staffSchoolAssociation 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.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
staffReference/staffIdentity | StaffUniqueId - The staff member providing services to the school. | Integer | [Teachers]NE_StaffID Derived from: [SchoolStaff]Users_DCID | M |
schoolReference/schoolIdentity | SchoolId - The school where the staff member provides services. | Integer | SchoolId downloaded from State Derived from: [SchoolStaff]SchoolID | M |
schoolYear | SchoolYearType – The identifier for a school year. | Enumerated List | Derived from: YearId for term selected in the PowerSchool UI | O |
programAssignment | ProgramAssignmentDescriptor - The name of the program for which the individual is assigned, for example, Regular education, Title I-Academic, Title I-Non-Academic, Special Education, Bilingual/ English as a Second Language. | Descriptor | [S_NE_SSF_X]PrimarySubjectCode 19: '04' (Special Ed) 25: '05' (Title I-Academic) 31: '01 (Bilingual/English as a Second Language) Else: '03' (Regular Education) | M |
Staff Sections
This view captures the section assignments for each teacher as published in the staffSectionAssociation resource within the Staff Association category. The layout includes the School Name, Teacher Number, Staff Name, Course Number, Course Name, Section Number, NDE Staff ID, Last Publish Date, and the Publishing ID.
staffSectionAssociation
This association indicates the class sections to which a teacher is assigned. This resource is required for all teachers.
Primary PowerSchool Source Data
- [SectionTeacher]
- [Sections]
Selection Criteria
Records are published if the following criteria are met:
- The section was published in the Master Schedule category.
- StaffUniqueId must be populated in PowerSchool.
- The staff member must not be excluded from Ed-Fi.
- The teacher's school is not excluded from state reporting.
- The teacher's section is not excluded from state reporting.
- The course must have a valid state course code.
Resource Output
- A separate staffSectionAssociation record is published for each course section in which the Teacher is scheduled based on the year for the Term selected in the PowerSchool UI.
- A teacher with classes at multiple schools will have a record for each section at each school.
- A section with multiple teachers will have a record for each teacher associated with the section.
- The staffSectionAssociation 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.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
staffReference/staffIdentity | StaffUniqueId - The staff member assigned to the section. | Integer | [Teachers]NE_StaffID Derived from: [SectionTeacher]TeacherId | M |
sectionReference/sectionIdentity The section the staff member is assigned to. | M | |||
/locationReference/locationIdentity The location, typically a classroom, where the section meets. | R | |||
//classroomIdentificationCode | A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. | Varchar(20) | [Sections]Room If blank, default = 'OPEN' | M |
//schoolReference/schoolIdentity | SchoolId - The school for the section's classroom. | Integer | SchoolId downloaded from State Derived from: [Sections]SchoolID | M |
/classPeriodReference/classPeriodIdentity The class period during which the section meets. | M | |||
//classPeriodName | An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules. | Varchar(20) | [Period]Abbreviation If blank: [Period]Period_Number | M |
//schoolReference/schoolIdentity | SchoolId - The school for which the period is defined. | Integer | SchoolId downloaded from State Derived from: [Sections]SchoolID | M |
/courseOfferingReference/courseOfferingIdentity The course offering taught in the section. | M | |||
//localCourseCode | The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students. This must match localCourseCode in corresponding courseOffering. | Varchar(60) | [Sections]Course_Number + '-' + [Sections]DCID | M |
//term | TermType - The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match term in corresponding courseOffering. | Enumerated List | [Sections]TermID [Terms]Portion [Terms]Abbreviation | M |
//schoolYear | SchoolYearType - The identifier for the school year, for example, 2010-2011. This must match schoolYear in corresponding courseOffering. | Enumerated List | [Terms]YearID | M |
//schoolReference/schoolIdentity | SchoolId – The school offering the course. This must match schoolID in corresponding courseOffering. | Integer | SchoolId downloaded from State Derived from: [Sections]SchoolID | M |
classroomPosition | ClassroomPositionDescriptor - The type of position the staff member holds in the specific class/section, for example, Teacher of Record, Assistant Teacher, Support Teacher, Substitute Teacher, etc. | Descriptor | Derived from: [SectionTeacher]RoleId linked to [RoleProperty]Value and [RoleDef]Name Lead Teacher: '01' Co-teacher or Job Share Teacher: '02' Teacher's Aide: '03' If blank, derived from: [SchoolStaff]StaffStatus 4: '04'; else '01' | R |
beginDate | Month, day, and year of a teacher's assignment to the section. If blank, defaults to the first day of the first grading period for the section. | Date | The first in-session day between [SectionTeacher]Start_Date and [SectionTeacher]End_Date | R |
endDate | Month, day, and year of the last day of a teacher's assignment to the section. | Date | Last in-session day between [SectionTeacher]Start_Date and [SectionTeacher]End_Date | R |
percentageContribution | Indicates the percentage of the total scheduled course time, academic standards, and/or learning activities delivered in this section by this staff member. A Teacher of Record designation may be based solely or partially on this contribution percentage. | Decimal(5,4) | [SectionTeacher]Allocation | O |