District Fact for ACT 35

PIMS District Fact for ACT 35 Template Specifications

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

Template Description

The District Fact Template is used to submit counts of the total budgeted complement of professional staff positions and the number of those budgeted professional staff positions that are vacant as of the date of final budget adoption by the LEA's governing Board.

Professional staff positions are those that are listed in PIMS Manual, Volume 2, Appendix B. 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 counted as a vacancy.

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

Information is captured in an Excel file, automatically creating the District Fact Template to be submitted to PIMS. The Act35 Form and directions on how to complete this form are located on the PDE website under Data and Reporting/PIMS/Excel Reporting Tools/ACT35 After reading the directions, proceed as follows:

  1. Open the Excel file "ACT35"
  2. Complete the required information on the PIMS_Input Tab:
    1. Supply your LEA Information by entering your 9-digit AUN.
    2. Select the current School Year from the drop-down menu.
    3. Enter the Count of TOTAL Budgeted Professional Staff
    4. Enter the Count of VACANT Budgeted Professional Staff.
  3. When all information has been completed the form should be saved in Excel.
  4. After saving the Input form in Excel, click on the DISTRICT_FACT tab and do the following:
    1. click on File
    2. click on Save As
    3. name the file correctly (SUBMITTINGAUN_DISTRICT_FACT_DATE&TIME). Example file name: 123456789_DISTRICT_FACT_201506110800
    4. save file type as .csv
  5. Upload the .csv file into the PIMS system as a District Fact Template

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
  • ACT35

4 - CATEGORY 02

RequiredKeyMax Length: 7

Constant value defining the type of data entered.

Valid Values
  • BUDGET

5 - CATEGORY 03

RequiredKeyMax Length: 4

Constant value defining the type of data entered. As of the date of final Budget adoption: TOTAL - The Total Number of budgeted Professional Staff. VACANT - The number of budgeted Professional Staff positions that are vacant.

Business Rules

An entry for each Valid value (TOTAL, VACANT) must be reported in CATEGORY 03. Your template will have two rows of data.

Rule 1: COUNT > 0 where CATEGORY 03 = TOTAL Reason: Total count cannot be 0 which would indicate the LEA has no staff budgeted for the SY

Rule 2: COUNT where CATEGORY 03 = TOTAL <> COUNT where CATEGORY 03 = VACANT Reason: Total count cannot equal the Vacant count which would indicate that all budgeted staff positions are vacant

Valid Values
  • TOTAL
  • VACANT

6 - MEASURE TYPE

RequiredKeyMax Length: 5
Valid Values
  • COUNT

7 - COUNT

RequiredUpdateableMax Length: 3

Provide the COUNT of TOTAL budgeted professional Staff positions when CATEGORY 03= TOTAL Provide the COUNT of VACANT budgeted professional Staff positions when CATEGORY 03= VACANT

Business Rules

Must be a whole number. If None to report, then enter as 0. You must provide a COUNT for each Valid Value in CATEGORY 03 (TOTAL, VACANT)

Sample Value

2

8-21 🛇

Fields not collected. Must be delimited in template file.

Rules

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