Skip to main content
Skip table of contents

Staff Demographics Extract

Contents


Introduction

The Staff Demographics extract is used to track staff members in order submit staff data to the Nebraska Student and Staff Record System (NSSRS). The extract is generated in a comma-delimited format.

Selection Criteria

Selection criteria determine which database records are used in the report.

Staff Selection

The Staff and Staff Snapshot extract include staff records from the [SchoolStaff] table that meet the following criteria:

  • Staff members whose Master Staff Record Indicator is set to Yes. In DDE: [Teachers]NE_MasterRecordInd = 1.
  • Staff members whose status is set to Current. In DDE: [SchoolStaff]Status = 1.
  • Staff members associated with a school that is not excluded from state reporting.

Report Input

For help with navigation and report generation, see How to Find and Generate a Report.

Field

Description

Select Schools

Choose one of the following:

  • Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
  • All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Notes:

Current Selection Staff

Indicate which staff to include in the report by selecting one of the following options:

  • The Selected [number] Staff Only
  • All Staff (default)

Note: If running the report for a single staff member, or a group of staff, select the staff prior to running report.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Element #

Data Element

Description

[Table]FieldName

1

Record Number

The sequential and unique number starting with 1 for the first record.

N/A

2

District Code

NDE Number for the district.

[Prefs]Value

[Prefs]Name=districtnumber

3

NDE Staff ID

The identifier assigned to the staff member by the NDE.

[S_NE_USR_X]Staff_ID

4

Local Staff ID

The locally assigned staff identifier.

[Users]TeacherNumber

5

Last Name

The staff member’s last name.

[Users]Last_Name

6

First Name

The staff member’s first name.

[Users]First_Name

7

Middle Name

The staff member’s middle initial.

[Users]Middle_Name

8

Suffix

Not reported.

The suffix for the staff member’s surname, such as Jr. or III.

N/A

9

Gender Code

The staff member’s gender.

[UsersCoreFields]Gender

10

Hispanic Indicator Code

Indicates whether the student is identified as Hispanic/Latino.Valid values:

  • 1 – Yes
  • 2 – No

[Users]FedEthnicity

11

Race Code 1

The staff member’s first identified race.

This field is required.

The race codes in this report are extracted in order of the internal ID. Currently, there is no method to identify the priority of the race codes.

Valid values:

  • AM – American Indian/Alaska Native
  • AS – Asian
  • BL – Black
  • PI – Native Hawaiian or Other Pacific Islander
  • WH – White

[TeacherRace]RaceCd

12

Race Code 2

The staff member’s second identified race, required if applicable.

This field is optional.

[TeacherRace]RaceCd

13

Race Code 3

The staff member’s third identified race, required if applicable.

This field is optional.

[TeacherRace]RaceCd

14

Race Code 4

The staff member’s fourth identified race, required.

This field is optional.

[TeacherRace]RaceCd

15

Race Code 5

The staff member’s fifth identified race, required if applicable.

This field is optional.

[TeacherRace]RaceCd

16

Education Attained Code

The highest degree earned by the teacher. See the Appendix for more information.

[S_NE_USR_X]Highest_Degree_Code

17

Paraprofessional Assessment Passed Flag

The paraprofessional assessment passed flag. This field applies to instructional paraprofessionals only.

Valid values:

  • 0 – Not applicable
  • 1 – Parapro by ETS
  • 2 – Workkeys by ACT
  • 3 – Para Educator by Master Teacher
  • 4 – Project Para by UNL

[S_NE_USR_X]ParaAssess_Code

18

Contract Indicator Code

Indicates if the staff member’s contract is held by the organization designated in the County District Number.

Valid values:

  • 1 – Yes (default)
  • 2 – No

[S_NE_USR_X]LocalContract

19

Contract Date

The date the staff member was most recently contracted by the district/system for the current school year.

[S_NE_USR_X]Service_Date

20

Contract Days

The number of whole days contracted for each staff member.

[S_NE_USR_X]Contract_Days

21

Basic Salary

The gross pay for the district-wide FTE assignment before deductions in whole dollars.

[S_NE_USR_X]Salary

22

Additional Compensation

The additional compensation in whole dollars provided to the staff member, as described in the NSSRS Staff Guide: http://www.education.ne.gov/nssrs/Resources.html#User_Guides.

[S_NE_USR_X]AltSalary

23

Salary Benefits

The annualized amount for benefits, in whole dollars, as described in the NSSRS Staff Guide. This amount should include benefits and payroll costs paid by the district.

[S_NE_USR_X]Benefits_Value

24

Experience in this District

The total numbers of years of experience attained by this staff member in this district/system, including the current school year. The minimum value is 1. This value must be reported in whole years.

This is not required for paraprofessionals.

[S_NE_USR_X]DistrictYrsExp

25

Total Experience

The total number of years experience attained by this staff member in education, including the current school year. The minimum value is 1. This value must be reported in whole years.

[S_NE_USR_X]TotalYrsExp

26

School Year

The current fiscal school year. This value is extracted as June 30th, in the format YYY-06-30. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms.

[Terms]Last_Day

27

Electronic Mail Address

Staff Members email address.  Required for certain positions

[Users]Email_Addr

28

Primary Subject Area

Position assignment for teaching positions.

[S_NE_USR_StaffAssignment_C] StaffAssignSubjectCode

[S_NE_SSF_X]PrimarySubjectCode

Back to Top

Extraction of Federal Race Codes

Count the number of Race Codes in the [TeacherRace] table for a particular staff member based on TeacherID.

Race Code

1 Race

2 Races

3 Races

4 Races

5 Races

Race Code 1 (#21)

X

X

X

X

X

Race Code 2 (#78)

-

X

X

X

X

Race Code 3 (#79)

-

-

X

X

X

Race Code 4 (#80)

-

-

-

X

X

Race Code 5 (#81)

-

-

-

-

X

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.