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.
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:
Notes:
|
Current Selection Students | Indicate which students to include in the report by selecting one of the following options:
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:
|
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:
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 |