WA Learning Assistance Program Report

Introduction

The Student Growth File (formally know as the Learning Assistance Program) report (1094E) is used to gather student program participation, specifically those programs associated with Student Growth File (SGF). The SGF report uses the State Reporting Platform (SRP) which optimizes the performance of the report.

The report counts those students who attended at any time during the selected academic year and participated in one of the SGF programs selected from the Program Code field on the Special Programs Enrollments page:

Reading (4)
Language Arts (5)
Math (6)
Readiness (7)
Graduation Assistance (11)

This report can be used to identify the number of students participating in a SGF program sorted by the following:

Grade
Federal Ethnicity/Race
Gender
Program by School

This report may be run at the school or district level and may take several hours to run depending on the size of your school or district.

Running the SGF report will generate the output files, which are in a zip format: WA_Learning_Assistance_Program_Report.zip. When unzipped, there are two files:

LAP_Audit. This is the CSV file listing of each student included in the report and their associated information.
LAP_Basic. This is the PDF file displaying the program participation totals by school.

PS_Enrollment_All - This view provides Current Enrollment, Previous Enrollment, and Special Program Enrollment information.

Selection Criteria

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

Student Selection

The report selects school records from the [Schools] and [Students] table based on the following criteria:

The school must not be excluded from state reporting.
The student must not be excluded from state reporting.
The student must be enrolled in a Learning Assistance Program (Codes 4, 5, 6, 7 or 11).
The student's school Entry Date and the student's Program Start Date must both occur on or before the report end date.
The student's school Exit Date and the student's Program End Date must both occur on or after the report start date.

Report Input

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

Field	Description
Use	Choose one of the following from the pop-up menu: Current School Only (default) – Includes all student 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. District Wide – Includes all student records on the PowerSchool server that meet the selection criteria.
Start Date (MM/DD/YYYY)	Enter the report start date.
End Date (MM/DD/YYYY)	Enter the report end date.

Back to Top

Report Output – LAP Audit

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

Item #	Data Element	Description	[Table]FieldName
1	School Name	The name of the school at which the attendance was recorded.	[Students]SchoolID [Schools]Name
2	Student Number	The locally assigned student identifier.	[Students]Student_Number
3	State Student Number	The state assigned student identifier.	[Students]State_StudentNumber
4	Last Name	The student's last name. Note: If the Legal Name name fields are populated, the student's legal name overrides the student's preferred name.	[StudentCoreFields]PSCore_Legal_Last_Name [Students]Last_Name
5	First Name	The student's first name. Note: If the Legal Name name fields are populated, the student's legal name overrides the student's preferred name.	[StudentCoreFields]PSCore_Legal_First_Name [Students]First_Name
6	Middle Name	The student's middle name. Note: If the Legal Name name fields are populated, the student's legal name overrides the student's preferred name.	[StudentCoreFields]PSCore_Legal_Middle_Name [Students]Middle_Name
7	Grade Level	The student's grade level.	[Students]Grade_Level
8	Ethnicity/Race	Indicates the student's selected racial categories.	[Students]Fedethnicity [StudentRace]Racecd
9	Ethnicity/Race Code	Indicates the code for the student's racial categories.	[Students]Fedethnicity [StudentRace]Racecd
10	Gender	The student's gender.	[Students]Gender
11	Birth date	The student's birth date.	[Students]DOB
12	Lap Qual Code	The Qualification Code associated with the Learning Assistance Program assigned to the student.	[S_WA_STU_SpecialPrograms_C]QualificationCode
13	LAP Code	The LAP program code.	[S_WA_STU_SpecialPrograms_C]ProgramCode
14	LAP Description	The LAP program description.	[S_WA_STU_SpecialPrograms_C]ProgramCode
15	Entry Date	The student's school entry date at the time of the reporting period, reported in the format MM/DD/YYYY.	[Students]EntryDate
16	Exit Date	The student's school exit date at the time of the reporting period, reported in the format MM/DD/YYYY.	[Students]ExitDate
17	LAP Entry Date	The date the student enrolled in the LAP program, reported in the format MM/DD/YYYY.	[S_WA_STU_SpecialPrograms_C]StartDate
18	LAP Exit Date	The date the student exited the program, reported in the format MM/DD/YYYY.	[S_WA_STU_SpecialPrograms_C]EndDate
19	LAP Exit Code	The reason the student exited the LAP program.	[S_WA_STU_SpecialPrograms_C]ExitReasonCode

Back to Top

Report Output – LAP Basic

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
1	Unduplicated count by grade and gender for all programs	The number of students enrolled in one or more LAP special programs sorted by gender and grade level. Note: This is an unduplicated count. Students are counted only once regardless of the number of qualifying programs they may be enrolled.	[Students]Gender [Students]Grade_Level
2	Total Served	The total number of students served in each grade level as well as each gender.	[Students]Gender [Students]Grade_Level
3	Unduplicated count by grade and Race/Ethnicity for all programs	The number of students enrolled in one or more LAP special programs sorted by Federal Ethnicity/Race and grade level. Note: This is an unduplicated count. Students are counted only once regardless of the number of qualifying programs they may be enrolled.	[Students]Grade_Level [Students]Fedethnicity [StudentRace]Racecd
4	Total Served	The total number of students served in each grade level as well as each Federal Ethnicity/Race.	[Students]Grade_Lev [Students]Fedethnicity [StudentRace]Racecd
5	Number of students served in each program	The number of students enrolled in one or more LAP special programs sorted by LAP program and grade level.	[Students]Grade_Level
6	Total Served	The total number of students served in each grade level as well as each LAP program.	[Students]Grade_Level
7	Specific Instructional Program	The summary of the total number of students served in each LAP program for each selected school. The number of students enrolled is sorted by grade level and gender.	[Schools]Name [Students]Grade_Level [Students]Gender
8	Total Served	The total number of students served in each grade level, gender, and school.	[Schools]Name [Students]Grade_Level [Students]Gender

Back to Top