Staff Demographics Report
The following table lists the field number, field name, description, data type, size, and location of the data for the Staff Demographics report.
Field Number | Field Name | Description | Data Type | Location |
|---|---|---|---|---|
1 | Record Number | A sequential and unique number starting with 1 for the first record. | Numeric(5) | Record count when records are reported |
2 | County District Number | A six-digit NDE-assigned number to identify the district/system, including leading zeros and hyphen. The format is xx-xxxx. | Char(7) | Nssrs_mnt.contract_org |
3 | NDE Staff ID | The ten-digit NDE Staff ID. | Char(10) | nssrs_mnt.nde_id |
4 | Local Staff ID | A unique number used to designate a staff member at the local level. | VarChar(20) | nssrs_mnt.empl_no |
5 | Last Name | The last name of the staff member. | VarChar(30) | nssrs_mnt.lname |
6 | First Name | The first name of the staff member. | VarChar(30) | nssrs_mnt.fname |
7 | Middle Initial | The middle initial of the staff member. | Char(1) | nssrs_mnt.mid_init |
8 | Name Suffix | The suffix for the staff member's surname, if applicable. | VarChar(10) | nssrs_mnt.name_suffix |
9 | Gender | The gender of the staff member. Valid values:
| Char(1) | nssrs_mnt.sex |
10 | Hispanic Indicator Code | The code indicating if the staff person is identified with an ethnicity of Hispanic/Latino. Valid values:
| Char(1) | nssrs_mnt.hispan |
11 | Race Code 1 | The code indicating the staff member's identified race. Valid values:
| Char(2) | nssrs_mnt.race |
12 | Race Code 2 | The code indicating the staff person's second identified race. | Char(2) | nssrs_mnt.race2 |
13 | Race Code 3 | The code indicating the staff person's third identified race. | Char(2) | nssrs_mnt.race3 |
14 | Race Code 4 | The code indicating the staff person's fourth identified race. | Char(2) | nssrs_mnt.race4 |
15 | Race Code 5 | The code indicating the staff person's fifth identified race. | Char(2) | nssrs_mnt.race5 |
16 | Education Attained Code | The code for the type of degree earned by the staff member. The highest level degree should be used as the value if the staff member has multiple degrees. | Char(2) | nssrs_mnt.education |
17 | Paraprofessional Assessment Passed Flag | This is for instructional paraprofessionals only. Enter codes 1 through 4 ONLY if a passing score was achieved in the assessment. Otherwise, enter 0 (zero). | Char(1) | nssrs_assignment.qual_status |
18 | Contract Indicator Code | The code indicating if the staff member's contract is held by the organization designated in the County District Number. Valid values:
| Char(1) | nssrs_mnt.contract |
19 | Contract Date | The date on which the district/system most recently contracted the staff member for the current school year. The format is YYYY-MM-DD. | Char(10) | payrate.cont_start |
20 | Contract Days | The number of days contracted for each staff member. Valid values are 0-366. | Numeric(3) | nssrs_mnt.cdays |
21 | Basic Salary | The gross pay for the district-wide FTE assignment before deductions in whole dollars. Do not include summer school if it is a separate contract. Valid values are 0-999999. | Numeric(6) | nssrs_mnt.salary |
22 | Additional Compensation | Additional compensation in whole dollars. Do not include summer school if it is a separate contract. Valid values are 0-999999. | Numeric(6) | nssrs_mnt.add_comp |
23 | Salary Benefits | Salary benefit amount. Valid values are 0-999999. | Numeric(6) | nssrs_mnt.benefit |
24 | Experience this District | The number of years of experience in the district. Valid values are 01-99. | Numeric(2) | nssrs_mnt.dist_exp |
25 | Total Experience | The total years of experience. Valid values are 01-99 | Numeric(2) | nssrs_mnt.tot_exp |
26 | School Year | June 30th of the current school year. The format is YYYY-MM-DD. | Char(10) | Snapshot date entered |
27 | Electronic Mail Address | The staff member's email address. Required for some positions only. | VarChar(128) | nssrs_mnt.email_addr This field is populated by retrieving the email address from employee.email_addr and, if blank, from employee.personal_email. |
28 | Primary Subject Area | The staff member's primary subject taught. | Numeric(2) | nssrs_mnt.primary_subj |