Skip to main content
Skip table of contents

PA State Auditors Report – HTML

Contents

Introduction

This report generates the Pennsylvania State Auditor Report in HTML format, and runs for all students enrolled in a school or an entire district during the date range specified. The PA Auditor report is developed as a report to be shared with a State Auditor when an LEA is in the process of being audited. Data from this report may also be used for other internal purposes.

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 various tables based on the following criteria:

  • The student is not excluded from state reporting.
  • The school is not excluded from state reporting.
  • The student has an active school enrollment during the reporting period.
  • The student’s school enrollment is not excluded from state reporting.
  • The student’s school enrollment is not a no-show record; i.e. the entry date is different from the exit date.

Report Input

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

Field

Description

Select Schools

Indicate which schools to include in the report by selecting from the following options:

If sub-districts are not enabled:

  • Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria.
  • All Schools (default) – Run the report for all schools. Includes all student records on the PowerSchool server that meet the selection criteria

If sub-districts are enabled: 

  • Select Sub-district - Select the sub-district for which you want to run the report.
  • Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria.
  • All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Students to include

Choose to run the report for selected students or All Students.

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

Report Start Date

Enter the start date for the reporting period.

Report End Date

Enter the end date for the reporting period.

Use Tracks

If your school or district uses tracks, select Yes or No to indicate whether to include tracks in the report output.

Scheduling

Select when to run the report.

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

Field Type

Field Length

1

Student Number

The local Student Number assigned to the student by the school

[Students]Student_Number

Float

126

2

State Student Number

The unique, 10 digit PAsecureID assigned to the student

[Students]State_StudentNumber

Alpha-numeric

32

3

Student Name

The student’s name in the format last name, first name.

[Students]LastFirst

Alpha-numeric

135

4

Student Gender

The student's gender.

[Students]Gender

Alpha-numeric

2

5Student DOBThe student's date of birth.

[Students]DOB

Numeric10
6Student AddressThe student's postal mailing address.

When stu.Street is not null then stu.Street||' '|| stu.City||', '|| stu.State ||' '||stu.Zip

WHen stu.Street is null and Coalesce(stu.Mailing_Street,stu.Mailing_City,stu.Mailing_State,stu.Mailing_Zip) is not null then stu.Mailing_Street||' '|| stu.Mailing_City||', '|| stu.Mailing_State ||''|| stu.Mailing_Zip else null end as stuaddress

Alpha-numeric

MAILING_CITY(50)
MAILING_STREET(60)
MAILING_STATE(2)
MAILING_ZIP(10)

7

Student Ethnicity

The student's race and ethnicity.

[StudentRace]RaceCD

[Students]FedEthnicity

Alpha-numeric

Numeric

20

10


8

School Number

The internal identifier for the school where the student was enrolled during the reporting period.

[Students]SchoolID

[ReEnrollments]SchoolID

Numeric

10

9

School Name

The name of the school in which the student was enrolled during the reporting period.

[Schools]Name

Alpha-numeric

60

10

Track

Represents the times in the year the student went to school during the reporting period.

[Students]Track

[ReEnrollments]Track

Alpha-numeric

20

11

Resident

The student's residence code.

[S_PA_STU_X]PIMS_Residence_Code

[S_PA_REN_X]PIMS_Residence_Code

Alpha-numeric

4

12

District of Residence

The student's district of residence

[Gen]Cat='districts' and [Gen]value=[Students]DistrictofResidence

[Gen]cat='districts' and [Gen]value=[ReEnrollments]DistrictofResidence

Alpha-numeric

15

13

Residence Status Code

The student's PIMS residence status code:

  • A – resident (includes 1302 guardianship and resident foster children)
  • B – 1305: non-resident foster child, resident foster parent
  • C – 1305: non-resident foster child, non-resident foster parent
  • D – 1306: institutionalized non-resident, unknown district of residence
  • E – 1306: institutionalized non-resident, unknown district of residence – detention
  • F – 1306: institutionalized non-resident acknowledged
  • G – non-resident district paid tuition
  • H – non-resident parent paid tuition
  • I – non-resident tuition waiver in state
  • J – non-resident OOS
  • K – Act 6 Philadelphia City SD only

[S_PA_STU_X]PIMS_Residence_Status_Code

[S_PA_REN_X]PIMS_Residence_Status_Code

Alpha-numeric

1

14

Economically Disadvantaged

Indicates whether the student is economically disadvantaged.

  • 1 = Yes
  • blank = No

[S_PA_STU_X]EconomicDisadvantage_TF

[S_PA_REN_X]EconomicDisadvantage_TF

Numeric

1

15

Migrant

Indicates whether the student meets the criteria for a migrant student.

  • 1 = Yes
  • blank = No

[S_PA_STU_X]Migrant_TF

[S_PA_REN_X]Migrant_TF

Numeric

1

16

English Language Learner

Indicates whether the student is eligible to participate in an English Language Learner (ELL) program.

  • 1 = Yes
  • blank = No

[S_PA_STU_X]ELL_TF

[S_PA_REN_X]ELL_TF

Numeric

1

17

Special Education

Indicates whether the student is eligible to participate in a Special Education program. This value is extracted from Start Page > Student > Transfer Info > Edit Enrollment.

  • 1 = Yes
  • blank = No

[S_PA_STU_X]IS_SPED_Student_YN

[S_PA_REN_X]IS_SPED_Student_YN

Alpha-numeric

1

18

AVTS Program

Indicates whether the student is in an Area Vocational Technical School program.

[S_PA_STU_X]AVTSProgram_TF

[S_PA_REN_X]AVTSProgram_TF

Numeric

1

19

IU Inclusion

Indicates whether the student is included in an Intermediate Unit.

[S_PA_STU_X]IUInclusion_TF

[S_PA_REN_X]IUInclusion_TF

Numeric

1

20

Grade Level

The student's grade level.

[Students]Grade_Level

[S_PA_STU_X]State_Grade_Code

Numeric

10

21

Elem or Sec

Indicates whether the student is an elementary or secondary student.

[Students]Grade_Level

[S_PA_STU_X]State_Grade_Code

Numeric

10

22

Days in Session

Derived from the calendar in-session days. Takes Tracks into consideration if tracks are assigned to the student.

Derived



23

Enrollment Entry Date

Student’s entry dates for the current school year.

[Students]EntryDate

[ReEnrollments]EntryDate

Date


24

Enrollment Entry Code

Student entry codes for the current school year.

[Students]EntryCode

[ReEnrollments]EntryCode

Alpha-numeric

10

25

Enrollment Exit Date

Students exit dates for the current school year.

[Students]ExitDate

[ReEnrollments]ExitDate

Date


26

Enrollment Exit Code

Student exit codes for the current school year.

[Students]ExitCode

[ReEnrollments]ExitCode

Alpha-numeric

10

27

Percentage of Time Enrolled for Calendar

The percentage of time the student is enrolled in a calendar.

[S_PA_STU_X]Calendar_Enrolled_Time_Percent

[S_PA_REN_X]Calendar_Enrolled_Time_Percent

Numeric

11

28

State Calendar Code

Provides additional context for calendars created by LEAs for students in certain special situations.

[S_PA_Calendar_S]Calendar_Program_Code

Alpha-numeric

8

29

Calendar ID

A unique number used to identify this calendar.

[S_PA_STU_X]Calendar_ID

[S_PA_REN_X]Calendar_ID

Numeric

11

30

First Day of Period

The student's entry date.

If the student's entry date is less than the report start date, the report start date is used.

[Students]EntryDate

[ReEnrollments]EntryDate

Date


31

Last Day of Period

The student's exit date.

If the student's exit date is greater than the report end date, the report end date is used

If the exit date is greater than the entry date then the value for the last day of the reporting period is the exit date minus 1.

[Students]ExitDate

[ReEnrollments]ExitDate

Date


32

Resident Days Membership for Period

Days enrolled for resident students

Derived

N/A

N/A

33

Non-Resident Days Membership for Period

Days enrolled for non-resident students

Derived

N/A

N/A

34

Total Days Membership for Period

Days enrolled for the student

Derived

N/A

N/A

35

Days Present for Period

The student's ADA - Present

Derived

N/A

N/A

36

Days Absent for Period

The student's ADA - Absent

Derived

N/A

N/A

37

ADA for Period

The student's ADA divided by their ADM

Derived

N/A

N/A

38

ADM for Period

The student's ADM

Derived

N/A

N/A

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.