15_StudentSecResults

Report Description

This file is used to submit student results by course section. This report produces the Student Section Results extract for current school year in a comma-delimited format.

The report translates some of the letter grades to their CodeSet values. Some of the grades are not sufficiently standardized across PowerSchool to allow mapping, and will return the letter grade, which will need to be corrected before submission.
These grades will be output with their CodeSet value:
CODE - Letter Grade in PowerSchool

10 - A+
11 - A
12 - A-
13 - B+
14 - B
15 - B-
16 - C+
17 - C
18 - C-
19 - D+
20 - D
21 - D-
22 - F
23 - P (Pass)
30 - W (Withdrawn)
31 - WP (Withdrawn - Pass)
32 - WF (Withdrawn - Fail)
40 - I or INC (Incomplete)
50 - EX or EXC (Excused)
77 - AU or AUD (Audited)
The following grades will not be mapped:
CODE - Letter Grade in PowerSchool (not standardized)
24 - Fail
25 - Failing (Very Poor Performance)
26 - Minimally Acceptable (Lowest passing grade)
27 - Acceptable (Meets some of the basic standards for the course)
28 - Good (Meets standards for the assignment or course)
29 - Outstanding (Meets the highest standards for the assignment of course)
55 - Mark is not required
66 - Ungraded Course
88 - Course in Progress
99 - Numeric Mark (only) provided for this course

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 07_SpringOfficial
SFTP Connections	Choose a selection from the pop-up menu. The default value is Disable.

Report Output

For courses that use standards-based grade scales, the color level (green, light green, yellow, orange, and red) of the proficiency grade will be output as the COURSELETTERMARK as follows:

Green outputs as 29
Light Green outputs as 28
Yellow outputs as 27
Orange outputs as 26
Red outputs as 25

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 district's SU/SD ID.	[S_VT_District_S]AdminID	String	6
2	PERMNUMBER	The student's state-assigned student ID.	[Students]State_StudentNumber	Number	10
3	ENRORGID	The student's enrolling org ID.	[S_VT_Schools_X]EnrOrgID	String	6
4	LOCALCOURSEID	The course ID used by the district or school to represent the unique course number.	[StoredGrades]Course_Number	String	55
5	COURSESECTION	Section number used for the identification of a unique occurrence of a class/staff/location.	[StoredGrades]SectionID	String	30
6	COURSELETTERMARK	Code set for student grades.	[StoredGrades]Grade	Number	2
7	COURSENUMERICMARK	A numeric value indicating the course mark achieved on a 100-point scale.	[StoredGrades]Percent	Number	3,2
8	CREDITSEARNED	The number of credits awarded to the student upon completion of the course.	[StoredGradesEarnedCrHrs	Number	2,2
9	SY	The school year.	[S_VT_District_S]SY	Number	4
10	FLEXIBLE_PATHWAYS	Flexible pathways	[S_VT_SEC_X]COURSEFLEXIBLEPATHWAYS	String	100

Back to top