Campus Solutions - PSFT (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT Campus Solutions Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center