Location Marking Period (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.
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. |
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.
Note: NY_Marking_Periods is a virtual table. See Virtual Tables for more information.
Item # | Data Element | Description | [Table]FieldName | Max Length |
|---|---|---|---|---|
1 | District Code | The district number. | [If Pref NY_CHARTER_NP = 0 then 'NY' concatenated with Pref NY_BEDS_CODE If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X]DistrictLocationCode is blank then '8' concatenated with Pref NY_BEDS_CODE If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X]DistrictLocationCode is not blank then '8' concatenated with [S_NY_SCH_X]DistrictLocationCode | 8 |
2 | Location Code | The local BOCES building code. | [S_NY_SCH_X] BOCESBuilding | 12 |
3 | Marking Period Code | A code from the marking period number table. If the term associated with the marking period code is in the 2015-2016 school year or earlier, the report extracts the value from the "Marking Period Code" field defined for the appropriate NY Marking Period via Start Page > District Setup > Schools/School Info > Edit School > Edit Marking Period Information. If the term associated with the marking period is in the 2016-2017 school year or beyond, the report extracts the value from the "Marking Period number" field on the Start Page > School Setup > Final Graded/Reporting Term Setup > New Final Grade page for each school. | [S_NY_TRB_X]Marking_Period_Number (Used when the term is in the 2016-2017 school year and later.) [NY_MarkingPeriods]user_defined_text (Used when the term is in the 2015-2016 school year and earlier.) | 3 |
4 | School Year Date | The report extracts June 30th of the school year chosen at report runtime. For example, report 2019-06-30 for 2018-2019. | N/A | 10 |
5 | Marking Period Start Date | The first day of the marking period. The report extracts the value from the "Starting Date" field via Start Page > School Setup > Final Grade Setup. The report chooses a final grade with a matching NY Marking Period defined via Start Page > District Setup > Schools/School Info > Edit School > Edit Marking Period Information. | [TermBins]Date1 | 10 |
6 | Marking Period End Date | The last day of the marking period. The report extracts the value from the "Ending Date" field for the appropriate final grade setup, as described for the previous field. | [TermBins]Date2 | 10 |
7 | Description | Not reported | N/A | 30 |
8 | Term Code | The term the course is offered. | [S_NY_TRB_X]Term_Code (Used when the term is in the 2016-2017 school year and later.) [NY_MarkingPeriods]Term_Code (Used when the term is in the 2015-2016 or earlier.) | 20 |
9 | Instructional Days | Not Reported | N/A | N/A |
10 | Instructional Minutes | Not Reported | N/A | N/A |
11 | Location Term Category | Not Reported | N/A | N/A |
12 | School Day Minutes | Not Reported | N/A | N/A |
13 | Days in Session | Not Reported | N/A | N/A |