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:
|
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)