S_SCH_CRDC_X (ver 14.8.0)
This table is an extension of the [Schools] table. This CRDC table is available for all states and may or may not be utilized for your state.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| SchoolsDCID | 14.8.0 | Number(10,0) | Primary Key |
| CorpPunishment_YN | 14.8.0 | Varchar2(1) | Indicates whether the school uses corporal punishment to discipline students. |
CreditRecovery_YN | 14.8.0 | Varchar2(1) | Indicates whether the school has any students who participate in at least one credit recovery program that allows them to earn missed credit in order to graduate from high school. |
DualEnrollment_YN | 14.8.0 | Varchar2(1) | Indicates whether the school has any students enrolled in a dual enrollment/dual credit program. |
FTESecurity_YN | 14.8.0 | Varchar2(1) | Indicates whether the school has any sworn law enforcement officers. |
| JusticeFacilityDays | 14.8.0 | Number(11,0) | If the school is a justice facility, indicates the number of days that make up the regular school year. |
| JusticeFacilityHours | 14.8.0 | Number(11,0) | If the school is a justice facility, indicates the hours per week that the educational program is offered during the regular school year. |
| JusticeFacilityType | 14.8.0 | Varchar2(16) | If the school is a justice facility, indicates the type that best describes the facility. |
PreKGAgeNonIDEA3_YN | 14.8.0 | Varchar2(1) | Indicates whether the school provides preschool to non-IDEA students age 3. |
PreKGAgeNonIDEA4_YN | 14.8.0 | Varchar2(1) | Indicates whether the school provides preschool to non-IDEA students age 4. |
PreKGAgeNonIDEA5_YN | 14.8.0 | Varchar2(1) | Indicates whether the school provides preschool to non-IDEA students age 5. |
UngradedDetail | 14.8.0 | Varchar2(1) | If the school is ungraded, indicates whether the school has mainly elementary, middle, and/or high school students. |
| SCH_ID | 14.9.3 | Varchar2(15) | CRDC School ID assigned to the school. In most cases, it is the last 5-digits of the unique identification number assigned to each school by ED’s National Center for Education Statistics (NCES). |
| PrimarySchoolRecord_TF | 14.9.3 | Number(1,0) | If multiple schools in PowerSchool are reported under the same CRDC SCH ID, indicates one school as the primary. |
| NonLEAFacility_YN | 15.11.0 | Varchar2(1) | Indicates whether the school is a non-LEA facility. |
| FirearmUse_YN | 15.11.0 | Varchar2(1) | Indicates if there has been at least one incident at the school that involved a shooting, regardless of whether anyone was hurt. |
| Homicide_YN | 15.11.0 | Varchar2(1) | Indicates if any of the school's students, faculty, or staff died as a result of a homicide committed at the school. |
| SchInternetFiber_YN | 18.7.0 | Varchar2(1) | Indicates whether school is connected to the Internet through fiber-optic connection. |
| SchInternetWiFi_YN | 18.7.0 | Varchar2(1) | Indicates whether school has WiFi in every classroom. |
| SchInternetSchDev_YN | 18.7.0 | Varchar2(1) | Indicates whether school allows students to take home school-issued devices that can be used to access the Internet for student learning. |
| SchInternetStuDev_YN | 18.7.0 | Varchar2(1) | Indicates whether school allows students to bring to school student-owned devices that can be used to access the Internet for student learning. |
| WiFiEnabledDevices | 18.7.0 | Varchar2(1) | Indicates the number of WiFi enabled devices provided by the school to students for student learning use. |
| NoOfFTETeachers | 21.4.2.0 | Number(25,10) | Indicates the total number of FTE teachers. |
| NoOfFTETeachersCert | 21.4.2.0 | Number(25,10) | Indicates the total number of FTE teachers who are certified. |
| NoOfFTETeachersNotCert | 21.4.2.0 | Number(25,10) | Indicates the total number of FTE teachers who are not certified. |
| NoOfFTECounselors | 21.4.2.0 | Number(25,10) | Indicates the total number of FTE School Counselors. |
| NoOfFTENurses | 21.4.2.0 | Number(25,10) | Indicates the total number of FTE Nurses. |
| NoOfFTEPsychologists | 21.4.2.0 | Number(25,10) | Indicates the total number of FTE Psychologists. |
| NoOfFTESocWorkers | 21.4.2.0 | Number(25,10) | Indicates the total number of FTE Social Workers. |
| NoOfFTELawEnforcement | 21.4.2.0 | Number(25,10) | Indicates the total number of FTE sworn law enforcement officers. |
| NoOfFTESecGuards | 21.4.2.0 | Number(25,10) | Indicates the total number of FTE security guards. |
| IncStaffRape | 21.4.2.0 | Number(11,0) | Indicates the number of documented incidents of rape or attempted rape committed by school staff. |
| IncStaffSexAsslt | 21.4.2.0 | Number(11,0) | Indicates the number of documented incidents of sexual assault (other than rape) committed by school staff. |
| IncStaffResignOrRetdRape | 21.4.2.0 | Number(11,0) | Indicates the number of documented incidents of rape or attempted rape committed by school staff, which were followed by resignation or retirement. |
| IncStaffResgnOrRetdSexAsslt | 21.4.2.0 | Number(11,0) | Indicates the number of documented incidents of sexual assault (other than rape) committed by school staff, which were followed by resignation or retirement. |
| IncStaffDetdRespRape | 21.4.2.0 | Number(11,0) | Indicates the number of documented incidents of rape or attempted rape committed by school staff, which were followed by a determination that the school staff member was responsible for the offense. |
| IncStaffDetdRespSexAsslt | 21.4.2.0 | Number(11,0) | Indicates the number of documented incidents of sexual assault (other than rape) committed by school staff, which were followed by a determination that the school staff member was responsible for the offense. |
| IncStaffDetdNotRespRape | 21.4.2.0 | Number(11,0) | Indicates the number of documented incidents of rape or attempted rape committed by school staff, which were followed by a determination that the school staff member was not responsible for the offense. |
| IncStaffDetdNotRespSexAsslt | 21.4.2.0 | Number(11,0) | Indicates the number of documented incidents of sexual assault (other than rape) committed by school staff, which were followed by a determination that the school staff member was not responsible for the offense. |
| IncStaffDetdPendRape | 21.4.2.0 | Number(11,0) | Indicates the number of documented incidents of rape or attempted rape committed by school staff, which had a determination that remained pending. |
| IncStaffDetdPendSexAsslt | 21.4.2.0 | Number(11,0) | Indicates the number of documented incidents of sexual assault (other than rape) committed by school staff, which had a determination that remained pending. |
| IncStaffDutyReasgmntRape | 21.5.3.0 | Number(11,0) | Indicates the number of allegations against a school staff member, which had a duty reassignment. |
| IncStaffDutyReasgmntSexAslt | 21.5.3.0 | Number(11,0) | Indicates the number of allegations against a school staff member sexual assault (other than rape), which had a duty reassignment. |
| InstructionType | 21.5.3.0 | Varchar2(1) | COVID-related Directional Indicators, Instruction Type. |
| VirtualInstructionType | 21.5.3.0 | Varchar2(1) | COVID-related Directional Indicators, Virtual Instruction Type. |