PALS Report

Contents

Introduction

This report creates the required file for the PALS Student Data Upload.

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 Criteria

The report selects student records based on the following criteria:

The student must not be excluded from WISE Reporting.
The student must be currently enrolled in a course that matches a Course Number specified at runtime.

School Selection Criteria

The school must not be excluded from State Reporting.

Report Input

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

Field	Description
Report Parameters	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.
Select School	Select the desired school.
PALS Assigned Division ID	Enter the division ID assigned to your division by PALS.
PALS Assigned School ID	Enter the school ID assigned to the selected School by PALS.
New School	If this is a new school, select New; otherwise, select Not New.
Principal First Name	If this is a new school, this field must contain the school principal's first name.
Principal Last Name	If this is a new school, this field must contain the school principal's last name.
Course Number for K4 Homeroom	Enter the course number of the course used to select pre-kindergarten students.
Course Number for KG Homeroom	Enter the course number of the course used to select 5-year-old kindergarten students.
Course Number for Grade 1 Homeroom	Enter the course number of the course used to select first-grade students.
Course Number for Grade 2 Homeroom	Enter the course number of the course used to select second-grade students.

Report Output

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

The PALS Student Data Upload file is a comma-separated variable (.csv) file.

Item	Data Element	Description	[Table]FieldName	Field Length
1	DivisionID	Specified at run time.	Runtime parameter	50
2	DivisionName	The division's name. This value is extracted from the start page at the District Office > District > District Info	[Prefs] where Name='districtname'	50
3	NewSchool	An indicator of whether this is a new school as specified at runtime.	Specified at run time. 0 = Not a New School 1 = New School	1
4	SchoolID	Specified at run time	Runtime parameter	50
5	SchoolName	The name of the school. This value is extracted from start page at the District Office > Schools/School Info > Select a School > Edit School.	[Schools]Name	50
6	PrincipalFirstName	The principal’s first name as specified at run time.	Runtime parameter	50
7	PrincipalLastName	The principal’s last name as specified at run time.	Runtime parameter	50
8	PrincipalEmail	The Principal’s email address. This value is extracted from the start page at the District Office > Schools/School Info > select a School > Edit School.	[Schools]PrincipalEmail	50
9	SchoolYear	The school year when the request is submitted.	The four-digit year for the fall term currently selected. For example, 2017 for the term 2017-2018.	4
10	TimeOfDay	The time of the day of the class. Not required.	Not submitted.	null
11	Grade	The grade level that the student attends. This value is extracted from start page > select student > Transfer Info > Edit Current Enrollment.	[Students]Grade_Level P is reported if [Students]Grade_Level < 0 K is reported if [Students]Grade_Level = 0 Else [Students]Grade_Level	2
12	TeacherFirstName	The teacher's first name. This value is extracted from the start page > Staff > select staff member > Information.	[Users]First_Name	50
13	TeacherLastName	The teacher's last name. This value is extracted from the start page > Staff > select staff member > Information.	[Users]Last_Name	50
14	TeacherEmail	The teacher's email address. This value is extracted from the start page > Staff > select staff member > Information.	[Users]Email_Addr	50
15	StudentFirstName	The student’s first name. This value is extracted from the start page > select student > State/Province - WI > WISEid Student Information or Demographics.	[StudentCoreFields]Pscore_Legal_First _Name OR [Students]First_Name	100
16	StudentLastName	The student’s last name. This value is extracted from the start page > select student > State/Province - WI > WISEid Student Information or Demographics.	[StudentCoreFields]Pscore_Legal_Last _Name OR [Students]Last_Name	100
17	StudentMiddleName	The student’s middle name. This value is extracted from the start page > select student > State/Province - WI > WISEid Student Information or Demographics.	[StudentCoreFields]Pscore_Legal_Middle_Name OR [Students]Middle_Name	100
18	DateOfBirth	The student’s date of birth. This value is extracted from the start page > selected student > Demographics.	[Students]DOB	mm/dd/yyyy
19	Gender	The student’s gender This value is extracted from the start page > select student > State/Province - WI > WISEdata Student Information or Demographics. Valid values: M = Male F = Female	[StudentCoreFields]Pscore_Legal_Gender OR [Students]Gender	1
20	StudentNumber	The student’s WISEid. This value is extracted from the start page > select student > State/Province - WI > WISEid Student Information.	[Students]State_StudentNumber	10
21	Hispanic	A code representing the student’s Hispanic status. This value is extracted from the start page > select student > State/Province - WI > WISEid Student Information or Demographics.	[Students]FedEthnicity 0 = The student’s ethnicity is NOT Hispanic 1 = The student’s ethnicity is Hispanic 2 = The student's ethnicity is unspecified	1
22	Race	A one- or two-digit numeric code representing the student’s race. Required. This value is extracted from the start page > select student > State/Province - WI > WISEid Student Information or Demographics.	[StudentRace]RaceCode(s) 1 is reported if RaceCode = I else 2 is reported if RaceCode = A else 3 is reported if RaceCode = B else 5 is reported if RaceCode = W else 6 is reported if RaceCode = P else 7 is reported if RaceCode = I,A else 8 is reported if RaceCode = I,B else 9 is reported if RaceCode = I,W else 10 is reported if RaceCode = I,P else 11 is reported if RaceCode = A,B else 12 is reported if RaceCode = A,W else 13 is reported if RaceCode = A,P else 14 is reported if RaceCode = B,W else 15 is reported if RaceCode = B,P else 16 is reported if RaceCode = W,P else 17 is reported if RaceCode = I,A,B else 18 is reported if RaceCode = I,A,W else 19 is reported if RaceCode = I,A,P else 20 is reported if RaceCode = A,B,W else 21 is reported if RaceCode = A,B.P else 22 is reported if RaceCode = B.W,P else 23 is reported if RaceCode = I,B.P else 24 is reported if RaceCode = I,B.W else 25 is reported if RaceCode = I,W.P else 26 is reported if RaceCode = A,W.P else 27 is reported if RaceCode = I,A,B.W else 28 is reported if RaceCode = A,B.W,P else 29 is reported if RaceCode = I,B.W,P else 30 is reported if RaceCode = I,A,W.P else 31 is reported if RaceCode = I,A,B.P else 32 is reported if RaceCode = I,A,B,W.P	5
23	DisabilityStatus	A one- or two-digit numeric code representing the student’s disability status. Required. This value is extracted from the start page > select student > State/Province - WI > WISEdata Student Information.	[S_WI_STU_X]DisabilityCode, [S_WI_STU_X]SecondaryDisability, and [S_WI_STU_X]Section504 1 is reported if [S_WI_STU_ X]DisabilityCode = N or is NULL else 4 is reported if [S_WI_STU_X]SecondaryDisability is not NULL else 5 is reported if [S_WI_STU_ X]DisabilityCode = OI Then 5 Else 6 is reported if [S_WI_STU_ X]DisabilityCode = V Else 7 is reported if [S_WI_STU_ X]DisabilityCode = H then 7 Else 8 is reported if [S_WI_STU_ X]DisabilityCode = LD Else 9 is reported if [S_WI_STU_ X]DisabilityCode = EBD Else 10 is reported if [S_WI_STU_ X]DisabilityCode = SL Else 11 is reported if [S_WI_STU_ X]DisabilityCode = OHI else 12 is reported if [S_WI_STU_ X]DisabilityCode = DB else 13 is reported if [S_WI_STU_ X]DisabilityCode = A else 14 is reported if [S_WI_STU_ X]DisabilityCode = TBI else 15 is reported if [S_WI_STU_ X]Section504 = Y else 16 is reported if [S_WI_STU_ X]DisabilityCode = SDD else 19 is reported if [S_WI_STU_ X]DisabilityCode = ID else	2