S_NC_RPT_CRDC_LEA_DETAIL_1 (ver 13.6.0)
This table is a stand alone table that stores information about the LEA detail for the Civil Rights Data Collection Part 1.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| CIVILRIGHTSCOORDINATORDSBL | 13.6.0 | NUMBER(1,0) | Indicates the LEA has a Civil Rights Coordinator that coordinates issues on the basis of disability. |
| CIVILRIGHTSCOORDINATORGEND | 13.6.0 | NUMBER(1,0) | Indicates the LEA has a Civil Rights Coordinator that coordinates issues on the basis of gender. |
| CIVILRIGHTSCOORDINATORRACE | 13.6.0 | NUMBER(1,0) | Indicates the LEA has a Civil Rights Coordinator that coordinates issues on the basis of race. |
| CIVILRIGHTSEMAILDSBL | 13.6.0 | VARCHAR2(150) | The email address of the coordinator for issues based on disability. |
| CIVILRIGHTSEMAILGEND | 13.6.0 | VARCHAR2(150) | The email address of the coordinator for issues based on gender.. |
| CIVILRIGHTSEMAILRACE | 13.6.0 | VARCHAR2(150) | The email address of the coordinator for issues based on race. |
| CIVILRIGHTSFNAMEDSBL | 13.6.0 | VARCHAR2(500) | The first name of the coordinator for issues based on disability. |
| CIVILRIGHTSFNAMEGEND | 13.6.0 | VARCHAR2(500) | The first name of the coordinator for issues based on gender. |
| CIVILRIGHTSFNAMERACE | 13.6.0 | VARCHAR2(500) | The first name of the coordinator for issues based on race. |
| CIVILRIGHTSLNAMEDSBL | 13.6.0 | VARCHAR2(500) | The last name of the coordinator for issues based on disability. |
| CIVILRIGHTSLNAMEGEND | 13.6.0 | VARCHAR2(500) | The last name of the coordinator for issues based on gender. |
| CIVILRIGHTSLNAMERACE | 13.6.0 | VARCHAR2(500) | The last name of the coordinator for issues based on race. |
| CIVILRIGHTSNAMEDSBL | 13.6.0 | VARCHAR2(135) | The name of the coordinator for issues based on disability. |
| CIVILRIGHTSNAMEGEND | 13.6.0 | VARCHAR2(135) | The name of the coordinator for issues based on gender. |
| CIVILRIGHTSNAMERACE | 13.6.0 | VARCHAR2(135) | The name of the coordinator for issues based on race. |
| CIVILRIGHTSPHONEDSBL | 13.6.0 | VARCHAR2(150) | The phone number of the coordinator for issues based on disability. |
| CIVILRIGHTSPHONEGEND | 13.6.0 | VARCHAR2(150) | The phone number of the coordinator for issues based on gender. |
| CIVILRIGHTSPHONERACE | 13.6.0 | VARCHAR2(150) | The phone number of the coordinator for issues based on race. |
| DESEGORDERORPLAN | 13.6.0 | NUMBER(1,0) | Indicates whether the LEA is under a desegregation order or plan. |
| DISTANCELEARNING | 18.11.0 | NUMBER(1,0) | Indicates the LEA has distance learning courses. |
| HARASSPOLICY | 13.6.0 | NUMBER(1,0) | Indicates if the LEA has a policy for harassment and bullying. |
| HARASSPOLICYDISABILITY | 13.6.0 | NUMBER(1,0) | Indicates if the LEA has a policy for harassment and bullying based on disabilities. |
| HARASSPOLICYHASLINK | 13.6.0 | NUMBER(1,0) | Indicates if the LEA has the policy for harassment and bullying on a website. |
| HARASSPOLICYLINK | 13.6.0 | VARCHAR2(500) | The URL for the harassment and bullying website. |
| HARASSPOLICYRACEORNATL | 13.6.0 | NUMBER(1,0) | Indicates if the LEA has a policy for harassment and bullying based on race. |
| HARASSPOLICYSEX | 13.6.0 | NUMBER(1,0) | Indicates if the LEA has a policy for harassment and bullying based on gender. |
| HSEQUIVALENCYEXAM | 18.11.0 | NUMBER(1,0) | Indicates the LEA has a program to help students prepare for an high school equivalency exam. |
| LEANAME | 13.6.0 | VARCHAR2(60) | The name of the LEA |
| PART1LEACOMMENTS | 13.6.0 | VARCHAR2(4000) | No longer used. |
| PKSERVEDAGE2 | 13.6.0 | NUMBER(10,0) | Indicates if the number of PK students served that are age 2. |
| PKSERVEDAGE3 | 13.6.0 | NUMBER(10,0) | Indicates if the number of PK students served that are age 3. |
| PKSERVEDAGE4 | 13.6.0 | NUMBER(10,0) | Indicates if the number of PK students served that are age 4. |
| PKSERVEDAGE5 | 13.6.0 | NUMBER(10,0) | Indicates if the number of PK students served that are age 5. |
| PREKG0TO2 | 13.6.0 | NUMBER(1,0) | Indicates if the LEA serves students in Early Childhood programs if the are age 2 or less. |
| PREKG3TO5 | 13.6.0 | NUMBER(1,0) | Indicates if the LEA servers student in preschool programs if the age is between 3 and 5. |
| PREKGAGEIDEAONLY | 13.6.0 | NUMBER(1,0) | Indicates if the Preschool classes are for IDEA students only. |
| PREKGAGENONIDEA0TO2 | 13.6.0 | NUMBER(1,0) | Indicates if the Preschool is provided to non-IDEA students less than 2 |
| PREKGAGENONIDEA3 | 13.6.0 | NUMBER(1,0) | Indicates if the Preschool is provided to non-IDEA students age 3. |
| PREKGAGENONIDEA4 | 13.6.0 | NUMBER(1,0) | Indicates if the Preschool is provided to non-IDEA students age 4. |
| PREKGAGENONIDEA5 | 13.6.0 | NUMBER(1,0) | Indicates if the Preschool is provided to non-IDEA students age 5. |
| PREKGELIGALL | 13.6.0 | NUMBER(1,0) | Indicates if the Preschool is provided to all students. |
| PREKGELIGIDEA | 13.6.0 | NUMBER(1,0) | Indicates if the Preschool is provided to IDEA students. |
| PREKGELIGLOWINCOME | 13.6.0 | NUMBER(1,0) | Indicates if the Preschool is provided to low-income students. |
| PREKGELIGOTHER | 13.6.0 | NUMBER(1,0) | No longer collected. |
| PREKGELIGOTHERCOMMENT | 13.6.0 | VARCHAR2(500) | No longer collected. |
| PREKGELIGTITLEI | 13.6.0 | NUMBER(1,0) | Indicates if the Preschool is provided in Title I schools. |
| PROVIDESKG | 13.6.0 | NUMBER(1,0) | Indicates if the LEA provides Kindergarten. |
| PROVIDESKGFULLDAY | 13.6.0 | NUMBER(1,0) | Indicates if the LEA provides full day kindergarten for free. |
| PROVIDESKGFULLDAYFULLCHG | 13.6.0 | NUMBER(1,0) | No longer collected after 13-14. |
| PROVIDESKGFULLDAYPARTCHG | 13.6.0 | NUMBER(1,0) | Indicates if the LEA provides full day kindergarten for a partial or full fee. |
| PROVIDESKGPARTDAY | 13.6.0 | NUMBER(1,0) | Indicates if the LEA provides partial day kindergarten for free. |
| PROVIDESKGPARTDAYFULLCHG | 13.6.0 | NUMBER(1,0) | No longer collected after 13-14. |
| PROVIDESKGPARTDAYPARTCHG | 13.6.0 | NUMBER(1,0) | Indicates if the LEA provides partial day kindergarten for a partial or full fee. |
| PROVIDESPREKGFULLDAY | 13.6.0 | NUMBER(1,0) | Indicates if the LEA provides full day pre-kindergarten for free. |
| PROVIDESPREKGFULLDAYFULLCHG | 13.6.0 | NUMBER(1,0) | No longer collected after 13-14. |
| PROVIDESPREKGFULLDAYPARTCHG | 13.6.0 | NUMBER(1,0) | Indicates if the LEA provides full day pre-kindergarten for a partial or full fee. |
| PROVIDESPREKGPARTDAY | 13.6.0 | NUMBER(1,0) | Indicates if the LEA provides partial day pre-kindergarten for free. |
| PROVIDESPREKGPARTDAYFULLCHG | 13.6.0 | NUMBER(1,0) | No longer collected after 13-14. |
| PROVIDESPREKGPARTDAYPARTCHG | 13.6.0 | NUMBER(1,0) | Indicates if the LEA provides partial day pre-kindergarten for a partial or full fee. |
| RPT_RUN_ID | 13.6.0 | NUMBER(10,0) | Indicates the unique report run ID for this run. This links to the S_NC_RPT_RUN table to identify the LEA, School, Report Type, Instance ID, and Year ID. |
| TOTPUBLICSCHOOLMEMBERSHIP | 13.6.0 | NUMBER(10,0) | Overall student enrollment for the LEA |
| TOTPUBLICSCHOOLS | 13.6.0 | NUMBER(10,0) | The total number of public schools included. |
| TOTPUBLICSCHOOLMEMBERSHIPNON | 18.11.0 | NUMBER(10,0) | The total number of students served in non-LEA facilities |
| TOTSTUDENTSIDEAINITEVAL | 13.6.0 | NUMBER(10,0) | No longer collected. |
| TOTSTUDENTSSERVED | 13.6.0 | NUMBER(10,0) | No longer collected |