[Student Financial] How to identify which waiver is calculated first
Hi,
I have a situation in which 2 different waivers are applied to the same tuition fee. For example,
Tuition fee is 1000, waiver A is 20% (higher priority configured in tuition group) is calculated first. Waiver amount is 200
Waiver B is 10% (lower priority configured in tuition group) is calculated based on the remain amount, which has value (1000-200)*10%=80
Now I have to write a PS query to show something like:
Tuition fee Waiver Remains
1000 200 800
800 80 720
However, it seems in from the item table, item xref view, and tuition cal table we cannot know which waiver is calculated first, second. Could you let me know which table/field that I can use to identify that the waiver A is calculated first, then the waiver B. Thank you.