Program Core Report

Contents

Introduction

Use the Program Core report to report the student-level services provided by the LEA/school.

Selection Criteria

Selection criteria determine which database records are used in the report.

School Selection

The report selects which school records to use based on the following criteria:

The school is not excluded from state reporting.
The school must be associated with a student included in the report.

Student Selection

The report selects which student records to use based on the following criteria:

The student is not excluded from state reporting.
The student's program start date is on or after the Report Start Date.

Required Data Setup

You must define the following information before generating this extract.

Exclude students from this report, Exclude from State Reporting, General tab, Start Page > Student Selection > Rhode Island State Information.
Setup Special Programs for each of the programs offered at your district. The report will only pull a program code when the actual code is entered in the Program Code (leave blank to exclude program from Program Core report) field.
Enroll the applicable students into the Special Program(s) in which they are participating.

Back to Top

Report Input

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

Data to be Filled
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. 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.
Select Students	The default option is All students. Use The xxx Selected Students to extract by a user-defined filtered student selection.
Report Start Date	Enter the beginning date in the range of dates you want to use to determine the student attendance records to include on the report.
Scheduling Options	Description
Scheduling – Run Now	Leave Run Now selected to run the report now.
Submit	Click Submit to run the report now.
Scheduling – Please Select When to run	Click the Schedule button to schedule this report to run.
Please Select Schedule Settings	Enter the Start Date and Start time. Click the Repeat button.
Please select repeat cycle options.	Choose the applicable option.
Please select end date range option	Enter the appropriate information.
Submit	Click Submit to schedule the report

Districts using the Automated Data Transfer (ADT) system may utilize the SQL script for state reporting purposes provided at the bottom of the report page.

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.

Column	Data Element	Description	[Table]FieldName	Field Type	Field Length
A	DISTCODE	This field contains the reporting district code	[Schools]District_Number	Text	2
B	SCHCODE	The five-digit RIDE ID for the school that the student attends as noted on the Edit School page, Start Page > District Setup > Schools/School Info > Edit School.	[S_RI_SCH_X]Ride_ID	Text	5
C	SASID	The student's state identification code as noted on the Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information.	[Students]State_StudentNumber	Text	10
D	LASID	The student's local school identification code as noted on the Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information.	[Students]Student_Number	Text	16
E	LASTNAME	The last name of the student as noted on the General Demographics page, Start Page > Student Selection > General Demographics, or if the legal last name is populated on the Rhode Island State Information page, Start Page > Student Selection > Rhode Island State Information.	[Students]Last_Name OR [StudentCoreFields]PSCore_Legal_Last_Name	Text	50
F	PROGRAM_CODE	The Eligible/Participating Program Code as noted on the Special Programs page, Start Page > Student Selection > Special Programs.	[SPEnrollments]ProgramID	Text	4
G	PROGRAM_SDATE	The program start date as noted on the Special Programs page, Start Page > Student Selection > Special Programs.	[SPEnrollments]Enter_Date	Date
H	PROGRAM_EDATE	The program end date as noted on the Special Programs page, Start Page > Student Selection > Special Programs.	[SPEnrollments]Enter_Date	Date
I	PROGRAM_EXIT_CODE	The program exit status as noted on the Special Programs page, Start Page > Student Selection > Special Programs. Valid Values: 1 - Completed Program 2 - Voluntary Withdrawal 3 - Involuntary Withdrawal 4 - Still Active (NOTE: If field is left blank, this code will be populated)	[SpEnrollments]ExitCode	Text	1

Back to Top