Sidebar
gradereporting:maintenance:tables:tsdscrosswalks
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.
- A blank row is added to the bottom of the grid.
If the time is not entered into the Course-Section, the system will look at the Crosswalk for monthly minutes totals.
Setting monthly minutes by Period is used when campus is operating daily using set periods each day of the week.
Setting monthly minutes by Service Id (Course Code) is used more in the Elem setting when grade levels are blocked and have their own schedule of minutes per course.
If the course doesn't follow either format, Period or Service Id (Course Code), enter the Begin Time and End Time on the section.
Crosswalk Type:
- Each course, whether by Period or Service Id (Course Code), will calculate the minutes per day X # days per week X 4 weeks. (multiply the number of instructional minutes for each period/course by the number of days per week - then multiply that by the 4 weeks immediately prior to the Fall PEIMS Snapshot date - last Friday in October)
❏ Click +Add to add a new row.
A blank row is added to the bottom of the grid.
| Row Nbr |
The rows are automatically numbered. |
|---|---|
| From |
Type the district code you want to convert. |
| To |
Type the TEA format code to which you want to convert. |
❏ Click Save.
Crosswalk Type:
044 PE Responsibilities - Campus/Crs/Sec
This crosswalk allows you to enter the number of days and minutes in which the PE teacher provides physical education instruction 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 the following physical education (PE) service IDs (Course Code):
02530002
02530003
02530004
02530005
02530006
02530007
02530008
02850000
03823000
03823070
03823080
82210XXX
82931XXX
83210XXX
84200XXX
PES00051
PES00053
PES00056
All districts will use this crosswalk, except for Business-only districts whose responsibility records come from Human Resources, or if PE service IDs (Course Code) are not used for PE courses, or if your PE service ID (Course Code) courses do not have students.
Important: Minutes for any holidays should be included.
NOTE:
These fields are not reported for employees with PE substitution responsibilities (i.e., employees with service IDs (Course Code) PES00000-PES00015).
Records are created for non-campus-based PE courses (i.e., Non Campus Based is greater than 00 in the campus master schedule) if the course is taught during semester 1 and at least one student is enrolled in the class.
This crosswalk is not used for Business-only districts whose responsibility records come from Human Resources, or if PE service IDs (Course Code) are not used for PE courses, or if your PE service ID (Course Code) courses do not have students. All other districts should use this crosswalk.
Create or update the crosswalk:
❏ In the Crosswalk Table field, select 044-PE Responsibilities - Campus/Crs/Sec.
❏ 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.
A list of course-sections associated with physical education (PE) service IDs (Course Code) is listed. This list is predefined and cannot be changed.
The From column lists course-sections 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.
❏ For the Teacher of Record for each course-section listed, enter the following information for the four weeks in October that include the last Friday in October:
- In the Day Week 1-4 fields, type the number of days in which the employee provides physical education instruction each week at the campus. Valid entries are one digit between 0-5.
- In the Mins Week 1-4 fields, type the number of minutes the employee provides physical education instruction each week at the campus. Valid entries are up to four digits between 0-3000.
These fields are automatically populated according to the Days code entered on Grade Reporting > Maintenance > Master Schedule > Campus Schedule > Section for each course-section meeting time. The program calculates the minutes in the days from the section Time Begin/End and sums for each meeting time the days per week for that meeting time, then multiplies the minutes per day for that meeting time to calculate the minutes for each week.
❏ Click Save.
❏ Click Print to print the data displayed.
❏ If new PE responsibilities records are found the next time you access the page, the Create button will be replaced with the Refresh button. Click Refresh to add new records to the grid.
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.
Crosswalk Type:
ADP Additional Days School Year Courses
❏ Click +Add to add a new row.
A blank row is added to the bottom of the grid.
| Row Nbr |
The rows are automatically numbered. |
|---|---|
| Course |
Type the course code you want to convert. |
| Campus |
Type the campus number to which you want the course to transfer. |
❏ Click Save.
Other functions and features:
gradereporting/maintenance/tables/tsdscrosswalks.txt · Last modified: 2022/08/30 15:41 by apape