File Layout for Pre-ID (2013-2014)

Test Program ID

N/A

From prompt for Test Program Id

1

1

1

X

X

District Name

N/A

reg_district.name
Administration > General Setup > District > District>District Name

2

21

20

X

X

County / District Code

CFS Field Name: 1.04 Reporting LEA
Code Set Name: N/A

reg_building.state_code_equiv (first 7 characters)

Administration > Registration Setup > Building > Building Definition>Preferences Tab>State Equivalency Code

22

28

7

X

X

Student will also be assessed with the STS

N/A

Calculated for students who have primary language of Spanish (165-166) and english proficiency of English Learner (EL) (69) and enrolled a year or less.
OR
From the prompt for STS Student (Over 12 Months) for STS Students for over 12 months.

29

29

1

X

Filler

N/A

30

30

1

School Name

N/A

reg_building.name

Administration > Registration Setup > Building > Building Definition>Building Name

31

50

20

X

X

School Code

CFS Field Name: 1.05 School of Attendance
Code Set Name: N/A

reg_building.state_code_equiv (last 7 characters)

Administration > Registration Setup > Building > Building Definition>Preferences Tab>State Equivalency Code

51

57

7

X

X

Test Purpose

N/A

From prompt for CELDT Test Purpose

58

58

1

X

Filler

N/A

59

60

2

Delivery Name

N/A

From prompt for Delivery Name.

61

80

20

X

X

Delivery Code

N/A

From prompt for Delivery Code.

81

90

10

X

X

Grade in which student is enrolled

CFS Field Name: 1.25 Grade Level Code
Code Set Name: Grade Level

reg.grade – reg_grade.state_code_equiv

Registration > Entry & Reports > Student Demographic > Registration

If Current Year prompt is checked, Current Year Tab>Grade else Next Year Tab>Grade

91

92

2

X

X

Student's Last Name

CFS Field Name: 1.12 Student Legal Last Name
Code Set Name: N/A

reg.last_name

Registration > Entry & Reports > Student Demographic > Registration>Last Name

93

103

11

X

X

Student's First Name

CFS Field Name: 1.10 Student Legal First Name
Code Set Name: N/A

reg.first_name

Registration > Entry & Reports > Student Demographic > Registration>First Name

104

112

9

X

X

Student's Middle Initial

CFS Field Name: 1.11 Student Legal Middle Name
Code Set Name: N/A

reg.middle_name

Registration > Entry & Reports > Student Demographic > Registration>Middle Name

113

113

1

X

X

Student ID Number (Locally Assigned)

CFS Field Name: 1.09 Local Student ID
Code Set Name: N/A

reg.student _id

Registration > Entry & Reports > Student Demographic > Registration>ID

114

123

10

X

X

Date of Birth (Month)

CFS Field Name: 1.17 Student Birth Date
Code Set Name: N/A

reg.birthdate Month part of date.

Registration > Entry & Reports > Student Demographic > Registration>Current Year Tab>Birth Date

124

125

2

X

X

Date of Birth (Day)

CFS Field Name: 1.17 Student Birth Date
Code Set Name: N/A

reg.birthdate Day part of date.

Registration > Entry & Reports > Student Demographic > Registration>Current Year Tab>Birth Date

126

127

2

X

X

Date of Birth (Year)

CFS Field Name: 1.17 Student Birth Date
Code Set Name: N/A

reg.birthdate Year part of date.

Registration > Entry & Reports > Student Demographic > Registration>Current Year Tab>Birth Date

128

131

4

X

X

Gender

CFS Field Name: 1.18 Student Gender Code
Code Set Name: Gender

reg.gender

Registration > Entry & Reports > Student Demographic > Registration>Current Year Tab>Gender

132

132

1

X

X

Statewide Student Identifier (SSID)

CFS Field Name: 1.08 SSID
Code Set Name: N/A

reg_personal.state_report_id

Registration > Entry & Reports > Student Demographic > Personal>State Report ID

133

142

10

X

X

Hispanic or Latino?

CFS Field Name: 2.24 Student Hispanic Ethnicity Indicator
Code Set Name: N/A

reg_personal.hispanic

Registration > Entry & Reports > Student Demographic > Personal>Hispanic/Latino Ethnicity

143

143

1

X

X

Filler

N/A

N/A

144

145

2

Race

N/A

reg_ethnicity.ethnic_code – regtb_ethnicity.state_code_equiv equals the appropriate State Race code
Registration > Entry & Reports > Student Demographic > Personal>Race(>More Button>Race)

146

163

18

X

X

Race – Black or African American

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 600

146

146

1

X

X

Race - American Indian or Alaskan Native

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 100

147

147

1

X

X

Race - Chinese

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 201

148

148

1

X

X

Race - Japanese

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 202

149

149

1

X

X

Race - Korean

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 203

150

150

1

X

X

Race - Vietnamese

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 204

151

151

1

X

X

Race - Asian Indian

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 205

152

152

1

X

X

Race - Laotian

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 206

153

153

1

X

X

Race - Cambodian

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 207

154

154

1

X

X

Race - Other Asian

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 299

155

155

1

X

X

Race - Hmong

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 208

156

156

1

X

X

Race - Filipino

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 400

157

157

1

X

X

Race - Native Hawaiian

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 301

158

158

1

X

X

Race - Guamanian

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 302

159

159

1

X

X

Race - Samoan

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 303

160

160

1

X

X

Race - Tahitian

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 304

161

161

1

X

X

Race - Other Pacific Islander

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 399

162

162

1

X

X

Race - White

CFS Field Name: 2.26 – 2.30 Student Race Code
Code Set Name: Race Category

state code equiv = 700

163

163

1

X

X

Filler

N/A

164

164

1

Student's Primary Language

CFS Field Name: 1.22 Primary Language Code
Code Set Name: Language

reg.language – regtb_language.state_code_equiv
Registration > Entry & Reports > Student Demographic > Registration>Current Year Tab>Home Language

165

166

2

X

X

Parent Education Level

CFS Field Name: 2.50 Parent Guardian Highest Education Level Code
Code Set Name: Highest Education Level

reg_contact.education_level --regtb_edu_level.state_code_equiv for guardians. If multiple guardian records, the highest education level is used.
Registration > Entry & Reports > Student Demographic > Contacts >General>Education Level

167

168

2

X

Filler

N/A

169

169

1

Country of Origin

CFS Field Name: 1.21 Student Birth Country Code
Code Set Name: Country International Standards Organization

reg_personal.birth_country
Registration > Entry & Reports > Student Demographic > Personal>Birth Country

170

171

2

X

Student's English Proficiency

CFS Field Name: 2.41 English Language Acquisition Status Code
Code Set Name: English Language Acquisition Status State

reg_programs.value
view is reg_v_programs.state_code_equiv = 'ca120_prof'
Registration > Entry & Reports > Student Demographic > Programs>CA120 – English Proficiency >English Proficiency

172

175

4

X

Post-Grade 12 Student

N/A

reg_user.field_value
reg_user.page_number = 201 reg_user.field_number = 9
view is ca_v_stu_grad.post_grade_12
Registration > Entry & Reports > Student District Defined > CA Graduation>Post-Grade 12 Student

176

176

1

Migrant Education

CFS Field Name: 3.13 Education Program Code
Code Set Name: Education Program

reg_programs.value
view is reg_v_programs.state_code_equiv = 'ca135_prog'
Registration > Entry & Reports > Student Demographic > Programs>CA135 – Migrant Education>Migrant Education

177

177

1

X

X

Filler

N/A

N/A

178

178

1

Gifted and Talented

CFS Field Name: 3.13 Education Program Code
Code Set Name: Education Program

reg_programs.value
view is reg_v_programs.state_code_equiv = 'ca127_prog'
Registration > Entry & Reports > Student Demographic > Programs>CA127 – Gifted and Talented Education (GATE)>Gifted and Talented Education

179

179

1

X

X

English Learner Services

CFS Field Name: 9.20 Education Service Code
Code Set Name: Education Service English Learners

reg_programs.value
view is reg_v_programs.state_code_equiv = 'ca120_serv'
Registration > Entry & Reports > Student Demographic > Programs>CA120 – English Proficiency>Service Received

180

180

1

X

X

Filler

N/A

181

184

4

N.S.L.P. (Identified as Eligible)

CFS Field Name: 3.13 Education Program Code
Code Set Name: Education Program

reg_programs.value
view is reg_v_programs.state_code_equiv = 'meal_status'
Registration > Entry & Reports > Student Demographic > Programs>CALNC– National School Lunch Program>National School Lunch

185

185

1

X

Other – CDE Use Only (#1) – Reserved for possible use

N/A

186

186

1

X

X

Other – CDE Use Only (#2) – Reserved for possible use

N/A

187

187

1

X

X

Filler

N/A

188

188

1

Special Education-Primary Disability

CFS Field Name: 3.21 Primary Disability Code
Code Set Name: Disability Category

reg_programs.value
view is reg_v_programs.state_code_equiv = 'ca144_disa'
Registration > Entry & Reports > Student Demographic > Programs>CA144 – Special Education>Disability

189

191

3

X

X

English Learner Date First Enrolled (USA)

CFS Field Name: 2.45 Student Initial US School Enrollment Date
Code Set Name: N/A

reg.us_enroll_date

Registration > Entry & Reports > Student Demographic > Registration>Current Year Tab>US Enrollment Date

192

199

8

X

X

R – FEP Date Reclassified

CFS Field Name: 2.42 English Language Acquisition Status Start Date
Code Set Name: English Language Acquisition Status Start State

reg_programs.start_date
reg_programs.program_id=CA120, field_number=8
when program_value using state code equiv

Student Center>Demographic>CA Demographic>English Proficiency—click on link and look at Start Date for program vector where value = RFEP or your local code used to indicate RFEP

200

207

8

X

R-FEP Student Scored Proficient or Advanced 3 years on ELA CST and/or CMA

CFS Field Name: 2.43 Student Proficient or Advanced for ELA Code
Code Set Name: English Language Arts Proficiency Test

reg_user.field_value
reg_user.page_number = 200 reg_user.field_number = 3
view is ca_v_stu_demo.ela_cst_prof

Student Center>Demographic>CA Demographic>ELA CST Proficient or Advanced

208

208

1

X

English Learner in school in the U.S. less than 12 months (cumulative)

N/A

Calculated using reg.us_enroll_date

Registration > Entry & Reports > Student Demographic > Registration>Current Year Tab>US Enrollment Date

209

209

1

X

Filler

N/A

210

210

1

Student with significant disability will be assessed with CAPA

N/A

From prompt for Primary Disability Asses with CAPA.

211

211

1

X

Filler

N/A

212

213

2

Multiple Choice Test Administration Period

N/A

From prompt for Test Administration Period or Default Value.

214

215

2

X

Writing Test Date

N/A

From prompt for Writing Test Date.

216

217

2

X

Student will be assessed with CMA - ELA     

N/A

From prompt for CMA ELA (including students in grades 3-11 starting in 2011 School Year)

218

218

1

X

Student will be assessed with CMA - Math    

N/A

From prompt for CMA Math (including students in grades 8 - 11 starting in 2010 School Year)

219

219

1

X

Student will be assessed with CMA - Science 

N/A

From prompt for CMA Science (including students in 10^th grade starting in 2010 School Year)

220

220

1

X

Filler

N/A

221

230

10

Student Receives Spec Ed Services at Nonpublic Nonsectarian School (NPS)

N/A

reg_programs.value
view is reg_v_programs.state_code_equiv = 'canps'
Registration > Entry & Reports > Student Demographic > Programs>CALNPS– Nonpublic/Nonsectarian Special Education>Institution of Service

231

231

1

X

X

Nonpublic, Nonsectarian School (NPS) CDS School Code

CFS Field Name: 1.06 School of Attendance NPS
Code Set Name: N/A

reg_programs.value
view is reg_v_programs.state_code_equiv = 'canps'
Registration > Entry & Reports > Student Demographic > Programs>CALNPS– Nonpublic/Nonsectarian Special Education>Institution of Service

232

238

7

X

X

Exit Date from Special Education Services (YYYYMMDD)

CFS Field Name: 3.16 Education Program Membership End Date

CFS Field Name: 3.13 Education Program Code
Code Set Name: Education Program

CFS Field Name: 3.14 Education Program Membership Code
Code Set Name: Membership Category

reg_programs.withdrawal_date
view is reg_v_programs.state_code_equiv = 'ca144'
Registration > Entry & Reports > Student Demographic > Programs>CA144– Special Education>End Date

239

246

8

X

County / District Code of Residence for Students with IEPs

CFS Field Name: 3.22 District of Special Education Accountability
Code Set Name: N/A

reg.building – reg_building.state_code_equiv First 7 characters
OR
reg_programs.value
view is reg_v_programs.state_code_equiv = 'cadis_prog'
Registration > Entry & Reports > Student Demographic > Programs>CADIS – District of Residence>District of Residence

247

253

7

X

X

Most Recent Previous CELDT Administration (MMYYYY)

N/A

From prompt for Student Grade during Previous CELDT Administration.

254

259

6

X

Student's Grade during Most Recent Previous CELDT Administration

CFS Field Name: 2.32 Grade Level Code
Code Set Name: Grade Level

From prompt for Student Grade during Previous CELDT Administration.

260

261

2

X

Most Recent Previous Listening Scale Score

N/A

From prompt for CELDT Previous Listening Scale Score.

262

264

3

X

Most Recent Previous Speaking Scale Score

N/A

From prompt for CELDT Previous Speaking Scale Score.

265

267

3

X

Most Recent Previous Reading Scale Score

N/A

From prompt for CELDT Previous Reading Scale Score.

268

270

3

X

Most Recent Previous Writing Scale Score

N/A

From prompt for CELDT Previous Writing Scale Score.

271

273

3

X

Most Recent Previous Overall Scale Score

N/A

From prompt for CELDT Previous Overall Scale Score.

274

276

3

X

Filler

N/A

277

280

4

Local Use

N/A

From prompt for Local Use Field.

281

290

10

X

X

Filler

291

330

40

Student's Street Address-First Line

CFS Field Name: 2.36 Residential Address Line 1

reg_contact.street_number, reg_contact.street_prefix, reg_contact.street_name, reg_contact.street_suffix, reg_contact.street_type

Registration > Entry & Reports > Student Demographic > Contacts>Address Tab>House Number, Street Prefix, Street Name, Street Type

331

360

30

X

X

Student's Street Address-Second Line

2.37 Residential Address Line 2

reg_contact.apartment reg_contact.complex

Registration > Entry & Reports > Student Demographic > Contacts>Address Tab>Apartment, Complex

361

390

30

X

X

Student's City Name

CFS Field Name: 2.38 Residential Address City Name

reg_contact.city

Registration > Entry & Reports > Student Demographic > Contacts>Address Tab>City

391

410

20

X

X

State

CFS Field Name: 2.39 Residential Address State Province Code
Code Set Name: State/Province

reg_contact.state

Registration > Entry & Reports > Student Demographic > Contacts>Address Tab>State

411

412

2

X

X

Student's Zip Code

CFS Field Name: 2.40 Residential Address Zip Code
Code Set Name: N/A

reg_contact.zip

Registration > Entry & Reports > Student Demographic > Contacts>Address Tab>Zip Code

413

421

9

X

X

Customer Pre-ID Data Field

N/A

From prompt for Customer Data.

422

500

79

X

Student English Teacher SEID

N/A

N/A

501

510

10

X

Student Math Teacher SEID

N/A

N/A

511

520

10

X

Reserved for Future Use

N/A

N/A

521

600

80