NCEA Faculty Detail Validation Report

Contents

Introduction

This report provides the details for each key staff-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 is output in delimited .txt format, and may be opened in a spreadsheet application. Users may apply sorting to the file along with column filters in order to identify staff members with potentially inaccurate, or missing data. When no data has been entered for a particular field on the Staff Information for NCEA Reporting data entry page in PowerSchool , the NCEA summary reports typically evaluate the element as "No" (value of 0) for Boolean-type fields, or as "Unknown" (value of Unk) for fields with a dropdown list. Users may wish to give particular attention to these conditions when working with the validation report.

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 faculty records from the [Users], [S_USR_NCEA_X], and [S_SSF_NCEA_X] tables based on the following criteria:

The staff member must have the Active checkbox selected.
The staff member must not be excluded from NCEA reporting.
The staff member's school must not be excluded from NCEA reporting.

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

Report Input

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

Field	Description
Schools to Include	Use Ctrl+Click to select multiple schools or Shift+Click to select a range of schools. Note: When at a school, only that school will be available.
Current Selection Staff*	Indicate which staff members to include in the report by selecting one of the following options: The Selected x Staff Only – Run the report for staff in the current selection. All Staff – Run the report for all staff in the current school(s) or district. Note: If running the report for a single staff member, or group of staff, select the staff member prior to running report.
Include Staff Flagged as Excluded from NCEA Reporting?	If this option is selected, those staff members are excluded; otherwise, they are included for verification purposes.
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.

Back to Top

Report Output: NCEA Faculty Detail Validation Report

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.

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. Refer to the Report Logic for School Categories section for additional details.	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

Back to Top