Staff Snapshot Template
Contents
Introduction
This report is used to reflect the current employee situation - there is only one LEA record for each professional employee, even if the employee has worked in more than one location within the LEA for a given collection period.
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 staff member must be enrolled in a school that the report is run for.The staff member cannot be excluded from state reporting.The staff member must be in a school building that is included in state reports.
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 staff 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/2017 @ 10 AM : 05. |
Report End Date | Choose the final day to report. |
Run Snapshot Extract (Reports End Date above) | Choose Yes to extract data from only the report end date. Notes:
|
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. |
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 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
4 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
5 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
6 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
7 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
8 | Job Description | The level of access that should be granted in the PVAAS Roster Verification system for this school year. | [S_PA_USR_X]Job_Description | Alpha-numeric | 3 |
9 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
10 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
11 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
12 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
13 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
14 | Location Code | The 4-digit PDE defined school number. This field is extracted from the PIMS location code on the Edit School page at the district level. If that field is blank, then the School Number is reported. | [S_PA_SCH_X]PIMS_Location_Code or [Users]SchoolID If sub-districts are enabled: [CST_SchoolSubDistricts]SchoolID | Alpha-numeric | 4 |
15 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
16 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
17 | Staff Employment Type Code | Indicates if the staff member is full or part time. This field is extracted from Start Page > Staff Selection > Edit Information > Template and Staff Snapshot Record. | [S_PA_USR_X]Staff_Type_Code | Alpha-numeric | 1 |
18 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
19 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
20 | Gender Code | The staff member’s gender. This field is extracted from Start Page > Staff Selection > Edit Information. | [UsersCoreFields]Gender | Alpha-numeric | 1 |
21 | Race or Ethnicity Code | This field is calculated based on the entry in the Federal Ethnicity and Race fields on the Edit Staff Information page, Start Page > Staff Selection > Edit Information. | [TeachersRace]RacecD | Numeric | 1 |
22 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
23 | Home Phone | The staff member’s home phone number. This field is extracted from Start Page > Staff Selection > Edit Information. | [Users]Home_Phone | Alpha-numeric | 14 |
24 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
25 | Address 1 | The staff member’s street address. This field is extracted from Start Page > Staff Selection > Edit Information. | [Users]Street | Alpha-numeric | 40 |
26 | Address 2 | The second line of the staff member’s street address, if applicable. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Address_2 | Alpha-numeric | 40 |
27 | City | The staff member’s residential city. This field is extracted from Start Page > Staff Selection > Edit Information. | [Users]City | Alpha-numeric | 30 |
28 | State | The staff member’s residential state. This field is extracted from Start Page > Staff Selection > Edit Information. | [Users]State | Alpha-numeric | 2 |
29 | Full Zip Code | The staff member’s residential zip code. This field is extracted from Start Page > Staff Selection > Edit Information. | [Users]Zip | Alpha-numeric | 10 |
30 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
31 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
32 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
33 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
34 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
35 | Current Service Date | The staff member’s date of hire for the position being reported. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Current_Service_Date | Numeric | 10 |
36 | Exit Date | The date the staff member ended employment. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Exit_Date | Numeric | 10 |
37 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
38 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
39 | Years Experience | The total number of years the staff member worked in one or more education institutions. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Years_Experience | Alpha-numeric | 2 |
40 | Birth Date | The birth date of the staff member. This field is extracted from > Staff > Select A Staff Member > Edit Information>DOB. | [UsersCoreFields]dob | Numeric | 10 |
41 | Active/Inactive Indicator | Indicates if the staff member is currently active, terminated or on leave. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Active_Status_Code | Alpha-numeric | 1 |
42 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
43 | Years Experience in District | The total number of years the staff member worked for the reporting LEA. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Years_Experience_In_District | Alpha-numeric | 2 |
44 | Job Class Code Long | The nature and degree of the staff member’s participation in the work force. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Job_Class_Long_Code | Alpha-numeric | 4 |
45 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
46 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
47 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
48 | Staff Qualification Status Code | Indicates the staff member’s role as part of the security team in the school district. | [S_PA_SSF_X]Staff_Qual_Status_Code | Alpha-numeric | 3 |
49 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
50 | Snapshot Date | The reporting period date for the staff record. This is the report end date entered when running the report. | N/A | Numeric | 10 |
51 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
52 | Annual Salary | The salary or wage (in whole dollars) that the staff member is paid before deductions. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Annual_Salary | Numeric | 10 |
53 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
54 | Termination Code | The primary reason for the termination of the staff member’s employment. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Termination_Code | Alpha-numeric | 2 |
55 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
56 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
57 | Alternate Staff ID | The identifier assigned to the staff member by the LEA. This field is extracted from Start Page > Staff Selection > Edit Information. | [Users]TeacherNumber | Alpha-numeric | 20 |
58 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
59 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
60 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
61 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
62 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
63 | Local Contract | Indicates if the staff member has a contract or is working without a contact. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Local_Contract_TF | Alpha-numeric | 1 |
64 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
65 | First Name Long | The first name of the staff member. If the First Name Long field is populated on the Staff Template/Snapshot Information page, then that value is reported. Otherwise, the value is reported from the Edit Information staff page. | [Users]First_Name [S_PA_USR_X]First_Name_Long | Alpha-numeric | 60 |
66 | Last Name Long | The last name of the staff member. If the Last Name Long field is populated on the Staff Template/Snapshot Information page, then that value is reported. Otherwise, the value is reported from the Edit Information staff page. | [Users]Last_Name [S_PA_USR_X]Last_Name_Long | Alpha-numeric | 60 |
67 | Name Suffix | The staff member’s name suffix. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Name_Suffix | Alpha-numeric | 10 |
68 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
69 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
70 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
71 | Highest Degree Institution Code | The staff member’s formal instruction. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]High_Degree_Institution_Code | Alpha-numeric | 4 |
72 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
73 | Address 3 | The apartment, room, or suite number of the staff member’s residential address. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Address_3 | Alpha-numeric | 40 |
74 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
75 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
76 | E-mail Address | The staff member’s email address. This field is extracted from Start Page > Staff Selection > Edit Information. | [Users]Email_Addr | Alpha-numeric | 80 |
77 | Middle Name | The middle name of the staff member. If the Middle Name field is populated on the Staff Template/Snapshot Information page, then that value is reported. Otherwise, the value is reported from the Edit Information staff page. | [Users]Middle_Name [S_PA_USR_X]Middle_Name_Long | Alpha-numeric | 60 |
78 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
79 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
80 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
81 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
82 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
83 | Employment Eligibility Verification | The identification document with photograph furnished by the staff member to be legally employed in the United States. This field is extracted from Start Page > Staff Selection > Edit Information > Staff Template and Snapshot Record. | [S_PA_USR_X]Employ_Eligibility_Verif_Code | Alpha-numeric | 4 |
84 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
85 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
86 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
87 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
88 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
89 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
90 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
91 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
92 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
93 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
94 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
95 | Authorized to Carry Weapon Indicator | Indicates (1 or blank) if the staff member is authorized to carry a weapon in your school district. | [S_PA_SSF_X]Authorized_Carry_Weapon_TF | Numeric | 1 |
96 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
97 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
98 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
99 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
100 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
101 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
102 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
103 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
104 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
105 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
106 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
107 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
108 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
109 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
110 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
111 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
112 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
113 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
114 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
115 | Not Collected | A blank placeholder is extracted. | N/A | N/A | N/A |
116 | Gender Identity | The personal conception of an individual's gender. Valid values:
| [S_PA_USR_X]Gender_Identity | Alpha-numeric | 30 |