Section 2 - TREx Data Element Descriptions

schema, which is a defined
structure based on standard tag-based formatting instructions. XML applications work with a schema to
allow institutions to transfer data in a format (extract file) that will be understood between varying
applications.
An XML schema is comprised of elements, also known as data elements. Elements can be blank,
required, or optional as specified by the schema. Elements also can be repeated if declared in the
schema. An example of this type of data element is a course grade. Other elements can be limited to a
single instance by the schema. An example of this type of data element is the student name.
Data elements that are shown as coded, refer to enumerated values for data types within the schema,
which is similar to using a code table. These are included in or defined as part of an XML Simple Type. To
reuse common data elements (such as Address, City, StateProvince and PostalCode), simple types are
grouped within a Complex Type. A data element is further defined by the related complex type within the
schema.
This section describes each of the TREx data elements. A legend of the information found on each data
element definition follows:
Information Description
Common Name
Common name of the element, many of which follow PEIMS and AAR standards
XML Name
XML name or tag for the data element as found in the XML schema
Complex Type
Name of the related XML complex type as found in the XML schema
Definition
Meaning of the data element
Special Instructions
Additional information or edit criteria for the data element, when applicable
Element ID
Unique ID assigned to the TREx data element and formatted as TE---.
(Reference to PEIMS data element number in the form E---- is included if
applicable.)
Code Table ID
Unique ID assigned to the TREx code table and formatted as TC--.
(Reference to a PEIMS code table that includes the same codes for this data
element in the form C---- is included if applicable.)
Required?
Indication whether the field is required or optional Yes - the element is required; if the requirement is only for specific grade
levels, this is noted; NA may be entered if data are not available/applicable No - the element is optional and may be left blank unless specified
otherwise in an edit or validation rule
Note: If a field is shown as not required but data are available and relevant to
the accuracy and completeness of the student record or transcript, it is the
responsibility of the campus to include these data. Examples include
indicators for ESL, Bilingual, GT, CTE, At Risk, Title I Part A, Special
Education, IEP, Personal Graduation Plan, Migrant, and Homeless.
2.1
2007-2008 TREx Data Standards
Section 2 TREx Data Element Descriptions

2.2
Information Description
Domain of Values
The acceptable values for the data element
Applicable Record
Record type on which the data element is located, i.e. student record and/or AAR-
transcript.
Length
Length of the data element in characters
Type
A data element is specified as one of the following:
NUMERIC value must be numeric characters value cannot be negative
TEXT value may be alpha-numeric characters alpha characters may be upper and/or lower case may include any of the following characters, in addition to the space
character:
ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz01234
56789 ~ ! @ # $ % ^ & * ( ) - _ + = : ; , . / < > ? may not include the following characters: \ { } [ ] |
CODED if a value is required, it may not contain blanks corresponds to a table in Section 3 of this manual
DATE YMD Type date is formatted as yyyy-mm-dd and includes year, month
and day YM Type date is formated as yyyy-mm and includes year and month only
DECIMAL value may be numeric characters and decimal point only decimal precision is required

Symbols found in Pattern are as follows:
Symbol
Restriction on Value
*
any of the characters accepted in the name field data type
.
decimal point
...
pattern continues without change
#
numeric characters "0" through "9"
mm month
dd day
Pattern
yyyy year
2007-2008TREx Data Standards
Section 2 TREx Data Element Descriptions
Data Elements

Common Name
XML Name
Complex Type
ACADEMIC-YEAR
SchoolYear AcademicSessionType
Definition
ACADEMIC-YEAR indicates a school year, for example 2007-2008. Based on the related complex type,
this can be either the current school year or the school year in which coursework was completed by the
student.
Special Instructions
Include a dash between the two academic years.
May be used for current or past academic years.
On a transcript, the school year should appear by Campus Awarding Credit or by each course credit
awarded.
This field can be repeated as needed.
Data Specifications
Element ID
Code Table ID
Required?
Domain of Values
TE001 Yes

Applicable Record
Length
Type
Pattern
Student Record
AAR-Transcript
9 TEXT
####-####


Common Name
XML Name
Complex Type
ADDRESS
Address SchoolType
AddressType
Definition
ADDRESS indicates the street address information for the student or campus address. For a campus, this
address also may be a post office box.
Data Specifications
Element ID
Code Table ID
Required?
Domain of Values
TE002 No
AddressType
Applicable Record
Length
Type
Pattern
Student Record
AAR-Transcript
50 TEXT
*

2.3
2007-2008 TREx Data Standards
Section 2 TREx Data Element Descriptions

Common Name
XML Name
Complex Type
ASSESSMENT-DATE
TestDate AssessmentType
Definition
ASSESSMENT-DATE is the date (month and year) on which an assessment instrument or test was taken by
the student. (This is also known as the Administration Date.)
Special Instructions
If the assessment date is included, then either a score or score code should be present.
Exit-level TAKS data are required for the high school transcript.
Data Specifications
Element ID
Code Table ID
Required?
Domain of Values
TE003
No yyyy = 1957-2012
mm = 01-12
Applicable Record
Length
Type
Pattern
Student Record
AAR-Transcript
7 DATE
yyyy-mm

Common Name
XML Name
Complex Type
ASSESSMENT-GRADE-LEVEL
TestLevel AssessmentType
Definition
ASSESSMENT-GRADE LEVEL is the grade level associated with the Assessment taken by the student.
Special Instructions
Include only the most recent assessment taken.
Data Specifications
Element ID
Code Table ID
Required?
Domain of Values
TE083

TC12
(PEIMS: C050)
No

Applicable Record
Length
Type
Pattern
Student Record
AAR-Transcript
2 CODED
##

2.4 2007-2008TREx Data Standards
Section 2 TREx Data Element Descriptions

Common Name
XML Name
Complex Type
ASSESSMENT-NAME
TestName AssessmentType
Definition
ASSESSMENT-NAME is the name of the assessment instrument or test taken by the student.
Special Instructions
If an assessment date and score are present, then the test name is required to be entered as well.
Exit-level TAKS data are required for the high school transcript.
Data Specifications
Element ID
Code Table ID
Required?
Domain of Values
TE004 TC01
No

Applicable Record
Length
Type
Pattern
Student Record
AAR-Transcript
2 CODED
##

Common Name
XML Name
Complex Type
ASSESSMENT-SCORE
TestScore AssessmentType
Definition
ASSESSMENT-SCORE is the scale score earned by the student on the assessment instrument or test.
Special Instructions
For TAKS tests, include the actual (scale) scores and not an asterisk. For lower grade levels if only a
mastery indicator is available, include that data.
For elementary grade levels, if only the mastery indicator is available, include that data.
If the student is receiving special education service and is exempt from the test, the term exempt should
be entered instead.
Exit-level TAKS data are required for the high school transcript.
Data Specifications
Element ID
Code Table ID
Required?
Domain of Values
TE005 No

Applicable Record
Length
Type
Pattern
Student Record
AAR-Transcript
6 TEXT
*

2.5
2007-2008 TREx Data Standards
Section 2 TREx Data Element Descriptions

Common Name
XML Name
Complex Type
ASSESSMENT-SCORE-CODE
TestCode AssessmentType
Definition
ASSESSMENT-SCORE-CODE is an explanation or notation related to the score earned by the student for
the assessment instrument or test.
Exit-level TAKS data are required for the high school transcript.
Data Specifications
Element ID
Code Table ID
Required?
Domain of Values
TE006 TC02 No

Applicable Record
Length
Type
Pattern
Student Record
1
CODED
*

Common Name
XML Name
Complex Type
ASSESSMENT-SUBTEST
AssessmentSubTest AssessmentType
Definition
ASSESSMENT-SUBTEST is the name of any subtest that is part of an assessment instrument or a test not
included in the standard coded values for ASSESSMENT-NAME.
Special Instructions
This field may be repeated as needed or left blank.
Examples of this type of assessment include those used to develop a Gifted and Talented profile for a
student.
Data Specifications
Element ID
Code Table ID
Required?
Domain of Values
TE007 No

Applicable Record
Length
Type
Pattern
Student Record
50
TEXT
*

2.6 2007-2008TREx Data Standards
Section 2 TREx Data Element Descriptions

Common Name
XML Name
Complex Type
AT-RISK-INDICATOR
AtRisk SpecialProgramsType
Definition
AT-RISK-INDICATOR indicates whether a student is currently identified as at-risk of dropping out of school
using state-defined criteria only (TE