Tool Search: Precode Extract
The Texas Assessment of Knowledge and Skills includes all students in grades 3 through 10 who are not participating in the TAKS alternate assessment. TAKS assessments are designed to measure the extent to which a student has learned and is able to apply the defined knowledge and skills at each tested grade level. This assessment measures a student's mastery of the state mandated curriculum, the TX Essential Knowledge and Skills (TEKS).
Precode Extract Editor
Report Logic
Report Layout
| Element | Description | Location |
|---|---|---|
GradeLevel Code Required | The current grade level of the student's enrollment. Alphanumeric, 2 characters | Student Information > General > Enrollments > Grade Database: Enrollment. grade |
CampusIDof Enrollment Required | 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 System Administration > Resources > School > State School Number Database: District. number School. number |
DistrictName Required | The name of the district in which the student is enrolled. Alphanumeric, 15 characters | System Administration > Resources > District Information > Name Database: District.name |
CampusName Required | The name of the campus or school in which the student is enrolled. Alphanumeric, 15 characters | System Administration > Resources > School > Name Database: School.name |
GroupName Required | 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 |
LastName Required | The legal last name of the student. Alphanumeric, 15 characters | Census > People > Demographics > Last Name Database: Identity. lastName |
FirstName Required | The legal first name of the student. Alphanumeric, 10 characters | Census > People > Demographics > First Name Database: Identity. firstName |
MiddleName Conditional | The student's middle initial. Alphanumeric, 1 character | Census > People > Demographics > Middle Name Database: Identity. middleName |
PIEMS ID Required | 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 OR Census > People > Demographics > Person Information > Previous State ID Database: Identity.ssn Previous.stateID |
SexCode Required | Identification of the student as male or female. Alpha, 1 character M or F | Census > People > Demographics > Gender Database: Identity. gender |
DateofBirth Required | 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 |
Filler 1 Required | N/A | N/A |
LocalUse - Filler Required | N/A | N/A |
LocalStudentID Required | The local Student ID assigned by school district. Alphanumeric, 9 characters | Census > People > Demographics > Person Identifiers > Local Student Number Database: Person. student Number |
Filler 2 Required | N/A | N/A |
ReadingELA ScoreCode Required | Indicates if the student is enrolled in an active ESL/Bilingual Program and is exempt from reading/ELA requirements. If the Reading/ELA Exempt checkbox is checked, reports as X. Otherwise reports as blank. Alphanumeric, 1 character | Student Information > Program Participation > English Learners (EL) > EL Accommodations > Reading/ELA Exempt Database: EslStatusTX.readingELAExempt |
Mathmatics ScoreCode Required | Indicates if the student is enrolled in an active ESL/Bilingual Program and is exempt from math requirements. If the Mathematics Exempt checkbox is checked, reports as X. Otherwise reports as blank. Alphanumeric, 1 character | Student Information > Program Participation > English Learners (EL) > EL Accommodations > Mathematics Exempt Database: EslStatusTX.mathematicsExempt |
Filler 3 Required | N/A | N/A |
Science ScoreCode Required | Indicates if the student is enrolled in an active ESL/Bilingual Program and is exempt from science requirements. If the Science Exempt checkbox is checked and the student is in grade 10 or 11 on the Effective Date, reports as X. Otherwise reports as blank. Alphanumeric, 1 character | Student Information > Program Participation > English Learners (EL) > EL Accommodations > Science Exempt Database: EslStatusTX. scienceExempt |
SocialStudies ScoreCode Required | Indicates if the student is enrolled in an active ESL/Bilingual Program and is exempt from social studies requirements. If the Social Studies Exempt checkbox is checked and the student is in grade 10 or 11 on the Effective Date, reports as X. Otherwise reports as blank. Alphanumeric, 1 character | Student Information > Program Participation > English Learners (EL) > EL Accommodations > Social Studies Exempt Database: EslStatusTX.socialStudiesExempt |
Filler 4 Required | N/A | N/A |
Home County/District/Campus Code Optional | 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 5 Required | N/A | N/A |
