Top of FIN Index Table of Contents Feedback

FINF7550 - Maintain Disbursement Formula Org Unit Override

Purpose

To override a Disbursement Formula for a particular Organisational Unit

SubSystem

Finance
Normally Run By Finance Specialist
Anticipated Frequency As required
Structure   Blocks FTCI Disbursement Formula
Disbursement Formula Organisational Unit Override

  

This function provides the ability to override a Disbursement Formula for particular Organisational Units (faculties, schools, etc.)

This function is accessed from FINF7510 – Maintain Fee Type Disbursement Formulae via the Org Unit 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 Organisational Unit Override block contains:

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

Rule/Notes:

Validations include:

  • The Override Organisational Unit must be ACTIVE
  • Classification code must be open
  • The Organisational Unit must be ACTIVE
  • If formula_type = 'RETENTION' ans s_fee_trigger_cat = 'INSTITUTN', Disbursment Type must be 'DIRECT'.
  • If formula_type = 'RETENTION' and s_fee_trigger_cat = 'INSTITUTN', Allocation Method must be 'STUDENT'
  • If formulat_type = 'RETENTION' and a s_fee_trigger_cat does not = 'INSTITUTN', Allocation Method must be either 'STUDENT' or 'PERCOURSE'
  • Only one of Fixed Disbursement Amount and Percentage Disbursement can be specified
  • If Disbursement Method is 'DIRECT', Organisational Unit details must be specified
  • If Disbursement Method is not 'DIRECT', Organisational Unit details must not be specified
  • If Management Level = 'COURSE' or NULL and Formula Type is 'RETENTION' and s_fee_trigger_cat does not = 'INSTITUTN', then the Override Disbursement Method must 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_DESCRIPTION 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_DESCRIPTION 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.START_DT No Prompt

Text Item

Non database field, value obtained from cal_instance.start_dt
DFIV.START_DT No Prompt

Text Item

Non database field, value obtained from cal_instance.start_dt
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.FORMULA_NUMBER Formula Num

Text Item

 
DFIV.S_FORMULA_TYPE No Prompt:

Text Item

Non visible item, Used in block DFOO validations
DFOO.FEE_TYPE No Prompt:

Text Item

Non visible item
DFIOO.FEE_CAL_TYPE No Prompt:

Text Item

Non visible item
DFOO.FEE_CI_SEQUENCE_NUMBER No Prompt:

Text Item

Non visible item
DFIV.FORMULA_CD No Prompt: Text Item Non visible item
DFOO.FORMULA_NUMBER No Prompt: Text Item Non visible item
DFOO.OVRD_ORG_UNIT_CD Override Organisational Unit Text Item  
DFOO.OVRD_ORG_UNIT_START_DT No Prompt Text Item Non visible item
DFOO.S_DISBURSEMENT_METHOD_TYPE Disbursement Method Text Item  
DFOO.S_ALLOCATION_METHOD_TYPE Allocation Method Text Item  
DFOO.FIXED_DISBURSMENT_AMOUNT Disbursement Fixed Text Item The prompt Disbursement is shared between Amount and %
DFOO.PERCENTAGE_DISBURSEMENT Disbursement % Text Item The prompt Disbursement is shared between Amount and %
DFOO.S_BASE_BALANCE Base Balance Text Item  
DFOO.OVRD_FORMULA_NUMBER Override Formula Number Text Item  
DFOO.OVRD_ORG_UNIT_CD_DESCRIPTION Override Org unit Description Text Item Non database field, values obtained from org_unit.description where org_unit_cd = :dfoo.ovrd_org_unit_cd and start_dt = dfoo.ovrd_org_unit_start_dt
FTDF.CLASSIFICATION_CD Classification Text Item  
FTDF.CLASSIFICATION_CD_DESCRIPTION No Prompt Text Item Database field, value obtained from account_classification.dscription
DFOO.ORG_UNIT_CD Organisational Unit Text Item  
DFOO.ORG_UNIT_START_DT No Prompt Text Item Non visible item
DFOO.ORG_UNIT_DESCRIPTION No Prompt Text Item Non database field, values obtained from org_unit.description where org_unit_cd = :dfoo.org_unit_cd and start_dt = dfoo.org_unit_start_dt

 

Last Modified on 21 November, 2005