Skip to main content
Skip table of contents

Unique ID Report (TEA) - File Layout

The file format of the TX Unique ID report is the same format required by the Upload Unique ID option.

Header Record Layout

The header record is the first record in the file with one column in the following format:

Constant “TH”, Extract date, Extract time, transmission id (from the TX Unique ID Report (TEA) page), constant “3.0 delimiter=0X2C qualifier=0X22 source=HR”

Detail Record Layout

The following table lists the fields, data types, whether required, and the data source.

Field

Data type

Required?

Data Source

Record Type

VarChar(2)

Yes

Constant “ID”

Current School Code

VarChar(9)

Yes

The six-character district code from hrmstate.state53 followed by the three-character hrm_locn.code

where

hrm_locn.code = r_person.location

Reserved Field

VarChar(20)

No

blank

Last Name

VarChar(60)

Yes

employee.l_name

The limit is 25 characters.

First Name

VarChar(60)

Yes

employee.f_name

The limit is 17 characters.

Middle Name

VarChar(60)

No

employee.m_name

The limit is 14 characters.

Name Suffix

VarChar(1)

No

The values from the employee.name_suffix field are translated as follows:

  • JR = 1

  • SR = 2

  • II = 3

  • III = 4

  • IV = 5

  • V = 6

  • VI = 7

  • VII = 8

  • VIII = 9

  • I = A

  • IX = B

  • X = C

Gender

VarChar(1)

Yes

r_person.sex

Date of Birth

VarChar(10)

Yes

employee.birthdate

Current Grade Level Code

VarChar(2)

Yes

Constant “00”

Local Student ID

VarChar(9)

Yes

employee.empl_no

Social Security Number or S-#

VarChar(9)

Yes

employee.ssn

Race

VarChar(1)

Yes

races.race_code

where

indx = 1

TSDS Uniq-ID

VarChar(10)

No

empuser.ftext9

Current District Code Y

VarChar(6)

Yes

hrmstate.state_53

Current School Year

VarChar(4)

Yes

fam_prof.yr

Alternate Last Name

VarChar(25)

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Ethnicity Indicator

VarChar(1)

Yes

Person.ethnic_code

If ethnic_code is H, 1 is displayed. Otherwise, 0 is displayed.

Race 2 Code

VarChar(1)

No

races.race_code

where

indx = 2

Race 3 Code

VarChar(1)

No

races.race_code

where

indx = 3

Race 4 Code

VarChar(1)

No

races.race_code

where

indx = 4

Race 5 Code

VarChar(1)

No

races.race_code

where

indx = 5

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Submission Purpose

VarChar(3)

Yes

Constant “001”

001 indicates assignment, and 002 indicates enrollment.

Person Type

VarChar(2)

Yes

Constant “03”

03 indicates staff, and 02 indicates student.

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Entry/Exit Date

Date

Yes/No

blank

Entry/Exit Type

Date

Yes/No

blank

Reserved Field

Not applicable

No

blank

Entry/Exit Verified Flag

VarChar(1)

Yes/No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Reserved Field

Not applicable

No

blank

Record Comments

VarChar (2048)

No

blank (only used in a canceled record file)

Trailer Record Layout

The trailer record is the final record in the file with one column in the following format:

Constant “TT”, transmission ID (from the TX Unique ID Report (TEA) page), count of records in the file (including header and trailer)

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.