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.
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
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