Classic View: TX State Reporting > PreCode Extracts > TELPAS

Search Terms: PreCode Extracts, TELPAS Extract, TELPAS

The Texas English Language Proficiency Assessment System includes all students enrolled in grades K through 12 who are identified as an English Learner (EL). These students are administered state-identified proficiency assessments annually in listening, speaking, reading and writing to fulfill state and federal requirements. The assessment is designed to assess the progress of limited English proficient students in learning the English language.

PreCode Extract Editor Example

Report Logic

All students enrolled in grades K-12 who have an EL Program Status of EL that is active on the Effective Date report a record.
If a student has one enrollment that is active on the Effective Date and it has a Service Type of N: Special Ed Services OR S: Partial, that enrollment reports.
- If more than one active enrollment exists for a student, only the P: Primary enrollment reports.
Students participating in the TAKS-Alt assessment do NOT report.
Students, Grade Levels or Calendars marked State Exclude do not appear in the report.
Students with no State ID or who are marked as No Show do not report.
Any data that is missing or not applicable will report as spaces/blanks.

Report Layout

Element

Description

Location

GRADE-LEVEL-CODE

The current grade level of the student's enrollment.

Alphanumeric, 2 characters

Student Information > General > Enrollments > Grade

Database:
Enrollment. grade

CAMPUS-ID-OF-ENROLLMENT

The unique school identification number made up the the district number and school number of the school in which the student is enrolled.

Numeric, 9 digits

System Administration > Resources > District Information > State District Number AND System Administration > Resources

Database:
District. number
School. number

DISTRICT-NAME

The name of the district in which the student is enrolled.

Alphanumeric, 15 characters

System Administration > Resources > District Information > Name

Database:
District.name

CAMPUS-NAME

The name of the campus or school in which the student is enrolled.

Alphanumeric, 15 characters

System Administration > Resources > School > Name

Database:
School.name

GROUP NAME

The Group/Teacher chosen in the Extract Editor.

If Selected Period or Homeroom is chosen in the extract editor, reports course number - section number and Teacher Display Name.

If Grade Level is selected, reports grade level of the student on the effective date of the report.

Alphanumeric, 20 characters

Student Information > General > Enrollments > Grade OR Scheduling > Courses > Course > Number

Scheduling > Courses > Section > Section Number

Scheduling > Courses > Section > Teacher Display Name

Scheduling > Courses > Section > Homeroom

Database:
Not dynamically stored

LAST-NAME

The legal last name of the student.

Alphanumeric, 15 characters

Census > People > Demographics > Last Name

Database:
Identity.lastName

FIRST-NAME

The legal first name of the student.

Alphanumeric, 10 characters

Census > People > Demographics > First Name

Database:
Identity. firstName

MIDDLE-INITIAL

The student's middle initial.

Alphanumeric, 1 character

Census > People > Demographics > Middle Name

Database:
Identity.middleName

PEIMS-ID

Either the student's social security number or a state-approved alternative ID number consisting of an "S" followed by 8 digits.

Alphanumeric, 9 characters

Census > People > Demographics > Soc Sec Number

Census > People > Demographics > Person Information > Previous.stateID

Database:
Identity.ssn
Previous.stateID

SEX-CODE

Identification of the student as male or female.

Alpha, 1 character M or F

Census > People > Demographics > Gender

Database:
Identity. gender

DATE-OF-BIRTH

The month, day and year on which the student was born.

Date field, 6 characters MMDDYY

Census > People > Demographics > Date of Birth

Database:
Identity. birthdate

HISPANIC-LATINO-CODE (ETH)

Indicates if the student is of Hispanic/Latino descent. Reports 1:Yes or 0: No.

Numeric, 1 digit

Census > People > Demographics > Race/Ethnicity > Is the individual Hispanic/Latino?

Database:
Identity. hispanic Ethnicity

AMERICAN-INDIAN-ALASKA-NATIVE-CODE (I)

Indicates if the student is of American Indian or Alaska Native descent. Reports 1:Yes or 0: No.

Numeric, 1 digit

Census > People > Demographics > Race/Ethnicity > American Indian or Alaska Native

Database:
Identity. raceEthnicity

ASIAN-CODE (A)

Indicates if the student is of Asian descent. Reports 1:Yes or 0: No.

Numeric, 1 digit

Census > People > Demographics > Race/Ethnicity > Asian

Database:
Identity. raceEthnicity

BLACK-AFRICAN- AMERICAN-CODE (O)

Indicates if the student is of Black or African American descent. Reports 1:Yes or 0: No.

Numeric, 1 digit

Census > People > Demographics > Race/Ethnicity > Black or African American

Database:
Identity. raceEthnicity

NATIVE-HAWAIIAN-PACIFIC-ISLANDER-CODE (P)

Indicates if the student is of Native Hawaiian or Other Pacific Islander descent. Reports 1:Yes or 0: No.

Numeric, 1 digit

Census > People > Demographics > Race/Ethnicity > Native Hawaiian or Other Pacific Islander

Database:
Identity. raceEthnicity

WHITE-CODE (W)

Indicates if the student is of White descent. Reports 1:Yes or 0: No.

Numeric, 1 digit

Census > People > Demographics > Race/Ethnicity > White

Database:
Identity. raceEthnicity

ECONOMIC-DISADVANTAGE-CODE (ED)

Indicates if the student is considered to be economically disadvantaged.

Code	Description
1	If the student has an Active Eligibility Status within the current school year as of the Effective Date entered on the report editor and an eligibility status of Free.
2	If the student has an Active Eligibility Status within the current school year as of the Effective Date entered on the report editor and an eligibility status of Reduced.
0	If the student has an Active Eligibility Status within the current school year as of the Effective Date entered on the report editor and an eligibility status of Paid or Non-reimbursable OR if the student does not have an active eligibility and the 'Code 99' checkbox is not marked on the student's enrollment.
9	If the student does not have an active eligibility and the 'Code 99' checkbox is marked on the student's enrollment.

Numeric, 1 digit

FRAM > Eligibility > Eligibility AND Student Information > General > Enrollments > State Reporting Fields > Code 99

Database:
POSeligibility. eligibility EnrollmentTX. code99

TITLE-I-PART-A-INDICATOR-CODE (TIA)

Indicates if the student is participating in a program authorized under ESEA, Title 1, Part A of the Improving America's School Act.

If Title 1 is selected in the School History tab, this element reports 6 regardless of any Title I records.

If there is no school-wide program, then this element reports from Student Information > Program Participation > Title 1.

The value reports from the most recent active record on the Effective Date.
- If multiple records exist, the value reports from the record with no end date.
- If all records are end dated then use record with the highest ID (last created).
If the student's reporting record contains the value A, then 0 reports.

Numeric, 1 digit

System Administration > Resources > School > School History > Title 1

Student Information > Program Participation > Title 1

Database:

School.title1

Title1.title1Program

MIGRANT-INDICATOR-CODE (MS)

Indicates if the student has been identified as a migrant. Reports 1:Yes or 0: No.

Numeric, 1 digit

Student Information > General > Enrollments > State Reporting Fields > Migrant

Database:
Enrollment. migrant

LEP-INDICATOR-CODE

Indicates whether the student is identified as Limited English Proficient by the Language Proficiency Assessment Committee (LPAC).

If the student has an EL Program Status that is active on the Effective Date (or has an F/S code and the current date is prior to the Second Year Monitoring date),the code in the EL field reports as outlined below.

EL Program Status	Reports
EL	C
Exited EL Current date is prior to First Year Monitoring date)	F
Exited EL Current date is after First Year Monitoring date, but prior to Second Year Monitoring date)	S
Exited EL Current date is after the Second Year Monitoring Date but prior to the Third Year Monitoring Date.	3
Exited EL Current date is after the Third Year Monitoring Date but prior to the Fourth Year Monitoring Date.	4
Not EL or Null	0

Alphanumeric, 1 character

Student Information > Program Participation > EL > EL Services > EL Program Status

Database:
Not dynamically stored

BILINGUAL-PROGRAM-TYPE-CODE (B)

Indicates if the student is participating in a state-approved bilingual education program. If the student has B2-B5 for an EL Service Type for a record active on the Effective Date, reports as follows. Otherwise reports as 0. Options are:

0: No Bilingual Program Participation
2: Transitional Bilingual Early Exit
3: Transitional Bilingual Late Exit
4: Dual Language Immersion/two-way
5: Dual Language Immersion/one-way

Numeric, 1 digit

Student Information > Program Participation > English Learners (EL) > EL Services

Database:
EslStatusTX. bilingual

ESL-PROGRAM-TYPE-CODE (ESL)

Indicates if the student is participating in a state-approved English as a Second Language (ESL) program. If the student has an EL Service Type of E2 or E3 for a record active on the Effective Date, reports as follows. Otherwise reports as 0. Options are:

0: No ESL program participation
2: ESL Content-based
3: ESL Pull-out

Numeric, 1 digit

Student Information > Program Participation > English Learners (EL) > EL Services

Database:
EslStatusTX.esl

SPECIAL-ED-INDICATOR-CODE (SE)

Indicates if the student is participating in a special education instruction and related services program or a general education program using special education support services, supplementary aids, or other special arrangements. Reports 1:Yes or 0: No.

Numeric, 1 digit

Student Information > Special Education > Documents > Plan

Database:
Plan.status

GIFTED-TALENTED-INDICATOR-CODE (G/T)

Indicates if the student is participating in a state-approved gifted and talented program. Reports 1:Yes or 0: No.

Numeric, 1 digit

Student Information > General > Programs > Program > GT: Gifted & Talented

Database:
Program.type

AT-RISK-INDICATOR-CODE (AR)

Indicates if the student is designated as being at risk of dropping out of school under state-mandated academic criteria only. Reports 1:Yes or 0: No.

Numeric, 1 digit

Student Information > General > Enrollments > State Reporting Fields > At Risk

Database:
EnrollmentTX.atRisk

CAREER-AND-TECHNICAL-ED-IND-CD (CT)

Indicates if the student is enrolled in one or more state-approved vocational education courses.

Reports 2 when a Career Tech program record exists (Student Information > Program Admin > Programs > Career Tech Programs > Career Tech Program Detail) with the following selections:

Active = Checked
State Reported = Checked
School = the calendar to which the current reporting enrollment is tied

Reports 1 for student currently enrolled in a course with a check in the Career and Technical Ed Services checkbox who do not have a current Career Tech program.

Otherwise, 0 reports.

Numeric, 1 digit

Database:
CteStatusTX. indicator

Local Use - Filler

N/A

LOCAL-STUDENT-ID

The local Student ID assigned by school district.

Alphanumeric, 9 characters

Census > People > Demographics > Person Identifiers > Local Student Number

Database:
Person. student Number

YEARS IN U.S. SCHOOLS (TELPAS Only)

The number of years the student has been enrolled in a US school.

This field reports 1 if the Date Entered US School occurs in the current school year.

This field reports 6 if the Date Entered US School occurs on or before 7/31 of the previous school year minus 4 years.

Numeric, 1 digit

Census > People > Demographics > Date entered US School

Database:
Calculated, not dynamically stored

PARENTAL DENIAL CODE

Indicates that the student's parent or guardian has denied placement of the student in and special language program. If Parental Permission code = C: Denied placement in any special language program, report 1. Otherwise 0 reports.

Numeric, 1 digit

Student Information > Program Participation > English Learners (EL) > EL Services> Service Type > Parental Permission

Database:
Custom Program
program Participation. parental Permission

Filler 2

N/A

Test Code

Populates on the student registration export.

Currently reports blank.

N/A

Filler 3

N/A

TELPAS CODE

Reports as A.

Alphanumeric, 1 character

Not dynamically stored

Filler 4

N/A

UNSCHOOLED ASYLEE/REFUGEE CODE

Indicates whether a student's initial enrollment in a school in the United States in grades 7 through 12 was as an unschooled asylee or refugee. Options are:

0: Not Applicable
1: Refugee
2: Asylee

Numeric, 1 digit

Census > People > Demographics > Person Information > Asylee Refugee

Database:
Identity.refugee

STUDENTS WITH INTERRUPTED FORMAL EDUCATION (SIFE) CODE

Indicates whether a student's education was interrupted. This field reports Y or N.

Alphanumeric, 1 character

Student Information > Enrollment > Assessments > Interrupted Formal Education

Database:
EnrollmentTX.interruptedFormalEdu

Filler 5

N/A

TX-Unique-Student-ID

Indicates the students TX Unique State ID.

Census > People > Demographics > Person Identifiers > Student Unique State ID

TELPAS Session Name

Assigns a student into a session.

N/A

Filler 6

N/A

HOME COUNTY/DISTRICT/CAMPUS CODE

Identifies the home school of the student being assessed. This field reports the Assessment Home County/District Code concatenated with the Campus Code.

Numeric, 9 digits

Student Information > Enrollment > Assessments > Assessment Home County/District Code

AND

Student Information > Enrollment > Assessments > Home Campus Code

Database:

EnrollmentTX.homeDisCountyCode

EnrollmentTX.homeCampusCode

Filler 7

N/A

TELPAS (PreCode Extracts) (Texas)

Report Logic

Report Layout

Related Articles