Staff Demographics
This category captures information about staff demographic record and contains identifying information as published in the Staffs 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 (PowerSchool ID), Staff Name, Gender, and PIC (Staff member's Personnel Identification Code).
Each staff member must first have an assigned Unique Person Identifier (Unique ID) in order for the staff record to be published; if needed, use the Request button to initiate the assignment of any missing Unique ID's. In turn, the publishing of all other staff-related Ed-Fi data is dependent on the successful publishing of the staff record; as needed, use the Publishing Errors data view to identify and resolve any issues.
staffs
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]
[USERSCOREFIELDS]
[S_USR_X]
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 state reporting.
The school must note be excluded from state reporting.
Resource Output
A single Staff record is published for each staff member and teacher in the district based on the year for the Term selected in the PowerSchool UI.
Additional Staff elements and complex types are included in the output based on availability of the data within PowerSchool.
Lunch staff are excluded from publishing.
The Staff resource is not dependent on prior publishing of any Ed-Fi resources.
Note: After a Staff record is uploaded, it cannot be modified until a StaffSchoolAssociations record in School Associations 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).
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 | ||||
/staffUniqueId | A unique alpha-numeric code assigned to staff. | String | concatenation of [Prefs]districtnumber and [Users]dcid | R |
identificationCodes | ||||
/staffIdentificationSystemDescriptor | The staff’s educator ID. | String | If [SCHOOLSTAFF]IDis not null then School Staff ID | 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 | If [s_sc_usr_x]tchr_id is not null then Educator ID | R |
/staffIdentificationSystemDescriptor | The staff’s Teacher Number. | String | If [USERS]teachernumber is not null then TeacherNumber | R |
/staffIdentificationSystemDescriptor | The staff’s SC Teacher Certification Number. | String | If [USERS]SIF_StatePrid is not null then SC Teacher Certification Number | R |
/staffIdentificationSystemDescriptor | If the staff has applied for certification. | String | If s_sc_usr_x.appl_for_cert = '1' or '0' then staffIdentificationSystemDescriptor = Applied for Certification | 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. | String | [s_sc_usr_x]tchr_id [USERS]teachernumber [USERS]SIF_StatePrid [S_SC_USR_X]appl_for_cert | R |
personalTitlePrefix | A prefix used to denote the title, degree, position or seniority of the person. | String | [Users]title | |
firstName | A name given to an individual at birth, baptism, during another naming ceremony, or through legal change. | String | [Users]first_Name [S_SC_STU_X]USERS.first_name | |
middleName | A secondary name given to an individual at birth, baptism, or during another naming ceremony. | String | [Users]middle_Name [S_SC_STU_X]USERS.middle_name | |
lastSurname | The name borne in common by members of a family. | String | [Users]last_Name [S_SC_STU_X]USERS.LastName | |
generationCodeSuffix | An appendage, if any, used to denote an individual's generation in his family, for example, Jr., Sr., III. | [s_sc_USR_ X]tchr_generation | ||
sexDescriptor | A person's gender, for example, Male or Female. | Type | [USERSCOREFIELDS]gender pscore_legal_gender first | |
birthDate | The month, day, and year on which an individual was born. | [USERSCOREFIELDS]dob | ||
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 | [Users]fedEthnicity | |
electronicMails | ||||
/electronicMailTypeDescriptor | The type of email listed for an individual or organization, for example, Home/Personal, Work, etc. | Type | If [USERS]email_addr is not null then electronicMailTypeDescriptor='Work' | |
/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 | |
races | ||||
/raceDescriptor | The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies. | Type | [TEACHERRACE]racecd | R |
telephones | ||||
/telephoneNumberTypeDescriptor | The type of communication number listed for an individual or organization. | Type | 'Work' and 'Mobile' | |
/telephoneNumber | The 10-digit telephone number, including the area code, for the person. The entries are trimmed to 24 characters. | String | [Users]School_Phone [S_USR_X]cell_phone | |
credentials | ||||
/credentialReference | ||||
/credentialIdentifier | 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. | [users]sif_stateprid Concat(SC Teacher Certification Number, [users]sif_stateprid) [S_SC_STU_X]CertNo | R | |
/stateOfIssueStateAbbreviationDescriptor | SC | Hardcoded 'SC' | R | |