Classic View: PA State Reporting > PIMS Extracts > Staff Template
Search Terms: PIMS Extracts
The Staff Template reports each staff member who is actively employed on the Reporting Date entered on the extract editor.
See the PIMS Reporting article for additional PIMS Reporting information.
Report Logic
One record is submitted per staff member in October, December, March and August.This extract reports the same information as the Staff Snapshot Template.
- If the Exclude checkbox is marked on the District Assignment tab, the staff person does not report.
- For the October reporting period, if the District Employment Qualification field on the District Employment editor is populated, the staff person does not report.
- For the June reporting period, all current staff reporting, including those with the District Employment Qualification field populated.
Generate the Staff Template
- Select Staff Template from the Extract Type from the dropdown list.
- Select the desired Reporting Period.
- Enter the Effective Date of the extract in mmddyy format or use the calendar icon to select a date.
- Select the Format of the extract.
- Select a Staff Ad hoc Filter, if desired.
- Select the appropriate Calendar(s) from which to include data on the extract.
- Click the Generate Extract button or the Submit to Batch button, if available. The extract displays in the selected format.
Staff Template, CSV Format
Staff Template, HTML Format
Report Layout
| Data Element | Description | Type, Format and Length | Campus Database | Campus Interface |
|---|---|---|---|---|
| District Code | State District Number Reports the district number of the reporting school unless there is a different district located in the Serving District field. | Numeric, 9 digits | District.number | System Administration > Resources > District Information > State District Number Student Information > General > Enrollments > State Reporting Fields > Serving District |
| Staff ID | Reports the staff person's state-assigned identification number. For the October reporting period, staff who have the District Employment Qualification field populated do not report. This field reports from the Staff State ID field. For the June reporting period, all current staff report, including those with the District Employment Qualification field populated.
| Numeric, 9 digits | Person.staffStateID | Census > People > Demographics > Person Identifiers > Staff State ID Census > People > District Employment > License Number |
| Fields 3-7 | These fields do not report. | N/A | N/A | N/A |
| Job Description | Reports the level of access that should be granted in the PCAAS Roster Verification System for the selected school year. Options are:
| Alphanumeric, 3 characters | CustomEmployment Employment. jobDescription | Census > People > District Employment > Employment Information > Job Description |
| Fields 9-13 | These fields do not report. | N/A | N/A | N/A |
| Location Code | State School Number of the reporting school. This code reports from the Alt School Number field on the School editor. If that field is not populated, the State School Number field on the School editor is used. | Numeric, 4 digits | School.altNumber School.number | System Administration > Resources > School > Alt School Number, State School Number |
| Fields 15-16 | These fields do not report. | N/A | N/A | N/A |
| Staff Type | Indicates whether the staff person is employed for a standard number of hours in a week, month or other period of time. When the staff person is full-time, reports as F. When the staff person is part-time, reports as P. | Alphanumeric, 1 character | Employment.Status | Census > People > District Employment > Status |
| Fields 18-19 | These fields do not report. | N/A | N/A | N/A |
| Gender Code | Reports the staff person as being either Male (M) or Female (F). | Alphanumeric, 1 character | Identity.gender | Census > People > Demographics > Person Information > Gender |
| Ethnic Code Short | Reports the staff person's race/ethnicity. | Numeric, 1 digit | Identity.raceEthnicity | Census > People > Demographics > Person Information > Race/Ethnicity |
| Field 22 | This field does not report. | N/A | N/A | N/A |
| Home Phone | Reports the household phone number (area code, number, extension). | Numeric, 14 digits | Household.phone | Census > People > Households > Phone |
| Field 24 | This field does not report. | N/A | N/A | N/A |
| Address 1 | Reports the street name and number or PO Box of the staff person's mailing address. | Alphanumeric, 30 characters | Address.number Address.prefix Address.street Address.tag Address.dir Address.POBox | Census > Address > Address Info > Number, Prefix, Street, Tag, Direction, PO Box |
| Address 2 | Reports the apartment number of the staff person's mailing address. | Alphanumeric, 30 characters | Address.apt | Census > Address > Address Info > Apt |
| City | Reports the city of the staff person's mailing address. | Alphanumeric, 25 characters | Address.city | Census > Address > Address Info > City |
| State | Reports the state of the staff person's mailing address. | Alphabetic, 2 characters | Address.state | Census > Address > Address Info > State |
| Full Zip Code | Reports the complete zip code (5 digit code plus 4) of the staff person's mailing address. | Numeric, 10 digits | Address.zip | Census > Address > Address Info > Zip |
| Fields 30-34 | These fields do not report. | N/A | N/A | N/A |
| Current Service Date | Month, day and year on which the staff person was hired. | Date field, 10 characters YYYY-MM-DD | Employment.startDate | Census > People > District Employment > Start Date |
| Exit Date | Month, day and year on which the staff person was no longer employed by the district. | Date field, 10 characters YYYY-MM-DD | Employment.endDate | Census > People > District Employment > End Date |
| Fields 37-38 | These fields do not report. | N/A | N/A | N/A |
| Years Experience | Total number of years the staff person has worked in one or more education institutions. This field always reports a value that is not zero (0). This field is calculated from the Teaching Start Year and the Effective Date of the report generation. The Teaching Years Modifier will be added to this calculation if not null or 0. The logic for this field is as follows:
| Numeric, 2 digits | Employment.teaching StartYear | Census > People > District Employment > Teacher Start Year |
| Birth Date | Reports the birth date of the staff person. | Date field, 10 characters YYYY-MM-DD | Identity.birthDate | Census > People > Demographics > Person Information > Birth Date |
| Active/Inactive Indicator | Indicates whether the staff person is currently active, terminated or on leave. | Alphabetic, 1 character | Employment.employ- mentStatus | Census > People > District Employment > Employment Status |
| Field 42 | This field does not report. | N/A | N/A | N/A |
| Years Experience in District | Total number of years the staff person has worked in the current district. This is a calculated value based on the start date of employment. This field always reports a value that is not zero (0). This field is calculated from the District Employment Start Date and the Effective Date of the report generation. The logic for this field is as follows:
| Numeric, 2 digits | Calculated, data not stored | Census > People > District Employment > Start Date |
| Job Class Code Long | For all submission dates, this field identifies the nature and degree of staff participation. | Numeric, 4 digits | Employment.employ- mentStatus | Census > People > District Employment > Employment Status |
| Fields 45-47 | These fields do not report. | N/A | N/A | N/A |
| Qualification Status | Reports the staff person's security status.
| Alphabetic, 3 characters | Employment.qualification Status | Census > People > District Employment > Qualification Status |
| Fields 49-51 | These fields do not report. | N/A | N/A | N/A |
| Annual Salary | Reports the staff person's salary/wage in whole dollars. | Numeric, 10 digits | Employment.salary | Census > People > District Assignment > Salary |
| Field 53 | This field does not report. | N/A | N/A | N/A |
| Termination Code | Reports the reason the staff person is no longer employed at the district. | Numeric, 2 digits | Employment. terminationCode | Census > People > District Assignment > Termination Code |
| Fields 55-56 | These fields do not report. | N/A | N/A | N/A |
| Alternate Staff ID | Reports the staff person's local staff number. | Alphanumeric, 2 characters | Person.local StaffNumber | Census > People > Demographics > Person Identifiers > Local Staff Number |
| Fields 58-62 | These fields do not report. | N/A | N/A | N/A |
| Local Contract | Indicates whether the staff member has a current contract (Y) or is working without a contract because the contract is in negotiations (N). | Alphabetic, 1 character | Employment.contract Employee | Census > People > District Employment > Contract Employee |
| Field 64 | This field does not report. | N/A | N/A | N/A |
| First Name Long | Reports the staff person's first name. | Alphanumeric, 60 characters | Identity.firstName | Census > People > Demographics > Person Information > First Name |
| Last Name Long | Reports the staff person's last name. | Alphanumeric, 60 characters | Identity.lastName | Census > People > Demographics > Person Information > Last Name |
| Name Suffix | Reports any entered indication of the staff person having a generational name (III, Jr,, etc.) | Alphanumeric, 5 characters | Identity.suffix | Census > People > Demographics > Person Information > Suffix |
| Fields 68-70 | These fields do not report. | N/A | N/A | N/A |
| Highest Degree Institution Code | Reports the staff person's highest institutional degree. | Numeric, 4 digits | Employment. educationLevel | Census > People > District Employment > Education Level |
| Field 72 | This field does not report. | N/A | N/A | N/A |
| Address 3 | Reports the apartment, room or suite of the staff person's address. | Alphanumeric, 30 characters | Address.apt | Census > People > Household > Addresses |
| Fields 74-75 | These fields do not report. | N/A | N/A | N/A |
| Email Address | Reports the staff person's email address. | Alphanumeric, 25 characters | Contact.email | Census > People > Demographics > Personal Contact Information > Email |
| Middle Name | Reports the staff person's middle name. | Alphanumeric, 25 characters | Identity.middleName | Census > People > Demographics > Person Information > Middle Name |
| Fields 78-82 | These fields do not report. | N/A | N/A | N/A |
| Employment Eligibility Verification | Reports the item used to verify the staff person's ability to be employed. | Numeric, 4 digits | Employment.verification | Census > People > District Employment > Employment Eligibility Verification |
| Fields 84-94 | These fields do not report. | N/A | N/A | N/A |
| Authorized to Carry Weapon | Indicates whether the staff person is authorized to carry a weapon. | Alphabetic, 1 character Y or N | Employment. weapon | Census > People > District Employment > Authorized to Carry a Weapon |
