Skip to main content
Skip table of contents

S_SCH_NCEA_X (ver 16.7.1)

This table is an extension of the [Schools] table. This NCEA table holds school-level information necessary for reporting by Catholic schools and dioceses to the National Catholic Educational Association.

Column Name

Version

Data Type

Description

SchoolsDCID16.7.1Number(10,0)Primary Key
BoardComCoun_TF16.7.1Number(1,0)Indicates whether the school has a board, commission, or council. Obsolete as of the 2022-23 school year. Replaced by new field for BoardType.
BoardType22.7.1

VarChar(2)1

Indicates the school's type of board, commisson or council.
Dual_Lang_Imm_TF21.8.2Number(1,0)Indicates whether the school offers a Dual Language Immersion program.

ERateApplied_TF

16.7.1

Number(1,0)

Indicates whether the school applied for an E-rate discount in the current year. Obsolete as of the 2021-22 school year.

ERateReceived_TF

16.7.1

Number(1,0)

Indicates whether the school received an E-rate discount in the prior year.

ExcludeFromNCEA_TF

16.7.1

Number(1,0)

Indicates whether the school is excluded from NCEA reporting.

ExtDayProgram_TF

16.7.1

Number(1,0)

Indicates whether the school offers an extended day program.

FederalNutritionAll_TF22.7.1Number(1,0)Indicates whether all students in the school receive free/reduced lunch regardless of income qualification.
IB_Prog_TF21.8.2Number(1,0)Indicates whether the school offers an International Baccalaureate program.

InternetAccess_TF

16.7.1

Number(1,0)

Indicates whether students have school access to the internet. Obsolete as of the 2021-22 school year.

Location

16.7.1

Varchar2(1)

The location of the school: urban, inner-city, suburban, rural or virtual.

OffersFedNutrition_TF

16.7.1

Number(1,0)

Indicates whether the school offers federal nutrition programs.

OffersSubsidizedTrans_TF

16.7.1

Number(1,0)

Indicates whether the school offers subsidized transportation services, including state or local services. Obsolete as of the 2021-22 school year.

OffersTitleI_TF16.7.1Number(1,0)Indicates whether the school receives Title I services.
PK12SingleSchool_TF16.7.1Number(1,0)Indicates whether the school serves all grades PK-12, and is considered a single school.
ReceivesTitleII_TF21.8.2Number(1,0)Indicates whether the school receives Title II services.
ReceivesTitleIII_TF21.8.2Number(1,0)Indicates whether the school receives Title III services.
ReceivesTitleIV_TF21.8.2Number(1,0)Indicates whether the school receives Title IV services.
SchoolGender16.7.1Varchar2(1)The primary gender of students served by the school: male, female, or co-ed.
Sponsorship16.7.1Varchar2(1)The type of school sponsorship: single parish, interparish, diocesan, or religious congregation/private.
Staff_Asst_Princ21.8.2Number(10,0)Number of Assistant Principals who serve the school.
Staff_Guid_Cnslr21.8.2Number(10,0)Number of Guidance Counselors who serve the school.
Staff_Lib22.7.1Number(10,0)Number of Librarians who serve the school.
Staff_Other21.8.2Number(10,0)Number of Other Staff who serve the school.
Staff_Pres21.8.2Number(10,0)Number of Presidents/Heads of School.
Staff_Princ21.8.2Number(10,0)Number of Principals who serve the school.
Staff_Teacher21.8.2Number(10,0)Number of Teachers who serve the school.
Staff_Teacher_Asst_Aide21.8.2Number(10,0)Number of Teacher Assistants/Instructional Aids who serve the school.
Teacher_Both_Yrs21.8.2Number(10,0)Number of teachers who taught at the school both last year and this year. 
Teacher_Last_year22.7.1Number(10,0)Number of teachers who did not return for the new school year.
Teacher_Not_Return21.8.2Number(10,0)Number of teachers who taught at the school last year and who did not return in the Fall this year for reasons other than retirement. Obsolete as of the 2022-23 school year. Replaced by new Teacher_Last_year field.
WaitList_TF16.7.1Number(1,0)Indicates whether the school has a waiting list for one or more grade levels.
JavaScript errors detected

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

If this problem persists, please contact our support.