Skip to main content
Skip table of contents

Student Unique ID Request

The Student Unique ID Request extracts information for the assignment of the state unique student identification number. The Texas Education Data Standards (TEDS) requires that each student has a state-assigned unique ID.

Selection Criteria

Selection criteria determine which database records are used in the report.

School Selection

The report selects school records to include based on the following criteria:

  • The school must be associated with a student included in the report.

Student Selection

The report selects student records to include based on the following criteria:

  • The student must have a blank State Student Number.
  • The student must not be excluded from state reporting.
  • The student must not be considered a no-show.
  • The student must have enrollment or re-enrollment records that fall within the user-selected start and end dates for the report.
  • The following required student demographic fields must be populated with valid values:
    • Student Name (last and first names)
    • Federal Ethnicity
    • Race Code
    • Birthdate
    • SSN
  • The student's State Grade Level must contain a valid value, if populated.

Report Input

Each of the available run options and data fields for the report is described below. 

Field

Description

Select Schools

If run at the district level, choose one of the following:

  • Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.
  • All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Current Selection Students

Indicate which students to include in the report by selecting one of the following options:

  • The Selected [number] Students Only – Run the report for students in the current selection.
  • All Students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student or group of students, select the students prior to running the report.

School Year

Choose the school year for the student enrollment data you want to include in the report. This value populates the school year field within the extract.

Note: Verify that the start and end dates populated are within the school year selected. At the present time, SRP does not allow for data validation to prevent these from being out of sync.

Start Date

Enter a start date for the report.

End Date

Enter an end date for the report

Transmission ID

Enter a local identifier to include in the file header and trailer records. If left blank, the first 10 characters of the current user's last name outputs on the record.

Note: This field may not exceed 10 characters.

Schedule

Select this option if the user wants to run this report on a scheduled basis. Once this option is selected the following choices are:

  • Run Once
    • Start Date and Start Time to run the report.
  • Repeat
    • Select Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report.
      • If Daily is selected, check the Weekdays only box to limit to weekdays.
      • If Weekly is selected, check which weekday to run the report.
      • If Monthly is selected, check the month to run the report.
      • If Yearly is selected, select either the date or the weekday to run the report.
  • Date Range – Select No End Date or a date that the re-occurrence should end.

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

This extract creates a comma-delimited file.

Position

Data Element

Description

[Table]FieldName
Req'd
Length

Header Record Layout

The header record is the first record in the file.

1

Record Type

The record type.

'TH'Yes2

2

Extract Date

The date the extract was run.

DerivedYes10

3

Extract Time

The time the extract was run.

DerivedYes8

4

Transmission ID

The identifier of the submitter. Used for auditing.

Derived

The runtime parameter, Transmission ID, if populated. Otherwise the last name of the user logged into the system.

Yes10

5

Version

The TEDS version.

'3.0'Yes10

6

Delimiter

The type of file delimiter. Hard-coded as 0X2C to note that the delimiter is a comma.

'0X2C'Yes4

7

Source Name

The name of the source. Hard-coded as SIS for students.

'SIS'YesN/A

8

Text Qualifier

The type of text qualifier. Hard-coded as 0X22 to note that the qualifier is double quote.

'0X22'YesN/A

Detail Record Layout

All fields that are reserved and not used by TEA must be included as blank, separated by a comma, and in double quote. The detail records represent the individual student event data.

1

Record Type

The record type.

'ID'Yes2

2

Current School Code

The school where the student is enrolled.


[Students]SchoolID

[Reenrollments]SchoolID

[Schools]Alternate_School_Number

[Schools]School_Number

Yes9

3

Reserved Field

Not used by TEA. Always blank.

N/ANo20

4

Last Name

The student's legal last name.

Override: [S_TX_STU_X]E0705

[Students]Last_Name

Yes60

5

First Name

The student's legal first name.

Override: [S_TX_STU_X]E0703

[Students]First_Name

Yes60

6

Middle Name

The student's legal middle name.

Override: [S_TX_STU_X]E0704

[Students]Middle_Name

No60

7

Name Suffix

The student's generational suffix code.

[S_TX_STU_X]E0706No1

8

Gender

The student's gender.

[Students]GenderYes1

9

Date of Birth

The student's birth date.

[Students]DOBYes10

10

Current Grade Level Code

The student's grade level.

[S_TX_STU_X]State_Grade_Level

[Students]Grade_Level

[S_TX_REN_X]State_Grade_Level

[Reenrollments]Grade_Level

Yes2

11

Local Student ID

The student's local ID number. This field provides a mechanism to import student data from the TSDS Unique ID system back into local systems.

[Students]Student_NumberYes9

12

Social Security Number or S-#

The student's social security number.

[Students]SSNYes9

13

Race

The student's race code.

[StudentRace]RaceCDYes1

14

TSDS Uniq-ID

The student's state unique identifier.

[Students]State_StudentNumber

This field will be blank for new Unique ID Requests.

Yes10

15

Current District Code

The district where the student is enrolled.

[Prefs]DistrictNumberYes6

16

Current School Year

The current school year for the data contained in the extract. This value extracts from the school year runtime parameter selected on the report input.

[Terms]YearIDYes4

17

Alternate Last Name

The student's maiden name. This field is not stored in PowerSchool and is an optional field per TEA.

N/ANo25

18

Reserved Field

Not used by TEA. Always blank.

N/ANo25

19

Reserved Field

Not used by TEA. Always blank.

N/ANo25

20

Reserved Field

Not used by TEA. Always blank.

N/ANo25

21

Reserved Field

Not used by TEA. Always blank.

N/ANo25

22

Reserved Field

Not used by TEA. Always blank.

N/ANo25

23

Reserved Field

Not used by TEA. Always blank.

N/ANo25

24

Reserved Field

Not used by TEA. Always blank.

N/ANo25

25

Reserved Field

Not used by TEA. Always blank.

N/ANo25

26

Reserved Field

Not used by TEA. Always blank.

N/ANo25

27

Reserved Field

Not used by TEA. Always blank.

N/ANo25
28

Reserved Field

Not used by TEA. Always blank.

N/ANo25
29

Reserved Field

Not used by TEA. Always blank.

N/ANo25
30

Reserved Field

Not used by TEA. Always blank.

N/ANo25

31

Ethnicity Indicator

The student's Hispanic/Latino indicator.

Valid values:

  • 1 - Hispanic/Latino
  • 0 - Not Hispanic/Latino.
[Students]FedEthnicityYes1

32

Race 2 Code

If the student has multiple race codes, this field contains the second code.

[StudentRace]RaceCD

No1

33

Race 3 Code

If the student has multiple race codes, this field contains the third code.

[StudentRace]RaceCDNo1

34

Race 4 Code

If the student has multiple race codes, this field contains the fourth code.

[StudentRace]RaceCDNo1

35

Race 5 Code

If the student has multiple race codes, this field contains the fifth code.

[StudentRace]RaceCDNo1
36

Reserved Field

Not used by TEA. Always blank.

N/ANo10
37

Reserved Field

Not used by TEA. Always blank.

N/ANo60
38

Reserved Field

Not used by TEA. Always blank.

N/ANo100
39

Reserved Field

Not used by TEA. Always blank.

N/ANo60
40

Reserved Field

Not used by TEA. Always blank.

N/ANo50
41

Reserved Field

Not used by TEA. Always blank.

N/ANo50
42

Reserved Field

Not used by TEA. Always blank.

N/ANo30
43

Reserved Field

Not used by TEA. Always blank.

N/ANo30
44

Reserved Field

Not used by TEA. Always blank.

N/ANo2
45

Reserved Field

Not used by TEA. Always blank.

N/ANo17
46

Reserved Field

Not used by TEA. Always blank.

N/ANo22
47

Reserved Field

Not used by TEA. Always blank.

N/ANo20
48

Reserved Field

Not used by TEA. Always blank.

N/ANoN/A
49

Reserved Field

Not used by TEA. Always blank.

N/ANo20
50

Reserved Field

Not used by TEA. Always blank.

N/ANo20
51

Reserved Field

Not used by TEA. Always blank.

N/ANo125
52

Reserved Field

Not used by TEA. Always blank.

N/ANo25
53

Reserved Field

Not used by TEA. Always blank.

N/ANo20
54

Reserved Field

Not used by TEA. Always blank.

N/ANo2
55Submission Purpose

The type of data in the input file.

Hard-coded as 001 for assignment.

'001'Yes3
56Person Type

The type of person on the record.

Hard-coded as 02 for student.

'02'Yes2
57

Reserved Field

Not used by TEA. Always blank.

N/ANo1
58

Reserved Field

Not used by TEA. Always blank.

N/ANo100
59Entry/Exit DateThis field is blank for ID Assignment records.BlankNoN/A
60Entry/Exit TypeThis field is blank for ID Assignment records.BlankNo2
61

Reserved Field

Not used by TEA. Always blank.

N/ANo100
62Entry/Exit Verified FlagThis field is blank for ID Assignment records.BlankNo1
63Reserved FieldNot used by TEA. Always blank.N/ANoN/A
64Reserved FieldNot used by TEA. Always blank.N/ANoN/A
65Reserved FieldNot used by TEA. Always blank.N/ANo25
66Reserved FieldNot used by TEA. Always blank.N/ANo100
67Reserved FieldNot used by TEA. Always blank.N/ANo100
68Reserved FieldNot used by TEA. Always blank.N/ANo100
69Reserved FieldNot used by TEA. Always blank.N/ANo100
70Reserved FieldNot used by TEA. Always blank.N/ANoN/A
71Reserved FieldNot used by TEA. Always blank.N/ANoN/A
72Reserved FieldNot used by TEA. Always blank.N/ANo3
73Reserved FieldNot used by TEA. Always blank.N/ANo255
74Reserved FieldNot used by TEA. Always blank.N/ANo255
75Reserved FieldNot used by TEA. Always blank.N/ANo255
76Reserved FieldNot used by TEA. Always blank.N/ANo12
77Reserved FieldNot used by TEA. Always blank.N/ANo50
78Reserved FieldNot used by TEA. Always blank.N/ANo10

Trailer Record Layout

The trailer record is the last record in the file.

1

Record Type

The type of record.

'TT'Yes2

2

Transmission ID

The identifier of the submitter. Used for auditing.

Derived

The runtime parameter, Transmission ID, if populated. Otherwise the last name of the user logged into the system.

Yes10

3

Number of Records

The number of records in the file, including the header and trailer records.

DerivedYes10
JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close