05_PS_GradeProg

Contents

Report Description

This file is used to submit student grade progression. This report produces the student grade progress extract for all currently enrolled students in a comma-delimited format.

Note: For the DC04 collection, all promoted students that are expected to remain in your school in the fall, the 05_PS_GradeProg report contains two records -one row for the current grade with GRADEBEGIN and GRADEEND(EOY) and one for the future grade with GRADEBEGIN only. For students that have been retained, there is only one record with current grade and GRADEBEGIN and no GRADEEND date. For students who are exiting after the current year, there is one record with GRADEBEGIN and GRADEEND date for the current year. All other collections do not have this business rule.

The 05_PS_GradeProg should be run after EOY / End of Term date but before the EOY process for the DC04. All extracts in the DC04, except PS_Enroll, should be run prior to EOY.

Community Help for DC04 Collection - PowerSchool SIS Vermont State Reporting – July 202... - PowerSchool Community

Report Input

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

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Select Students	Choose one of the following: The Selected [x] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district.
File Path	Enter the file path. If applicable, select the associated checkbox to save as the default value.
Data Collection Name	Choose the applicable Data Collection from the pop-up menu. 03_NightlyCollection_Unofficial 04_YearEndCollection_Official 06_Fall_ADM_Official 07_SpringOfficial
SFTP Connections	Choose a selection from the pop-up. The default value is Disable.

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.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	ADMINID	The SU/SD ID.	[S_VT_District_S]ADMINID	String	6
2	ENRORGID	The school's enrolling org ID issued by the AOE.	[S_VT_Schools_X]ENRORGID	String	6
3	PERMNUMBER	The student's state-assigned student ID.	[Students]State_StudentNumber	Number	10
4	GRADE	The student's grade. Note: when stu.grade_level = 0 and 'FT' then 'KF' when stu.grade_level = 0 then 'KP' when stu.grade_level < 0 and IEP ='Y' then 'EE' when stu.grade_level < 0 then 'PK' when stu.grade_level = 13 then 'AW' in all other cases stu.grade_level	[Students]Grade_Level	String	2
5	GRADEBEGIN	The date the student began their grade level. Note: Format MM/DD/YYYY	Calculated	Date	N/A
6	GRADEEND	The date the student ended their grade level. Note: Format MM/DD/YYYY	Calculated [Students]EXITDATE - 1 in session day	Date	N/A
7	SY	The school year.	[S_VT_District_S]SY	Number	4

Back to top