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
5	Student DOB	The student's date of birth.	[Students]DOB	Numeric	10
6	Student Address	The 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