TemplatesPrograms

Programs Fact Template

PIMS Programs Fact Template Specifications

(18 Fields • 10 Collected • Delimited)
Target Table:
PROGRAMS_FACT
Load Sequence / Dependencies:

Dependency Requirement

The Programs Fact Template depends on the Student Template being loaded first.

Template Description

This template tracks student participation in specific programs for a given school year. Key points:

  • LEAs report the actual beginning date (and, if applicable, the actual ending date) for a student’s participation in a program.
  • Two record types are submitted for each reporting date:
    • Active participation records: beginning date populated, ending date left blank when a student is still participating as of the reporting date.
    • Ended participation records: both beginning and ending dates populated for students who stopped participating since the prior reporting date.
  • Program participation is specific to a school year. When participation spans school years, submit an August record with the prior school year end date (yyyy-06-30) and a new October record for the new school year beginning (yyyy-07-01).

For example, a student participating 9/5/2024 through 9/25/2026 would have records submitted in the October/August cycles as described above to reflect school-year boundaries.

SES Tutoring / Program Provider Code

This template accommodates SES Provider Numbers for the following programs: "SES Tutoring (Federal) – Reading", "SES Tutoring (Federal) – Math", and "SES Tutoring (Federal) – Science" (Program Codes 003, 004, and 034). When LEAs have students in these programs they must use the 25-field layout and populate the Program Provider Type Code (Field 23) appropriately. LEAs without these students may continue using the 18-field layout.

PDE requests that LEAs with students in SES tutoring submit records for all students who received tutoring during the school year so PDE can capture the SES Provider Number.


Template Specifications

1 - SUBMITTING AUN

RequiredKeyMax Length: 9

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

Sample Value

All LEA and School Numbers can be found on the EdNA website.

123456789

eScholar Name: DISTRICT CODE


2 - SCHOOL NUMBER

RequiredKeyMax Length: 4

The PDE defined 4-digit code identifying the school.

Sample Value

All LEA and School Numbers can be found on the EdNA website.

1234

eScholar Name: LOCATION CODE


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


4 - PASECUREID

RequiredKeyMax Length: 10

The unique, 10-digit PAsecureID assigned to the student.

Business Rules

It is essential that the correct PAsecureID be entered for each student. LEAs are encouraged to share this number, where appropriate and within FERPA guidelines, to ensure accurate data.

Sample Value

1000000009

eScholar Name: STUDENT ID


5 - PROGRAMS CODE

RequiredKeyMax Length: 3

The type of program in which the student participates.

Valid Value

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


6 - BEGINNING DATE

RequiredKeyMax Length: 10

Actual date upon which the student began participating in a program. For certain program codes this represents the date of first eligibility or date became homeless as applicable.

Business Rules

Must not be greater than the current date.

Sample Value

2021-09-03

eScholar Name: PROGRAM START DATE


7 - ENDING DATE

Conditionally RequiredUpdateableMax Length: 10

Actual date upon which the student stopped participating in a program. Required only when a student stops participating in a program.

Business Rules

When populated, the ending date must be greater than or equal to the beginning date.

Sample Value

2021-10-30

eScholar Name: PROGRAM END DATE


8, 10-17 🛇

Field(s) not collected. Must be delimited in template file.


9 - PROGRAM INTENSITY

OptionalMax Length: 20

This field is no longer used by PDE but is available for LEA use to display instructional minutes received for the program.

Notes

This field can be left blank.


18 - PGM PARTICIPATION INFORMATION CODE

Conditionally RequiredMax Length: 1

Indicator of the living arrangement of a student identified as homeless in Field 5 (PROGRAM CODE).

Business Rules

This field is required for students reported with Program Codes 055 (Homeless, Unaccompanied) and 056 (Homeless, Accompanied).

Valid Values

Valid Values:

  • S – shelter, transitional housing
  • D – doubled up
  • U – unsheltered (e.g., cars, parks, campgrounds, temporary trailer, abandoned building, substandard housing)
  • H – hotels/motels

Rules

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