Staff Demographics

This category captures information about the staff demographic record and contains identifying information as published in the staff resource. The Staff Demographics category includes the following data views and resources.

Staff Demographics

This view captures the core demographic record for teachers and staff. For each staff member in the district in the current year, the layout provides the School Name, Teacher Number, Staff Name, State Identifier, School Personnel Number (SPN), Gender, Last Publish Date, Publishing ID, and Resource ID.

Staff

This resource represents an individual who performs specified activities for any public or private education institution or agency that provides instructional and/or support services to students or staff at the early childhood level through high school completion. This resource is required for all Staff and Teachers.

Primary PowerSchool Source Data

[Users]
[SchoolStaff]
[S_IN_USR_X]
UserCoreFields (ucf)
S_IN_USR_X (ixt)
S_IN_SSF_X (ssxt)
TeacherRace (tr)

Selection Criteria

Records are published if the following criteria are met:

The staffUniqueId must be populated in PowerSchool.
The staff member must not be excluded from state reporting.
The school must not be excluded from state reporting.
The staff member has at least one school enrollment with an entry date that falls on or within the date range defined by the first day and the last day for the year of the Term selected in PowerSchool.

One record is published for each staff member where:

Staff is not lunch staff (has ss record where staffstatus is not 3)
Staff is active (has ss record where status is not 2) or taught section during year
Staff is not excluded from Ed-Fi (uxt.excludefromEdFi not 1)
Staff is not excluded from state reporting (has ss record where ssxt.state_excludefromreporting is not 1)
Dependency on SPN (ixt.teacher_spn not null)

Resource Output

A single staff record is published for each staff member in the district based on the year for the Term selected in the PowerSchool UI
Lunch staff are excluded from publishing
Staff is active (has ss record where status is not 2) or taught section during year
Staff is not excluded from Ed-Fi (uxt.excludefromEdFi is not 1)
Staff is not excluded from state reporting (has ss record where ssxt.state_excludefromreporting is not 1)
The staff resource is not dependent on prior publishing of any Ed-Fi resources
After a staff record is uploaded, it cannot be modified until a staffSchoolAssociations record in the School Associations category has also been uploaded for the same staff member.
- This establishes a relationship between the school, the associated LEA, and the staff member.
- The LEA then has permission to modify the previously uploaded Staff record.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand ("Run Now" button).

The Staff Demographics resource in EDFI_IN_2 profile is updated to publish the following fields:

StaffUniqueId	LastSurname	HispanicLatinoEthnicity	RaceType
PersonalTitlePrefix	GenerationCodeSuffix	YearsOfPriorProfessionalExperience	ElectronicMailType
FirstName	SexType	StaffIdentificationSystemDescriptor	EletronicMailAddress
MiddleName	BirthDate	IdentificationCode	EletronicMailAddress

Click Export to export the data collection results to an Excel spreadsheet.

Data Element	Description	Data Type	Stored in [Table]Field / Logic	Req'd
staffUniqueId	A unique alpha-numeric code assigned to a staff.	String	[Users]DCID	R
personalTitlePrefix	A prefix used to denote the title, degree, position, or seniority of the person.	String	[Users]Title	O
firstName	A name given to an individual at birth, baptism, during another naming ceremony, or through legal change.	String	[Users]First_Name	R
middleName	A secondary name given to an individual at birth, baptism, or during another naming ceremony.	String	[Users]Middle_Name	O
lastSurname	The name borne in common by members of a family.	String	[Users]Last_Name	R
generationCodeSuffix	A person's designation of generation.	String	ucf.pscore_legal_suffix or if blank then uxt.generationCodeSuffix	O
sexType	A person's gender, for example, Male or Female.	Type	[SchoolStaff]Gender M: 'Male' F: 'Female' Otherwise: 'Not Selected'	O
birthDate	A person's date of birth in yyyy-mm-dd format.	Date	ucf.dob	O
hispanicLatinoEthnicity	An indication that the individual traces his or her origin or descent to Mexico, Puerto Rico, Cuba, Central and South America, and other Spanish cultures, regardless of race. The term, "Spanish origin," can be used in addition to "Hispanic or Latino."	Boolean	If [Users]FedEthnicity = 1: '1' Otherwise:'0'	R
yearsOfpriorProfessionalExperience	The number of years of experience of the person. This field is no longer published in Staff Demographics	String	xt.yearsPriorProfExpericene	O
staffElectronicMail An unordered collection of staffElectronicMails. The numbers, letters and symbols used to identify an electronic mail (e-mail) user within the network to which the individual or organization belongs				R
/electronicMailType	The type of email listed for an individual or organization, for example, Home/Personal, Work, etc.	String	'Other'	R
/electronicMailAddress	The numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the individual or organization belongs.	String	[Users]Email_Addr	R
staffIdentificationCode An unordered collection of staffIdentificationCodes. A coding scheme that is used for identification and record-keeping purposes by schools, social services or other agencies to refer to a staff member				R
/staffIdentificationSystemDescriptor	A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a staff member.	String	'State' 'School' 'District'	R
/identificationCode	A unique number or alphanumeric code assigned to a staff member by a school, school system, a state, or other agency or entity. This is the last 4 digits of the SSN	String	[S_IN_USR_X]Teacher_SPN [Users]TeacherNumber [Users]DCID	R
staffRace An unordered collection of staffRaces. The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies. The way this data element is listed, it must allow for multiple entries so that each individual can specify all appropriate races.				R
/raceType	The general racial category which most clearly reflects the individual''s recognition of his or her community or with which the individual most identifies. derived from u.fedethnicity, u.ethnicity, tr.racecd if u.fedethnicity = 1 then hispanic if more than one race selected in tr, then multiracial otherwise get value from u.ethnicity or if blank from tr.racecd	String	[TeacherRace]RaceCd 1:'American Indian - Alaskan Native' 2: 'Black - African American' 3: 'Asian' 5: 'White' 7: 'Native Hawaiian - Pacific Islander' Case when u.fedethnicity = 1 then 'Hispanic Ethnicity and of any race' when (select count(*) from teacherrace tr where tr.teacherid = ss.id) > 1 then 'Multiracial (two or more races)' else case coalesce(u.ethnicity, (select racecd from teacherrace tr where tr.teacherid = ss.id)) when '1' then 'American Indian - Alaskan Native' when '2' then 'Black - African American' when '3' then 'Asian' when '4' then 'Hispanic Ethnicity and of any race' when '5' then 'White' when '6' then 'Multiracial (two or more races)' when '7' then 'Native Hawaiian - Pacific Islander' end end as RaceType	R