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