This folder contains 96 articles

How-To's and Troubleshooting

Aeries Query - Find Summer School Enrollment in Prior Year
Query to find which students are still enrolled in the current year database, that also attended last year's Summer School: LIST STU ENR STU.ID STU....

Fri, Dec 13, 2024 at 4:13 PM

Aeries Query - Why isn't the Extended Field SPECIALED Pulling all Students with an Active Special Education Record?
Issue The Extended Field SPECIALED is not pulling all students with an active Special Education record Cause The Extended Field SPECIALED pulls from t...

Fri, Oct 25, 2024 at 4:48 PM

CALPADS Fall 2 Query To Find Potential Misassignments
The Queries will mimic the 4.3 Staff Teaching Assignments - Detail CALPADS Report from Fall 2 and can be used to look at teacher credentials to help find po...

Mon, Dec 16, 2024 at 2:14 PM

Date Formats in Query
You can Query by Date and Time LIST LOG BY DTS IF OB : STU AND DTS > "8/23/2023 8:08 AM" AND DTS < "8/23/2023 12:58:53 PM"   ...

Fri, Jul 5, 2024 at 10:51 AM

Ethnicity/Race in Query
In the past, the extended field RACE was not working. This is a workaround for the field to create one column that shows the Ethnicity/Race For a Query ...

Tue, Nov 5, 2024 at 9:45 AM

Fall 2 Query CAR Records for Specific Teacher
With Secondary Scheduling, how can I query student Course Attendance Records (CAR) for a specific teacher for Census Day?  Find the Teacher Number on ...

Wed, Nov 20, 2024 at 11:09 AM

Fall 2 Query CAR Records for Specific Teacher - Flex
With Flex Scheduling, how can I query student Course Attendance Records (CAR) for a specific teacher for Census Day?  Find the Local Staff ID Number on ...

Wed, Nov 20, 2024 at 11:09 AM

How Can I Query The Course Attendance For An Alternative Ed School?
How can I query the Course Attendance (CAR) page for an Alt Ed School? It keeps duplicating and the Sections do not match. Also, the periods are all zero. ...

Wed, Dec 18, 2024 at 10:07 AM

How Can To Get An Average Total GPA With The Grading Periods So Far This Year?
How to Create a Current Year Average GPA During the Middle of the School Year Environment Decide which GPAs should be included, this would be from the...

Fri, Dec 6, 2024 at 7:26 AM

How to Create Unique Student Email Addresses in Query
How to create unique student email addresses in query? First decide what format is needed for the student Email address using First name, middle name, l...

Tue, Dec 3, 2024 at 3:29 PM