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 |
|---|---|---|---|
| SchoolsDCID | 16.7.1 | Number(10,0) | Primary Key |
| BoardComCoun_TF | 16.7.1 | Number(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. |
| BoardType | 22.7.1 | VarChar(2)1 | Indicates the school's type of board, commisson or council. |
| Dual_Lang_Imm_TF | 21.8.2 | Number(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_TF | 22.7.1 | Number(1,0) | Indicates whether all students in the school receive free/reduced lunch regardless of income qualification. |
| IB_Prog_TF | 21.8.2 | Number(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_TF | 16.7.1 | Number(1,0) | Indicates whether the school receives Title I services. |
| PK12SingleSchool_TF | 16.7.1 | Number(1,0) | Indicates whether the school serves all grades PK-12, and is considered a single school. |
| ReceivesTitleII_TF | 21.8.2 | Number(1,0) | Indicates whether the school receives Title II services. |
| ReceivesTitleIII_TF | 21.8.2 | Number(1,0) | Indicates whether the school receives Title III services. |
| ReceivesTitleIV_TF | 21.8.2 | Number(1,0) | Indicates whether the school receives Title IV services. |
| SchoolGender | 16.7.1 | Varchar2(1) | The primary gender of students served by the school: male, female, or co-ed. |
| Sponsorship | 16.7.1 | Varchar2(1) | The type of school sponsorship: single parish, interparish, diocesan, or religious congregation/private. |
| Staff_Asst_Princ | 21.8.2 | Number(10,0) | Number of Assistant Principals who serve the school. |
| Staff_Guid_Cnslr | 21.8.2 | Number(10,0) | Number of Guidance Counselors who serve the school. |
| Staff_Lib | 22.7.1 | Number(10,0) | Number of Librarians who serve the school. |
| Staff_Other | 21.8.2 | Number(10,0) | Number of Other Staff who serve the school. |
| Staff_Pres | 21.8.2 | Number(10,0) | Number of Presidents/Heads of School. |
| Staff_Princ | 21.8.2 | Number(10,0) | Number of Principals who serve the school. |
| Staff_Teacher | 21.8.2 | Number(10,0) | Number of Teachers who serve the school. |
| Staff_Teacher_Asst_Aide | 21.8.2 | Number(10,0) | Number of Teacher Assistants/Instructional Aids who serve the school. |
| Teacher_Both_Yrs | 21.8.2 | Number(10,0) | Number of teachers who taught at the school both last year and this year. |
| Teacher_Last_year | 22.7.1 | Number(10,0) | Number of teachers who did not return for the new school year. |
| Teacher_Not_Return | 21.8.2 | Number(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_TF | 16.7.1 | Number(1,0) | Indicates whether the school has a waiting list for one or more grade levels. |