PowerSchool ERP Nebraska

NE NSSRS Report - Demographics Comparison Report - File Layout and Data Mapping

The default file names for the Demographics Comparison report are:

  • Excel: nssrsDemoCmprpt<####_#####>.xlsx

  • PDF: nssrsDemoCmp_<#####>.pdf

  • RPT: nssrsDemoCmp.rpt

The following table shows the columns, column names, descriptions, and data sources or valid values for the Demographics Comparison report’s .xlsx file format.

Column

Column Name

Description

Data Source or Valid Values

A

EMPLOYEE NUMBER


The employee’s identification (ID) number.

Retrieved from the Employee Number field on the Staff Demographics tab of the NE NSSRS Report page.

B

NAME


The employee’s name.

Retrieved from the Last Name, First Name, Middle Initial, and Suffix fields on the Staff Demographics tab of the NE NSSRS Report page (combined as "Last, First MI Suffix").

C

NDE ID


The 10-digit staff identification number assigned by the Nebraska Department of Education.

Retrieved from the NDE Staff ID field on the Staff Demographics tab of the NE NSSRS Report page.

D

FIELD NAME


The name of the demographic field whose value differs between the prior and current report dates.

Dynamically generated based on which field differs between the prior and current report dates. The field name corresponds to one of the following fields from the NE NSSRS Report page:

  • Staff Demographics tab: School Number, NDE County District Number, NDE Staff ID, Social Security, Last Name, First Name, Middle Initial, Suffix, Gender, Hispanic Descent, Race (1-5), Email Address

  • Employment tab: Education, Contract, Contract Date, Contract Days, Years Experience in the District, Total Years Experience, Basic Salary, Additional Compensation, Salary Benefits

E

PRIOR VALUE


The value of the field from the prior report date.


Retrieved from the corresponding field (identified by FIELD NAME) on the Staff Demographics tab or the Employment tab of the NE NSSRS Report page for the Prior Report Date.

F

CURRENT VALUE


The value of the field from the current report date.

Retrieved from the corresponding field (identified by FIELD NAME) on the Staff Demographics tab or the Employment tab of the NE NSSRS Report page for the Current Report Date.