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