Day Calendar Extract (SFTP)

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.

Display Headers

Choose Yes or No from the pop-up menu to indicate whether to display the name of each field included in the extract.

Start Date

Enter the start date for the report.

End Date

Enter the end date for the report.

Generate records from*

Select whether you want the extract to pull all of the data from the District Calendars or School Calendars.

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.

1

District Code

Public school districts: NYnnnnnn

(NY followed by the first 6 digits of the BEDS code)

Charter and nonpublic schools, State agencies, State-operated schools, AND child care institutions with schools: 8nnnnnnn

(8 followed by the last 7 digits of their Institution code)

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

Yes

8

2

Location Code

Building code used by the Data Warehouse, uniquely identifying the building, typically assigned by the local student management system.

[S_NY_SCH_X]BOCESBuilding

Yes

6

3

School Year Date

June 30 of the reporting school year. Ex: 2012–13 =  2013-06-30

N/A

Yes

6

4

School Date

Calendar date during school year.

[Districtcalendarday]datevalue

Yes

10

5

Location Grade Level

If the school calendar differs by grade level within a location, report one record for each grade level, otherwise use "AL".

[nydistrictcalendar]grade

If [nydistrictcalendar]grade = ‘99’ Then ‘AL’

Yes

2

6

Duration

N/A

N/A

No

5,3

7

Day Type

If the value of [Gen]Value ( where [Gen]cat is 'dailymembtypes' and [Gen]id equals [Districtcalendarday] type )

is below:

• 'I' - 'Instructional day'
• 'T' - 'Teacher only day'
• 'H' - 'Holiday'
• 'M' - 'Make-up day'
• 'W' - 'Weather day'
• 'LE' - 'Late Arrv/Early Dism'
• 'E' - 'Emergency Day'
• 'S' - 'Strike'
• 'O' - 'Other'
• 'R' - 'Instructional Day'
• 'RH' - 'Holiday'
• 'RT' - 'Regents-Attendance Taken'
• 'RN' - 'Regents-Attendance Not Taken'
• 'SC' - 'Superintendent Conference Full Day'

Otherwise:

• If [Districtcalendarday]Insession = ‘1’ - 'Instructional Day'
• If [Districtcalendarday]Insession = ‘0’ - 'Other'

No

20

8

Day Status

Not reported

N/A

No

40

9

Day Number

Not reported

N/A

Yes

4,0

10

School Month Number

Not reported

N/A

Yes

3,0

11

School Month Name

Not reported

N/A

Yes

30

12

Instructional Minutes

Not reported

N/A

Yes

4,0