S_NC_CRDC_LEA (ver 13.6.0)
This table is a stand alone table and stores LEA data used in reporting the Civil Rights Data Collection (CRDC).
Column Name | Version | Data Type | Description |
|---|---|---|---|
| CIVIL_RIGHTS_COORDINATOR | 14.7.0 | VARCHAR2(1) | Set to Yes if the LEA has a coordinator based on gender. |
| CIVIL_RIGHTS_COORDINATOR_DSBL | 14.7.0 | VARCHAR2(1) | Set to Yes if the LEA has a coordinator based on disability. |
| CIVIL_RIGHTS_COORDINATOR_RACE | 14.7.0 | VARCHAR2(1) | Set to Yes if the LEA has a coordinator based on race. |
| CIVIL_RIGHTS_EMAIL | 14.7.0 | VARCHAR2(500) | Email of the coordinator based on gender. |
| CIVIL_RIGHTS_EMAIL_DSBL | 14.7.0 | VARCHAR2(500) | Email of the coordinator based on disability. |
| CIVIL_RIGHTS_EMAIL_RACE | 14.7.0 | VARCHAR2(500) | Email of the coordinator based on race. |
| CIVIL_RIGHTS_NAME | 14.7.0 | VARCHAR2(500) | No longer used. |
| CIVIL_RIGHTS_NAME_DSBL | 14.7.0 | VARCHAR2(500) | No longer used. |
| CIVIL_RIGHTS_NAME_RACE | 14.7.0 | VARCHAR2(500) | No longer used. |
| CIVIL_RIGHTS_PHONE | 14.7.0 | VARCHAR2(50) | Phone number of the coordinator based on gender. |
| CIVIL_RIGHTS_PHONE_DSBL | 14.7.0 | VARCHAR2(50) | Phone number of the coordinator based on disability. |
| CIVIL_RIGHTS_PHONE_RACE | 14.7.0 | VARCHAR2(50) | Phone number of the coordinator based on race. |
| COORD_DISABILITY_FIRSTNAME | 16.8.0 | VARCHAR2(500) | First name of the coordinator based on disability. |
| COORD_DISABILITY_LASTNAME | 16.8.0 | VARCHAR2(500) | Last name of the coordinator based on disability. |
| COORD_GENDER_FIRSTNAME | 16.8.0 | VARCHAR2(500) | First name of the coordinator based on gender. |
| COORD_GENDER_LASTNAME | 16.8.0 | VARCHAR2(500) | Last name of the coordinator based on gender. |
| COORD_RACE_FIRSTNAME | 16.8.0 | VARCHAR2(500) | First name of the coordinator based on race. |
| COORD_RACE_LASTNAME | 16.8.0 | VARCHAR2(500) | Last name of the coordinator based on race. |
| DESEG_ORDER_OR_PLAN | 13.6.0 | VARCHAR2(1) | Indicates if the LEA is under a desegregation order or plan. |
| DISTANCE_LEARNING_PROGRAM | 14.7.0 | VARCHAR2(1) | Indicates if the LEA has distance learning programs. |
| GED_PREP_PROGRAM | 13.6.0 | VARCHAR2(1) | Indicates if the LEA has High School Equivalency programs. |
| HARASS_POLICY | 14.7.0 | VARCHAR2(1) | Indicates if the LEA has a harassment policy. |
| HARASS_POLICY_BY_DISABILITY | 13.6.0 | VARCHAR2(1) | No longer used. |
| HARASS_POLICY_BY_GENDER | 13.6.0 | VARCHAR2(1) | No longer used. |
| HARASS_POLICY_BY_RACE | 13.6.0 | VARCHAR2(1) | No longer used. |
| HARASS_POLICY_HAS_LINK | 15.8.0 | VARCHAR2(1) | Indicates if the LEA has a web link to their harassment policy. |
| HARASS_POLICY_LINK | 14.7.0 | VARCHAR2(2000) | The URL to the LEA's harassment policy. |
| ID | 13.6.0 | NUMBER(19,0) | Primary key. |
| KG_ANY | 14.7.0 | VARCHAR2(1) | Indicates if the LEA has kindergarten for any student. |
| KG_FULL_DAY | 13.6.0 | VARCHAR2(1) | Indicates if the LEA offers full day KG for free. |
| KG_FULL_DAY_FULLCHARGE | 14.7.0 | VARCHAR2(1) | Indicates if the LEA offers full day KG for full fee. |
| KG_FULL_DAY_PARTIAL | 14.7.0 | VARCHAR2(1) | Indicates if the LEA offers full day KG for partial fee. |
| KG_PART_DAY | 14.7.0 | VARCHAR2(1) | Indicates if the LEA offers part day KG for free. |
| KG_PART_DAY_FULLCHARGE | 14.7.0 | VARCHAR2(1) | Indicates if the LEA offers part day KG for full fee. |
| KG_PART_DAY_PARTIAL | 14.7.0 | VARCHAR2(1) | Indicates if the LEA offers part day KG for partial fee. |
| LEA_PART1_COMMENTS | 13.6.0 | VARCHAR2(500) | No longer used. |
| LEA_PART2_COMMENTS | 13.6.0 | VARCHAR2(500) | No longer used. |
| PRE_KG_AGE_2ORLESS | 13.6.0 | VARCHAR2(1) | Indicates if preschool services are offered to students less than 2. |
| PRE_KG_AGE_3TO5 | 13.6.0 | VARCHAR2(1) | Indicates if preschool is offered to student age 3 to 5. |
| PRE_KG_ELIG_ALL | 13.6.0 | VARCHAR2(1) | Indicates if preschool is offered to all students. |
| PRE_KG_ELIG_IDEA | 13.6.0 | VARCHAR2(1) | Indicates if preschool is offered to non-IDEA students. |
| PRE_KG_ELIG_LOWINCOME | 13.6.0 | VARCHAR2(1) | Indicates if preschool is offered to students from low income families. |
| PRE_KG_ELIG_OTHER | 13.6.0 | VARCHAR2(1) | No longer used. |
| PRE_KG_ELIG_OTHER_COMMENT | 13.6.0 | VARCHAR2(30) | No longer used. |
| PRE_KG_ELIG_TITLEI | 13.6.0 | VARCHAR2(1) | Indicates if preschool is offered to students in Title I schools. |
| PRE_KG_FULL_DAY | 13.6.0 | VARCHAR2(1) | Indicates if the LEA offers full day PK for free. |
| PRE_KG_FULL_DAY_FULLCHARGE | 14.7.0 | VARCHAR2(1) | Indicates if the LEA offers full day PK for full fee. |
| PRE_KG_FULL_DAY_PARTIAL | 14.7.0 | VARCHAR2(1) | Indicates if the LEA offers full day PK for partial fee. |
| PRE_KG_IDEA_ONLY | 13.6.0 | VARCHAR2(1) | Indicates if the LEA offers part day KG for free. |
| PRE_KG_NON_IDEA_AGE_2ORLESS | 13.6.0 | VARCHAR2(1) | Indicates if the LEA offers preschool to non-IDA students less than 2. |
| PRE_KG_NON_IDEA_AGE_3 | 13.6.0 | VARCHAR2(1) | Indicates if the LEA offers preschool to non-IDA students age 3. |
| PRE_KG_NON_IDEA_AGE_4 | 13.6.0 | VARCHAR2(1) | Indicates if the LEA offers preschool to non-IDA students age 4. |
| PRE_KG_NON_IDEA_AGE_5 | 14.7.0 | VARCHAR2(1) | Indicates if the LEA offers preschool to non-IDA students age 5. |
| PRE_KG_PART_DAY | 13.6.0 | VARCHAR2(1) | Indicates if the LEA offers part day PK for full fee. |
| PRE_KG_PART_DAY_FULLCHARGE | 14.7.0 | VARCHAR2(1) | Indicates if the LEA offers part day PK for partial fee. |
| PRE_KG_PART_DAY_PARTIAL | 14.7.0 | VARCHAR2(1) | Indicates if the LEA offers part day PK for partial fee. |