Sidebar
academy:fall_submission_update_crosswalks
Crosswalks are used to calculate and assign the MONTHLY-MINUTES (E1057) for staff responsibilities in the four weeks preceding the PEIMS Fall snapshot date (the last Friday in October). They are essential for ensuring minutes are reported accurately and consistently across the district.
Logic for Monthly Minutes Assignment
The system determines the Monthly Minutes (E1057) for a course section using the following hierarchy:
- Time Fields First: The system first looks at the Begin Time and End Time fields for the specific course section. If these fields are populated, the minutes are calculated from this time range.
- 043 Crosswalk: If the Begin Time and End Time fields are blank, the system checks the 043 Crosswalk (Responsibilities – From Campus/Service ID to Minutes) to see if the CourseCode (Service ID) is set up.
- 042 Crosswalk: If the CourseCode (Service ID) is not set up on the 043 Crosswalk, the system looks at the 042 Crosswalk (Responsibilities – From Campus/Period to Minutes).
Grade Reporting > Maintenance > Tables > TSDS Crosswalks
NOTE: Minutes for any holidays should be included.
| Crosswalk Type | Purpose and Usage |
|---|---|
| 042 – Responsibilities – From Campus/Period to Minutes | For campuses with a set bell schedule, use Crosswalk 042 Responsibilities – From Campus/Period to Minutes to assign MonthlyMinutes (E1057) based on the period. Only enter the Time Begin and Time End fields for the few, specific course sections that do not follow the standard bell schedule. |
| 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 (formerly known as SERVICE-ID). |
| 044 – PE Responsibilities – Campus/Crs/Sec | Use Crosswalk 044 (PE Responsibilities – Campus/Crs/Sec) 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 specific physical education (PE) CourseCodes. |
These fields are not reported for employees with PE substitution responsibilities (i.e., employees with service IDs 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 are not used for PE courses, or if your PE service ID courses do not have students. All other districts should use this crosswalk.
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.
Crosswalk Type:
042 Responsibilities - From Campus/Period to Minutes
Update Data:
❏ Click +Add to add a new row. A blank row is added to the bottom of the grid.
- In the From field, type the three-digit campus ID and a two-digit period (e.g., for campus 001 and period 01, type 00101).
- In the To field, type the monthly minutes value. Zero-fill the value to five digits (e.g., 00940).
❏ Click Save.
Crosswalk Type:
043 Responsibilities - From Campus/Service ID to Minutes
Update Data:
❏ Click +Add to add a new row. A blank row is added to the bottom of the grid.
- In the From field, type the three-digit campus and ID and the eight-digit CourseCode (e.g. campus 101 and CourseCode 01020000, type 10101020000).
- In the To field, type the monthly minutes value. Zero-fill the value to five digits (e.g. 07200).
❏ Click Save.
Crosswalk Type:
044 PE Responsibilities - Campus/Crs/Sec
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 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.
academy/fall_submission_update_crosswalks.txt · Last modified: 2025/11/13 19:45 by apape