Location Fact Safe School - AED Extract
Contents
Introduction
The Location Fact Safe School - AED Extract reports data on Automatic External Defibrillator(s) within schools. Information is captured in an Excel file, automatically creating the Location Fact template to be submitted to PIMS.
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:
If sub-districts are enabled:
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. |
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 [CST_SubDistricts]SUBDISTRICT_NUMBER If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number | Alpha-numeric | 9 |
2 | Location Code | The PDE-defined 4-digit code identifying the school. | [S_PA_SCH_X]PIMS_Location_Code | Alpha-numeric | 10 |
| 3 | Reporting Date | A single date indicating the whole school year; June 30 at the end of the standard school year is used to designate a school year; for example, the 2017-2018 school year would be indicated by 2018-06-30. | [S_PA_SCH_AED_C]YearID | Date | 10 |
| 4 | Category 1 | Description of the data element reported in this record. Always AED. | Static Value | Alpha-numeric | 40 |
| 5 | Category 2 | A unique number identifying each AED in service at the location. Valid values:
| [S_PA_SCH_AED_C]RecNo | Alpha-numeric | 40 |
| 6 | Category 3 | The overall condition of the AED. Valid values:
| [S_PA_SCH_AED_C]Condition | Alpha-numeric | 40 |
| 7 | Not collected | Not collected. | N/A | N/A | N/A |
| 8 | Not collected | Not collected. | N/A | N/A | N/A |
| 9 | Not collected | Not collected. | N/A | N/A | N/A |
| 10 | Not collected | Not collected. | N/A | N/A | N/A |
| 11 | Not collected | Not collected. | N/A | N/A | N/A |
| 12 | Not collected | Not collected. | N/A | N/A | N/A |
| 13 | Not collected | Not collected. | N/A | N/A | N/A |
| 14 | Primary Measure Type | In the PDE-provided reporting tool, this is prepopulated. Always INDICATOR | Static value | N/A | 20 |
| 15 | Not collected | Not collected. | N/A | N/A | N/A |
| 16 | Not collected | Not collected. | N/A | N/A | N/A |
| 17 | Not collected | Not collected. | N/A | N/A | N/A |
| 18 | Indicator | Indicates whether the location has AED(s) in service. | [S_PA_SCH_AED_C]Indicator_YN | Alpha-numeric | 3 |
| 19 | Not collected | Not collected. | N/A | N/A | N/A |
| 20 | Service Date | A single date indicating the school year in which the AED was placed in service. June 30th at the end of the school year is used to designate the school year. Example: The 2017-2018 school year would be indicated by 2018-06-30. | [S_PA_SCH_AED_C]Service_Date | Date | 10 |
| 21 | Inspection Expires Date | The date the current AED inspection expires. If no date has been entered, the report extracts the earliest date of expiration of any component (batteries, pads, etc.). | [S_PA_SCH_AED_C]Inspection_Expires_Date | Date | 10 |
| 22 | Placement | The location of the AED within the school. | [S_PA_SCH_AED_C]Placement | Alpha-numeric | 3000 |