PA PIMS Report - Staff Or Staff Snapshot
The following table lists the position, data item, description, length, and location of the data.
Position | Data Item | Description | Length | Location |
---|---|---|---|---|
1 | District Code | The unique, nine-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education (PDE). | Numeric(9) | hrmstate.state2 (first 9 characters) |
2 | Staff ID | A unique identifier for each staff member. Use the seven-digit Professional Personnel ID (PPID) for all certified and non-certified staff. Do not use leading zeros or spaces. | Numeric(7) | pa_pims_mnt.ppid |
3 | Social Security Number | The nine-digit number of identification assigned to the individual by the Social Security Administration. Omit dashes. | Numeric(9) | pa_pims_mnt.ssn |
4 | Not Used | Not Applicable | Not Applicable | Not Applicable |
5 | Not Used | Not Applicable | Not Applicable | Not Applicable |
6 | Not Used | Not Applicable | Not Applicable | Not Applicable |
7 | Not Used | Not Applicable | Not Applicable | Not Applicable |
8 | Job Description | The level of access that should be granted in the Pennsylvania Value-Added Assessment System (PVAAS) Roster Verification System for this school year. Valid values:
| Char(3) | pa_pims_mnt.pvaas_role |
9 | Not Used | Not Applicable | Not Applicable | Not Applicable |
10 | Not Used | Not Applicable | Not Applicable | Not Applicable |
11 | Not Used | Not Applicable | Not Applicable | Not Applicable |
12 | Not Used | Not Applicable | Not Applicable | Not Applicable |
13 | Not Used | Not Applicable | Not Applicable | Not Applicable |
14 | Location Code | The PDE-defined, four-digit school code identifying the staff member's primary school of employment. | Numeric(4) | pa_pims_mnt.location |
15 | Not Used | Not Applicable | Not Applicable | Not Applicable |
16 | Not Used | Not Applicable | Not Applicable | Not Applicable |
17 | Staff Employment Type Code | Indicates whether an individual is employed for a standard number of hours (as determined by civil or organizational policies) in a week, month, or another period. Valid Values:
| Char(1) | pa_pims_mnt.part_time |
18 | Not Used | Not Applicable | Not Applicable | Not Applicable |
19 | Not Used | Not Applicable | Not Applicable | Not Applicable |
20 | Gender | The employee's gender. | Char(1) | pa_pims_mnt.sex |
21 | Race or Ethnicity Code | The general racial or ethnic category that reflects the individual's recognition of their community or with which they most identify. | Char(2) | pa_pims_mnt.race |
22 | Not Used | Not Applicable | Not Applicable | Not Applicable |
23 | Home Phone | The telephone number, including the area code and extension, if applicable. | Char(14) | Optional – not supplied |
24 | Not Used | Not Applicable | Not Applicable | Not Applicable |
25 | Address 1 | The street number, street name, or post office box number of the home address. | Char(40) | employee.addr1 |
26 | Address 2 | Additional street address information. | Char(40) | employee.addr2 |
27 | City | The name of the city. | Char(30) | employee.city |
28 | State | The two-character abbreviation for the state, if within the United States, or outlying area in which an address is located. | Char(2) | employee.state_id |
29 | Full Zip Code | The five- or nine-digit zip code portion of the home address. | Char(10) | employee.zip |
30 | Not Used | Not Applicable | Not Applicable | Not Applicable |
31 | Not Used | Not Applicable | Not Applicable | Not Applicable |
32 | Not Used | Not Applicable | Not Applicable | Not Applicable |
33 | Not Used | Not Applicable | Not Applicable | Not Applicable |
34 | Not Used | Not Applicable | Not Applicable | Not Applicable |
35 | Current Service Date | The month, day, and year an individual was hired for a position. This must be the date the employee was first hired for the current position, even if that is a prior year. The format is YYYY-MM-DD | Char(10) | pa_pims_mnt.hire_date |
36 | Exit Date | The month, day, and year an individual ended a period of self-employment or employment with an organization or institution. This field is required for exited staff only. The format is YYYY-MM-DD | Char(10) | pa_pims_mnt.term_date |
37 | Not Used | Not Applicable | Not Applicable | Not Applicable |
38 | Not Used | Not Applicable | Not Applicable | Not Applicable |
39 | Years Experience | The total years an individual has worked in one or more educational institutions. Enter whole numbers only, not fractions or decimals. You should report an individual in their first year as 1. | Numeric(2) | pa_pims_mnt.tot_exp |
40 | Birth Date | The employee's birth date. The format is YYYY-MM-DD | Char(10) | pa_pims_mnt.birth_date |
41 | Active/Inactive Indicator | Valid Values:
| Char(1) | pa_pims_mnt.active_inact |
42 | Not Used | Not Applicable | Not Applicable | Not Applicable |
43 | Years Experience In District | The total number of consecutive years an individual has worked for the Local Education Agency (LEA). | Numeric(2) | pa_pims_mnt.dist_exp |
44 | Job Class Code Long | The category that most reflects the nature and degree of an individual’s participation in the workforce. Valid values (after 8/31/2023):
| Char(4) | pa_pims_mnt.empl_basis |
45 | Not Used | Not Applicable | Not Applicable | Not Applicable |
46 | Not Used | Not Applicable | Not Applicable | Not Applicable |
47 | Not Used | Not Applicable | Not Applicable | Not Applicable |
48 | Not Used | Not Applicable | Not Applicable | Not Applicable |
49 | Not Used | Not Applicable | Not Applicable | Not Applicable |
50 | Snapshot Date | Indicates the reporting period date for the staff record. Required for the Staff Snapshot. The format is YYYY-MM-DD | Char(10) | Snapshot date entered |
51 | Not Used | Not Applicable | Not Applicable | Not Applicable |
52 | Annual Salary | The gross salary or wage (in whole dollars only) an individual is paid before deductions (excluding differentials). | Numeric(10) | pa_pims_mnt.salary |
53 | Not Used | Not Applicable | Not Applicable | Not Applicable |
54 | Termination Code | The primary reason for the termination of the employment relationship. Valid values:
| Char(2) | pa_pims_mnt.term_code |
55 | Not Used | Not Applicable | Not Applicable | Not Applicable |
56 | Not Used | Not Applicable | Not Applicable | Not Applicable |
57 | Alternate Staff Id | A unique number or alphanumeric code assigned by the LEA to identify a staff member. | Numeric(9) | pa_pims_mnt.empl_no |
58 | Not Used | Not Applicable | Not Applicable | Not Applicable |
59 | Not Used | Not Applicable | Not Applicable | Not Applicable |
60 | Not Used | Not Applicable | Not Applicable | Not Applicable |
61 | Not Used | Not Applicable | Not Applicable | Not Applicable |
62 | Not Used | Not Applicable | Not Applicable | Not Applicable |
63 | Local Contract | Indicates whether the staff member has a current contract or is working without one because the contract is currently in negotiations. | Char(1) | pa_pims_mnt.local_contract |
64 | Not Used | Not Applicable | Not Applicable | Not Applicable |
65 | First Name Long | A legal name given to an individual at birth, baptism, during another naming ceremony, or through legal change. | Char(60) | pa_pims_mnt.fname |
66 | Last Name Long | The legal name borne in common by family members, also known as a surname. | Char(60) | pa_pims_mnt.lname |
67 | Name Suffix | An appendage, if any, used to denote an individual’s generation in his family. For example: Jr., Sr., III | Char(10) | pa_pims_mnt.fname |
68 | Not Used | Not Applicable | Not Applicable | Not Applicable |
68 | Not Used | Not Applicable | Not Applicable | Not Applicable |
69 | Not Used | Not Applicable | Not Applicable | Not Applicable |
70 | Not Used | Not Applicable | Not Applicable | Not Applicable |
71 | Highest Degree Institution Code | The extent of formal instruction an individual has received, such as the highest grade in school completed, its equivalent, or the highest degree received. Valid values:
| Char(4) | pa_pims_mnt.degree |
72 | Not Used | Not Applicable | Not Applicable | Not Applicable |
73 | Not Used | Not Applicable | Not Applicable | Not Applicable |
74 | Not Used | Not Applicable | Not Applicable | Not Applicable |
75 | Not Used | Not Applicable | Not Applicable | Not Applicable |
76 | E-mail Address | The numbers, letters, and symbols used to identify an e-mail user within the network to which the individual or organization belongs. | Char(80) | pa_pims_mnt.email_addr |
77 | Middle Name | A secondary name given to an individual at birth, baptism, or during another naming ceremony. | Char(60) | pa_pims_mnt.mname |
78 | Not Used | Not Applicable | Not Applicable | Not Applicable |
79 | Not Used | Not Applicable | Not Applicable | Not Applicable |
80 | Not Used | Not Applicable | Not Applicable | Not Applicable |
81 | Not Used | Not Applicable | Not Applicable | Not Applicable |
82 | Not Used | Not Applicable | Not Applicable | Not Applicable |
83 | Not Used | Not Applicable | Not Applicable | Not Applicable |
84 | Not Used | Not Applicable | Not Applicable | Not Applicable |
85 | Not Used | Not Applicable | Not Applicable | Not Applicable |
86 | Not Used | Not Applicable | Not Applicable | Not Applicable |
87 | Not Used | Not Applicable | Not Applicable | Not Applicable |
88 | Not Used | Not Applicable | Not Applicable | Not Applicable |
89 | Not Used | Not Applicable | Not Applicable | Not Applicable |
90 | Not Used | Not Applicable | Not Applicable | Not Applicable |
91 | Not Used | Not Applicable | Not Applicable | Not Applicable |
92 | Not Used | Not Applicable | Not Applicable | Not Applicable |
93 | Not Used | Not Applicable | Not Applicable | Not Applicable |
94 | Not Used | Not Applicable | Not Applicable | Not Applicable |
95 | Not Used | Not Applicable | Not Applicable | Not Applicable |
96 | Not Used | Not Applicable | Not Applicable | Not Applicable |
97 | Not Used | Not Applicable | Not Applicable | Not Applicable |
98 | Not Used | Not Applicable | Not Applicable | Not Applicable |
99 | Not Used | Not Applicable | Not Applicable | Not Applicable |
100 | Not Used | Not Applicable | Not Applicable | Not Applicable |
101 | Not Used | Not Applicable | Not Applicable | Not Applicable |
102 | Not Used | Not Applicable | Not Applicable | Not Applicable |
103 | Not Used | Not Applicable | Not Applicable | Not Applicable |
104 | Not Used | Not Applicable | Not Applicable | Not Applicable |
105 | Not Used | Not Applicable | Not Applicable | Not Applicable |
106 | Not Used | Not Applicable | Not Applicable | Not Applicable |
107 | Not Used | Not Applicable | Not Applicable | Not Applicable |
108 | Not Used | Not Applicable | Not Applicable | Not Applicable |
109 | Not Used | Not Applicable | Not Applicable | Not Applicable |
110 | Not Used | Not Applicable | Not Applicable | Not Applicable |
111 | Not Used | Not Applicable | Not Applicable | Not Applicable |
112 | Not Used | Not Applicable | Not Applicable | Not Applicable |
113 | Not Used | Not Applicable | Not Applicable | Not Applicable |
114 | Not Used | Not Applicable | Not Applicable | Not Applicable |
115 | Not Used | Not Applicable | Not Applicable | Not Applicable |
116 | Gender Identity | The employee's gender identity. | Char(1) | person.gender_identity or gender_identity_tbl.state_code if either are equal to X |