District Fact for English Learners

PIMS District Fact for English Learners Template Specifications

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

Template Description

The District Fact Template is used to submit counts of English Learners (ELs) and Immigrant Students for the Title III and LIEP Survey data sets. This report is required for all LEAs that report Student 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
  • ELSTUDENT
  • IMMIGRANT

4 - CATEGORY 02

RequiredKeyMax Length: 7

Constant Value defining the type of data entered.

Valid Values
  • TITLEIII
  • LIEPSURV

5 - CATEGORY 03

RequiredKeyMax Length: 4
Valid Values
  • EL - English Learner
  • FEP - Former English Learner
  • NEP - Never English Learner
  • IM - Immigrant

6 - CATEGORY 04

RequiredKeyMax Length: 2
Valid Values
  • K - Kindergarten
  • 1 - Grade 1
  • 2 - Grade 2
  • 3 - Grade 3
  • 4 - Grade 4
  • 5 - Grade 5
  • 6 - Grade 6
  • 7 - Grade 7
  • 8 - Grade 8
  • 9 - Grade 9
  • 10 - Grade 10
  • 11 - Grade 11
  • 12 - Grade 12
  • UG - Ungraded
  • PK - Pre-Kindergarten

7 - CATEGORY 05

RequiredKeyMax Length: 1
Valid Values
  • M - Male
  • F - Female

8 - CATEGORY 06

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

9 - MEASURE TYPE

RequiredKeyMax Length: 5
Valid Values
  • COUNT

10 - COUNT

RequiredUpdateableMax Length: 5

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

Sample Value

25

Sample Title III Submission for the District Fact Template

Submitting AUNSchool Year DateCategory 1Category 2Category 3Category 4Category 5Category 6Measure TypeCount
12345678902026-06-30ELSTUDENTTITLEIIIELKMYCOUNT5
12345678902026-06-30ELSTUDENTTITLEIIIELKFYCOUNT3
12345678902026-06-30ELSTUDENTTITLEIIIEL1MYCOUNT4
12345678902026-06-30ELSTUDENTTITLEIIIEL1FYCOUNT6
12345678902026-06-30ELSTUDENTTITLEIIIFEP2MNCOUNT2
12345678902026-06-30ELSTUDENTTITLEIIIFEP2FNCOUNT1

Sample LIEP Survey Submission for the District Fact Template

Submitting AUNSchool Year DateCategory 1Category 2Category 3Category 4Category 5Category 6Measure TypeCount
12345678902026-06-30ELSTUDENTLIEPSURVELKMYCOUNT5
12345678902026-06-30ELSTUDENTLIEPSURVELKFYCOUNT3
12345678902026-06-30ELSTUDENTLIEPSURVEL1MYCOUNT4
12345678902026-06-30ELSTUDENTLIEPSURVEL1FYCOUNT6
12345678902026-06-30ELSTUDENTLIEPSURVFEP2MNCOUNT2
12345678902026-06-30ELSTUDENTLIEPSURVFEP2FNCOUNT1
12345678902026-06-30ELSTUDENTLIEPSURVNEP3MNCOUNT15
12345678902026-06-30ELSTUDENTLIEPSURVNEP3FNCOUNT18

Sample Immigrant Submission for the District Fact Template

Submitting AUNSchool Year DateCategory 1Category 2Category 3Category 4Category 5Category 6Measure TypeCount
12345678902026-06-30IMMIGRANTTITLEIIIIMKMYCOUNT2
12345678902026-06-30IMMIGRANTTITLEIIIIMKFYCOUNT1
12345678902026-06-30IMMIGRANTTITLEIIIIM1MYCOUNT3
12345678902026-06-30IMMIGRANTTITLEIIIIM1FYCOUNT2

Rules

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