K01 - Student Programs

Introduction

The K01 - Student Programs report extracts student program data. One record is transmitted for every student for each program activity. A student can have multiple records for different assignments within the same school and fiscal year.

Selection Criteria

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

Student Selection

The report selects records from the [Students] table that meet the following criteria:

The student is not excluded from state reporting.

Special Program Selection

The report selects records from the [SpEnrollments] table that meet the following criteria:

The special program is set up at the district with the Alternative Education Program checkbox selected.
The special program enrollment is associated with the school included in the report.
The special program enrollment entry date occurs on or after the report start date.
Students who are enrolled in the special program on the user selected report date, with an enrollment entry date before or on, and an enrollment exit date after, the report date.
The program records are then further filtered to return only those programs with start dates on or after the report date.

Report Input

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

Field	Description
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. Select schools to include in the report 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.
Current Selection Students	Run the report for the current selection of students or all students.
Report Start Date	Enter the start date of the report. Note: Enter the date in a format of MM/DD/YYYY.
Report End Date	Enter the end date of the report. Note: Enter the date in a format of MM/DD/YYYY.
File Path and File Suffix	The File Path and File Suffix must both be valid in order to save the results to a location on the server. The File Name will be the district number, date, and time, in the format dddYYYYMMDDHHmi, followed by the provided file suffix. For example a report run at district 999 on August 1, 2014 at 9:15 AM with a suffix of _AAA.txt will save the results to a file named 999201408010915_AAA.txt in the provided location. If no path is given, or if PowerSchool is unable to write to the given folder, the report will run but will not be saved to the server.
Use Withdrawal Date as One Day Before Student Exit Date	Select the checkbox to extract the last in-session day prior to the student's Exit Date.
SFTP Connections	Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically. Please refer to Setting Up an SFTP Connection for details on how to create an SFTP connection.

Back to Top

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.

The students with Dexter Mosely set as Yes in the State Information page are not included in the report output.

ID	Data Element	Description	[Table]FieldName	Length
K001	Fiscal Year	The fiscal year of the record. The report extracts the year based on the last day in the current school calendar.	[Terms]LastDay	4
K002	Period	The reporting period. Always 1.	N/A	1
K003	System Code	The school system code. This is the district number in PowerSchool.	[Prefs]Value [Prefs]Name=districtnumber	3
K004	School Code	The school code. Note: If the HomeSchool Override Number is set up, it will be used. If not, the alternate school number is reported if populated. Otherwise, the school number is reported.	[S_GA_STU_X]SchoolNumberOverrid [S_GA_REN_X]SchoolNumberOverride [Schools]Alternate_School_Number [Schools]School_Number = [SpEnrollments]SchoolID	4
Filler	Filler	Filler	N/A	9
K006	Record Type	Identifies the record layout. Always K01.	N/A	3
K007	Program Type	Identifies the type of program in which the student is enrolled.	N/A	2
K008	Program Code	The code indicating the type of program in which the student is enrolled.	[S_GA_SEN_X]ProgramCode	3
K009	Beginning Date	The date that the service was first provided for the student for the program. Note: The date should not be null for program type other than 05. The date must be null for program type 05.	[SpEnrollments]Enter_Date	8
K010	Ending Date	The date that the service ended for the program. Note: The value will be null for program type 05.	[SpEnrollments]Exit_Date	8
K011	Alternate School Number	The 4-digit school code assigned by the DOE for the alternative school or special entity school in which the student was enrolled this school year.	[S_GA_SEN_X]AltSchNumber	4
Filler	Filler	Filler	N/A	5
K012	Alternative System Code	The systems code for the alternative school assigned to the student.	[S_GA_SEN_X]AltSysCode	3
K013	Number of Daily GNET Segments	The number of GNET segments for the student per day.	[S_GA_SEN_X]GNETS_Segments	1
K014	Georgia Test Identified (GTID)	The state assigned student identifier.	[Students]State_StudentNumber	10
Filler	Filler	Filler	N/A	3
K015	Hours Offered	HOURS OFFERED identifies the number of hours a student was offered the Flexible Learning Program.	[S_GA_SEN_X]HoursOffered	4
K016	Hours Attended	HOURS ATTENDED identifies the number of hours the student attended a Flexible Learning Program.	[S_GA_SEN_X]HoursAttended	4
K017	Subject Area	Identifies academic area in which the student received FLP services for the FLP model reported.	[S_GA_SEN_X]SubjectAreaCode	2
Filler	Filler	Filler	N/A	36

Back to Top