Staff Associations
This category captures information about staff assignments as published within the Staff Associations category. The Staff Associations category includes the following data views and resources for Vermont:
Staff Employments
staffEducationOrganizationEmploymentAssociations(StaffEMP)
Staff Employment Resource is added to the published data for staff as part of the Vermont AOE profile. This view captures details about staff employment as published in the StaffEducationOrganizationEmploymentAssociations(StaffEMP) within the Staff Associations category. The layout includes School Name, Teacher Number, Staff Name, State Identifier, Assignment, Begin Date, End Date, Last Publish Date, Publishing ID, and Resource ID.
Data Element | Description | Data Type | Stored in [Table]Field | Submission |
|---|---|---|---|---|
employmentStatusDescriptor | Descriptor | Descriptor | [S_VT_USR_X]EmpStatNo | Required |
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). | Date | [S_VT_USR_X]EmpBegDate | Required |
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_VT_USR_X]EmpEndDate | Required |
department | The department of the employee | String 60 | [S_VT_USR_X] | Required |
fullTimeEquivalency | Full Time Equivalent (FTE) | Interger (2) | [S_VT_USR_X]FTE | Required |
hourlyWage | Hourly wage of the employee | Double | Not applicable | Required |
offerDate | The offer job date of the employee | Date | Not applicable | Required |
separationDescriptor | Separation descriptor | Descriptor | Not applicable | Required |
separationReasonDescriptor | Separation reason | Descriptor | Not applicable | Required |
staffReference | ||||
staffUniqueId | Staff Unique ID | String 32 | 10_EmpOrg.EMPORGID When s_vt_schoolstaff_x.EMPORGID is null then, s_vt_usr_x.emporgid else s_vt_schoolstaff_x.EMPORGID | Required |
educationOrganizationReference | ||||
educationOrganizationId | The state-assigned identification for the Education Organization in which the staff is employed. If the manually created Staff Assignment record has Staff Classification as Student Support Plans, then School defaults to the District Office and theeducationOrganizationID is the District’s LEA ID. | Integer | [S_VT_USR_X]EDUCATORID 10_EmpOrg.EDUCATORID | Required |
credentialReference | ||||
credentialIdentifier | Credential identifier | String 60 | Not applicable | Optional |
stateOfIssueStateAbbreviationDescriptor | State of issue identifier | Descriptor | Not applicable | Optional |
Staff Assignments
Staff Assignments Resource is added to the published data for staff as part of vermont AOE profile. This view captures details about staff assignments as published in the staffEducationOrganizationAssignmentAssociation within the Staff Associations category. The layout includes School Name, Teacher Number, Staff Name, State Identifier, Assignment, Begin Date, End Date, Last Publish Date, Publishing ID, and Resource ID.
staffEducationOrganizationAssignmentAssociations(StaffASGN)
This association indicates the education organization to which a staff member provides services; also known as the school of service.
Primary PowerSchool Source Data
[SchoolStaff]
[Users]
[S_USR_X]
[S_VT_USR_X]
[S_USR_Assignments_C]
[ROLEDEF]
Selection Criteria
Records are published if the following criteria are met:
The staff member must have at least one Staff Assignment record that was published in Staff Demographics.
The staff member must not be excluded from Ed-Fi.
The staff member’s assigned organization must be either the district office or a school that is not excluded from state reporting.
The Common staff assignments extension table must be valid for the school year and not excluded:
If Common staff assignments extension table record exists at school for schoolstaff record then sources from [ROLEDEF] and [SchoolStaff] are excluded.
A User Access Roles mapping must be available for staff assignment in the ROLEDEF table.
If staff assignments are not defined in Common staff assignments extension and ROLEDEF tables then StaffStatus default roles in the [SchoolStaff] table are used.
Teacher or Substitute Teacher record is selected for the school where staff taught sections during the year:
If the staff are from schools listed in the Common staff assignments extension, ROLEDEF, or [SchoolStaff] then Teacher and Substitute Teacher record is not created.
If ss.staffstatus is 4, Substitute Teacher is selected, otherwise, Teacher is published.
Only one record is selected for each combination of staffUniqueId, schoolId, staffClassification, and beginDate.
If StaffStatus is blank and the staff member did not teach a section at the school then Staff Assignment records are not selected.
The State Staff ID (SPN) must be populated in PowerSchool.
The staff member is active at any point during the selected school year.
The staff member must not be assigned to a section or course that is excluded from Ed-Fi.
Resource Output
A separate staffEducationOrganizationAssignmentAssociation record is published for each school assignment for each staff member and teacher based on 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.
Lunch staff is excluded from publishing.
The educationOrganization 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 resource: staffs.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Describes details of a specific employee assignment within the district or a school.
Data Element | Description | Data Type | Stored in [Table]Field | Submission |
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_USR_Assignments_C]BeginDate, default start of school year If the field is populated and is within school calendar range then the same date is used. Otherwise, date is automatically set to the first day of school, including when the date is not set for an assignment. [Terms]FirstDay of selected school year Format:'YYYY-MM-DD' mapped to AOE field 11_POS POSBEGDATE | Required |
staffClassificationDescriptor | The titles of employment, official status, or rank of education staff. | Descriptor | ROLEID 11_POS | Required |
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 | POSENDDATE | Required |
fullTimeEquivalency | Full Time Equivalent (FTE) | Interger (2) | 11_POS.POSFTE (value between 0.10 and 1.00) | Required |
orderOfAssignment | Indicates the order of assignments | Integer |
| Required |
positionTitle | The descriptive name of an individual's position. *If available, this element is required. | String 100 | [USERS]title used only if equal to a descriptor short description, e.g., 'Principal' |
|
staffReference | ||||
staffUniqueId | The state-assigned number for the staff | String 32 | 0_Staff_Identity EDUCATORID | Required |
educationOrganizationReference | ||||
educationOrganizationId | The state-assigned identification for the Education Organization in which the staff is employed. If the manually created Staff Assignment record has Staff Classification as Student Support Plans, then School defaults to the District Office and theeducationOrganizationID is the District’s LEA ID | Integer | "11_POS, 11a_POS_Role" EMPORGID | Required |
credentialReference | ||||
credentialIdentifier | String 60 | Not applicable | Required | |
stateOfIssueStateAbbreviationDescriptor | Descriptor | Not applicable | Required | |
employmentStaffEducationOrganizationEmploymentAssociationReference | ||||
educationOrganizationId | Integer | EMPORGID | Required | |
employmentStatusDescriptor | Descriptor |
| Required | |
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). | Date | 10_EmpOrg EMPBEGDATE | Required |
staffUniqueId | The state-assigned number for the staff | String 32 | 11_POS 11a_POS_Role EDUCATORID | Required |
Staff Schools
This view captures a list of the school(s) or district to which a teacher provides services as published in the staffSchoolAssociation resource within the Staff Association category. The layout includes the School Name, Teacher Number (PowerSchool ID), Staff Name, State Identifier, Last Publish Date, Publishing ID, and Resource 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:
The teacher must not be excluded from state reporting.
The teacher’s school must not be excluded from state reporting.
The staffUniqueId must be populated in PowerSchool.
The teacher taught at least one class at the school during the year of the Term selected in PowerSchool
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 educationOrganization reported within this resource is the school (SchoolID).
The staffSchoolAssociation resource is dependent on the prior publishing of the following resources: staffs.
LEAs and Schools may upload (publish) data to the Ed-Fi 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 | Submission |
|---|---|---|---|---|
schoolReference A reference to the related schools resource | Required | |||
/schoolID | The school where the staff member provides services. | Integer | Derived from: [SchoolStaff]SchoolId | Required |
schoolYearTypeReference A reference to the related schoolYearType resource. | Required | |||
/schoolYear | The identifier for a school year. | Integer | Derived from: | Required |
staffReference A reference to the related staffs resource | Required | |||
/staffUniqueID | The staff member providing services to the school. | String | [Users]DCID | Required |
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. | String | 'Regular Education' | Required |
calendarReference Calendar reference represents a set of dates associated with an organization, such as a school. This includes instructional days, holidays, and other significant date. | ||||
/calendarCode | A unique identifier for the calendar. | Integer | Derived from: | Required |
/schoolID | The school where the staff member provides services. | Integer | Derived from: [SchoolStaff]SchoolId | Required |
/schoolYear | The identifier for a school year. | Integer | Derived from: | Required |
academicSubjects Classifies the subject matter of courses and educational activities. This descriptor includes a standardized list of subjects, ensuring consistency in how subjects are recorded and reported across different educational systems. | ||||
academicSubjectDescriptor | Descriptor | N/A | N/A | N/A |
gradeLevels Defines the grade level of students | ||||
gradeLevelDescriptor | Descriptor | N/A | N/A | N/A |
staffSection
This view captures the section assignments for each teacher as published in the StaffSectionAssociation resource within the Staff Section category.
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]
[S_VT_USR_X]
[S_VT_Schools_X]
[Sections]I
Selection Criteria
Records are published if the following criteria are met:
The teacher was published in the 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.
The teacher's section must not be excluded from state reporting.
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.
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 dependent on the prior publishing of the following resources: staff, staffSchoolAssociation, and section.
Note: staffSectionAssociation is not published for dual enrollment courses.
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 |
|---|---|---|---|---|
classroomPositionDescriptor Describes staff asociated with a student class | ||||
classroomPositionDescriptor | 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; must match LocalCourseCode in corresponding CourseOffering. | String | [SectionTeacher]RoleID | Y |
beginDate | Month, day, and year of the start or effective date of a staff assignment to a section. | Date | [SectionTeacher]Start_Date | Y |
endDate | Month, day, and year of the last day of a teacher's assignment to the section. | Date | [SectionTeacher]End_Date | Y |
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. | Integer | [SectionTeacher]Allocation Defaults to 1 (100%) | O |
staffReference | ||||
StaffUID | StaffUniqueId - The staff member assigned to the section. | Integer | [S_VT_USR_X]EducatorID | Y |
sectionReference | ||||
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. | String | [Sections]Course_Number | Y |
schoolId | The state-assigned identification for the Education Organization in which the staff is employed. | Integer | [S_VT_Schools_X]PosID | Y |
schoolYear | The selected school year. | Integer | [S_VT_District_S]SY | Y |
sectionIdentifier | A unique identifier for the section that is defined by the classroom, the subjects taught, and the instructors that are assigned. | String | [Sections]ID | Y |
sessionName | A unique identifier for a specific session within a school year. | String | Concatenation of p_profileid, [terms] abbreviation, [terms] dcid, [schools] school_number, p_yearid | Y |