Unique ID Enrollment Event Tracking

Select Schools

The multi-select list allows the user to use the Ctrl or SHIFT key on your keyboard to click each school for which you want to run the extract.

Note: At the school level, only the current school is available.

Current Selection Students

Select one of the following:

• The Selected [number] Students Only – Run the report for only pre-selected students.
• All Students – Run the report for all students in the indicated school(s).

School Year

Choose the school year for the student enrollment data you want to include in the report.

Select one of the following:

• Updates and New Records since the Last Submission – Run the report for only records that are new or updated since the last submission. (Default)
• All Records within Date Range – Run the report for all records within the reporting period.

Note: Except under special circumstances and unless specifically permitted by TEA, the default option, Updates, and New Records since the Last Submission should always be used.

Start Date

End Date

Select the last date in the reporting period from the calendar provided.

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 SIS for students.

8

Text Qualifier

The type of text qualifier. Hard-coded as 0X22 to note that the qualifier is a 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 detailed records represent the individual enrollment event data.

1

Record Type

The record type.

2

Current School Code

The school where the student is enrolled.

[Students]SchoolID

[Reenrollments]SchoolID

[Schools]Alternate_School_Number

[Schools]School_Number

3

Reserved Field

Not used by TEA. Always blank.

4

Last Name

The student's legal last name.

StudentCoreFields.PSCore_Legal_Last_Name

5

First Name

The student's legal first name.

StudentCoreFields.PSCore_Legal_First_Name

6

Middle Name

The student's legal middle name.

StudentCoreFields.PSCore_Legal_Middle_Name

7

Name Suffix

The student's generational suffix code.

8

Gender

The student's gender.

9

Date of Birth

The student's birth date.

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

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.

12

Social Security Number or S-#

The student's social security number.

13

Race

The student's race code.

[Students]State_StudentNumber

15

Current District Code

The district where the student is enrolled.

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 student'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 student's Hispanic/Latino indicator.

Valid values:

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

32

Race 2 Code

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

[StudentRace]RaceCD

33

Race 3 Code

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

34

Race 4 Code

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

35

Race 5 Code

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

The type of data in the input file.

Hard-coded as 002 for Enrollment Events.

The type of person on the record.

Hard-coded as 02 for a student.

[Students]EntryDate

[Students]Exitdate

Indicates if the date in the Entry/Exit Date field is an enrollment or withdrawal record.

Entry Date: '01'

Exit Date: '02'

The status of the enrollment event.

Valid values:

• 1 – Verified
• 2 – Unverified
• 3 – Calendar
• 4 – Delete

Derived

Record correction scenarios: a value of “4” (Delete) is output when a previously submitted record needs to be deleted from the Unique ID system. Typically, the deleted record is accompanied by a new, updated record that corrects and replaces the deleted record.

Values of 1-Verified, 2-Unverified, and 3-Calendar are never published. These fields can be manually edited in the Unique ID system when appropriate.

Trailer Record Layout

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.

Enrollment Events Tracking Report (Student Records Included)

This section of the PDF output contains a list of student records that were included in the CVS file.

[Students]SchoolID

[Reenrollments]SchoolID

[Schools]Alternate_School_Number

[Schools]School_Number

Override: [S_TX_STU_X]E0705

[Students]Last_Name

Override: [S_TX_STU_X]E0703

[Students]First_Name

Override: [S_TX_STU_X]E0704

[Students]Middle_Name

The student's generational suffix code.

[S_TX_STU_X]State_Grade_Level

[Students]Grade_Level

[S_TX_REN_X]State_Grade_Level

[Reenrollments]Grade_Level

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.

The student's social security number.

The student's race code.

[Students]State_StudentNumber

The student's Hispanic/Latino indicator.

Valid values:

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

The date on which the student enrolled or withdrew from the reporting campus.

Notes:

• Entry and exit dates are listed from oldest to newest.
• Each entry and exit event is listed on a separate line with School ID, Grade Level, and Entry or Exit Date.
• Entry and exit events that contain a code 4 (Delete) value in the Entry/Exit Verified field are also displayed.

[Students]EntryDate

[Students]Exitdate

Indicates if the date in the Entry/Exit Date field is an enrollment or withdrawal record.

Entry Date: '01'

Exit Date: '02'

The status of the enrollment event.

Valid values:

• 1 – Verified
• 2 – Unverified
• 3 – Calendar
• 4 – Delete

Derived

Record correction scenarios: a value of “4” (Delete) is output when a previously submitted record needs to be deleted from the Unique ID system. Typically, the deleted record is accompanied by a new, updated record that corrects and replaces the deleted record.

Values of 1-Verified, 2-Unverified, and 3-Calendar are never published. These fields can be manually edited in the Unique ID system when appropriate.

ET Event Error Report (Students Not Included)

This section of the PDF output contains a list of student records that were not included in the CVS file due to an error.

• • Student Name Fields
  • SSN
  • TX Unique ID
  • Birthdate
  • Hispanic/Latino Code
  • Race Code (at least one is required for all students)

1

Local ID

This column contains the district-assigned student ID.

[Students]Student_Number

2

Student Name

This column contains the student's name in last name, first name, middle name format.

[S_TX_STU_X]E0705

[Students]Last_Name

[S_TX_STU_X]E0703

[Students]First_Name

[S_TX_STU_X]E0704

[Students]Middle_Name

'Missing' or 'Invalid' + field