This folder contains 45 articles

How-To's and Troubleshooting

How to Query Primary Teacher in SQL
List the desired columns: SELECT STU.FN, STU.LN, STU.ID, STU.SC, STU.GR, Use a case statement to account for blank records Concatenate 2 fields ...

Mon, Aug 12, 2024 at 7:26 AM

How to Show Records That Have Been Set to "Completed" in Records Request Manager
How to show records that have been set to Completed in Records Request Manager Step 1: Navigate to Records Request Manager Step 2: Under the applica...

Tue, Oct 22, 2024 at 4:05 PM

How to Tag a 12th Grader Returning in the Next School Year (5th Year)
These are the steps needed if to tag a 12th Grade student that will be returning in the next school year as a 5th Year Senior Step 1: Navigate to the st...

Sat, Aug 10, 2024 at 6:22 PM

How to Transfer a Teacher to a Different School in Flex School
How to Transfer a Teacher to a Different School in a Flex Scheduling setting. Step 1: Change the teacher's Primary School (STF.PSC) on their Staff r...

Sat, Aug 10, 2024 at 6:16 PM

Permissions for Define Withdrawal Form Headings
What permissions are needed to allow non-Admin Users to Define Withdrawal Form Headings User accounts need READ and UPDATE permissions to LOC Table

Thu, Dec 19, 2024 at 9:48 AM

Primary Teacher Does Not Show on Student Demographics - Things to Check
When using Flex Scheduling for a Daily Attendance school, here are things to check when the Primary Teacher does not appear on the Student Demographics page...

Sat, Aug 10, 2024 at 6:16 PM

Query Counselor Field – Staff ID Based Workaround
When selecting Counselor (CNF.CU) from the Counseling table in a Query where School Options has Use Staff ID Based Counselor Tracking set to yes, the Query ...

Tue, Aug 13, 2024 at 9:50 AM

Removing an Individual Picture for a Student
How to remove an individual picture for a student: Step 1: Log in to the school where the student is enrolled Step 2: Search for the student Ste...

Sat, Aug 10, 2024 at 6:16 PM

Require at Least One Contact Record to be Parent/Guardian During Parent Data Confirmation
How to make at least one Contact Record to be a Parent/Guardian during Parent Data Confirmation Step 1: Go to the District Settings page and select Chan...

Wed, Aug 21, 2024 at 8:29 AM

Send Emails List Includes a Contact Who is Not a Parent or Ed Rights Holder
Issue  The email address from a Contact record is being included in the Send Emails list for a contact who is not a Parent or Ed Rights Holder. Cause ...

Thu, Sep 5, 2024 at 8:20 AM