Marking Period Code (SFTP)

Introduction

This report includes a record for each Location Marking Period for the particular school and school year.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Selection

The report selects records from the [S_NY_TRB_X] table based on the following criteria:

The NY Marking Period must be assigned a name that matches the name of a final grade setup, such as S1.
The NY Marking Period must be assigned to a school included in the report.
The NY Marking Period must be assigned to the school year included in the report.

Report Input

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

Field

Description

Display Header

Choose Yes or No from the pop-up menu to indicate whether to display the header (data element name) for each column in the report output, as well as to display additional fields used to audit the data in the report.

SFTP connections

Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically.

Please refer to the System Administrator portion of the PowerSchool Administrator User Guide for details on how to create an SFTP connection for use with this new report parameter.

Note: Remote connection requires PowerSchool 7.1.4 or higher.

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.

Item #	Data Element	Description	[Table]FieldName	Max Length
1	Marking Period Code	A code from the marking period number table. For full-year courses, use codes that begin with "0." For 1^st semester courses, use codes that begin with "1." For 2^nd semester courses, use codes that begin with "2," and so on for 3^rd and 4^th semester courses. For summer school courses, use codes that begin with "9." The report extracts the value from the Marking Period Number field defined for the appropriate NY Marking Period via School > School Setup > Final Grade/Reporting Term Setup.	[S_NY_TRB_X]Marking_Period_Number	3
2	School Year Date	The report extracts June 30^th of the school year chosen at report runtime. For example, report 2019-06-30 for 2018-2019.	N/A	10
3	Marking Period Name	The marking period name. Note: If the marking period name is not supplied, the marking period code is used as a default.	Not reported	N/A
4	Marking Period Description	The marking period description. Note: If the marking period description is not supplied, the marking period code is used as a default.	Not reported	N/A
5	Marking Period Category	Not reported	N/A	N/A
6	Marking Period Sort Sequence	Not Reported	N/A	N/A
7	Term Code	The term that the marking period is associated with. Values are as follows: 0Term 0 1Term 1 2Term 2 3Term 3 4Term 4 5Term 5 6Term 6 7Term 7	[S_NY_TRB_X]Term_Code	20
8	Term Description	Not reported	N/A	N/A
9	Term Category	Not reported	N/A	N/A
10	Term Sort Sequence	Not reported	N/A	N/A
11	Term Marking Period Description	Not reported	N/A	N/A
12	Marking Period ID	Not reported	N/A	N/A
13	Term ID	Not reported	N/A	N/A
14	Alternate Marking Period Description	Not reported	N/A	N/A

Back to Top