Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.