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.

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

Header Record Layout

The header record is the first record in the file.

1

Record Type

The record type.

2

Extract Date

The date the extract was run.

3

Extract Time

The time the extract was run.

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.

5

Version

The TEDS version.

6

Delimiter

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

7

Source Name

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

'HR'

8

Text Qualifier

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

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.

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

3

Reserved Field

Not used by TEA. Always blank.

4

Last Name

The staff member's last name.

[UsersCoreFields]PSCore_Legal_Last_Name if populated.

Otherwise, [Users]Last_Name

5

First Name

The staff member's first name.

[UsersCoreFields]PSCore_Legal_First_Name if populated.

Otherwise, [Users]First_Name

6

Middle Name

The staff member's middle name.

[UsersCoreFields]PSCore_Legal_Middle_Name if populated.

 Otherwise, [Users]Middle_Name

7

Name Suffix

The staff member's generational suffix code.

[UsersCoreFields]PSCore_Legal_Suffix if populated.

Otherwise, [S_TX_USR_X]E0706_Generation_Code

8

Gender

The staff member's gender.

9

Date of Birth

The staff member's birth date.

10

Current Grade Level Code

For staff members, this outputs as 00.

11

Local Student ID

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

12

Social Security Number or S-#

The staff member's social security number.

13

Race

The staff member's race code.

14

TSDS Uniq-ID

The staff member's state unique identifier.

15

Current District Code

The district where the staff member is employed.

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.

17

Alternate Last Name

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

18

Reserved Field

Not used by TEA. Always blank.

19

Reserved Field

Not used by TEA. Always blank.

20

Reserved Field

Not used by TEA. Always blank.

21

Reserved Field

Not used by TEA. Always blank.

22

Reserved Field

Not used by TEA. Always blank.

23

Reserved Field

Not used by TEA. Always blank.

24

Reserved Field

Not used by TEA. Always blank.

25

Reserved Field

Not used by TEA. Always blank.

26

Reserved Field

Not used by TEA. Always blank.

27

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

31

Ethnicity Indicator

The staff member's Hispanic/Latino indicator.

Valid values:

• 1 - Hispanic/Latino
• 0 - Not Hispanic/Latino.

32

Race 2 Code

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

[TeacherRace]RaceCD

33

Race 3 Code

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

34

Race 4 Code

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

35

Race 5 Code

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

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

The type of data in the input file.

Hard-coded as 001 for assignment.

The type of person on the record.

Hard-coded as 03 for staff.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Reserved Field

Not used by TEA. Always blank.

Trailer Record Layout

The trailer record is the last record in the file.

1

Record Type

The type of record.

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.

3

Number of Records

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