Top of FIN Index Table of Contents Feedback

Finance Rules

Continuing Development

The definition of available rules, operators, parameters and functions is part of an ongoing development process. Future delivery sets may offer a broader range of rules, and/or a broader range of rule options for currently available rules.

 

Syntax of Student Contribution Amount Formula Rule

Operators

Usage

( )

Definition: Parenthesis
Example. (6-4)/3

Returns 2/3 or 0.666666…

ROUND(<value>,decimal places)

Definition: Round a number to so many decimal places
Example. ROUND((6-4)/3,2)

Returns 0.67

TRUNC(<value>,decimal places)

Definition: Truncates a number to so many decimal places
Example. TRUNC((6-4)/3,2)

Returns 0.66

,

Definition: comma, used to separate operand from parameter in rounding and truncation functions above.
Example. See above

+

Definition: Plus
Example. 10 + 11

Returns 21

-

Definition: Minus
Example. 5-2

Returns 3

/

Definition: Division
Example. 10/2

Returns 5

*

Definition: Multiply
Example. 2*8

Returns 16

 

Parameter/Function

Description

Current Values

CHARGE_ELEMENTS

The derived value of the Charge Method

 

CHARGE_RATE

The derived value of the Fee Assessment Rate

 

 

Variables

Description

Number

0-9

 

Syntax of Standard Fee Assessment Formula Rule 

Operators

Usage

( )

Definition: Parenthesis
Example. (6-4)/3

Returns 2/3 or 0.666666…

ROUND(<value>,decimal places)

Definition: Round a number to so many decimal places
Example. ROUND((6-4)/3,2)

Returns 0.67

TRUNC(<value>,decimal places)

Definition: Truncates a number to so many decimal places
Example. TRUNC((6-4)/3,2)

Returns 0.66

,

Definition: comma, used to separate operand from parameter in rounding and truncation functions above.
Example. See above

+

Definition: Plus
Example. 10 + 11

Returns 21

-

Definition: Minus
Example. 5-2

Returns 3

/

Definition: Division
Example. 10/2

Returns 5

*

Definition: Multiply
Example. 2*8

Returns 16

 

Parameter/Function

Description

Current Values

CHARGE_ELEMENTS

The derived value of the Charge Method

 

CHARGE_RATES

The derived value of the Fee Assessment Rate

 

 

Variables

Description

Number

0-9

 

Syntax of Tax (GST) & Loan Rule

Operators

Usage

( )

Definition: Parenthesis
Example. (6-4)/3

Returns 2/3 or 0.666666…
GOVT_COURSE_TYPE IN {<set of government course types>}

Definition: Defines a list of government course types.
Example. GOVT_COURSE_TYPE IN {08, 09, 10, 13, 20, 21, 22, 41, 62}

Returns Boolean

IF GOVT_COURSE_TYPE IN {<set of government course types>} THEN Loan Fee 20% ELSE AMOUNT ENDIF

Note: Only Loan Rule, NOT Tax

Definition: If a Government Course Type is of a defined Course Type then apply Loan Rule
Example: IF GOVT_COURSE_TYPE IN {08, 09, 10, 13, 20, 21, 22, 41, 62} THEN Loan Fee 20% ELSE AMOUNT ENDIF

Returns Number

ROUND(<value>,decimal places)

Definition: Round a number to so many decimal places
Example. ROUND((6-4)/3,2)

Returns 0.67

TRUNC(<value>,decimal places)

Definition: Truncates a number to so many decimal places
Example. TRUNC((6-4)/3,2)

Returns 0.66

,

Definition: comma, used to separate operand from parameter in rounding and truncation functions above.
Example. See above

+

Definition: Plus
Example. 10 + 11

Returns 21

-

Definition: Minus
Example. 5-2

Returns 3

/

Definition: Division
Example. 10/2

Returns 5

*

Definition: Multiply
Example. 2*8

Returns 16

 

Parameter/Function

Description

Current Values
AMOUNT The amount on which Tax is calculated  

Loan Fee 20%

The percentage of the Loan Fee Help

 

Variables

Description

Number

0-9

 

Last Modified on 17 August, 2004