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.
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:
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. |
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 | 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:
| [SpEnrollments]ExitCode | Text | 1 |