This is a collection of queries related to Other Aeries Features that have been obtained from various sources. These queries are being provided here for the convenience of our customers. The results of each query should be verified for accuracy and carefully considered before using.


List Queries

FEE:  List of Fees and Payment by Grade Level for Students with Unpaid Fees

List students who have an outstanding fee with the fee code, payment amounts by a specific grade level.


LIST STU FEE STU.NM  STU.ID STU.GR FEE.DT FEE.CD? (( FEE.AM - FEE.PD )) IF STU.GR = # AND (( FEE.AM - FEE.PD )) # 0.00


LKR:  List of Unassigned Lockers with Combinations

List to show all unassigned Lockers with Combinations


LIST LKR LK CM SN BY LK IF SN = 0


Change Queries

LKR:  Change the Student Number on the Locker Table to Match the Student Number in Student Demographics

Change to have Student Number in the Locker Table match the Student Number in Student Demographics if the numbers do not match


CHANGE STU LKR LKR.SN TO STU.SN IF LKR.SN # STU.SN