NCEA Faculty Detail Validation Report (2026-2027)

Introduction

This report provides the details for each key student-level data element included in NCEA reporting. The purpose is to allow users at a school or diocese to view and verify the source data that contribute to the summary totals as reported in the NCEA Diocese Summary and School Summary reports.

The report exports as a delimited .txt file that can be opened in a spreadsheet. Use sorting and filters to check for missing or inaccurate data, especially fields reported as "No" or "Unknown".

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Record Selection

The report selects records from the [Students] and [S_STU_NCEA_X] tables based on the following criteria:

The student must not be excluded from NCEA reporting.
The student's school must not be excluded from NCEA reporting.
The student must be enrolled on the Count Day specified by the user at runtime on the report page.
The student's school must have a valid Building Type defined.

Unlike the NCEA Diocese Summary and School Summary reports, users have the option to include students who are flagged as "Exclude from NCEA Reporting" in order to verify the correct students are reported.

Report Input

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

Buildings must have a valid Building Type to appear in the Schools to Include drop-down list. Ensure selected students belong to schools with a valid Building Type; otherwise, their data will not appear in the report.

Field	Description
Schools to Include	Ctrl+Click to select multiple schools. Shift+Click to select a range of schools. Only schools with a defined Building Type are displayed.
Students to Include*	Indicate which students to include in the report by selecting one of the following options: The Selected x Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school(s) or district that meet the selection criteria. If running the report for a single student, or group of students, select the students prior to running the report.
Include Students Flagged as Excluded from NCEA Reporting?	Select to include NCEA-excluded students; otherwise, they are included for verification purposes.
Count Date*	Enter the date requested by NCEA as the official count date for the current school year.
Processing Options	Choose a time to run the report: Run Now (Recommended) – Run the report immediately in the background. Schedule – Run the report in the order it is received in the Report Queue. Start Date – The date the report is scheduled to run. Start Time – The time the report is scheduled to run. Run Once OR Repeat – The report can be scheduled to run one time or run on a Daily, Weekly, Monthly, or Yearly schedule, Weekdays only, and an end date can be entered.

Report Output

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

Column	Column Heading	Description	[Table]FieldName
A	School Name	The name of the staff member' school.	[Schools]Name
B	School Category	The category of the school under which the staff member's data is reported on the NCEA summary reports: Elem/Middle or Secondary. The school categories are based on Building type field.	Derived from: [Schools]High_Grade [Schools]Low_Grade
C	Teacher #	The PowerSchool teacher number.	[Users]TeacherNumber
D	Last Name	The staff member's Last Name.	[Users]Last_Name
E	First Name	The staff member's First Name.	[Users]First_Name
F	MI	The staff member's Middle Initial.	[Users]Middle_Name
G	Gender	The staff member's Gender: M, F, or blank. Note: Staff with no value selected in the dropdown are reported as blank.	[UserCoreFields]Gender
H	Religious Affiliation	The staff member's Religious Affiliation: Valid values: C – Catholic N – Non-Catholic U – Unknown Note: Staff with no value selected in the dropdown are reported as U – Unknown.	[S_USR_NCEA_X]ReligiousAffiliation
I	Ethnicity	An indication of the staff member's Federal Ethnicity, as to whether the staff member is Hispanic or Latino: 0 (no) or 1 (yes). Note: Staff with no value entered in the field are reported as 0.	[Users]FedEthnicity
J	Race	The staff member's Race code(s). Valid values: A – Asian B – Black/African American I – American Indian/Native Alaskan P – Native Hawaiian/Pacific Islander W – White MR – Multi-Racial/Two or More Races Note: Staff with no value entered in the field are reported as UNKNOWN.	[TeacherRace]RaceCD [S_GEN_NCEA_X]RaceCodeMap
K	Staff Type	The staff member's religious category type. Valid values: C – Clergy L – Lay R - Religious Note: Staff with no value entered in the field are reported as blank.	[S_USR_NCEA_X]ReligiousClergyLay
L	FTE	The staff member's employment status. Valid values: FT – Full-time PT – Part-time Note: Staff with no value entered in the field are reported as blank.	[S_SSF_NCEA_X]FTE
M	Exclude from NCEA	An indication of whether the staff member is excluded from NCEA reporting: 0 (no) or 1 (yes).	[S_SSF_NCEA_X]ExcludeFromNCEA_TF