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