District Fact for Professional Staff Vacancies

PIMS District Fact for Professional Staff Vacancies Template Specifications

(21 Fields • 11 Collected • Delimited)
Target Table:
DISTRICT_FACT
Load Sequence / Dependencies:
None

Template Description

The District Fact Template is used to submit counts of all full-time and part-time, vacant, professional staff (Appendix B) positions as of the Staff Snapshot date. For this collection, a vacant position shall be defined as an unoccupied position that has been board approved and posted to allow the LEA to proceed through the hiring process.

NOTE: Any posted position that is currently filled by an individual with a Type 01 Emergency Permit is not considered unoccupied and should not be reported as a vacancy.

This report is required for all LEAs that report Staff data.

Template Specifications

1 - SUBMITTING AUN

RequiredKeyMax Length: 9

The unique, 9-digit Administrative Unit Number (AUN) assigned by the PDE.

Sample Value

123456789

2 - SCHOOL YEAR DATE

RequiredKeyMax Length: 10

A single date (June 30), the last day of the current school year indicating the whole school year.

Sample Value

2026-06-30

3 - CATEGORY 01

RequiredKeyMax Length: 9

Constant Value defining the type of data entered.

Valid Values
  • PROFSTAFF

4 - CATEGORY 02

RequiredKeyMax Length: 7

Constant Value defining the type of data entered.

Valid Values
  • VACANCY

5 - CATEGORY 03

RequiredKeyMax Length: 4

Assignment Code

Business Rules

If no vacancies to report, then Category 03 must = NONE. Category 03 cannot =9998 (security personnel are only reported in the Safe Schools Collection).

Valid Values

See Appendix B of Volume 2 of the PIMS User Manual for a complete list of valid values. NONE

6 - MEASURE TYPE

RequiredKeyMax Length: 5
Valid Values
  • COUNT

7 - COUNT

RequiredUpdateableMax Length: 3

If MEASURE TYPE = COUNT, the count should be supplied in this field.

Business Rules

If Category 03 = NONE then Count must = 0.

Sample Value

2

8-10 🛇

Fields not collected. Must be delimited in template file.

11 - CATEGORY 04

RequiredKeyMax Length: 2

Staff Employment Type Code

Business Rules

If Category 03 = NONE then Category 04 must = NA.

Valid Values
  • F - Full Time
  • P - Part Time
  • NA

12 - CATEGORY 05

RequiredKeyMax Length: 3

Staff Status (How is the position being staffed)

Business Rules

If Category 03 = NONE then Category 05 must = NA.

Valid Values
  • LTS - Long Term Sub
  • STS - Short Term Sub
  • NS - Not Staffed (No individual regularly designated to fill this position)
  • NA

13 - CATEGORY 06

RequiredKeyMax Length: 3

Quarter identifier

Valid Values
  • OCT

14-18 🛇

Fields not collected. Must be delimited in template file.

19 - START DATE

RequiredKeyMax Length: 10

C1 Staff Snapshot Date

Business Rules

Must match C1 Staff Snapshot Date 10/1,2,3.

Sample Value

2025-10-01

20-21 🛇

Fields not collected. Must be delimited in template file.

Sample Staff Vacancy Submission for the District Fact Template

Submitting AUNSchool Year DateCategory 1Category 2Category 3Measure TypeCountNCNCNCCategory 4Category 5Category 6NCNCNCNCNCSnapshot DateNCNC
12345678902026-06-30PROFSTAFFVACANCY1875COUNT1FNSOCT2025-10-01
12345678902026-06-30PROFSTAFFVACANCY8405COUNT2FLTSOCT2025-10-01
12345678902026-06-30PROFSTAFFVACANCY3250COUNT1PSTSOCT2025-10-01
12345678902026-06-30PROFSTAFFVACANCY1401COUNT1FLTSOCT2025-10-01

Rules

See the Rules Section of the Template Domain for rules consistent throughout all templates.