Fee Weight Calculated on Subject Credit Values {FSAM1-10}

The purpose of this option is to update subjects fee weights {FSAM-1b2} event 07 in bulk by applying a monetary value per subject credit. Subject credits are defined on the academic structure - subject definition {SACAD-14}.

If the user selects records per fee structure key fields, the user is prompted for all of the seven fee table key fields (block code, offering type etc.) in the program, although only the key fields defined for the selected year {FSAM-29} are used to select fee records. The user selection is sufficient to select up to one specific record/s from the SD fee structure.

The fee weight formula for event 07 record/s are:

Subject Credit value time Monetary Value per Credit Value divided by Base Value of the Academic Year and Event and rounded to 5th decimal.

Prompt Text ^{* an item between square brackets [ ] is the default answer}	Type & Length	Comments
Transaction Type Selection: 1. Range of Transaction Types 2. ALL Transaction Types Please Enter your Selection : [2}	N1
If Transaction Type Selection = 1 Start and End Transaction Type	N4x2	If Transaction Type Selection = 2 the next prompt is 'Year' . <List of Values> is available on both fields.
Year	YYYY	Defaults the current academic year from the system cycle for system cycle type =S 'Current Academic Year' {SMNT-2} TAB - Academic Structure and Exams.
Subject Code Selection : 1. Range of Subject Codes 2. ALL Subject Codes Please Enter your Selection : [2]	N1
If Subject Code Selection = 1 Start and End Subject Code	A7x2	If Subject Code Selection = 2 the next prompt is 'Select Fee Records per Fee Structure Key Fields'. <List of Values> is available on both fields.
Select Fee Records per Fee Structure Key Fields [N]	A1	Valid values is Y (Yes) or N. If Yes the the user must specified which key fields must be used. Else if No the system will use the event 07 key fields for the academic year as define in option {FSAM-29}.
If Select Fee Records per Fee Structure Key Fields = Y Start and End Currency Code [0] and [ZZZ] Start and End Offering Type [0] and [ZZ] Start and End Student Type [0] and [ZZ] Start and End Exam Type [0] and [Z] (C)ash / (T)erms / (B)oth [B] Start and End Block Code [0] and [ZZ]	A3x2 A2x2 A2x2 A1x2 A1 A2x2	If Select Fee Records per Fee Structure Key Fields = N the next prompt is 'Monetary Value per Crediet Value of 1.000'
Monetary Value per Crediet Value of 1.000	N17	What is the cost per crediet value. E.g. R1.00, $1.00 etc.
Should Existing Fee Weight be Updated [N]	A1	Valid values are Y (Yes) or N (No). if No then the run will No select only records where the fee weight is null or zero.
(T)rial or (U)pdate Run [T]	A1

Sort Order	Per	Comments
	Subject Code, Transaction Type, Currency, Offering Type, Period of Study, Block Code, Student Type, Examp Type, Post Graduate, Cash Terms

System Select

Example:

Processing Rules
	Select all event "07" fee records for the input criteria/user selection If the input parameter "Update existing fee weight" is No select only records where the fee weight is null or zero else select all records according to input criteria/user selection For each selected record get the subjects credit value {SACAD-14}, TAB - Subject Information for the subject and academic year from the subject information. Multiply the subject credit value with the monetary value per credit value divided by the event "07" fee base value for the academic year. For each subject code update the rounded fee weight (5th decimal) if run in update mode.

Processing
Rules

Select all event "07" fee records for the input criteria/user selection
If the input parameter "Update existing fee weight" is No select only records where the fee weight is null or zero else select all records according to input criteria/user selection
For each selected record get the subjects credit value {SACAD-14}, TAB - Subject Information for the subject and academic year from the subject information.
Multiply the subject credit value with the monetary value per credit value divided by the event "07" fee base value for the academic year.
For each subject code update the rounded fee weight (5th decimal) if run in update mode.

Example a Fee Weight Calculation:

Base value on event 07 year 2006 is 1000 {FSAM-1b1}

Base value on event 07 year 2007 is 1050 {FSAM-1b1}

Subject 101REC Credit Value is 25.000 {SACAD-14b1}

Monetary Value per Credit Value is $1.00

Subject 101REC Credit Value * Monetary Value per Credit Value divide by Base value on event 07 for the academic year.

2006 Fee weight:

25.000 * 1.00 / 1000 = 0.02500

2007 Fee weight

25.000 * 1.00 / 1050 = 0.0238095

rounded to 5 decimals = 0.02381

Date	System Version	By Whom	Job	Description
19-Jul-2007	v01.0.0.0	Amanda Nell	t143350	New manual format.
11-May-2009	v01.0.0.1	Ernie van den Berg	t157364	Review the manual