Generation - StaffAssociation Interchange Data

This section outlines the StaffAssociation Interchange generation rules.

Input & Precursors

This document can be generated independently of other interchange files by providing input parameters (e.g., number of students, ethnicity and gender percentages, etc.), or as part of a generation run including Education Organizations.

Entities & Elements

Interchange-StaffAssociation.xsd contains the following entities:

  • Staff
  • StaffEdOrgEmploymentAssociation
  • StaffEdOrgAssignmentAssociation
  • StaffSchoolAssociation
  • StaffSectionAssociation
  • LeaveEvent
  • OpenStaffPosition (not currently supported)

General Methodology

Staff expertise requirements are built using the data defined in the MasterSchedule.Section CSV input file. In this way we ensure the Staff generation process will create the correct number of staff with the correct qualifications to teach all sections defined in MasterSchedule.

PathElementRulesNotes
StaffRaceRandom, based on XML configuration in StaffProfile.StaffRaceConfiguration

HispanicLatinoEthnicity


SexRandom, based on XML configuration in StaffProfile.StaffSexConfiguration

NameRandom, based on gender and ethnicity; Names draw from FirstNames* and Surnames* CSV files

StaffUniqueIdRandom GUID, formatted without dashes

StaffIdentificationCode

SchoolId assigned when process MasterSchedule.Section references
IdentificationCode same as StaffUniqueId
StaffIdentificationSystem hard coded to School



HighlyQualifiedTeacherTrue for 10% of Staff population, chosen at random

BirthDateMinimum age 25 / 33 for HighlyQualified teach; Max age 65. Birth date is a random date between Min and Max age, starting from the first day of the School Year, as defined in XML TimeConfig.SchoolCalendar.StartDate

YearsOfPriorTeachingExperienceLet DateStartedTeaching be a random date is chosen between (StaffBirthday + 18 years) and Current School Year Start Date. The difference (in years) between the Current School Year Start Date and DateStartedTeaching is used for YearsOfPriorTeachingExperience.

YearsOfPriorProfessionalExperienceLet DateOfFirstProfessionExperience be a random date between (StaffBirthday + 18 years) and DateStartedTeaching. The difference (in years) between the Current School Year Start Date and DateOfFirstProfessionalExperience is used for YearsOfPriorProfessionalExperience.

HighestCompletedLevelOfEducationIf HighlyQualified, 50/50 split between Doctorate and Masters; Otherwise, Bachelors.

LoginIdFormatted as "$(FirstName).$(LastName)$(id)"; Where $(id) is a number starting at 0, and only added if the LoginId already exists for another staff member.

ElectronicMailFormatted as $(LoginId)@$(SchoolName).edu
StaffSectionAssociation

Generated per notes above in the General Methodology section