Skip to main content
Skip table of contents

N - Student Absence File 2019-2020

Introduction

The Student Absence file captures daily absence information for each student who is absent from seat-time classes. Absences from Alternative Learning and Online classes that do not require regular seat-time attendance do not have to be reported in this file. All absences from the seat-time instruction should be reported, even if the absence is due to the participation in a district or school approved or instructional program.

This file consists of one record for each student served in the district during the current school year for each absence associated with the student for each school the student is enrolled. Even when a student leaves the school associated with these absence records, these records must continue to be reported through the remainder of the school year.

Absences must be reported for students in grades K-12. If attendance is tracked for pre-school students, those absences may also be reported in this file.

PS_AdaAdm_Defaults_All - This is a reporting view. This view supports ADA/ADM calculation using default settings for all valid attendance mode and conversion mode combinations.

Selection Criteria

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

Student Selection

  • The student must have an absence within the reporting year.
  • The student must not be excluded from state reporting.
  • The student must not be excluded from CEDARS reporting.

School Selection

The report selects records from the [Schools] table that are not excluded from state reporting.

Back to Top

Report Input

For help with report navigation and generation, 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.

Current Selection Students

Indicate which students to include in the report by selecting one of the following options:

  • The Selected [Number] 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 that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running report.

Present Attendance Codes to includeSelect the attendance codes to include in the report. To include all codes, leave all blank.
School YearChoose the year for which to run the report.

Scheduling

Default is Run Now. Select Schedule to run the report on a specific date and time.

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

Reqd

Field Type

Length

N01

School Year

The four-digit year in which the school year ends.

[Terms]LastDay

Yes

Char

4

N02

Serving County District Code

The County District code for the district submitting the data.

[Prefs]Value

[Prefs]Name=districtnumber

Yes

Char

5

N03

District Student ID

The locally assigned student identifier.

[Students]Student_Number

Yes

VarChar

50

N04

State Student ID (SSID)

The identifier assigned to each WA public school student by OSPI.

Rule: This field is not required if the student has not yet been assigned an SSID.

[Students]State_StudentNumber

Con

Char

10

N05

Location ID

The Location ID for the school. The school number is reported.

[Schools]School_Number

Yes

VarChar

4

N06

Absence Date

The date the absence occurred.

[Calendar_Day]Date

Yes

Date

10

N07

Absence Code

This element indicates the Excused/Unexcused status and the amount of the day of the absence.

  • ATN is used to calculate the following valid values:
  • EF – Excused Full Day Absence
  • UF – Unexcused Full Day Absence
  • EP – Excused Part Day Absence
  • UP – Unexcused Part Day Absence

Calculated.

Yes

VarChar

2

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.