Staff Development Fact Template - RE
Contents
Introduction
This report is used to collect qualification and training data on school security officers, resource officers, and police officers. The report contains the following information for the current school year:
- The date of the most recent firearms qualification
- The date of the most recent CPR qualification
- The date of the most recent first aid qualification
- The number of hours of Municipal Police Officer's Education and Training Commission (MPOETC) training
- The number of hours of National Association of School Resource Officers (NASRO) training
- The number of hours of local training
If you do not want a particular staff member to be reported, flag the staff member with the Exclude from PIMS field on the Edit Information page.
Selection Criteria
Selection criteria determine which database records are used in the report. For the Staff Development Fact Template, staff development records are selected.
School Selection
The report selects records from the Schools table that meet the following criteria:
- The school must be associated with a staff member included in the report.
- The school must not be excluded from state reporting.
Staff Selection
The report selects staff records from the Teachers table that meet the following criteria:
- The staff member must not be excluded from state reporting.
- The staff member must have a Staff Development Fact template record with an activity start date that falls during the reporting period.
Report Input
For help with report generation and navigation, see How to Find and Generate a Report.
Field | Description |
Use | If run at the district level, choose one of the following from the pop-up menu:
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. |
Records to Include | Indicate which staff members to include in the report by selecting one of the following options:
Note: If running the report for a single staff member, or group of staff members, select the students prior to running report. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM: 05. |
Report Start Date | Enter the start date for the reporting period. |
Report End Date | Enter the end date for the reporting period. |
Field Delimiter | Select the field delimiter for the extract file. |
Show Column Field Headers | Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report. |
Run From Extract Viewer | Choose one of the following from the pop-up menu:
Note: Use the extract viewer to view and edit records before submitting the file to the state. |
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 assigned by the PDE. This field is extracted from Start Page > District Setup > District Information. | [Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number | Alpha-numeric | 9 |
2 | Staff Id | The staff member’s 7-digit PPID. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Staff Snapshot Record. This value should not be entered for non-certified staff. If the value is blank, then the staff member’s social security number is reported. | [Users]state_teachernumber [Users]SSN | Alpha-numeric | 9 |
3 | Activity Code | The type of qualification or training in which this staff member participated. This value is extracted from Start Page > Staff > Edit Information > Staff Development Fact Template Record. | [S_PA_SSF_Staff_Development_C]Activity_Code | Alpha-numeric | 8 |
4 | Activity Start Date | The date the staff member started participating in this qualification or training activity. This value is extracted from Start Page > Staff > Edit Information > Staff Development Fact Template Record. | [S_PA_SSF_Staff_Development_C]Activity_Start_Date | Alpha-numeric | 10 |
5 | Not Collected | This field is currently not collected. | N/A | N/A | N/A |
6 | Not Collected | This field is currently not collected. | N/A | N/A | N/A |
7 | Not Collected | This field is currently not collected. | N/A | N/A | N/A |
8 | Not Collected | This field is currently not collected. | N/A | N/A | N/A |
9 | Not Collected | This field is currently not collected. | N/A | N/A | N/A |
10 | Not Collected | This field is currently not collected. | N/A | N/A | N/A |
11 | Not Collected | This field is currently not collected. | N/A | N/A | N/A |
12 | Not Collected | This field is currently not collected. | N/A | N/A | N/A |
13 | Not Collected | This field is currently not collected. | N/A | N/A | N/A |
14 | Activity Hours | If the staff member participated in MPOETC, NASRO, or a Local training program, the number of hours training this staff member received in the current year. This value is extracted from Start Page > Staff > Edit Information > Staff Development Fact Template Record. | [S_PA_SSF_Staff_Development_C]Activity_Hours | Alpha-numeric | 10 |