TSDS Crosswalks

Grade Reporting > Maintenance > Tables > TSDS Crosswalks

This page allows you to convert data in your district format to the standard TEA format for the fall and mid-year collections. This conversion only affects the data in the State Reporting tables, allowing you to continue maintaining your data in your format in the Business and Student systems.

Update Data:

Crosswalk Type	Select the crosswalk table for which you want to convert data.

The selected crosswalk table is displayed. The list can be re-sorted.

You can re-sort the grid by clicking on an underlined column heading. It will sort in ascending order. Click it again to sort in descending order.

A triangle next to the column heading indicates the column by which the grid is currently sorted and whether it is sorted in ascending or descending order.

Crosswalk Type:

042 - Responsibilities – From Campus/Period to Minutes
042 - Responsibilities – From Campus/Period to Minutes

Use for campuses with a standard bell schedule to assign MonthlyMinutes based on the campus and period. Enter Begin Time and End Time on individual sections only when they do not follow the standard bell schedule.

Monthly Minutes Logic

MonthlyMinutes (E1057) represents the staff responsibility minutes for the four weeks preceding the PEIMS Fall snapshot date, which is the last Friday in October.

The system determines MonthlyMinutes for a course section in the following order:
1. If Begin Time and End Time are entered on the section, the system calculates the minutes using those values and the section’s meeting days.
2. If Begin Time and End Time are blank, the system searches Crosswalk 043 – Responsibilities – From Campus/Service ID to Minutes for the section’s campus and CourseCode.
3. If the CourseCode is not found in Crosswalk 043, the system searches Crosswalk 042 – Responsibilities – From Campus/Period to Minutes.
043 - Responsibilities – From Campus/Service ID to Minutes
043 - Responsibilities – From Campus/Service ID to Minutes

For course sections where daily subject minutes may fluctuate, such as elementary teachers whose subject times vary, use Crosswalk 043 (Responsibilities – From Campus/Service ID to Minutes) to assign MonthlyMinutes (E1057) based on the CourseCode.

Monthly Minutes Logic

MonthlyMinutes (E1057) represents the staff responsibility minutes for the four weeks preceding the PEIMS Fall snapshot date, which is the last Friday in October.

The system determines MonthlyMinutes for a course section in the following order:
1. If Begin Time and End Time are entered on the section, the system calculates the minutes using those values and the section’s meeting days.
2. If Begin Time and End Time are blank, the system searches Crosswalk 043 – Responsibilities – From Campus/Service ID to Minutes for the section’s campus and CourseCode.
3. If the CourseCode is not found in Crosswalk 043, the system searches Crosswalk 042 – Responsibilities – From Campus/Period to Minutes.

❏ Click +Add to add a new row.

A blank row is added to the bottom of the grid.

Row Nbr
From	042 – Responsibilities – From Campus/Period to Minutes Enter the three-digit campus ID followed by the two-digit period. For example, enter 00101 for campus 001 and period 01. 043 – Responsibilities – From Campus/Service ID to Minutes Enter the three-digit campus ID followed by the eight-digit CourseCode. For example, enter 10101020000 for campus 101 and CourseCode 01020000.
To	Enter the monthly minutes, zero-filled to five digits. For example, enter 07200.

❏ Click Save.

Crosswalk Type:
044 PE Responsibilities - Campus/Crs/Sec

Crosswalk 044 does not assign MonthlyMinutes (E1057). It is used to maintain the number of days and minutes a teacher of record provides physical education instruction during each week at the campus for the four weeks in October that include the last Friday in October.

This is required for all teachers of record for course-sections associated with specific physical education (PE) CourseCodes.

IMPORTANT: Include minutes for any holidays occurring during the four reporting weeks.

Create or Update the Crosswalk

The first time you access the page, there will be rows from the previous year displayed. Click Delete then click Create to add current year courses.

NOTE: You cannot delete data row by row. You must click Delete to delete all rows on the page. Then, click Create to populate the page with PE course-sections. Then, you can re-enter all data.

WARNING: If you click Delete, all rows are deleted.

The next time you access the page, the Create button will be replaced with a Refresh button. Click Refresh to add new records to the grid.

From	A list of course-sections associated with physical education (PE) CourseCodes that must have NumberDaysTaughtWeek1-4 and NumberMinutesTaughtWeek1-4 is listed. CourseCodes that must have NumberDaysTaughtWeek1-4 and NumberMinutesTaughtWeek1-4 reported: 02530002 02530003 02530004 02530005 02530006 02530007 02530008 02850000 03823070 03823080 82210XXX 82931XXX 83210XXX 84200XXX PES00051 PES00053 PES00056 This list is predefined and cannot be changed. Courses are listed in the campus-course-section format, where: The first three digits are the campus ID. The next digits are the course number, which may contain between four and eight digits. The last two digits are the section number. The course-sections are for semester 1.
Day Week 1-4	Enter the number of days in which the Teacher of Record provides physical education instruction each week at the campus. Valid entries are one digit between 1-5.
Min Week 1-4	Enter the number of minutes in which the Teacher of Record provides physical education instruction each week at the campus. Valid entries may contain up to four digits; however, the total monthly minutes for the course cannot exceed 1,800.

❏ Click Save.

Crosswalk Type:
ADP Additional Days School Year Courses

Use the ADP – Additional Days School Year Courses crosswalk to identify the campus to which an ADSY course should be associated for reporting.

❏ Click +Add to add a new row.

A blank row is added to the bottom of the grid.

Course	Type the ADSY course number.
Campus	Type the campus number to which the course should be associated for reporting.

❏ Click Save.

Other functions and features:

Print	Print the crosswalk report. Review the report using the following buttons: Click to go to the first page of the report. Click to go back one page. Click to go forward one page. Click to go to the last page of the report. The report can be viewed and saved in various file formats. Click to save and print the report in PDF format. Click to save and print the report in CSV format. (This option is not available for all reports.) When a report is exported to the CSV format, the report headers may not be included. Click to close the report window. Some reports may have a Close Report, Exit, or Cancel button instead.
Retrieve	Retrieve data from the last save. Discard unsaved changes, and retrieve information since the last time data was saved.
	Delete a row. Click to delete the selected row. The row is shaded red to indicate that it will be deleted when the record is saved. Click Save. A message is displayed confirming that you want to delete the row. Click OK to delete the row. Click Cancel not to delete the row.

Student

Sidebar

Table of Contents

TSDS Crosswalks

Update Data:

Create or Update the Crosswalk

Other functions and features:

Americans with Disabilities Act (ADA) and Web Accessibility

Student

User Tools

Site Tools

Sidebar

Table of Contents

TSDS Crosswalks

Update Data:

Create or Update the Crosswalk

Other functions and features:

Page Tools

Americans with Disabilities Act (ADA) and Web Accessibility