File Layout for 2017-2018 Pre-ID (CELDT Only)

Test Program ID

N/A

From prompt for Test Program Id

1

1

1

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 panel > State Equivalency Code

2

8

7

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.

9

9

1

N/A

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 panel > State Equivalency Code

10

16

7

X

Test Purpose

N/A

From prompt for CELDT Test Purpose

17

17

1

X

Delivery Name

N/A

From prompt for Delivery Name.

18

37

20

X

Delivery Code

N/A

From prompt for Delivery Code.

38

47

10

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 Grade else Next Year Grade

48

49

2

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

50

60

11

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

61

69

9

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

70

70

1

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

71

80

10

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 > Birth Date

81

82

2

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 > Birth Date

83

84

2

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 > Birth Date

85

88

4

X

Gender

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

reg.gender

Registration > Entry & Reports > Student Demographic > Registration > Gender

89

89

1

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

90

99

10

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

100

100

1

N/A

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 > US Enrollment Date

101

101

1

N/A

Student with significant disability will be assessed with CAPA

N/A

From prompt for Primary Disability Asses with CAPA.

102

102

1

N/A

Multiple Choice Test Administration Period

N/A

From prompt for Test Administration Period or Default Value.

103

104

2

N/A

Student will be assessed with CMA - Science 

N/A

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

105

105

1

N/A

Satisfied CAHSEE requirement – ELA

N/A

From prompt for Satisfied ELA Requirements.

106

106

1

N/A

Satisfied CAHSEE requirement - Math

N/A

From prompt for Satisfied Math Requirements.

107

107

1

N/A

Most Recent Previous CELDT Administration (MMYYYY)

N/A

From prompt for Student Grade during Previous CELDT Administration.

108

113

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.

114

115

2

X

Most Recent Previous Listening Scale Score

N/A

From prompt for CELDT Previous Listening Scale Score.

116

118

3

X

Most Recent Previous Speaking Scale Score

N/A

From prompt for CELDT Previous Speaking Scale Score.

119

121

3

X

Most Recent Previous Reading Scale Score

N/A

From prompt for CELDT Previous Reading Scale Score.

122

124

3

X

Most Recent Previous Writing Scale Score

N/A

From prompt for CELDT Previous Writing Scale Score.

125

127

3

X

Most Recent Previous Overall Scale Score

N/A

From prompt for CELDT Previous Overall Scale Score.

128

130

3

X

Local Use

N/A

From prompt for Local Use Field.

131

140

10

X

Student's Parents Name

CFS Field Name: 2.51 Guardian 1 First Name
2.52 Guardian 1 Last Name

reg_contact.first_name reg_contact.middle_name reg_contact.last_name
Registration > Entry & Reports > Student Demographic > Contacts > First Name, Middle Name, Last Name

141

180

40

N/A

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 > Addresses panel > House Number, Street Prefix, Street Name, Street Type

181

210

30

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 > Addresses panel > Apartment, Complex

211

240

30

X

Student's City Name

CFS Field Name: 2.38 Residential Address City Name

reg_contact.city

Registration > Entry & Reports > Student Demographic > Contacts > Addresses panel > City

241

260

20

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 > Addresses panel > State

261

262

2

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 > Addresses panel > Zip Code

263

271

9

X

Customer Pre-ID Data Field

N/A

From prompt for Customer Data.

272

350

79

N/A