District Fact for Quarterly Vacancy Updates

PIMS District Fact for Quarterly Vacancy Updates 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 START 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

2025-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 🛇

Field not collected. Must be delimited in template file.

13 - 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

14-18 🛇

Fields not collected. Must be delimited in template file.

19 - START DATE

RequiredKeyMax Length: 10

Snapshot Date that identifies the quarter represented by data being submitted

Business Rules

JAN 2- Quarter 2 (Oct-Dec) APR 2- Quarter 3 (Jan- March) JUNE 27- Quarter 4 (April- June) Field 19 must = START DATE (Specific to each Quarterly requirement)

Sample Value

2026-01-02

20-21 🛇

Fields not collected. Must be delimited in template file.

Sample (April) Quarterly Vacancy Updates Submission for the District Fact Template

Submitting AUNSchool Year DateCategory 1Category 2Category 3Measure TypeCountNCNCNCCategory 4Category 5Category 6NCNCNCNCNCStart DateNCNC
12345678902026-06-30PROFSTAFFVACANCY1875COUNT1FNSAPR2026-04-02
12345678902026-06-30PROFSTAFFVACANCY8405COUNT2FLTSAPR2026-04-02
12345678902026-06-30PROFSTAFFVACANCY3250COUNT1PSTSAPR2026-04-02
12345678902026-06-30PROFSTAFFVACANCY1401COUNT1FLTSAPR2026-04-02

Rules

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

Load Sequence / Dependencies

No dependencies