District Fact Template for Support Personnel Data

PIMS District Fact Template for Support Personnel Data Specifications

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

Template Description

The District Fact Template is used to submit the results of the Support Personnel Form. Information is captured in an Excel file, automatically creating the District Fact Template to be submitted to PIMS. This survey applies to all public LEAs.

The Support Personnel Form and directions on how to complete this form are located on the PDE website under Data and Reporting/PIMS/Excel Reporting Tools SupPer. After reading the directions, proceed as follows:

  1. Open the Excel file "Support Personnel Form" and supply the LEA & School Information by entering your 9-digit AUN. Certain information will automatically populate this first page.
  2. Proceed to filling out page 2 of the Form.
  3. When all information has been completed on the disclosure form it should be saved in Excel.
  4. After saving the disclosure form in Excel, click on Page 3_PIMS Input Page 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

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

4 - CATEGORY 02

RequiredKeyMax Length: 7

Constant Value defining the type of data entered.

Valid Values
  • SURVEY

5 - CATEGORY 03

RequiredKeyMax Length: 4

Question Number

Valid Values

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

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.

Sample Value

15

8-12 🛇

Fields not collected. Must be delimited in template file.

13 - CATEGORY 04

RequiredKeyMax Length: 2
Valid Values
  • Y - Yes
  • N - No

14-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.