User Tools

Site Tools


Sidebar

Table of Contents

extracts:fall:student

Student Fall Extract

State Reporting > Extracts > Fall > Student

Data extracted: InterchangeStudentExtension, InterchangeStudentEnrollmentExtension, and InterchangeStudentAttendanceExtension

All existing data is deleted and replaced by the extracted data.

IMPORTANT: Back up your database before extracting data.


The extract creates No Show leaver tracking records. The extract writes data to State Reporting for current students, No Show leavers, and prior year leavers.

  • If a district has no prior year enrollment data, the program assumes the students were promoted and subtracts 1 to determine the student's prior year grade level. Therefore, current year 7th grade No Show students are not extracted and must be manually added to the leaver tracking table.
  • If a student was enrolled in 7th grade or higher in the prior school year, is not enrolled in the current school year, and is not in the leaver tracking table, a warning message is printed on the report indicating that the student is a potential under-reported leaver.
  • If a student has a non-graduate leaver record for the prior school year but enrolled during the school-start window in the current school year, a warning message is printed on the report indicating that a leaver record was not extracted.
  • Withdrawal codes 02, 04, 09, 10, 14, 15, 19, 22, 30, 44, 61, 72, 79, and 84 are converted to PEIMS code 98.
  • Withdrawal codes 21, 31, 63, 64, and 80 are considered “movers” and are not extracted.

Extract data:

Ending School Year

(Display only) The submission year as entered in the Submission Year field on State Reporting > Options is displayed.

PEIMS Fall As-of Date

(Display only) The fall as-of date is displayed, as entered in the As-of Date field on State Reporting > Options.

School Start Window (SSW) Date

(Display only) The TEA school-start window date is displayed as entered in the School Start Window (SSW) Date field on State Reporting > Options.

Local Program for Dyslexia Reporting

(Display only) The district local program code used to track dyslexic students is displayed, as entered in the Local Program for Dyslexia Reporting field on State Reporting > Options.

Local Program for Early College High School Reporting

(Display only) The district local program code used to track students participating in the Early College High School (ECHS) program is displayed, as entered in the Local Program for Early College High School Reporting field on State Reporting > Options.

Local Program for IGC Reporting

(Display only) The district local program code used to track students assigned to an Individual Graduation Committee (IGC) is displayed, as entered in the Local Program for IGC Reporting field on State Reporting > Options.

Local Program Code for Intervention Strategy

(Display only) The district local program code used to track students participating in an intervention strategy at any time of the year is displayed, as entered in the Local Program for Intervention Strategy field on State Reporting > Options.

Local Program for New Tech

(Display only) The district local program code used to track students in grade level 7-12 and enrolled in a New Tech Network campus as identified by the New Tech Network, as entered in the Local Program for New Tech field on State Reporting > Options.

Local Program for Pathways in Technology

(Display only) The district generic program code used to track students in grade levels 9-12 who are participating in the Pathways in Technology (P-TECH) Early College High School program is displayed, as entered in the Generic Program for Pathways in Technology field on State Reporting > Options.

Local Program Code for Section 504

(Display only) The district local program code used to track students who receive assistance through either an aid, accommodation, or service under Section 504 Rehabilitation Act of 1973 at any time during the school year is displayed, as entered in the Local Program for Section 504 field on State Reporting > Options.

Local Program for T-STEM Academy Reporting

(Display only) The district local program code used to track students participating in the Texas Science, Technology, Engineering and Mathematics (T-STEM) Initiative program is displayed, as entered in the Local Program for T-STEM Academy Reporting field on State Reporting > Options.

Default Values for Prior Year Leavers

The following values are used if either the Graduation Type and/or Graduation Date field is blank on Registration > Maintenance > Prior Year Leaver Tracking:

Graduation Date

Type the month and year of the graduation date.

Graduation Type

Type the plan under which the student graduated (e.g., 34 - Foundation High School Program).

TWEDS Data Element: GRADUATION-TYPE-CODE (E0806) (Code table: C062)

These fields must contain values if you are reporting any graduates (i.e., students with leaver code 01 - Graduate).

Email

(Optional) Type your email address if you wish to receive email notification when the extract is complete.

❏ Click Run.

A message is displayed indicating that the extract has started.

You can either wait for an email notification that the extract is complete, or view the status of the extract on Extracts > Extracts Status.

The email message is delivered to your Inbox once the extract is completed, if you entered an email address.



❏ When your extract is complete, you can view the associated error reports from Extracts > Extracts Status.

NOTE: You cannot maintain data on State Reporting maintenance pages while running an extract; a message is displayed on all fall maintenance pages indicating that the extract is in progress, and the Save button is disabled.




extracts/fall/student.txt · Last modified: 2020/11/13 17:20 by apape