Skip to main content
Skip table of contents

Participation Rate Report


Introduction

This collection is to assist in the calculation of school, district and state level Annual Yearly Progress (AYP), test demographic checks, and student test participation calculations. This submission is a student level data file that includes all students enrolled in a district on the first day of testing. 

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.

Student Selection

The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:

  • The student and school must not be excluded from state reporting.
  • The student must have an enrollment at a school included in the report.
  • The student must be enrolled on the user defined snapshot date.
  • The student must be in grades KG to 12.

Report Input

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

Field

Description

School(s) to report

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.
  • District Wide (Default) – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The District Wide option is only available when running the report from the District Office.

Students to Include

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.

Report Snapshot Date

Enter the snapshot date the report will be run for.

Display Header?

Choose Yes or No from the pop-up menu to indicate whether the header, with the name of each field in the report, should display in the report result file.

Back to Top

Report Output

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

Item #

Data Element

Description

[Table]FieldName

Field Type

Field Length

Req

1

Alaska Student Identification Number (ASKID)

The student’s unique state assigned identifier.

[Students]State_StudentNumber

Number

10

Y

2

LocalID

The student’s district identifier.

[Students]Student_Number

Number

15

N

3

LastName

The student’s last name.

[Students]Last_Name

Text

35

Y

4

FirstName

The student’s first name.

[Students]First_Name

Text

35

Y

5

MiddleName

The student’s middle name.

[Students]Middle_Name

Text

35

O

6

Suffix

The student’s suffix

[S_AK_STU_X]Suffix

Text

8

O

7

BirthDate

The student’s birthdate.

Format: MM/DD/YYYY

[Students]DOB

Date

10

R

8

Gender

The student’s gender.

[Students]Gender

Text

1

R

9

Race

The student’s race.

[Students]Ethnicity

Text

1

R

10

SchoolID

The EED assigned school number.

[Students]SchoolID

[ReEnrollments]SchoolID

[Schools]Alternate_School_Number

[Schools]School_Number

Number

6

R

11

Grade

The student’s grade level.

Note: Grade levels restricted to 3 to 10

[Students]Grade_Level

[ReEnrollments]Grade_Level

Number

2

R

12

Disability

The student’s disability.

[S_AK_STU_X]Disability_Code

Number

2

R

13

EL_Status

The student’s LEP status.

[S_AK_STU_X]LEP

Text

2

R

14

EconDisadv

Economically disadvantaged indicator.

[S_AK_STU_X]Econ

Text

1

R

15

ActiveDuty

Indicates the student’s parent/guardian is active duty.

[S_AK_STU_X]ActiveDuty_PG

Text

1

R

16ArmedForces

Indicates whether or not the student has a parent or guardian in armed forces. The value of this field is same as ths of the ActiveDuty field. If the value of the ActiveDuty field is reported as Y, then the value of this field is also reported as Y.

Valid values:

  • Y
  • N
[S_AK_STU_X]ActiveDuty_PGOct1Text1R
17HomelessIndicates whether or not a student is homeless.[S_AK_STU_X]HomelessText1R

18

Group

The student’s group name.

[S_AK_STU_X]GroupName

Text

30

O

19

AltAssess

Is this student participating in any of the alternate assessments?

Valid values:

  • Y
  • N

[S_AK_STU_X]AlternateAssessment

Text

1

C

20

FTE

Is the student’s FTE greater than .25?

Valid values:

  • Y
  • N

[S_AK_STU_X]DualEnrolled

[S_AK_STU_X]FTE

[S_AK_STU_X]FTE2

Text

1

C

21

FAYSchool

Was this student continuously enrolled in the school for the full academic year (10/1 through 4/3)?

Valid values:

  • Y
  • N

Note: If the student override field is blank, the report calculates this element based on the student’s school enrollments.

[S_AK_STU_X]FAYSchool

[Students]EntryDate

[Students]ExitDate

[ReEnrollments]EntryDate

[ReEnrollments]ExitDate

Text

1

R

22

FAYDistrict

Was this student continuously enrolled in the district for the full academic year (10/1 through 4/3)?

Valid values:

  • Y
  • N

Note: If the student override field is blank, the report calculates this element based on the student’s school enrollments.

[S_AK_STU_X]FAY_District

[Students]EntryDate

[Students]ExitDate

[ReEnrollments]EntryDate

[ReEnrollments]ExitDate

Text

1

R

23

RAELStudent

Is this FYI/LEP student to be excluded from the Language Arts Participation?

Valid values:

  • Blank
  • Y
  • N

Blank values are reported for non-tested grades. Y/N are reported for students in grades 3-10.

[S_AK_STU_X]ExcLAPart

Text

1

C

24Grade9Algrebra

The student's Algebra I enrollment status in grade 9.

Valid values:

  • 1 - Currently Enrolled: Scheduled to complete course content during the 17-18 school year
  • 2 - Currently Enrolled: Scheduled to complete course content during the 18-19 year or later
  • 3 - Not Currently Enrolled

Note: If the student override field is blank, the report calculates a value of 1 or 3 based on a student’s course enrollment (if one exists) into a course flagged as Algebra I.

Student override field:

[S_AK_STU_X]Grade9_Algebra


[S_CRS_CRDC_X]CourseTypeAlgebraI_YN

[CC]Date_Enrolled

[CC]Date_Left

Number1C

25

Notes

Enter any comments regarding the student’s record.

[S_AK_STU_X]Record_Notes

Text

35

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.