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


DRI:  List of Assets Checked out to Students - School or District Level

Lists all assets checked out to Students, along with the Barcode, Item Number, and student information that can be run at the School or District level


LIST DRA DRI DRT STU STU.FN STU.LN DRT.TI DRA.ID DRA.DT DRI.BC IF DRA.RD = NULL AND DRA.ST = "S"


DRI:  List of Assets Check out to Staff - District Level

Lists all assets checked out to Staff, however, this query only work at the District level


LIST DRT DRI DRA STF STF.FN STF.LN DRT.TI DRA.ID DRA.DT DRI.BC IF DRA.RD = NULL AND DRA.ST  = "T"


LKR:  LIst of Locker Information

Provides a list of locker information including:  Locker Number, Combination, Student Number, five additional combination fields and Serial Number


LIST LKR LK CM SN C1 C2 C3 C4 C5 SE


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