Top of FIN Index Table of Contents Feedback

FINF7520 - Maintain Disbursement Formula Fee Category Override

Purpose

To override a Disbursement Formula Item for particular Fee Categories

SubSystem

Finance
Normally Run By Finance Specialist
Anticipated Frequency As required
Structure   Blocks FTCI Disbursement Formula
Disbursement Formula Fee Category Override

  

This function provides the ability to override a Disbursement formula Item for particular Fee Categories. An override applies for a selected Disbursement formula Item/FTCI combination.

For Alternative Disbursement Formula Example, see heading in FININTR3

This function is accessed from FINF7510 – Maintain Fee Type Disbursement Formulae via the Fee Category Override button.

 

The FTCI Disbursement Formula block contains:

  • Fee Type
  • System Fee Type
  • System Fee Trigger Cat
  • Management Level
  • Calendar Type
  • Formula Code
  • Formula Number

The Disbursement Formula Fee Category Override block contains:

  • Override Fee Category (LOV)
  • Disbursement Method (LOV)
  • Allocation Method (LOV)
  • Disbursement Fixed
  • Disbursement %
  • Base Balance
  • Override Formula Number
  • Override Fee Category Description
  • Classification (LOV)
  • Organisational Unit (LOV)

Rule/Notes:

Validations include:

  • The Fee Category must be ACTIVE
  • The Classification code must be open
  • The Organisational Unit must be ACTIVE
  • An ACTIVE fee_type_ci_account of type REVENUE must exist. If not, then DSBRSMNT_FRML_FEE_CAT_OVRD records cannot be created for the fee_type_cal_instance
  • The Organisational Unit details must be specified when the Disbursement Method is DIRECT. Organistional Unit details cannot be specified when the Disbursement Method is other than DIRECT
  • Only one Disbursement Fixed amount and Disbursement Percentage can be specified
  • If the Management Level of the Fee Type = COURSE or NULL and Formula Type is RETENTION and s_fee_trigger_cat != INSTITUTN then the Override disbursement Method must not be UNITTEACH
  • If Management_Level = UNIT and Formula Type is RETENTION and s_fee_trigger_cat != ‘INSTITUTN’ and the Disbursement Method = UNITTEACH, then the Allocation Method must be ‘PERUNIT’.

 

Field Source

Prompt

Display Type

Comments

DFIV.FEE_TYPE

Fee Type Text Item  
DFIV.FEE_TYPE_DESC No Prompt Text Item

Non database field, value obtained from fee_type.description .

DFIV.S_FEE_TYPE System Fee Type Text Item

Non database field, value obtained from fee_type.s_fee_type

DFIV.S_FEE_TRIGGER_CAT

System Fee Trigger Cat Text Item Non database field, value obtained from fee_type.s_fee_trigger_cat

DFIV.FEE_MANAGEMENT_LEVEL

Management Level

Text Item

Non database field, value obtained from fee_type.fee_management_level

DFIV .FEE_CAL_TYPE

Calendar Type

Text Item

DFIV.FEE_CAL_TYPE_DESC

No Prompt

Text Item

Non database field, value obtained from cal_type.description

DFIV.FEE_CI_SEQUENCE_NUMBER No Prompt Text Item Non visible item

DFIV.FORMULA_CD

Formula Code

Text Item

DFIV.FORMULA_DESCRIPTION

No Prompt

Text Item

Non database field, value obtained from disbursement_formula.formula_description

DFIV.CAL_START_DT

No Prompt

Text Item

Non database field, value obtained from cal_instance.start_dt

DFIV.CAL_END _DT

No Prompt

Text Item

Non database field, value obtained from cal_instance.end_dt

DFIV.FORMULA_NUMBER

Formula Number

Text Item

DFIV.S_FORMULA_TYPE

No Prompt

Text Item

Non visible item, used in block DFFCO validations

DFFCO.FEE_TYPE

No Prompt

Text Item

Non visible item

DFFCO.FEE_CAL_TYPE No Prompt Text Item Non visible item
DFFCO.FEE_CI_SEQUENCE_NUMBER No Prompt Text Item Non visible item
DFFCO.FORMULA_CD No Prompt Text Item Non visible item
DFFCO.FORMULA_NUMBER No Prompt Text Item Non visible item
DFFCO.FEE_CAT Override Fee Category Text Item  
DFFCO.S_DISBURSEMENT_METHOD_TYPE Disbursement Method Text Item  
DFFCO.S_ALLOCATION_METHOD_TYPE Allocation Method Text Item  
DFFCO.FIXED_DISBURSMENT_AMOUNT Disbursement Method Text Item  
DFFCO.PERCENTAGE_DISBURSEMENT % Text Item  
DFFCO.S_BASE_BALANCE Base Balance Text Item  
DFFCO.OVRD_FORMULA_NUMBER Override Formula Number Text Item

SELECT NVL ( MAX(ovrd_formula_number),0) + 1 FROM dsbrsmnt_frml_feecat_ovrd dffco WHERE dffco.fee_type = :dffco.fee_type AND dffco.fee_cal_type = :dffco.fee_cal_type AND dffco.fee_ci_sequence_number = :dffco.fee_ci_sequence_number AND dffco.formula_cd = :dffco.formula_cd

DFFCO.OVRD_FEE_CAT _DESC Override Fee Category Description Text Item Non database field, values obtained from fee_cat.description
DFFCO.CLASSIFICATION_CD Classification Text Item  
DFFCO.CLASSIFICATION_CD_DESC No Prompt Text Item Database field, value obtained from account_classification.dscription
DFFCO.ORG_UNIT_CD Organisational Unit Text Item  

DFFCO.ORG_UNIT_START_DT

No Prompt

Text Item

Non visible item

DFFCO.ORG_UNIT_DESC

No Prompt

Text Item

Non database field, values obtained from org_unit.description where org_unit_cd = :dffco.org_unit_cd and start_dt = dffco.org_unit_start_dt

 

Last Modified on 21 December, 2005