Get documents about "NCLB09 LAYOUT
Document Sample
New Jersey Department of Education
NCLB Report Data Layout
2008-2009 Edition
Table Name: SCH_HEADER
Content: Contains school identification information
Field Width Data Type Description
co_code 2 Char County code
dist_code 4 Char District code
sch_code 3 Char School code
co_name 10 Char County name
dis_name 30 Char District name
sch_name 32 Char School name
stype 2 Char school type
Key to the stype codes:
C=Special services
E=Elementary school
H=Secondary school
P=Special education
T=Charter school elementary
U=Charter school secondary
V=Vocational school
9/12/2012
New Jersey Department of Education
NCLB Report Data Layout
2008-2009 Edition
Table Name: ASSESSMENT
Content: Contains New Jersey statewide assessment data by school, district, state
Field Width Data Type Description
co_code 2 Char County code
dist_code 4 Char District code
sch_code 3 Char School code
year 4 Char School year when a test was administered
testprg 5 Char Indicator of test program – GEPA, HSPA, NJASK
subject 1 Char Indicator of test subject – L=LAL, M=MATH
level 1 Char Indicator of level of the statistics- S=SCHOOL, D=DISTRICT, T=STATE
tntest 6 Alphanumeric, 1 decimal All students - % not tested
tpp 5 Alphanumeric, 1 decimal All students - % partially proficient
tp 5 Alphanumeric, 1 decimal All students - % proficient
tap 5 Alphanumeric, 1 decimal All students - % advanced proficient
mntest 6 Alphanumeric, 1 decimal Male students - % not tested
mpp 5 Alphanumeric, 1 decimal Male students - % partially proficient
mp 5 Alphanumeric, 1 decimal Male students - % proficient
map 5 Alphanumeric, 1 decimal Male students - % advanced proficient
fntest 6 Alphanumeric, 1 decimal Female students - % not tested
fpp 5 Alphanumeric, 1 decimal Female students - % partially proficient
fp 5 Alphanumeric, 1 decimal Female students - % proficient
fap 5 Alphanumeric, 1 decimal Female students - % advanced proficient
wntest 6 Alphanumeric, 1 decimal White students - % not tested
wpp 5 Alphanumeric, 1 decimal White students - % partially proficient
wp 5 Alphanumeric, 1 decimal White students - % proficient
wap 5 Alphanumeric, 1 decimal White students - % advanced proficient
bntest 6 Alphanumeric, 1 decimal Black students - % not tested
bpp 5 Alphanumeric, 1 decimal Black students -% partially proficient
bp 5 Alphanumeric, 1 decimal Black students -% proficient
bap 5 Alphanumeric, 1 decimal Black students -% advanced proficient
antest 6 Alphanumeric, 1 decimal Asian/Pacific Islanders students - % not tested
app 5 Alphanumeric, 1 decimal Asian/Pacific Islanders students - % partially proficient
ap 5 Alphanumeric, 1 decimal Asian/Pacific Islanders students - % proficient
aap 5 Alphanumeric, 1 decimal Asian/Pacific Islanders students - % advanced proficient
nntest 6 Alphanumeric, 1 decimal American Indian/Alaska Native students - % not tested
npp 5 Alphanumeric, 1 decimal American Indian/Alaska Native students - % partially proficient
np 5 Alphanumeric, 1 decimal American Indian/Alaska Native students - % proficient
nap 5 Alphanumeric, 1 decimal American Indian/Alaska Native students - % advanced proficient
hntest 6 Alphanumeric, 1 decimal Hispanic students - % not tested
hpp 5 Alphanumeric, 1 decimal Hispanic students -% partially proficient
hp 5 Alphanumeric, 1 decimal Hispanic students -% proficient
hap 5 Alphanumeric, 1 decimal Hispanic students -% advanced proficient
ontest 6 Alphanumeric, 1 decimal Other students - % not tested
opp 5 Alphanumeric, 1 decimal Other students - % partially proficient
op 5 Alphanumeric, 1 decimal Other students - % proficient
oap 5 Alphanumeric, 1 decimal Other students - % advanced proficient
gntest 6 Alphanumeric, 1 decimal General education students - % not tested
gpp 5 Alphanumeric, 1 decimal General education students - % partially proficient
gp 5 Alphanumeric, 1 decimal General education students - % proficient
gap 5 Alphanumeric, 1 decimal General education students - % advanced proficient
sntest 6 Alphanumeric, 1 decimal Students with disabilities - % not tested
spp 5 Alphanumeric, 1 decimal Students with disabilities - % partially proficient
sp 5 Alphanumeric, 1 decimal Students with disabilities - % proficient
sap 5 Alphanumeric, 1 decimal Students with disabilities - % advanced proficient
mgntest 6 Alphanumeric, 1 decimal Migrant students - % not tested
mgpp 5 Alphanumeric, 1 decimal Migrant students - % partially proficient
mgp 5 Alphanumeric, 1 decimal Migrant students - % proficient
mgap 5 Alphanumeric, 1 decimal Migrant students - % advanced proficient
lntest 6 Alphanumeric, 1 decimal LEP - % not tested
lpp 5 Alphanumeric, 1 decimal LEP - % partially proficient
lp 5 Alphanumeric, 1 decimal LEP - % proficient
lap 5 Alphanumeric, 1 decimal LEP - % advanced proficient
9/12/2012
New Jersey Department of Education
NCLB Report Data Layout
2008-2009 Edition
Table Name: ASSESSMENT
Content: Contains New Jersey statewide assessment data by school, district, state
Field Width Data Type Description
entest 6 Alphanumeric, 1 decimal Economically disadvantaged students - % not tested
epp 5 Alphanumeric, 1 decimal Economically disadvantaged students - % partially proficient
ep 5 Alphanumeric, 1 decimal Economically disadvantaged students - % proficient
eap 5 Alphanumeric, 1 decimal Economically disadvantaged students - % advanced proficient
9/12/2012
NEW JERSEY DEPARTMENT OF EDUCATION
NCLB Report Data Layout
2008-2009 Edition
Table: ATTENDANCE
Content: Contains school, district, and state level attendance rates
Field Type Description
CO_CODE CHAR County code
DIST_CODE CHAR District code
SCH_CODE CHAR School code
YEAR CHAR School year
LEVEL CHAR S=School, D=District, T=State
PK Alphanumeric, 1 decimal Pre-kindergarten (including half and full day)
KG Alphanumeric, 1 decimal Kindergarten (including half and full day)
G1 Alphanumeric, 1 decimal Grade 1
G2 Alphanumeric, 1 decimal Grade 2
G3 Alphanumeric, 1 decimal Grade 3
G4 Alphanumeric, 1 decimal Grade 4
G5 Alphanumeric, 1 decimal Grade 5
G6 Alphanumeric, 1 decimal Grade 6
G7 Alphanumeric, 1 decimal Grade 7
G8 Alphanumeric, 1 decimal Grade 8
G9 Alphanumeric, 1 decimal Grade 9
G10 Alphanumeric, 1 decimal Grade 10
G11 Alphanumeric, 1 decimal Grade 11
G12 Alphanumeric, 1 decimal Grade 12
VOCK12 Alphanumeric, 1 decimal Vocational K-12
SPED Alphanumeric, 1 decimal Special Education - ungraded
TOTAL Alphanumeric, 1 decimal Total students
9/12/2012
9/12/2012
New Jersey Department of Education
NCLB Report Data Layout
2008-2009 Edition
Table Name: AYP
Content: Contains AYP data
Field Width Data Type Description
co_code 2 Char County code
dist_code 4 Char District code
sch_code 3 Char School code
year 4 Char School year
aypd_need 1 Char District classified as "in need of improvement"? -Y/N
d_status 1 numeric 1- Early Warning; 2 - LEA Improvement (DINI 1); 3 - LEA
Improvement (DINI 2); 4 - District Corrective Action (DINI 3); 5 -
District Corrective Action (DINI 4); 6 - District Corrective Action
ayp 1 Char School made AYP? - Y/N
ayps_need 1 Char School classified as "in need of improvement"? -Y/N
status 1 numeric 1 - Early warning; 2 - public school choice; 3 - supplemental
educational services; 4 - corrective action; 5 - develop
restructuring plan; 6 - implemnet restructuring plan
9/12/2012
New Jersey Department of Education
NCLB Report Data Layout
2008-2009 Edition
Table Name: TEACHER
Content: Contains Highly Qualified Teacher data
Field Width Data Type Description
co_code 2 Char County code
dist_code 4 Char District code
sch_code 3 Char School code
year 4 Char School year
level 1 Char Level of data: S=school, D=district, T=state
pctclass 5 %
Numeric, 1 decimal of classes taught by highly qualified teachers
New Jersey Department of Education
NCLB Report Data Layout
2008-2009 Edition
Table Name: TPF
Content: Contains Teachers' Professional Qualifications data
Field Width Data Type Description
co_code 2 Char County code
dist_code 4 Char District code
sch_code 3 Char School code
year 4 Char School year
babs 5 Numeric, 1 decimal % of teachers with a bachelor's degree.
mams 5 Numeric, 1 decimal % of teachers with a master's degree.
phdedd 5 Numeric, 1 decimal % of teachers with a doctorate.
Note: This table was added for the 2003-2004 edition.
New Jersey Department of Education
NCLB Report Data Layout
2008-2009 Edition
Table Name: DROPOUT
Content: Contains dropout rate data
Field Width Data Type Description
co_code 2 Char County code
dist_code 4 Char District code
sch_code 3 Char School code
year 4 Char School year
level 1 Char Level of data: S=school, D=district, T=state
wdrp 5 Alphanumeric, 1 decimal Dropout rate: White students
bdrp 5 Alphanumeric, 1 decimal Dropout rate: Black students
hdrp 5 Alphanumeric, 1 decimal Dropout rate: Hispanic students
ndrp 5 Alphanumeric, 1 decimal Dropout rate: American Indian/Alaska Native students
adrp 5 Alphanumeric, 1 decimal Dropout rate: Asian/P.I. Students
odrp 5 Alphanumeric, 1 decimal Dropout rate: Other Races
mdrp 5 Alphanumeric, 1 decimal Dropout rate: Male students
fdrp 5 Alphanumeric, 1 decimal Dropout rate: Female students
sedrp 5 Alphanumeric, 1 decimal Dropout rate: Students with disabilities
ledrp 5 Alphanumeric, 1 decimal Dropout rate: LEP students
eddrp 5 Alphanumeric, 1 decimal Dropout rate: Economically disadvantaged students
totdrp 5 Alphanumeric, 1 decimal Dropout rate: Total students
9/12/2012
New Jersey Department of Education
NCLB Report Data Layout
2008-2009 Edition
Table Name: GRAD RATE
Content: Contains Graduation Rate Information
Field Width Data Type Description
co_code 2 Char County code
dist_code 4 Char District code
sch_code 3 Char School code
year 4 Char School year
level 1 Char Level of data: S=school, D=district, T=state
pctgrad 5 Numeric, 1 decimal % of graduating students
New Jersey Department of Education
NCLB Report Data Layout
2008-2009 Edition
Table Name: LEP EXEMPT
Content: LEP EXEMPT information
Field Width Data Type Description
Field Length
COUNTY_CODE 2 CHAR County code
DISTRICT_CODE 4 CHAR District code
SCHOOL_CODE 3 CHAR School code
YEAR 4 CHAR School Year
LEVEL_SD 1 CHAR Level of data: S=school, D=district, T=state
LEP<1 2 Count of recently received students who are exempt from
Alphanumeric taking the language portion of the tests.
