Purpose

To establish a Fee Disbursement Formula, whereby multiple Fee Types can be linked to a formula

SubSystem

Finance

Tabs

This form provides an alternative mechanism for establishing Fee Disbursement Formula, whereby multiple Fee Types can be linked to a formula. Fee Types are associated with a formula in the context of a Fee Type Calendar Instance.

The function includes the ability to give a code and description to a formula for ease of identification with a formula comprising of one or more formula items . The evaluation order of a formula item within a formula must be specified.

This form also provides buttons to navigate to FINF7530 - Maintain Disbursement Fee Categorisation, FINF7540 – Maintain Fee Type Disbursement Formula Rules, FINF7520 - Maintain Disbursement Formula Fee Override and FINF7550 – Maintain Disbursement Formula Organisational Unit Override.

For descriptions of Lamps see table below.

For descriptions of each Field Source, see last table at the end of this online help.

For Alternative Disbursement Formula Example, see heading in FININTR3

This form is accessed from the main menu.

The Disbursement Formula block contains:

• Formula Code
• Description

Tabs

The Disbursement Formula Item tab contains:

• Evaluation Order
• Formula Type (POP)
• Disbursement Method (LOV)
• Allocation Method (LOV)
• Disbursement Fixed Amount
• Disbursement %
• Disbursement Base Balance
• Formula Number
• Description
• Classification (LOV)
• Organisational Unit (LOV)

The FTCI tab contains:

Fee Type Calendar Instance

• Fee Calendar Type (LOV)
• Description
• Start Date
• End Date
• Status

Fee Type

• Fee Type (LOV)
• Description
• System Fee Type
• System Fee Trigger Category
• Fee Management Level

The FTCI Disbursement Formula tab contains:

Fee Type Calendar Instance

• Fee Type
• Calendar Type
• Description
• Start Date
• End Date
• Status

Fee Type Calendar Instance Disbursement Formula

• Evaluation Order
• Formula Type
• Disbursement Method
• Allocation Method
• Disbursement Base Fixed
• Disbursement Base %
• Disbursement Base Balance
• Formula Number
• Organisational Unit

Buttons

• Categorisation (FINF7530)
• Formula Rules (FINF7540)
• Fee Category Override (FINF7520)
• Org Unit Override (FINF7550)

Rule/Notes:

Validations include:

• The Organisational Unit must be ACTIVE
• The Classification code must be open
• The fee_type_ci_account status of the Fee Type Calendar Instance must be ‘ACTIVE’ and the s_account_ type must be ‘REVENUE’
• Warning: IF DISBURSEMENT_FORMULA_ITEM.s_formula_type = ‘RETENTION’ and DISBURSEMENT_FORMULA_ITEM.s_disbursement_ method_type = ‘DIRECT’ and there are not records in FTCI_DSBRSMNT_FRML where fee_type. s_fee_trigger_cat = ‘INSTITUTN’
• Warning: If FTCI_DSBRSMNT_FRML.fee type.s_fee_trigger_cat = ‘INSTITUTN’, and there are no records with the same formula code in table DISBURSEMENT_FORMULA_ITEM WHERE s_ formula_type = ‘RETENTION’ and s_disbursement_method_type = ‘DIRECT’
• Warning: IF DISBURSEMENT_FORMULA_ITEM.formula_type = ‘RETENTION’ and DISBURSEMENT_FORMULA_ITEM. s_allocation_method_type = ‘STUDENT’ and there are not records in FTCI_DSBRSMNT_FRML where s_fee_trigger_cat = ‘INSTITUTN’
• Warning: If FTCI_DSBRSMNT_FRML. fee type, s_fee_trigger_cat = ‘INSTITUTN’, and there are no records with the same formula code in table DISBURSEMENT_FORMULA_ITEM WHERE s_ formula_type = ‘RETENTION’ and s_ allocation method_type = ‘STUDENT’
• Warning: IF DISBURSEMENT_FORMULA_ITEM.s_formula_type = ‘RETENTION’ and DISBURSEMENT_FORMULA_ITEM.s_disbursement_ method_type != ‘UNITTEACH’ and DISBURSEMENT_FORMULA_ITEM .s_ allocation_method_method = ‘STUDENT’ or ‘PERCOURSE’ and there are not records in FTCI_DSBRSMNT_FRML where s_fee_trigger_cat != ‘INSTITUTN’
• Warning: If FTCI_DSBRSMNT_FRML. fee type, s_fee_trigger_cat != ‘INSTITUTN’, and there are no records with the same formula code in table DISBURSEMENT_FORMULA_ITEM WHERE s_ formula_type = ‘RETENTION’ and s_disbursement_method_type ! = ‘UNITTEACH’ and s_ allocation_method_type = ‘STUDENT’ or ‘PERCOURSE’
• Only one Fixed Disbursement Amount and Percentage Disbursement can be specified.
• If Disbursement Method is 'DIRECT’, Organisation Unit details must be specified
• If Disbursement Method is not 'DIRECT’, Organisation Unit details must not be specified
• The Evaluation Order in block Disbursement Formula Item must be unique
• A Fee Type Calendar Instance cannot be associated with more than one formula
• Warning: If FTCI_DSBRSMNT_FRML. fee type, s_fee_trigger_cat != ‘INSTITUTN’ and fee_management_level = ‘COURSE:and there is/are record(s) exist with the same formula code in table DISBURSEMENT_FORMULA_ITEM WHERE s_ formula_type = ‘RETENTION’ and s_disbursement_method_type = ‘UNITTEACH’
• Warning: if the configuration method is different to that of the form
• Warning: IF DISBURSEMENT_FORMULA_ITEM.s_formula_type = ‘RETENTION’ and DISBURSEMENT_FORMULA_ITEM.s_disbursement_ method_type = ‘UNITTEACH’ and DISBURSEMENT_FORMULA_ITEM.s_ allocation_method = ‘PERUNIT’ and there is no record in FTCI_DSBRSMNT_ FRML where s_fee_trigger_cat != ‘INSTITUTN’ and fee_management_level = ‘UNIT’’.

When the Tab' FTCI Disbursement Formula' is selected, blocks Fee Type Calendar Instance (FTCIDFV) and Fee Type Calendar Instance Disbursement Formula (DFIV) are auto query to obtain the most recent records from the database.

The warning messages are displayed on lamps at the top of blocks Disbursement Formula Item (Tab Disbursement Formula Item) and Fee Type (Tab FTCI).

If more than one warning is generated on a record validation, only the first one is shown. If multipule records are validated with multiple warnings, only the first one of the last record in the block is shown.

The Lamp message is reset on each record. See the next section below for descriptions of the lamps and what they mean.

Lamp Text

Validation

Help Text

INVALID FEE TYPE/ITEM COMBINATION EXISTS

This will display if the Fee Type has a trigger cat of INSTITUTN and there is a RETENTION item where the Disbursement Method is not DIRECT

The lamp will display in the FTCI Disbursement Formula tab when the invalid item and Fee Type are in context

If the formula is linked to a Fee Type with a System Fee Trigger Category of INSTITUTN, and the System Disbursement Formula Type of a formula item is RETENTION, the System Disbursement Method must be DIRECT.

To correct, change the System Disbursement Method or Formula Type, or remove the link to Fee Type(s) with a System Fee Trigger Category of INSTITUTN

INVALID FEE TYPE/ITEM COMBINATION EXISTS

This will display if the Fee Type set up with a trigger cat of INSTITUTN and there is a RETENTION item where the Allocation Method is not STUDENT.

The lamp will display in the FTCI Disbursement Formula tab when the invalid item and Fee Type are in context

If the formula is linked to a Fee Type with a System Fee Trigger Category of INSTITUTN, and the System Disbursement Formula Type of a formula item is RETENTION, the System Allocation Method must be STUDENT.

To correct, change the System Allocation Method or Formula Type, or remove the link to Fee Type(s) with a System Fee Trigger Category of INSTITUTN

INVALID FEE TYPE/ITEM COMBINATION EXISTS

This will display if the Fee Type a trigger cat that is NOT INSTITUTN and there is a RETENTION item where the Disbursement Method is not UNITTEACH and the Allocation Method is not STUDENT or PERCOURSE.

The lamp will display in the FTCI Disbursement Formula tab when the invalid item and Fee Type are in context

If the formula is linked to a Fee Type with a System Fee Trigger Category that is not INSTITUTN, and the System Disbursement Formula Type of a formula item is RETENTION, the System Allocation Method must be STUDENT or PERCOURSE.

To correct, change the system allocation method or remove the link to Fee Type(s) that do not have a system fee trigger category of INSTITUTN.

This will display if the Fee Type has a trigger cat that is NOT INSTITUTN and there is a RETENTION item where the Disbursement Method is UNITTEACH and the Fee Management Level is not UNIT.

If the formula is linked to a Fee Type with a System Fee Trigger Category that is not INSTITUTN, and the System Disbursement Formula Type of a formula item is RETENTION, the Fee Management Level must be UNIT.

This will display if the fee type has a trigger cat that is NOT INSTITUTN and there is a RETENTION item where the Disbursement Method is UNITTEACH and the Fee Management Level is UNIT and the Allocation Method is not PERUNIT.

The lamp will display in the FTCI Disbursement Formula tab when the invalid item and Fee Type are in context.

If the formula is linked to a Fee Type with a system fee trigger category that is not INSTITUTN, and the system disbursement formula type of a formula item is RETENTION and the Fee Management Level is UNIT, the Allocation Method must be PERUNIT.

To correct, change the system allocation method or remove the link to Fee Type(s) that do not have a system fee trigger category of INSTITUTN.

Field Source

Prompt

Display Type

Comments

DF.FORMULA_CD

Formula Code:

Text Item

DF.DESCRIPTION

Description:

Text Item

DFI.FORMULA_CD

No prompt

Text Item

Non visible field

DFI.EVALUTION_ORDER

Evaluation Order

Text Item

DFI.S_DISRUSEMENT_METHOD_TYPE

Disbursement Method

Text Item

DFI.S_ALLOCATION_METHOD_TYPE

Allocation Method

Text Item

DFI.FEE_DISBURSEMENT_AMOUNT

Disbursement Fixed

Text Item

The prompt disbursement is shared between Fixed and %

DFI.PERCENTAGE_DISBURSEMENT

Disbursement %

Text Item

The prompt Disbursement is shared between Fixed and %

DFI.S_BASE_BALANCE

Base Balance

Text Item

DFI.FORMULA_NUMBER

Formula Number:

Text Item

DFI.DESCRIPTION

Description:

Text Item

DFI.CLASSIFICATION_CD

Classification:

Text Item

DFI.CLASSIFICATION_DESC

No prompt

Text Item

Non database field, value obtained from account_classification. description

DFI.ORG_UNIT_CD

Organisational Unit:

Text

DFI.OU_DESCRIPTION

No prompt

Item

Non database field, values obtained from org_unit.description

DFI.ORG_UNIT_START_DT

No Prompt

Text Item

Non visible field

FTCI.FEE_CAL_TYPE

Fee Calendar Type

Text Item

FTCI.FEE_CI_SEQUENCE_NUMBER

No Prompt

Text Item

Non visible field

FTCI.DESCRIPTION

Description

Text Item

Non data base item

FTCI.START_DT

Start Date

Text Item

Non data base item

FTCI.END_DT

End Date

Text Item

Non data base item

FTCI.CAL_STATUS

Status

Text Item

Non data base item

FTCIDF.FEE_TYPE

Fee Type

Text Item

FTCIDF.FEE_CAL_TYPE

No prompt

Text Item

Non visible field, when insertion of record FTCIDF.FEE_CAL_TYPE = :FTCI.FEE_CAL_TYPE

FTCIDF.FEE_CI_SEQUENCE_NUMBER

No prompt

Text item

Non visible field, when insertion of record FTCIDF. FEE_CI_SEQUENCE_NUMBER = :FTCI. FEE_CI_SEQUENCE_NUMBER E

FTCIDF.DESCRIPTON

Description

Text Item

Non database field

FTCIDF.S_FEE_TYPE

System Fee Type Date

Text Item

Non database field

FTCIDF.S_FEE_TRIGGER_CATEGORY

System Fee Trigger Category

Text Item

Non database field

FTCIDF.FEE_MANAGEMENT _LEVEL

Fee Management Level

Text Item

Non database field

FTCIDFV.FEE_TYPE

Fee Type

Text Item

FTCIDFV.FEE_CAL_TYPE

Calendar Type

Text Item

FTCIDFV.DESCRIPTION

Description

Text Item

FTCIDFV.FORMULA_CD

No prompt

Text item

Non visible field

FTCIDFV.FEE_CI_SEQUENCE_NUMBER

No prompt

Text item

Non visible field

FTCIDFV.START_DT

Start Date

Text Item

FTCIDFV.END_DT

End Date

Text Item

FTCIDFV.CAL_STATUS

Status

Text Item

DFIV.FORMULA_CD

No Prompt

Text Item

Non visible field

DFIV.FEE_TYPE

No Prompt

Text Item

Non visible field

DFIV.FEE_CAL_TYPE

No Prompt

Text Item

Non visible field

DFIV.FEE_CI_SEQUENCE_NUMBER

No Prompt

Text Item

Non visible field

DFIV.EVALUATION_ORDER

Evaluation Order

Text Item

DFIV.S_FORMULA_TYPE

Formula Type

Text Item

DFIV.S_DISBURSEMENT_METHOD_TYPE

Disbursement Method

Text Item

DFIV.S_ALLOCATION_METHOD_TYPE

Allocation Method

Text Item

DFIV.FEE_DISBURSEMENT_AMOUNT

Disbursement Fixed

Text Item

The prompt Disbursement is shared between Fixed and %

DFIV.PERCENTAGE_DISBURSEMENT

Disbursement %

Text Item

The prompt Disbursement is shared between Fixed and %

DFIV.S_BASE_BALANCE

Base Balance

Text Item

DFIV.FORMULA_NUMBER

Formula Number:

Text Item

DFIV.ORG_UNIT_CD

Organisational Unit:

Text Item

DFIV.ORG_UNIT_START_DT

No Prompt

Text Item