Skip to main content
Skip table of 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.  



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 ConnectionsChoose 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



Field Type

Field Length



String 6
2ENRORGIDThe school's enrolling org ID issued by the AOE.[S_VT_Schools_X]ENRORGID String6
3PERMNUMBERThe student's state-assigned student ID.[Students]State_StudentNumberNumber10

The student's grade.


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  


The date the student began their grade level.

Note: Format MM/DD/YYYY


The date the student ended their grade level.

Note: Format MM/DD/YYYY


[Students]EXITDATE - 1 in session day

7SYThe school year.[S_VT_District_S]SYNumber4

Back to top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.