This folder contains 38 articles

How-To's and Troubleshooting

How to Add a Teacher to Section Staff Members from a Different School
A teacher can be added to the Section Staff table by using the Local Staff ID Number when the Teacher's Primary School is not the same school.  1. N...

Wed, Nov 6, 2024 at 4:00 PM

How To Check For Master Schedule Record Changes In LOG
How to check for users who may have made changes to sections in the Master Schedule Use a Log Query to see who made changes in the Master Schedule.  Ex...

Fri, Oct 25, 2024 at 3:33 PM

How to Delete SMS records via SQL
1. Identify the records to delete  EXAMPLE SELECT SC, SE, SM, CN FROM SMS WHERE DEL = 0 AND SM = 'S' 2. Run SQL statement to delete the des...

Sat, Aug 10, 2024 at 6:22 PM

How to Lock Staff Entered Course Requests prior to Students Entering Additional Course Requests
This article provides steps to lock staff entered Course Requests prior to students entering additional Course Requests via the Student Portal to ensure the...

Wed, Oct 16, 2024 at 8:02 AM

How to Mass Add Records to the Academic Plan
How to mass import records into the Individualized Academic Plan from a spreadsheet or csv. The target tables are APL and APC. Because APL is the parent of ...

Fri, Oct 25, 2024 at 10:43 AM

How to set a Maximum Number of Primary and Alternate Course Requests
Question How to set a Maximum Number of Primary and Alternate Course Requests for Parents and Students to select Answer Maximum Number of Primary and ...

Sun, Oct 20, 2024 at 6:33 PM

Inconsistent Periods/Semesters Error when Running the Scheduler
Scheduler > Scheduling All Students results in an Inconsistent Periods/Semesters error All Sections within a Course must be consistent within the Peri...

Sat, Aug 10, 2024 at 6:16 PM

Issue: Records appear duplicated on Academic Plan page
Academic Plan page displays duplicate records, but there are no duplicates in APL/APC Cause School-based codes in COD for CRS.DC causes the Academic Pl...

Tue, Apr 16, 2024 at 11:17 AM

Issue: SMS Board will not load for one user
The SMS Board will not load for a specific user Environment Scheduling Type: Secondary, Elem w/MST, Flex Cause Invalid value in USO.VL1 Resolut...

Thu, Sep 5, 2024 at 8:00 AM

Overlapping Primary Classes - How to Search in SQL
How to use SQL to search for Overlapping Primary Classes in a Flex Scheduling Environment District-wide: SELECT STU.[SC] ,STU.[ID] ,DAY.[DT] ...

Wed, Oct 30, 2024 at 10:42 AM