Update Student Program Fields Report

Introduction

This report copies data from CALPADS Program fields to the following new fields in the [Students] table:

504 Accommodation Plan (Program 504)
Opportunity (Program 108)
Title I Targeted (Program 122)
Gifted and Talented (Program 127)
Migrant (Program 135)
Primary Disability (Program 144)

The data is transferred from the CALPADS [S_CA_STU_CALPADSPrograms_C] table to the [Students] table to make the data easily accessible in the database and to reduce double-entry. The report includes both active and inactive students.

The report can be run for all students or a selection of students. The report can be run for a school or the entire district.

Selection Criteria

Student and Program Selection

The report selects records from the [Students] and [S_CA_STU_CALPADSPrograms_C] tables based on the following criteria:

The student must have a Program record for one of the following program codes: 101, 108, 122, 127, 135, or 144.
The Program Membership End Date must be blank or the Program Membership End Date must occur after the current date.
The Program Membership Start Date must occur on or before the current date.
The Program Membership Start Date must not be blank.

Report Input

This report is run at the District and School level.

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

Field

Description

Students to Include

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.

Programs to Update

(leave blank for all)

Choose one or more programs to update on the student table. Please blank to run for all the programs.

(101) 504 Accommodation Plan
(108) Opportunity
(122) Title I Targeted
(127) GATE
(135) Migrant
(144) Special Ed Primary Disability
(190) Foster Program
(191) Homeless Program
(192) Armed Forces Family Member
(193) Tribal Foster Youth

Report Mode

Choose one of the following from the pop-up menu:

1. See proposed updates – Choose this option to preview the new values for the student program fields. It is recommended to use this option before writing changes to the database.
2. Write changes to the database – Choose this option to update the values for the student program fields in the database. This option also includes an output file with the updated values.

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.

Note: If the report is run for a subset of programs, only the fields pertaining to the programs selected will be displayed.

Report Output Format: The report output format for this report is html.

Data Element	Description	[Table]FieldName
School Name	The student’s school.	[Students]SchoolDCID [Schools]Name
Student ID	The internal ID of the student.	[Students]ID
Student Number	The locally assigned student number.	[Students]Student_Number
New 504 Plan*	The value to be replaced in the 504 Accommodation Plan field. 1 = Yes – If the student has an active CALPADS 101 program, the student 504 Accommodation Plan field will be set to 1. Blank = No – If the student does not have an active CALPADS 101 program or the student is inactive, the student 504 Accommodation Plan field will be set to blank.	[S_CA_STU_X]SpEd504 [S_CA_STU_CALPADSPrograms_C]ProgramCode = 101 [S_CA_STU_CALPADSPrograms_C]StartDate <= current date [S_CA_STU_CALPADSPrograms_C]EndDate > current date or blank
New Opportunity*	The value to be replaced in the Opportunity field. 1 = Yes – If the student has an active CALPADS 108 program, the student Opportunity field will be set to 1. Blank = No – If the student does not have an active CALPADS 108 program or the student is inactive, the student Opportunity field will be set to blank.	[S_CA_STU_X]Opportunity [S_CA_STU_CALPADSPrograms_C]ProgramCode = 108 [S_CA_STU_CALPADSPrograms_C]StartDate <= current date [S_CA_STU_CALPADSPrograms_C]EndDate > current date or blank
New Title I Targeted*	The value to be replaced in the Title I Targeted field. 1 = Yes – If the student has an active CALPADS 122 program, the student Title I Targeted field will be set to 1. blank = No – If the student does not have an active CALPADS 122 program or the student is inactive, the student Title I Targeted field will be set to blank.	[S_CA_STU_X]TitleI_Targeted [S_CA_STU_CALPADSPrograms_C]ProgramCode = 122 [S_CA_STU_CALPADSPrograms_C]StartDate <= current date [S_CA_STU_CALPADSPrograms_C]EndDate > current date or blank
New GATE*	The value to be replaced in the GATE field. 1 = Yes – If the student has an active CALPADS 127 program, the student GATE field will be set to 1. blank = No – If the student does not have an active CALPADS 127 program or the student is inactive, the student GATE field will be set to blank.	[S_CA_STU_X]GATE [S_CA_STU_CALPADSPrograms_C]ProgramCode = 127 [S_CA_STU_CALPADSPrograms_C]StartDate <= current date [S_CA_STU_CALPADSPrograms_C]EndDate > current date or blank
New Migrant*	The value to be replaced in the Migrant field. 1 = Yes – If the student has an active CALPADS 135 program, the student Migrant field will be set to 1. blank = No – If the student does not have an active CALPADS 135 program or the student is inactive, the student Migrant field will be set to blank.	[S_CA_STU_X]MigrantEd [S_CA_STU_CALPADSPrograms_C]ProgramCode = 135 [S_CA_STU_CALPADSPrograms_C]StartDate <= current date [S_CA_STU_CALPADSPrograms_C]EndDate > current date or blank
New Primary Disability	The value to be replaced in the Primary Disability field. If the student has an active CALPADS 144 program, the student's Primary Disability field will be set to the same value as the CALPADS Primary Disability. If the student does not have an active CALPADS 144 program or the student is inactive, the student's Primary Disability field will be set to blank.	[S_CA_STU_X]PrimaryDisability [S_CA_STU_CALPADSPrograms_C]ProgramCode = 144 [S_CA_STU_CALPADSPrograms_C]StartDate <= current date [S_CA_STU_CALPADSPrograms_C]EndDate > current date or blank [S_CA_STU_CALPADSPrograms_C]PrimaryDisabilityCode