Civil Rights Data Collection Report - File Layout and Data Mapping
The Civil Rights Data Collection electronic report’s default file name is crdc_bldmaint_extract.csv.
The following table shows the columns, field names, descriptions, lengths, and whether required or optional for the Civil Rights Data Collection electronic report.
Column | Field Name | Description | Length | Required or Optional for 2024 Reporting |
---|---|---|---|---|
A | SCH_ID | The NCES School ID | 12 | Required |
B | SCH_FTETEACH_TOT | The total number of FTE teachers. | 10 | Required |
C | SCH_FTETEACH_CERT | The number of certified FTE teachers. | 10 | Required |
D | SCH_FTETEACH_NOTCERT | The number of non-certified FTE teachers. | 10 | Required |
E | SCH_FTETEACH_MATHCERT | The number of FTE mathematics teachers. | 10 | Required |
F | SCH_FTETEACH_SCICERT | The number of FTE science teachers. | 10 | Required |
G | SCH_FTETEACH_ESLCERT | The number of FTE English as a Second Language teachers. | 10 | Required |
H | SCH_FTETEACH_SPEDCERT | The number of FTE special education teachers. | 10 | Required |
I | SCH_FTETEACH_FY | The number of FTE teachers in their first year of teaching. | 10 | Required |
J | SCH_FTETEACH_SY | The number of FTE teachers in their second year of teaching. | 10 | Required |
K | SCH_FTETEACH_ABSENT | The number of FTE teachers who were absent more than ten school days during the school year. | 10 | Required |
L | SCH_TEACHERS_CURR_HI_M | The number of male Hispanic teachers. | 7 | Required |
M | SCH_TEACHERS_CURR_HI_F | The number of female Hispanic teachers. | 7 | Required |
N | SCH_TEACHERS_CURR_AM_M | The number of male American Indian/Alaska Native teachers. | 7 | Required |
O | SCH_TEACHERS_CURR_AM_F | The number of female American Indian/Alaska Native teachers. | 7 | Required |
P | SCH_TEACHERS_CURR_AS_M | The number of male Asian teachers. | 7 | Required |
Q | SCH_TEACHERS_CURR_AS_F | The number of female Asian teachers. | 7 | Required |
R | SCH_TEACHERS_CURR_HP_M | The number of male Native Hawaiian/Pacific Islander teachers. | 7 | Required |
S | SCH_TEACHERS_CURR_HP_F | The number of female Native Hawaiian/Pacific Islander teachers. | 7 | Required |
T | SCH_TEACHERS_CURR_BL_M | The number of male Black teachers. | 7 | Required |
U | SCH_TEACHERS_CURR_BL_F | The number of female Black teachers. | 7 | Required |
V | SCH_TEACHERS_CURR_WH_M | The number of male White teachers. | 7 | Required |
W | SCH_TEACHERS_CURR_WH_F | The number of female White teachers. | 7 | Required |
X | SCH_TEACHERS_CURR_TR_M | The number of male teachers belonging to two or more races. | 7 | Required |
Y | SCH_TEACHERS_CURR_TR_F | The number of female teachers belonging to two or more races. | 7 | Required |
Z | SCH_TEACHERS_PREV_TOT | The number of teachers in the previous school year. | 7 | Required |
AA | SCH_FTECOUNSELORS | The number of FTE school counselors. | 10 | Required |
AB | SCH_FTESERVICES_NUR | The number of FTE nurses. | 10 | Required |
AC | SCH_FTESERVICES_PSY | The number of FTE psychologists. | 10 | Required |
AD | SCH_FTESERVICES_SOC | The number of FTE social workers. | 10 | Required |
AE | SCH_FTESECURITY_LEO | The number of FTE law enforcement officers. | 10 | Required |
AF | SCH_FTESECURITY_GUA | The number of FTE security guards. | 10 | Required |