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, Gender, Unique Person ID, Last Publish Date, and the Publishing ID.
Each staff member must first have an assigned Unique Person Identifier (Unique ID) in order for the staff record to be published; the Ed-Fi publishing process automatically requests a Unique ID when needed. 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.
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]
- [S_TN_USR_X]
- [S_TN_SSF_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 staff member is not designated as Lunch Staff or Substitute.
- The staff member has an assignment in the school year for the term selected in the PowerSchool UI.
Resource Output
- A single Staff record is published for each staff member and teacher in the district who meets the selection criteria.
- The Staff 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 |
staffUniqueId | A unique alphanumeric code assigned to a staff. | Integer | [CST_PubUniqueIdStaff]UniqueId Derived from: [Users]DCID | M |
personalTitlePrefix | A prefix used to denote the title, degree, position or seniority of the person. | String | [Users]Title | |
name | R | |||
/firstName | A name given to an individual at birth, baptism, during another naming ceremony, or through legal change. | Varchar (75) | [Users]First_Name | R |
/middleName | A secondary name given to an individual at birth, baptism, or during another naming ceremony. | Varchar (75) | [Users]Middle_Name | O |
/lastSurname | The name borne in common by members of a family. | Varchar (75) | [Users]Last_Name | R |
/generationCodeSuffix | An appendage, if any, used to denote an individual's generation in his family, for example, Jr., Sr., III. Valid Values: Sr, Jr, I, II, III, IV | Varchar (75) | [S_TN_USR_X]NameSuffix | O |
sex | A person’s gender, for example, Male or Female. | Enumerated List | [Users]Gender Default = ‘Female’ | R |
birthDate | The month, day, and year on which an individual was born. | Date | [Teachers]DOB | R |
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 | R |
oldEthnicity | Previous definition of Ethnicity combining Hispanic/Latino and race. | Enumerated List | [Users]Ethnicity [Gen]Value where cat=’ethnicity’ | O |
licensureCheck | Licensure check descriptor. | Descriptor | [S_TN_USR_X]LicensureCheck | R |
address (0-many) | O | |||
/streetNumberName | The street number and street name or post office box number of an address. | Varchar(150) | [Users]Street | R |
/city | The name of the city in which an address is located. | Varchar(30) | [Users]City | R |
/stateAbbreviation | The abbreviation for the state (within the United States) or outlying area in which an address is located. | Enumerated List | [Users]State | R |
/postalCode | The five- or nine-digit zip code portion of an address. | Varchar(17) | [Users]Zip | R |
/addressType | The type of address listed for an individual or organization, for example, Physical Address, Mailing Address, Home Address, etc. | Enumerated List | 'Physical' | M |
staffCredentials | R | |||
/credentialFieldDescriptor | The field of certification for the certificate, for example, Mathematics, Music, etc. | String | ‘06’ | R |
/credentialType | An indication of the category of credential an individual holds. | String | ‘Other’ | R |
/levelDescriptor | An indication of the grade level(s) certified for teaching. | String | ‘12’ | R |
/teachingCredentialDescriptor | An indication of the category of a legal document giving authorization to perform teaching assignment services. | String | ‘05’ | R |
/credentialIssuanceDate | The month, day, and year on which an active credential was issued to an individual. | Date | ‘2000-01-01’ | R |
/licenseNumber | The staff members license number. | String | [S_TN_USR_X]LicenseNumber | R |
electronicMail (1-many) | 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. | Varchar(128) | [Users]Email_Addr | R |
/electronicMailType | The type of email listed for an individual or organization, for example, Home/Personal, Work, etc. | Enumerated List | ‘Organization’ | M |
/primaryEmailAddressIndicator | An indication that the electronic mail address should be used as the principal electronic mail address for an individual or organization. | Boolean | ‘1’ (True) is output for all records | O |
staffIdentificationCode/ (1-many) | R | |||
/identificationCode | A unique number or alphanumeric code assigned to a staff member by a school, school system, a state, or other agency or resource. | Varchar(60) | State: [Users]Sif_StatePrId District: [Users]DCID Professional Certificate: [S_TN_USR_X]LicenseNumber If blank: [S_TN_SSF_X]PrevLicenseNumber | R |
/staffIdentificationSystem | 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. | Enumerated List | ‘State’ if assigned by State ‘District’ if assigned by District ‘Professional Certificate’ if License Number | M |
/assigningOrganizationIdentificationCode | The organization code or name assigning the Staff Identification Code. | Varchar(60) | SEAId if assigned by State or for Professional Certificate: ‘47’ LEAId if assigned by District | O |
otherName (0-many) Other names associated with a person, for example, alias, nickname, or previous legal name. Note: When “Previous Legal Name” is published, at least one of PrevFirstName or PrevLastName must not be blank; if either (but not both) is blank, the staff member’s current FirstName or LastName will be used for the blank field. | O | |||
/firstName | A name given to an individual at birth, baptism, during another naming ceremony, or through legal change. | Varchar(75) | [S_TN_SSF_X]PrevFirstName | R |
/lastSurname | The name borne in common by members of a family. | Varchar(75) | [S_TN_SSF_X]PrevLastName | R |
/otherNameType | The types of alternate names for a person. | Enumerated List | 'Previous Legal Name' | M |
race (1-many) | The general racial category which most clearly reflects the individual's recognition of his or her community or with which the individual most identifies. | Enumerated List | [TeacherRace]RaceCD [Gen]Name where cat=’federalrace’ | R |
telephone (0-many) | O | |||
/telephoneNumber | The 10-digit telephone number, including the area code, for the person. | Varchar(24) | [Users]School_Phone [Users]Home_Phone | R |
/telephoneNumberType | The type of communication number listed for an individual or organization. | Enumerated List | ‘Work’ or ‘Home’ | M |