Skip to main content
Skip table of contents

Programs Fact Extract

Contents

Introduction

The Programs Fact extract is used to track student enrollment in the following programs:

  • Career Education
  • Early Childhood
  • Homeless
  • Rule 18 Interim Program

 The extract is generated in a comma-delimited format.

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

The Programs Fact extract includes student records from the [SpEnrollments] table that meet the following criteria:

  • Students who are not excluded from state reporting.
  • Students who are enrolled in a school not excluded from state reporting.
  • Students whose school enrollment Exit Date is after the report start date.
  • Students whose school enrollment Entry Date is on or before the report end date.
  • Students whose school enrollment Exit Date is after the Entry Date.
  • Students enrolled in one of the following special programs:
  • Fall Submission: Early Childhood
  • EOY Submission: Career Education, Early Childhood, Homeless, Rule 18 Interim Program

Note: Program names are set up at the District and stored in [Gen]Name, where [Gen]Cat=Specprog.

  • Students whose special program enrollment Exit Date is after the start date of the report, or equal to 0/0/0 (blank).
  • Students whose special program enrollment Entry Date is on or before the report end date.

Back to Top

Report Input

For help with navigation and report generation, see How to Find and Generate a Report.

Field

Description

Data to be Filled

Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All.

Select Schools

Choose one of the following:

  • Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
  • All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Notes:

Current Selection Students

Indicate which students to include in the report by selecting one of the following options:

  • The Selected Number of Students Only
  • All Students (default)

Note: If running the report for a single student, or group of students, select the students prior to running report.

Start Date

Enter the first in session day of the school year.

End Date

Enter the last in session day of the school year. The end date is automatically populated with 6/30/YY. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms.

Submission

Choose one of the following:

  • Fall
  • EOY

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Element #

Data Element

Description

[Table]FieldName

1

District Code

NDE Number for the district.

[Prefs]Name=districtnumber

[Prefs]Value

2

Location Code

The report extracts the value from the Alternate School Number field if it is populated on the Edit School page. Otherwise, the report extracts the value from the School Number field.

[Schools]Alternate_School_Number

[Schools]School_Number

[Students]SchoolID=[Schools]School_Number

[ReEnrollments]SchoolID=[Schools]School_Number

3

School Year

This value is automatically extracted as June 30th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms.

The value is extracted in the format YYYY-MM-DD.

[Terms]LastDay

4

Student ID

State issued identification number.

[Students]State_StudentNumber

5

Programs Code

See Program Codes for value values.

[S_NE_SEN_X]PgmFactProgramCode

6

Beginning Date

The date that the student enrolled in the program. The date should be prior to the current date. The date is extracted in the format YYYY-MM-DD.

[SpEnrollments]Enter_Date

7

Ending Date

This value should be blank for all programs except Interim. The date should occur prior to the current date, but on or after the Beginning Date.

The date should be entered as the last day that the student participated in the program, in the format YYYY-MM-DD.

Leave blank if student is participating in Interim program at time of reporting.

[SpEnrollments]Exit_Date

[S_NE_SEN_X]PgmFactProgramCode = Interim

8

Program District School Code

This field is extracted if the Program Code is Interim.

The County District School number assigned by NDE to the Rule 18 Interim program in the format ##-####-###.

You can obtain the Program District School Code from the Education Directory by accessing the following website:

https://www.education.ne.gov/nssrs/Resources.html

Note: The dashes separate the county number, district number, and school number.

[S_NE_SEN_X]PgmFactDistSchoolCode

9

Program Intensity

Not collected.

N/A

10

Entry Reason Code 1

Not collected.

N/A

11

Entry Reason Code 2

Not collected.

N/A

12

Entry Reason Code 3

Not collected.

N/A

13

Exit Reason Code 1

Not collected.

N/A

14

Exit Reason Code 2

Not collected.

N/A

15

Technical Skill Attainment (Exit Reason Code 3)

Valid values:

  • 0 – Not Applicable
  • CE0001 – Met Technical Skill Attainment through Industry Certification
  • CE0002 – Met Technical Skill Attainment through third party instrument
  • CE0003 – Met Technical Skill Attainment through Locally developed criterion
  • CE0004 – Did not meet Technical Skill Attainment

Note: Provide the code indicating Not Applicable (0) for Participation Info Code values other than CE0003 or CE0004.

[S_NE_SEN_X]PgmFactTechSkillAttain

16

Program Comment

Not collected.

N/A

17

Original Program Start Date

Not collected.

N/A

18

Participation Info Code

See the Appendix for program codes.

Early Childhood Notes:

Provide only one record per student, for all students, age birth through five served by center-based early childhood education programs approved under Rule 11.  This includes non-resident students as well as delegates and partners.

Do not include student’s age birth to five that are served only by Special Education and who are not in a center-based program.

If the district is the Head Start grantee or delegate and only federal Head Start grant funds are used, then only Participation Info Code values EC0003 or EC0004 apply.

The Early Childhood Birth to Age 3 Endowment Grant Program is a public-private funded endowment to provide grants to public school districts to provide programs and services for infants and toddlers who are at risk for school failure.

Homeless Code Notes:

Provide the code that best describes the student’s living situation immediately following the homeless event.   

There should be only one participation info code per homeless event per year.

Districts may report more than one homeless event, and therefore another Participation Info Code, per school year.

Do not report changes in living situation subsequent to a particular homeless event unless correcting an error or changing from Type of Residence Unknown (HM0004) to another code.

Provide the same Beginning Date in order to update the existing record.

[SpEnrollments]NE_ParticipationInfoCode

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.