Location Fact Template - Fire and Security Drill

Introduction

This report is used to report whether or not a fire drill was held at an LEA.

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.
Select School Year	Choose a school year from the pop-up menu.
Field Delimiter	Choose the field delimiter for the extract file.
Include Header Labels in output file?	Choose Yes or No from the pop up menu.

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	District Code	The unique, 9-digit Administrative Unit Number (AUN) assigned by the state.	[Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Alpha-numeric	9
2	Location Code	The PDE-defined 4-digit code identifying the school. All school location codes can be found at: https://www.education.pa.gov/Pages/Education-Directory-and-Maps.aspx A maximum of 13 records is generated per location code.	[S_PA_SCH_X]PIMS_Location_Code	Varchar2	10
3	Reporting Date	A single date indicating the whole school year.	[S_PA_SCH_FireDrill_C]SchoolYear [S_PA_DIST_FireDrill_S]SchoolYear	Number	11
4	Category 01	Indicates the data element reported in this record, in this case DRILL.	Static Value	N/A	N/A
5	Category 02	Indicates the type of drill reported in this record. FIRST DAY always = FIRE	[S_PA_SCH_FireDrill_C]Fire_Type [S_PA_DIST_FireDrill_S]Fire_Type [S_PA_SCH_FireDrill_C]Fire_Drill_FirstDay [S_PA_DIST_FireDrill_S]Fire_Drill_FirstDay	Varchar2	2
6	Category 03	Indicates the month the fire drill was reported. FIRST DAY always = blank	[S_PA_SCH_FireDrill_C]Fire_Drill_Month [S_PA_DIST_FireDrill_S]Fire_Drill_Month [S_PA_SCH_FireDrill_C]Fire_Drill_FirstDay [S_PA_DIST_FireDrill_S]Fire_Drill_FirstDay	Varchar2 Varchar2	3 1
7	Category 04	Indicates the reason(s) fire drills were not conducted. FIRST DAY always = blank	[S_PA_SCH_FireDrill_C]Fire_Drill_Reason [S_PA_DIST_FireDrill_S]Fire_Drill_Reason [S_PA_SCH_FireDrill_C]Fire_Drill_FirstDay [S_PA_DIST_FireDrill_S]Fire_Drill_FirstDay	Varchar2	2
8	NC01	Not collected.	N/A	N/A	N/A
9	NC02	Not collected.	N/A	N/A	N/A
10	NC03	Not collected.	N/A	N/A	N/A
11	NC04	Not collected.	N/A	N/A	N/A
12	NC05	Not collected.	N/A	N/A	N/A
13	NC06	Not collected.	N/A	N/A	N/A
14	Primary Measure Type	In the PDE-provided reporting tool, this is pre-populated. See the Indicator field for valid values.	Static Values.	N/A	20
15	NC07	Not collected.	N/A	N/A	N/A
16	NC08	Not collected.	N/A	N/A	N/A
17	NC09	Not collected.	N/A	N/A	N/A
18	Indicator	Indicates whether a drill was held during the month indicated in Category 03. FIRST DAY always = Y	[S_PA_SCH_FireDrill_C]Fire_Drill_Indicator_YN [S_PA_DIST_FireDrill_S]Fire_Drill_Indicator_YN [S_PA_SCH_FireDrill_C]Fire_Drill_FirstDay [S_PA_DIST_FireDrill_S]Fire_Drill_FirstDay	Varchar2	1
19	NC10	Not collected.	N/A	N/A	N/A
20	Date	The date on which the drill was conducted. If no drill was conducted, a blank is reported. FIRST DAY always = date of the first day of school.	[S_PA_SCH_FireDrill_C]Fire_Drill_Date [S_PA_DIST_FireDrill_S]Fire_Drill_Date [S_PA_SCH_FireDrill_C]Fire_Drill_Month [S_PA_DIST_FireDrill_S]Fire_Drill_Month [S_PA_SCH_FireDrill_C]Fire_Drill_FirstDay [S_PA_DIST_FireDrill_S]Fire_Drill_FirstDay	Date	N/A
21	NC11	Not collected.	N/A	N/A	N/A
22	Comment	The reason a required drill was not conducted.	[S_PA_SCH_FireDrill_C]Fire_Drill_Comment [S_PA_DIST_FireDrill_S]Fire_Drill_Comment	Varchar2	250

Back to Top