Classic View: CA State Reporting > CELDT Pre-ID
Search Terms: CELDT Pre-ID Extract
The CELDT (California English Language Development Test) extract is generated to request Pre-ID labels for students who are English Language Learners. The reporting group is any K-12 student in the requested calendar(s) who is enrolled on the effective date (and who has a start date after the "enrolled after" date if that is chosen).
CELDT Pre-ID Extract
Because the CELDT Pre-ID extract reports previous test scores, it is critical that these tests be set up correctly in the Assessment Test editor prior to generating these extracts. See the Assessment Setup for CELDT page for more information.
Students marked as Student Exclude on their enrollment record, or enrolled in a Grade Level marked State Exclude, or in a school marked as State Exclude are not reported.
Report Logic
This extract reports any student in grades KN-12 in the selected calendar(s) who is enrolled on the Effective Date (and who has a start date after the Enrolled After date if that is selected) and who has a Program Status of Pending and an Identified Date or Enrollment Start Date on or before the Effective Date.
Only those students who have an EL record in pending status and who have not previously taken the CELDT are included.
Students marked as State Exclude, in a grade level marked as State Exclude or in a school marked as State Exclude do not report. The report only includes the current identity of the student when more than one identity exists.
Tests with a State Code of 105 and Subject Codes of the following are included:
- 158: Listening
- 177: Overall Comprehension
- 187: Reading
- 231: Speaking
- 491: Writing
Extract Editor Details
The following describes each field of the dates section.
Field | Description |
|---|---|
Effective Date | Students with an active enrollment as of this date are included in the extract. Dates can be entered in mmddyy format or clicking the calendar icon and selecting a date. |
Only Report Students Enrolled After | Only students who enrolled within the selected calendar(s) on or after this date are included in the extract. Dates can be entered in mmddyy format or clicking the calendar icon and selecting a date. This is NOT a required field. |
Ad hoc Filter | Filters reported data based on preexisting Ad hoc filters. |
Format | The format of the generated extract. When submitting to the state, use the State Format (Fixed Width). |
Testing Date | This field indicates the date the test is administered. Dates can be entered in mmddyy format or clicking the calendar icon and selecting a date. |
| Legal Name and Gender | When marked, a student's legal name and legal gender information report (entered in the Protected Identity Information section on the Identites tool), instead of the name and gender entered in the Person Information section. If this checkbox is marked and the student does not have legal name and gender information populated, the student's name report from the name and gender fields. |
Delivery Homeroom | If selected, the teacher's name and course section number for the student's homeroom course is reported on the extract. |
Delivery Period | If selected, the teacher name and course section number for the student's course in that period report. If the student is not enrolled in a course during this period on the Testing Day, the field reports a blank value. Options for periods are limited to only those period names in the active year. |
Grades | Designates which grades have information pulled on the extract. |
| Calendar Selection | Users must select at least one calendar in order to generate a Pre-ID Extract. Multiple calendars can be selected by using the CTRL and SHIFT keys. Users are advised to limit the number of calendars selected as it impacts overall system performance. |
| Report Generation | Use the Generate Report button to display the results of the report immediately. Use the Submit to Batch button to choose when the report should generate. |
Generate the Report
- Enter the Effective Date in mmddyy format or by clicking the calendar icon and selecting a date.
- Enter the Only Report Students Enrolled After (if applicable) in mmddyy format or by clicking the calendar icon and selecting a date.
- Select an Ad hoc Filter, if applicable.
- Select a Format. When submitting the extract to the test vendor, use the State Format (Fixed Width).
- Enter a Testing Date.
- If a student's legal name and gender should report, leave the Legal Name and Gender checkbox marked. Otherwise, remove the checkmark.
- Mark the Delivery Homeroom checkbox, if desired. Marking this checkbox includes the teacher's name and course number of the student's homeroom course on the extract.
- Select a value from the Delivery Period list, if desired. Choosing a value in this field includes the teacher name and course section number for the student's course in that period on the extract.
- Select a value from the Grades list if desired.
- Select which Calendar(s) to report on the extract.
- Click the Generate Extract button. The extract displays in a separate window in the designated format.
CELDT Pre-ID Extract, State Format
CELDT Pre-ID Extract, CSV Format
CELDT Pre-ID Extract, HTML Format
Data Elements for the CELDT Extract
Element Name | Description | Type, Length and Format | Starting Position | Campus Database | Campus Application |
|---|---|---|---|---|---|
Test Program ID | Test Program ID | Alphanumeric, 1 character | 1 | Not dynamically stored | Not dynamically stored |
County/ District Code | Reports the State District Number associated with the reporting school. This field reports the Secondary District Number when the reporting calendar has a School Type of 16: Secondary State District Number. | Numeric, 7 digits | 2 | District.code School.type | System Administration > Resources > District Information > State District Number System Administration > Resources > School > Type |
Filler 1 | N/A | Blank, 2 spaces | 9 | N/A | N/A |
School Code | Reports the State School Number associated with the reporting school. If the CDS Number field is populated on the School editor, that value reports. | Alphanumeric, 7 characters | 10 | School.number | System Administration > Resources > School > State School Number System Administration > Resources > School > CDS Number |
Test Purpose | Indicates the reason for the test. | Numeric, 1 digit | 17 | assessment. score | Student Information > General > Assessments > Test Score Detail > State Code |
Delivery Name | If Delivery Homeroom is chosen, report the Teacher Name from the Course Section that is checked as Homeroom. This course/section must be on the Testing Day. If a Delivery Period is chosen, report the Teacher Name from the Course Section in which the student is scheduled for that period on the Testing Day. | Alphanumeric, 20 characters | 18 | Course.number | Course > Section > Homeroom, Display Name |
Delivery Code | If Delivery Homeroom is chosen, report the Course-Section number from the Course Section that is checked as Homeroom. This course/section must be on the Testing Day. If a Delivery Period is chosen, report the Course-Section number from the Course Section in which the student is scheduled for that period on the Testing Day. If the student does not have a course section marked as Homeroom or scheduled during the chosen period, this reports blank. | Alphanumeric, 10 characters | 38 | Course.number | Course Number > Section Number |
Grade | Grade in which student is enrolled. Reports student in grades KN-12 only; grade level KN reports as 00 | Alphanumeric, 2 characters | 48 | Enrollment. grade | Student Information > General > Enrollments > General Enrollment Editor > Grade |
Last Name | Student's legal last name | Alphanumeric, 11 characters | 50 | Identity.lastName Identity.legalLastName | Census > People > Demographics > Person Information > Last Name Census > People > Demographics > Protected Identity Information > Last Name |
First Name | Student's legal first name | Alphanumeric, 9 characters | 61 | Identity.firstName Identity.legalFirstName | Census > People > Demographics > Person Information > First Name Census > People > Demographics > Protected Identity Information > First Name |
Middle Initial | Student's middle initial | Alphanumeric, 1 character | 70 | Identity. middleName Identity.legalMiddleName | Census > People > Demographics > Person Information > Middle Name Census > People > Demographics > Protected Identity Information > Middle Name |
Student ID | Student's ID number assigned by the school or district | Alphanumeric, 10 characters | 71 | Person.student Number | Census > People > Demographics > Person Identifiers > Student Number |
DOB Month | Month of birth | Numeric, 2 digits MM | 81 | Identity.birthDate | Census > People > Demographics > Person Information > Birth Date |
DOB Day | Day of birth | Numeric, 2 digits DD | 83 | Identity.birthDate | Census > People > Demographics > Person Information > Birth Date |
DOB Year | Year of Birth | Numeric, 4 digits YYYY | 85 | Identity.birthDate | Census > People > Demographics > Person Information > Birth Date |
Gender | Indication of student being either male or female | M or F, 1 character | 89 | Identity.gender Identity.LegalGender | Census > People > Demographics > Person Information > Gender Census > People > Demographics > Protected Identity Information > Gender |
State ID | State-assigned Student Identifier | Numeric, 10 digits | 90 | Person.stateID | Census > People > Demographics > Person Identifiers > State ID |
Filler 2 | N/A | Blank, 8 spaces | 100 | N/A | N/A |
Local Use | N/A | Blank, 10 spaces | 131 | N/A | N/A |
Filler 3 | N/A | Blank, 40 spaces | 141 | N/A | N/A |
Address Line 1 | Reports the student's primary address house number, street name, tag, direction and PO Box is available. | Alphanumeric, 30 characters | 181 | Address.number | Census > Households > Address |
Address Line 2 | Reports any additional address information from the previous field if it overflows to a second line. | Alphanumeric, 30 characters | 211 | Address.number | Census > Households > Address |
Address City | Reports the city from the student's Primary Address. | Alphanumeric, 20 characters | 241 | Address.city | Census > Households > Address > City |
Address State | Reports the state from the student's Primary Address. | Alphabetic, 2 characters | 261 | Address.state | Census > Households > Address > State |
Address Zip | Reports the zip code (plus 4 if available) of the student's Primary Address. | Numeric, 9 digits | 263 | Address.zip | Census > Household > Address > Zip |
