Staff Unique ID Request

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.

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.

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.

Staff to Include

Select which staff to include in the report.

• All Staff

• Teachers Only

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 OnceStart Date and Start Time to run the report.

• RepeatSelect 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.

Header Record Layout

The header record is the first record in the file.

1

Record Type

The record type.

'TH'

Yes

2

2

Extract Date

The date the extract was run.

Derived

Yes

10

3

Extract Time

The time the extract was run.

Derived

Yes

8

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.

Yes

10

5

Version

The TEDS version.

'3.0'

Yes

10

6

Delimiter

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

'0X2C'

Yes

4

7

Source Name

The name of the source. Hard-coded as HR for staff members.

'HR'

Yes

N/A

8

Text Qualifier

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

'0X22'

Yes

N/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 staff event data.

1

Record Type

The record type.

'ID'

Yes

2

2

Current School Code

The school where the staff member is employed.

Note: For non-campus staff, the report outputs 000 as the last three digits of the current school code (for example, 227901000).

[S_TX_USR_RESP_C]SchoolID

Yes

9

3

Reserved Field

Not used by TEA. Always blank.

N/A

No

20

4

Last Name

The staff member's last name.

[UsersCoreFields]PSCore_Legal_Last_Name if populated.

Otherwise, [Users]Last_Name

Yes

60

5

First Name

The staff member's first name.

[UsersCoreFields]PSCore_Legal_First_Name if populated.

Otherwise, [Users]First_Name

Yes

60

6

Middle Name

The staff member's middle name.

[UsersCoreFields]PSCore_Legal_Middle_Name if populated.

 Otherwise, [Users]Middle_Name

No

60

7

Name Suffix

The staff member's generational suffix code.

[UsersCoreFields]PSCore_Legal_Suffix if populated.

Otherwise, [S_TX_USR_X]E0706_Generation_Code

No

1

8

Gender

The staff member's gender.

[UsersCoreFields]Gender

Yes

1

9

Date of Birth

The staff member's birth date.

[UsersCoreFields]DOB

Yes

10

10

Current Grade Level Code

For staff members, this outputs as 00.

'00'

Yes

2

11

Local Student ID

The staff member's local ID number. This field is used for the local Human Resource System.

[S_TX_USR_RESP_C]ID

Yes

9

12

Social Security Number or S-#

The staff member's social security number.

[Users]SSN

Yes

9

13

Race

The staff member's race code.

[TeacherRace]RaceCD

Yes

1

14

TSDS Uniq-ID

The staff member's state unique identifier.

[Users]SIF_StatePrid

Yes

10

15

Current District Code

The district where the staff member is employed.

[Prefs]DistrictNumber

Yes

6

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.

Derived

Yes

4

17

Alternate Last Name

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

N/A

No

25

18

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

19

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

20

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

21

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

22

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

23

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

24

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

25

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

26

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

27

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

28

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

29

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

30

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

31

Ethnicity Indicator

The staff member's Hispanic/Latino indicator.

Valid values:

• 1 - Hispanic/Latino

• 0 - Not Hispanic/Latino.

[Users]FedEthnicity

Yes

1

32

Race 2 Code

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

[TeacherRace]RaceCD

No

1

33

Race 3 Code

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

[TeacherRace]RaceCD

No

1

34

Race 4 Code

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

[TeacherRace]RaceCD

No

1

35

Race 5 Code

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

[TeacherRace]RaceCD

No

1

36

Reserved Field

Not used by TEA. Always blank.

N/A

No

10

37

Reserved Field

Not used by TEA. Always blank.

N/A

No

60

38

Reserved Field

Not used by TEA. Always blank.

N/A

No

100

39

Reserved Field

Not used by TEA. Always blank.

N/A

No

60

40

Reserved Field

Not used by TEA. Always blank.

N/A

No

50

41

Reserved Field

Not used by TEA. Always blank.

N/A

No

50

42

Reserved Field

Not used by TEA. Always blank.

N/A

No

30

43

Reserved Field

Not used by TEA. Always blank.

N/A

No

30

44

Reserved Field

Not used by TEA. Always blank.

N/A

No

2

45

Reserved Field

Not used by TEA. Always blank.

N/A

No

17

46

Reserved Field

Not used by TEA. Always blank.

N/A

No

22

47

Reserved Field

Not used by TEA. Always blank.

N/A

No

20

48

Reserved Field

Not used by TEA. Always blank.

N/A

No

N/A

49

Reserved Field

Not used by TEA. Always blank.

N/A

No

20

50

Reserved Field

Not used by TEA. Always blank.

N/A

No

20

51

Reserved Field

Not used by TEA. Always blank.

N/A

No

125

52

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

53

Reserved Field

Not used by TEA. Always blank.

N/A

No

20

54

Reserved Field

Not used by TEA. Always blank.

N/A

No

2

55

Submission Purpose

The type of data in the input file.

Hard-coded as 001 for assignment.

'001'

Yes

3

56

Person Type

The type of person on the record.

Hard-coded as 03 for staff.

'03'

Yes

2

57

Reserved Field

Not used by TEA. Always blank.

N/A

No

1

58

Reserved Field

Not used by TEA. Always blank.

N/A

No

100

59

Entry/Exit Date

This field is blank for ID Assignment records.

Blank

No

N/A

60

Entry/Exit Type

This field is blank for ID Assignment records.

Blank

No

2

61

Reserved Field

Not used by TEA. Always blank.

N/A

No

100

62

Entry/Exit Verified Flag

This field is blank for ID Assignment records.

Blank

No

1

63

Reserved Field

Not used by TEA. Always blank.

N/A

No

N/A

64

Reserved Field

Not used by TEA. Always blank.

N/A

No

N/A

65

Reserved Field

Not used by TEA. Always blank.

N/A

No

25

66

Reserved Field

Not used by TEA. Always blank.

N/A

No

100

67

Reserved Field

Not used by TEA. Always blank.

N/A

No

100

68

Reserved Field

Not used by TEA. Always blank.

N/A

No

100

69

Reserved Field

Not used by TEA. Always blank.

N/A

No

100

70

Reserved Field

Not used by TEA. Always blank.

N/A

No

N/A

71

Reserved Field

Not used by TEA. Always blank.

N/A

No

N/A

72

Reserved Field

Not used by TEA. Always blank.

N/A

No

3

73

Reserved Field

Not used by TEA. Always blank.

N/A

No

255

74

Reserved Field

Not used by TEA. Always blank.

N/A

No

255

75

Reserved Field

Not used by TEA. Always blank.

N/A

No

255

76

Reserved Field

Not used by TEA. Always blank.

N/A

No

12

77

Reserved Field

Not used by TEA. Always blank.

N/A

No

50

78

Reserved Field

Not used by TEA. Always blank.

N/A

No

10

Trailer Record Layout

The trailer record is the last record in the file.

1

Record Type

The type of record.

'TT'

Yes

2

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.

Yes

10

3

Number of Records

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

Derived

Yes

10