Center for Educational Performance and Information March 2004
Column Name Description
Downloadable Data File Layout Page 5 of 5
Center for Educational Performance and Information March 2004
Column Name Description
Please use the following file layout to read the downloadable data file for pupil headcount.
Column Name Description
scode School Code
sname School Name
dcode District Code
dname District Name
k_m_ai KINDERGARTEN AMERICAN INDIAN MALE
k_f_ai KINDERGARTEN AMERICAN INDIAN FEMALE
k_m_as KINDERGARTEN ASIAN MALE
k_f_as KINDERGARTEN ASIAN FEMALE
k_m_aa KINDERGARTEN AFRICAN AMERICAN MALE
k_f_aa KINDERGARTEN AFRICAN AMERICAN FEMALE
k_m_hs KINDERGARTEN HISPANIC MALE
k_f_hs KINDERGARTEN HISPANIC FEMALE
k_m_wh KINDERGARTEN WHITE MALE
k_f_wh KINDERGARTEN WHITE FEMALE
k_m_hw KINDERGARTEN NATIVE HAWAIIAN MALE
k_f_hw KINDERGARTEN NATIVE HAWAIIAN FEMALE
k_m_mr KINDERGARTEN MULTIRACIAL MALE
k_f_mr KINDERGARTEN MULTIRACIAL FEMALE
k_m_tot ** KINDERGARTEN TOTAL MALE
k_f_tot ** KINDERGARTEN TOTAL FEMALE
k_totl ** KINDERGARTEN TOTAL ENROLLMENT **
g1_m_ai G1 AMERICAN INDIAN MALE
g1_f_ai G1 AMERICAN INDIAN FEMALE
g1_m_as G1 ASIAN MALE
g1_f_as G1 ASIAN FEMALE
g1_m_aa G1 AFRICAN AMERICAN MALE
g1_f_aa G1 AFRICAN AMERICAN FEMALE
g1_m_hs G1 HISPANIC MALE
g1_f_hs G1 HISPANIC FEMALE
g1_m_wh G1 WHITE MALE
g1_f_wh G1 WHITE FEMALE
g1_m_hw G1 NATIVE HAWAIIAN MALE
g1_f_hw G1 NATIVE HAWAIIAN FEMALE
g1_m_mr G1 MULTIRACIAL MALE
g1_f_mr G1 MULTIRACIAL FEMALE
g1_m_tot ** G1 TOTAL MALE
g1_f_tot ** G1 TOTAL FEMALE
g1_totl ** G1 TOTAL ENROLLMENT **
g2_m_ai G2 AMERICAN INDIAN MALE
g2_f_ai G2 AMERICAN INDIAN FEMALE
g2_m_as G2 ASIAN MALE
g2_f_as G2 ASIAN FEMALE
g2_m_aa G2 AFRICAN AMERICAN MALE
g2_f_aa G2 AFRICAN AMERICAN FEMALE
g2_m_hs G2 HISPANIC MALE
g2_f_hs G2 HISPANIC FEMALE
g2_m_wh G2 WHITE MALE
g2_f_wh G2 WHITE FEMALE
g2_m_hw G2 NATIVE HAWAIIAN MALE
g2_f_hw G2 NATIVE HAWAIIAN FEMALE
g2_m_mr G2 MULTIRACIAL MALE
g2_f_mr G2 MULTIRACIAL FEMALE
g2_m_tot ** G2 TOTAL MALE
g2_f_tot ** G2 TOTAL FEMALE
g2_totl ** G2 TOTAL ENROLLMENT **
g3_m_ai G3 AMERICAN INDIAN MALE
g3_f_ai G3 AMERICAN INDIAN FEMALE
g3_m_as G3 ASIAN MALE
g3_f_as G3 ASIAN FEMALE
g3_m_aa G3 AFRICAN AMERICAN MALE
g3_f_aa G3 AFRICAN AMERICAN FEMALE
g3_m_hs G3 HISPANIC MALE
g3_f_hs G3 HISPANIC FEMALE
g3_m_wh G3 WHITE MALE
g3_f_wh G3 WHITE FEMALE
g3_m_hw G3 NATIVE HAWAIIAN MALE
g3_f_hw G3 NATIVE HAWAIIAN FEMALE
g3_m_mr G3 MULTIRACIAL MALE
g3_f_mr G3 MULTIRACIAL FEMALE
g3_m_tot ** G3 TOTAL MALE
g3_f_tot ** G3 TOTAL FEMALE
g3_totl ** G3 TOTAL ENROLLMENT **
g4_m_ai G4 AMERICAN INDIAN MALE
g4_f_ai G4 AMERICAN INDIAN FEMALE
g4_m_as G4 ASIAN MALE
g4_f_as G4 ASIAN FEMALE
g4_m_aa G4 AFRICAN AMERICAN MALE
g4_f_aa G4 AFRICAN AMERICAN FEMALE
g4_m_hs G4 HISPANIC MALE
g4_f_hs G4 HISPANIC FEMALE
g4_m_wh G4 WHITE MALE
g4_f_wh G4 WHITE FEMALE
g4_m_hw G4 NATIVE HAWAIIAN MALE
g4_f_hw G4 NATIVE HAWAIIAN FEMALE
g4_m_mr G4 MULTIRACIAL MALE
g4_f_mr G4 MULTIRACIAL FEMALE
g4_m_tot ** G4 TOTAL MALE
g4_f_tot ** G4 TOTAL FEMALE
g4_totl ** G4 TOTAL ENROLLMENT **
g5_m_ai G5 AMERICAN INDIAN MALE
g5_f_ai G5 AMERICAN INDIAN FEMALE
g5_m_as G5 ASIAN MALE
g5_f_as G5 ASIAN FEMALE
g5_m_aa G5 AFRICAN AMERICAN MALE
g5_f_aa G5 AFRICAN AMERICAN FEMALE
g5_m_hs G5 HISPANIC MALE
g5_f_hs G5 HISPANIC FEMALE
g5_m_wh G5 WHITE MALE
g5_f_wh G5 WHITE FEMALE
g5_m_hw G5 NATIVE HAWAIIAN MALE
g5_f_hw G5 NATIVE HAWAIIAN FEMALE
g5_m_mr G5 MULTIRACIAL MALE
g5_f_mr G5 MULTIRACIAL FEMALE
g5_m_tot ** G5 TOTAL MALE
g5_f_tot ** G5 TOTAL FEMALE
g5_totl ** G5 TOTAL ENROLLMENT **
g6_m_ai G6 AMERICAN INDIAN MALE
g6_f_ai G6 AMERICAN INDIAN FEMALE
g6_m_as G6 ASIAN MALE
g6_f_as G6 ASIAN FEMALE
g6_m_aa G6 AFRICAN AMERICAN MALE
g6_f_aa G6 AFRICAN AMERICAN FEMALE
g6_m_hs G6 HISPANIC MALE
g6_f_hs G6 HISPANIC FEMALE
g6_m_wh G6 WHITE MALE
g6_f_wh G6 WHITE FEMALE
g6_m_hw G6 NATIVE HAWAIIAN MALE
g6_f_hw G6 NATIVE HAWAIIAN FEMALE
g6_m_mr G6 MULTIRACIAL MALE
g6_f_mr G6 MULTIRACIAL FEMALE
g6_m_tot ** G6 TOTAL MALE
g6_f_tot ** G6 TOTAL FEMALE
g6_totl ** G6 TOTAL ENROLLMENT **
g7_m_ai G7 AMERICAN INDIAN MALE
g7_f_ai G7 AMERICAN INDIAN FEMALE
g7_m_as G7 ASIAN MALE
g7_f_as G7 ASIAN FEMALE
g7_m_aa G7 AFRICAN AMERICAN MALE
g7_f_aa G7 AFRICAN AMERICAN FEMALE
g7_m_hs G7 HISPANIC MALE
g7_f_hs G7 HISPANIC FEMALE
g7_m_wh G7 WHITE MALE
g7_f_wh G7 WHITE FEMALE
g7_m_hw G7 NATIVE HAWAIIAN MALE
g7_f_hw G7 NATIVE HAWAIIAN FEMALE
g7_m_mr G7 MULTIRACIAL MALE
g7_f_mr G7 MULTIRACIAL FEMALE
g7_m_tot ** G7 TOTAL MALE
g7_f_tot ** G7 TOTAL FEMALE
g7_totl ** G7 TOTAL ENROLLMENT **
g8_m_ai G8 AMERICAN INDIAN MALE
g8_f_ai G8 AMERICAN INDIAN FEMALE
g8_m_as G8 ASIAN MALE
g8_f_as G8 ASIAN FEMALE
g8_m_aa G8 AFRICAN AMERICAN MALE
g8_f_aa G8 AFRICAN AMERICAN FEMALE
g8_m_hs G8 HISPANIC MALE
g8_f_hs G8 HISPANIC FEMALE
g8_m_wh G8 WHITE MALE
g8_f_wh G8 WHITE FEMALE
g8_m_hw G8 NATIVE HAWAIIAN MALE
g8_f_hw G8 NATIVE HAWAIIAN FEMALE
g8_m_mr G8 MULTIRACIAL MALE
g8_f_mr G8 MULTIRACIAL FEMALE
g8_m_tot ** G8 TOTAL MALE
g8_f_tot ** G8 TOTAL FEMALE
g8_totl ** G8 TOTAL ENROLLMENT **
g9_m_ai G9 AMERICAN INDIAN MALE
g9_f_ai G9 AMERICAN INDIAN FEMALE
g9_m_as G9 ASIAN MALE
g9_f_as G9 ASIAN FEMALE
g9_m_aa G9 AFRICAN AMERICAN MALE
g9_f_aa G9 AFRICAN AMERICAN FEMALE
g9_m_hs G9 HISPANIC MALE
g9_f_hs G9 HISPANIC FEMALE
g9_m_wh G9 WHITE MALE
g9_f_wh G9 WHITE FEMALE
g9_m_hw G9 NATIVE HAWAIIAN MALE
g9_f_hw G9 NATIVE HAWAIIAN FEMALE
g9_m_mr G9 MULTIRACIAL MALE
g9_f_mr G9 MULTIRACIAL FEMALE
g9_m_tot ** G9 TOTAL MALE
g9_f_tot ** G9 TOTAL FEMALE
g9_totl ** G9 TOTAL ENROLLMENT **
g10_m_ai G10 AMERICAN INDIAN MALE
g10_f_ai G10 AMERICAN INDIAN FEMALE
g10_m_as G10 ASIAN MALE
g10_f_as G10 ASIAN FEMALE
g10_m_aa G10 AFRICAN AMERICAN MALE
g10_f_aa G10 AFRICAN AMERICAN FEMALE
g10_m_hs G10 HISPANIC MALE
g10_f_hs G10 HISPANIC FEMALE
g10_m_wh G10 WHITE MALE
g10_f_wh G10 WHITE FEMALE
g10_m_hw G10 NATIVE HAWAIIAN MALE
g10_f_hw G10 NATIVE HAWAIIAN FEMALE
g10_m_mr G10 MULTIRACIAL MALE
g10_f_mr G10 MULTIRACIAL FEMALE
g10_mtot ** G10 TOTAL MALE
g10_ftot ** G10 TOTAL FEMALE
g10_totl ** G10 TOTAL ENROLLMENT **
g11_m_ai G11 AMERICAN INDIAN MALE
g11_f_ai G11 AMERICAN INDIAN FEMALE
g11_m_as G11 ASIAN MALE
g11_f_as G11 ASIAN FEMALE
g11_m_aa G11 AFRICAN AMERICAN MALE
g11_f_aa G11 AFRICAN AMERICAN FEMALE
g11_m_hs G11 HISPANIC MALE
g11_f_hs G11 HISPANIC FEMALE
g11_m_wh G11 WHITE MALE
g11_f_wh G11 WHITE FEMALE
g11_m_hw G11 NATIVE HAWAIIAN MALE
g11_f_hw G11 NATIVE HAWAIIAN FEMALE
g11_m_mr G11 MULTIRACIAL MALE
g11_f_mr G11 MULTIRACIAL FEMALE
g11_mtot ** G11 TOTAL MALE
g11_ftot ** G11 TOTAL FEMALE
g11_totl ** G11 TOTAL ENROLLMENT **
g12_m_ai G12 AMERICAN INDIAN MALE
g12_f_ai G12 AMERICAN INDIAN FEMALE
g12_m_as G12 ASIAN MALE
g12_f_as G12 ASIAN FEMALE
g12_m_aa G12 AFRICAN AMERICAN MALE
g12_f_aa G12 AFRICAN AMERICAN FEMALE
g12_m_hs G12 HISPANIC MALE
g12_f_hs G12 HISPANIC FEMALE
g12_m_wh G12 WHITE MALE
g12_f_wh G12 WHITE FEMALE
g12_m_hw G12 NATIVE HAWAIIAN MALE
g12_f_hw G12 NATIVE HAWAIIAN FEMALE
g12_m_mr G12 MULTIRACIAL MALE
g12_f_mr G12 MULTIRACIAL FEMALE
g12_mtot ** G12 TOTAL MALE
g12_ftot ** G12 TOTAL FEMALE
g12_totl ** G12 TOTAL ENROLLMENT **
alt_m_ai ALTERNATIVE EDUCATION AMERICAN INDIAN MALE
alt_f_ai ALTERNATIVE EDUCATION AMERICAN INDIAN FEMALE
alt_m_as ALTERNATIVE EDUCATION ASIAN MALE
alt_f_as ALTERNATIVE EDUCATION ASIAN FEMALE
alt_m_aa ALTERNATIVE EDUCATION AFRICAN AMERICAN MALE
alt_f_aa ALTERNATIVE EDUCATION AFRICAN AMERICAN FEMALE
alt_m_hs ALTERNATIVE EDUCATION HISPANIC MALE
alt_f_hs ALTERNATIVE EDUCATION HISPANIC FEMALE
alt_m_wh ALTERNATIVE EDUCATION WHITE MALE
alt_f_wh ALTERNATIVE EDUCATION WHITE FEMALE
alt_m_hw ALTERNATIVE EDUCATION NATIVE HAWAIIAN MALE
alt_f_hw ALTERNATIVE EDUCATION NATIVE HAWAIIAN FEMALE
alt_m_mr ALTERNATIVE EDUCATION MULTIRACIAL MALE
alt_f_mr ALTERNATIVE EDUCATION MULTIRACIAL FEMALE
alt_mtot ** ALTERNATIVE EDUCATION TOTAL MALE
alt_ftot ** ALTERNATIVE EDUCATION TOTAL FEMALE
alt_totl ** ALTERNATIVE EDUCATION TOTAL ENROLLMENT **
Technical Note: Utilizing the fall 2003 Single Record Student Database (SRSD) submission, this data set was created by the Center for Educational Performance and Information, Data Analysis and Reporting Unit. This data set includes only student records that passed the CEPI Error Check Program. All total duplicated student records were omitted. Students submitted without a full-time equivalency (FTE) value were not included in the headcount. In addition, the following students were eliminated: graduates, "non-public" students, students that "exited before" the count date, students that "enrolled after" the count date, "adult education" students, students attending "non-public" schools, and potential duplicates matching on district code, school code, last name, first name, date of birth, and gender. Racial/ethnic codes include the following: American Indian (ai), Asian (as), African American (aa), Hawaiian (hw), White (wh), Hispanic (hs), and Multiracial (mr). This data set contains two new racial/ethnic codes not reported in prior years. Those new codes are Hawaiian and Multiracial.
Downloadable Data File Layout Page 5 of 5