Programs Fact Extract

Introduction

This extract is used to track student participation in the various programs like Bilingual Education and English as a Second Language, Home School, Vocational/Technical Education, etc. The report generates a comma-delimited file for students who were active on the Report Date.

Note: If charter school or home school students participate in a district activity, you must enter the student in the student extract in order to enter the student in the program facts extract. Use the district code and location code where the district activity was held.

Selection Criteria

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

Program Fact Selection

The report selects Program Fact records from the [S_NM_ProgramFact_C] table based on the following criteria:

The Program Fact beginning date must occur on or before the report date.
The Program Fact ending date must be blank, or 0/0/0.

Student Selection

The report selects student records from the [Students] or [ReEnrollments] table based on the following criteria:

The student must not be excluded from state reporting.
The student must be enrolled in a school included in the report.
The student’s school enrollment Exit Date must occur after the report date.
The student’s school enrollment Entry Date must occur on or before the report date.
The school enrollment Exit Date must occur after the Entry Date.
The students are extracted irrespective of whether the “Home Schooled & Taking Classes in District” flag is set or not.

Back to Top

Report Input

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

Field	Description
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. Note: The All Schools option is only available when running the report from the District Office.
Select Students	Choose one of the following: The Selected [x] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district.
Reporting Period	Choose a reporting period from the pop-up menu: K3P 40D 80D 120D EOY Summer
Select Report Date	Enter the report date. Data is extracted for a point-in-time, as opposed to a date range.
Report Mode	Choose one of the following: Extract – Choose this option to run the extract version this report, which includes only the columns/fields required for submission to the state. Audit – Choose this option to run the audit version of this report, which includes only the columns/fields for the purpose of reviewing program fact data. Run the audit version of the report to verify data before running the extract version.

Back to Top

Report Output – Audit Version

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.

Item #	Data Element	Description	[Table]FieldName	Begin / End Position
1	State Student Number	The state issued student identification number.	[Students]State_StudentNumber	N/A
2	Student Name	The student’s name.	[Students]First_Name [Students]Middle_Name [Students]Last_Name	N/A
3	School Number	The school number associated with the student.	[Schools]School_Number	N/A
4	Enroll Status	The student’s current status at the school. Valid values: -1 – Pre-Registered 0 – Active 1 – Inactive 2 – Transferred Out 3 – Graduated 4 – Imported as Historical Any other value is considered inactive.	[Students]Enroll_Status	N/A
5	Program Code	The program in which the student is enrolled. If the Program Code is 3Y or 4Y, then the Student Snapshot current grade level must equal PK. See the STARS Manual Volume 2 document available at https://webnew.ped.state.nm.us/bureaus/information-technology/stars-manual/ for a list of valid values.	[S_NM_STU_ProgramFact_C]ProgramCode	N/A
6	Program Start Date	The date the student enrolled in the program.	[S_NM_STU_ProgramFact_C]BeginningDate	N/A
7	Program End Date	The date the student exited the program.	[S_NM_STU_ProgramFact_C]EndingDate	N/A
8	Program Intensity	The number of program hours for a student participating in a bilingual education program (BEP).	[S_NM_STU_ProgramFact_C]ForeignKey_Alpha	N/A
9	Original Program Start Date	The date the student began receiving early intervening services. Required if the Program Code is CEIS, 3Y, 4Y, or FACE. The value is extracted in the format YYYY-MM-DD.	[S_NM_STU_ProgramFact_C]PgmStartDate	N/A
10	Participation Info Code	The student’s participation info code. This field is only required if the Program Code is one of the following: BEP ESL and the student is not participating in BEP CEIS See the STARS Manual Volume 2 document available at https://webnew.ped.state.nm.us/bureaus/information-technology/stars-manual/ for a list of valid values.	[S_NM_STU_ProgramFact_C]ParticipationInfoCode	N/A

Back to Top

Report Output – Extract Version

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.

Item #	Data Element	Description	[Table]FieldName	Begin / End Position
1	District Code	PED Number for the district	[Prefs]Name=DistrictNumber [Prefs]Value	1/8
2	Location Code	The alternate school number is extracted, if populated. Otherwise, the report extracts the Location Code from the eScholar Programs Fact Record page, which is automatically populated with the school number. Use the following Location Codes for special education students not enrolled at an actual district location: 993 – Students who are hospitalized 997 – Students who are enrolled in a private school 998 – Students who are homebound 999 – Students who are home schooled	[Schools]Alternate_School_Number [S_NM_STU_X]LocationCode [Schools]School_Number For the Summer reporting period: [S_NM_STU_X]LocationCode [ReEnrollments]SchoolID [Schools]Alternate_School_Number	9/14
3	School Year	This value is automatically extracted as June 30^th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms. To change terms, click Terms at the top of the page and choose a term from the list. The value is extracted in the format YYYY-MM-DD.	[Terms]LastDay	15/24
4	Student ID	The state issued identification number.	[Students]State_StudentNumber	25/36
5	Programs Code	The program in which the student is enrolled. If the Program Code is 3Y or 4Y, then the Student Snapshot current grade level must equal PK. See the STARS Manual Volume 2 document available at https://webnew.ped.state.nm.us/bureaus/information-technology/stars-manual/ for a list of valid values.	[S_NM_STU_ProgramFact_C]ProgramCode Auto Record Generation: T1A [S_NM_SCH_X]T1A_Flag [S_NM_SCH_X]T1A_GP2 Through [S_NM_SCH_X]T1A_G12 BUS [S_NM_STU_X]EligibleBusSvc_YN BSCE [S_NM_STU_X]EligibleBusSvcVocEd_YN BUSA [S_NM_STU_X]BusA StartSmart [S_NM_STU_X]StartSmart_PF TitleIII [S_NM_STU_X]ESLModel TitleVII [S_NM_STU_X]FederalForm506_YN [S_NM_STU_X]TitleVIIParticipation_YN TitleVIII [S_NM_STU_X]TitleVIIIParticipation_YN TitleIAND [S_NM_STU_X]TitleIAND TitleIAPR [S_NM_STU_X]TitleIAPR	37/44
6	Beginning Date	The date the student enrolled in the program.	Calculated for each submission.	45/54
7	Ending Date	Not collected.	N/A	55/64
8	Not used	Not collected.	N/A	65/84
9	Program Intensity	The number of program hours for a student participating in a bilingual education program (BEP).	[S_NM_STU_ProgramFact_C]ProgramIntensity Auto Record Generation: BEP [S_NM_STU_X]BilingualEducation	85/104
10	Entry Reason Code 1	Not collected.	N/A	105/114
11	Entry Reason Code 2	Not collected.	N/A	115/124
12	Entry Reason Code 3	Not collected.	N/A	125/134
13	Exit Reason Code 1	Not collected.	N/A	135/144
14	Exit Reason Code 2	Not collected.	N/A	145/154
15	Exit Reason Code 3	Not collected.	N/A	155/164
16	Program Comment	If field 18 is “Other”, describe the model.	[S_NM_STU_ProgramFact_C]ProgramComment	165/224
17	Original Program Start Date	The date the student began receiving early intervening services. Required if the Program Code is CEIS, 3Y, 4Y, or FACE. The value is extracted in the format YYYY-MM-DD.	[S_NM_STU_ProgramFact_C]PgmStartDate	225/234
18	Participation Info Code	The student’s participation info code. This field is only required if the Program Code is one of the following: BEP ESL and the student is not participating in BEP CEIS See the STARS Manual Volume 2 document available at https://webnew.ped.state.nm.us/bureaus/information-technology/stars-manual/ for a list of valid values.	[S_NM_STU_ProgramFact_C]ParticipationInfoCode Auto Record Generation: BEP [S_NM_STU_X]BEPModel	235/240

Back to Top