Skip to main content
Skip table of contents

022 – School Days

Introduction

This extract includes a record for each school day in the calendar for the current school year. The 022 is an Audit based extract.

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 school data is only reported for the Primary school and will not report from the Alternative School Number, except when the school number is invalid and the alternate school number (ASN) is populated and does not match another school number in the district. Then the ASN is reported as the School ID. See the School ID data element in the table below for more information.

Report Input

For help with navigation and extract generation, see Create Audit Based Extract File (015, 016, 022).

Extract Output

Each of the fields displayed in the output of the report are described below. SeeUnderstanding the Report Output Table for a definition of each column in the table.

Item #

Data Element

Description

[Table]FieldName

Field Length

Track

1

Record ID

The identifier of this record.

Always "022"

3

N

2

Record Version

The version of this record.

Always "01"

2

N

3

Record Type

One of the following record types is reported in order to indicate how to modify the state data to match data in PowerSchool. The data in this record either needs to be added to, modified in, or deleted from the state data:

  • N – New
  • E – Edit
  • D – Delete

N/A

1

N

4

Filler

N/A

N/A

2

N

5

District ID

The district number.

[Prefs]Value

[Prefs]Name=districtnumber

3

N

6

School ID

The school number.

Note: If the school number is invalid and the alternate school number (ASN) is populated and does not match another school number in the district, the ASN is reported as the School ID. If the ASN matches another school number in the district, the 022 extract will not report.

[SchoolCalendarDays]SchoolID

[S_Addtional_Days_S]School_ID

[Schools]Alternate_School_Number

4

N

7

School Year

The four-digit year that the instructional program will be operated to provide instructional services to students. This is the current full year term, as defined using the special operation. See the District Setup > Years & Terms section for more information.

[Terms]FirstDay

[Terms]LastDay

4

N

8

Instructional Program Number

The number used to uniquely identify the program within the school.

The school calendar will only report a value of 01 for the instructional program number.

Always "01"

2

N

9

Date

The date that the instructional or non-instructional event takes place.

[Calendar_day]DateValue

[S_Addtional_Days_S]Date_Value

8

Y

10

Type

Choose the event for this calendar day from the pop-up menu.

Note: Calendar Membership Types are defined under the district setup.

If more than one calendar type is required on a day then the code must defined in the district setup and be separated by a comma such as AS,CS for the Attendance Start Date and Calendar Start Date.

[Calendar_day]Type

[S_Addtional_Days_S]Type_ID

2

Y

11

Schedule (Event Duration

Enter the schedule type, such as:

  • A – Full Day
  • B – Half Day
  • C – Third of a Day

Note: Schedule name must include Full, Half or Third so that the State reported value can be determined for the day.

[Calendar_day]Bell_Shedule_ID

[S_Addtional_Days_S]Bell_Schedule_ID

3

Y

12

Membership Type

Enter 1 or 0 to assign a school membership value to students for this school day.

[Calendar_day]MembershipValue

[S_Addtional_Days_S]Membership_Value

1

Y

13

Filler

N/A

N/A

20

N

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.