S_SBD_CRDC_X (ver 14.11.0)
This table is an extension of the [CST_SUBDISTRICTS] 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 |
|---|---|---|---|
| CST_SUBDISTRICTSID | 14.11.0 | Number(10,0) | Primary Key |
| CoordinatorDisability_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA has a Civil Rights Coordinator to coordinate efforts to comply with and carry out the responsibilities under federal law prohibiting discrimination against students and others on the basis of disability (Section 504 and/or Title II). |
CoordinatorDisabilityEmail | 14.11.0 | Varchar2(254) | Email address of the Civil Rights Coordinators Contact for Disability (Section 504 and/or Title II). |
| CoordinatorDisabilityFirstName | 14.11.0 | Varchar2(35) | First name of the Civil Rights Coordinators Contact for Disability (Section 504 and/or Title II). |
| CoordinatorDisabilityLastName | 14.11.0 | Varchar2(35) | Last name of the Civil Rights Coordinators Contact for Disability (Section 504 and/or Title II). |
| CoordinatorDisabilityPhone | 14.11.0 | Varchar2(20) | Phone number of the Civil Rights Coordinators Contact for Disability (Section 504 and/or Title II). |
| CoordinatorGender_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA has a Civil Rights Coordinator to coordinate efforts to comply with and carry out the responsibilities under federal law prohibiting discrimination against students and others on the basis of sex/gender (Title IX). |
| CoordinatorGenderEmail | 14.11.0 | Varchar2(254) | Email address of the Civil Rights Coordinators Contact for sex/gender (Title IX). |
| CoordinatorGenderFirstName | 14.11.0 | Varchar2(35) | First name of the Civil Rights Coordinators Contact for sex/gender (Title IX). |
| CoordinatorGenderLastName | 14.11.0 | Varchar2(35) | Last name of the Civil Rights Coordinators Contact for sex/gender (Title IX). |
| CoordinatorGenderPhone | 14.11.0 | Varchar2(20) | Phone number of the Civil Rights Coordinators Contact for sex/gender (Title IX). |
| CoordinatorRace_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA has a Civil Rights Coordinator to coordinate efforts to comply with and carry out the responsibilities under federal law prohibiting discrimination against students and others on the basis of race/color/national origin (Title VI). |
| CoordinatorRaceEmail | 14.11.0 | Varchar2(254) | Email address of the Civil Rights Coordinators Contact for race/color/national origin (Title VI). |
| CoordinatorRaceFirstName | 14.11.0 | Varchar2(35) | First name of the Civil Rights Coordinators Contact for race/color/national origin (Title VI). |
| CoordinatorRaceLastName | 14.11.0 | Varchar2(35) | Last name of the Civil Rights Coordinators Contact for race/color/national origin (Title VI). |
| CoordinatorRacePhone | 14.11.0 | Varchar2(20) | Phone number of the Civil Rights Coordinators Contact for race/color/national origin (Title VI). |
| DesegOrderOrPlan_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA is covered by a desegregation order or plan. |
| DistanceEdEnrolled_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA has any students enrolled in any distance educational courses. |
| GEDPrepProgram_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA operates a General Educational Development (GED) preparation program for students aged 16-19. |
| HarassmentBullyingPolicy_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA has a written policy or policies prohibiting discriminatory harassment or bullying of students on the basis of sex, race/color/national origin, and disability. |
| HarassmentBullyingPolicyURL_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA has a web link to its written policy or policies prohibiting discriminatory harassment or bullying of students. |
| HarassmentBullyingPolicyURL | 14.11.0 | Varchar2(2000) | The web link to the LEA’s written policy or policies prohibiting discriminatory harassment or bullying of students on the basis of sex, race/color/national origin, and disability. |
| KGFullDayCost | 14.11.0 | Varchar2(10) | The cost, if any, associated with full-day kindergarten. |
| KGPartDayCost | 14.11.0 | Varchar2(10) | The cost, if any, associated with part-day kindergarten. |
| LEA_ID | 14.11.0 | Varchar2(10) | The LEA ID provided to the district's CRDC Principal Contact Person (PCP). In most cases, it is the 7-digit unique identification number assigned to each LEA by ED’s National Center for Education Statistics (NCES). |
| PreKGAge0to2_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides early childhood services to children birth through age 2. |
| PreKGAge3to5_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides preschool services or programs that serve children ages 3 through 5. |
| PreKGAgeNonIDEA0to2_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides early childhood services to non-IDEA children birth through age 2. |
| PreKGAgeNonIDEA3_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides preschool to non-IDEA students age 3. |
| PreKGAgeNonIDEA4_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides preschool to non-IDEA students age 4. |
| PreKGAgeNonIDEA5_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides preschool to non-IDEA students age 5. |
| PreKGEligAll_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA offers its preschool service(s) or program(s) to all children. |
| PreKGEligIDEA_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides preschool to students with disabilities (IDEA). |
| PreKGEligLowIncome_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides preschool to students from low income families. |
| PreKGEligTitleI_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides preschool to students in Title I schools. |
| PreKGFullDayCost | 14.11.0 | Varchar2(10) | The cost, if any, associated with full-day preschool. |
| PreKGPartDayCost | 14.11.0 | Varchar2(10) | The cost, if any, associated with part-day preschool. |
| ProvidesKGAny_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides one or more kindergarten programs that serve any students. |
| ProvidesKGFullDay_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides full-day kindergarten. |
| ProvidesKGPartDay_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides part-day kindergarten. |
| ProvidesPreKGFullDay_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides full-day preschool. |
| ProvidesPreKGPartDay_YN | 14.11.0 | Varchar2(1) | Indicates whether the LEA provides part-day preschool. |