English Language Learner (ELL) Database Collection Record Extract

Contents

Report Description

This extract includes students with a test date entered in the Proficiency atom for the Listening, Speaking, Reading, Writing, and Comprehensive scores. The test date must fall within the current school year for the student to be included on the extract.

ELL Data Setup

Before generating this report, verify that ELL tests are defined at the District and scores are assigned to the students that took the ELL tests. Navigate to Start Page > District Setup > Tests for district setup. Navigate to Start Page > Student > Test Scores and Start Page > Student > State/Province – CT > ELL Database Collection Record Extract for student level setup. See District Setup and Student Setup for instructions.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] or [StudentTest] table based on the following criteria:

The student must be enrolled between the Report Start and Report End Date.
The student must have a qualifying Test Score that falls between the Report Start and Report End Date.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05.
Report Start Date	Enter the start date for the reporting period.
Report End Date	Enter the end date for the reporting period.
Display Header	Choose Yes or No from the pop-up menu to determine whether to display header fields in the extract. Headers display the name of each data element for each record extracted. Use headers for troubleshooting purposes.
File Format	Choose whether to extract the records in comma-delimited format for troubleshooting purposes or in fixed length format for submission to the state.
Run From Extract Viewer	Choose one of the following from the pop-up menu: No (default) – The records that currently exist in the Extract Viewer are replaced. Yes – Create an extract file from the records in the Extract Viewer.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length	Begin / End Position
1	State Assigned Student ID (SASID)	The state-assigned student ID number for this student.	[Students]State_StudentNumber [S_CT_STU_X]State_Student_ID	Alpha-numeric	10	1–10
2	Date of Birth	The student’s date of birth.	[Students]DOB	Numeric	8	11–18
3	District Student ID	The student’s district or locally assigned ID number.	[Students]Student_Number	Alpha-numeric	20	19–38
4	Reporting District	The three-digit code for the reporting school district.	[Students]DistrictOfResidence	Alpha-numeric	3	39–41
5	Facility Code 1	The school attended by the student; or, if the student is changing schools, the new school the student will attend.	[S_CT_STU_X]FacilityCode1	Alpha-numeric	7	42-48
6	Grade Code	The student’s current grade level. If a value is entered for the Pre-Kindergarten/Kindergarten Grade Code, then that value is reported. Otherwise, the Grade Level value is reported.	[Students]Grade_Level [ReEnrollments]Grade_Level [S_CT_STU_PreKKG_X] PreKKGGradeCode [S_CT_REN_X]PK_KGGrade	Numeric	2	49–50
7	Native Language Code	The student’s primary language.	[Students]primarylanguage	Alpha-numeric	3	50–52
8	English Learner (EL)	Indicates (Y/N) if this student qualifies as an English Learner.	[S_CT_STU_Language_X]ELLIndicator	Alpha-numeric	1	53
9	EL Program Code	The English Learner Program for which this student qualifies. See the Appendix for valid values.	[S_CT_STU_Language_X]ELLIndicator	Numeric	2	54–55
10	First Date of ELL Service — in District	The first date the student received English language services, regardless of type, from this district during their current enrollment. If the student withdraws from the district and later re-enrolls, then report the date that services started on the student’s return.	[S_CT_STU_Language_X] ELLDistrictServiceDate	Numeric	8	56–63
11	Date of Mastery	The date the student achieved the English mastery standard. This field is blank for students who have not achieved the English mastery standard.	[S_CT_STU_Language_X] ELLDateOfMastery	Numeric	8	64–71
12	Listening Scale Score	The test score that corresponds to the number correct on the LAS Links Listening test. See the Appendix for valid values.	[StudentTestScore]NumScore	Numeric	3	72–74
13	Speaking Scale Score	The test score that corresponds to the number correct on the LAS Links Speaking test. See the Appendix for valid values.	[StudentTestScore]NumScore	Numeric	3	75–77
14	Reading Scale Score	The test score that corresponds to the number correct on the LAS Links Reading test. See the Appendix for valid values.	[StudentTestScore]NumScore	Numeric	3	78–80
15	Writing Scale Score	The test score that corresponds to the number correct on the LAS Links Writing test. See the Appendix for valid values.	[StudentTestScore]NumScore	Numeric	3	81–83
16	Comprehension Scale Score	The test score that corresponds to the number correct on the LAS Links Comprehension test. See the Appendix for valid values.	[StudentTestScore]NumScore	Numeric	3	84–86
17	Date Testing Completed	The date the LAS Links testing was completed. If the exact date is not known, an estimated date may be reported.	[StudentTest]Test_Date	Numeric	8	87–94
18	Listening Scale Score Missing Code	The two-character code indicating the reason why no Listening Score is reported. See Missing LAS Link Codes in the Appendix for valid values.	[S_CT_STU_Language_X] ListeningScaleMissingCode	Numeric	2	95–96
19	Speaking Scale Score Missing Code	The two-character code indicating the reason why no Speaking Score is reported. See Missing LAS Link Codes in the Appendix for valid values.	[S_CT_STU_Language_X] SpeakingScaleMissingCode	Numeric	2	97–98
20	Reading Scale Score Missing Code	The two-character code indicating the reason why no Reading Score is reported. See Missing LAS Link Codes in the Appendix for valid values.	[S_CT_STU_Language_X] ReadingScaleMissingCode	Numeric	2	99–100
21	Writing Scale Score Missing Code	The two-character code indicating the reason why no Writing Score is reported. See Missing LAS Link Codes in the Appendix for valid values.	[S_CT_STU_Language_X] WritingScaleMissingCode	Numeric	2	101–102
22	Comprehension Scale Score Missing Code	The two-character code indicating the reason why no Comprehension Score is reported. See Missing LAS Link Codes in the Appendix for valid values.	[S_CT_STU_Language_X] CompScaleMissingCode	Numeric	2	103–104
23	Listening Scale Score Missing Other	A text explanation of why the Listening score is not reported. This field is extracted only if no score is reported for Listening and the Missing code is Other (Missing code = 5).	[S_CT_STU_Language_X] ListeningScaleMissingOther	Alpha-numeric	100	105–204
24	Speaking Scale Score Missing Other	A text explanation of why the Speaking score is not reported. This field is extracted only if no score is reported for Speaking and the Missing code is Other (Missing code = 5).	[S_CT_STU_Language_X] SpeakingScaleMissingOther	Alpha-numeric	100	205–304
25	Reading Scale Score Missing Other	A text explanation of why the Reading score is not reported. This field is extracted only if no score is reported for Reading and the Missing code is Other (Missing code = 5).	[S_CT_STU_Language_X] ReadingScaleMissingOther	Alpha-numeric	100	305–404
26	Writing Scale Score Missing Other	A text explanation of why the Writing score is not reported. This field is extracted only if no score is reported for Writing and the Missing code is Other (Missing code = 5).	[S_CT_STU_Language_X] WritingScaleMissingOther	Alpha-numeric	100	405–504
27	Comprehension Scale Score Missing Other	A text explanation of why the Comprehension score is not reported. This field is extracted only if no score is reported for Comprehension and the Missing code is Other (Missing code = 5).	[S_CT_STU_Language_X] CompScaleMissingOther	Alpha-numeric	100	505–604
28	End of Record Indicator	X is automatically included at the end of the record.	N/A	Alpha-numeric	1	605