Maintain Student Loan Detail {FBLO-22}

The repayment detail and the link to the accounts receivable system for a student loan is maintained in this option.

Fields in the option:

Block 1: Bursary Debtor Detail

The information in this block is populated when money is allocated to the student in {FBLO-6} or by running {FBLO-7}. If money was allocated to the student against a loan, both the debtor code (as created in the accounts receivable system) and the contract received fields can be updated. If money was allocated against a bursary, only the contract received field can be updated if a contract is required.

Field	Type & Length	Description
Loan Code	N5	The loan code for a specific loan is allocated programmatically
Debtor Code	N9	The accounts receivable debtor number for the student. This field must be entered for loans. AR debtors are maintained on {FARO-21}. All transactions regarding a student loan must be processed against an AR account type where the AR category of the account type is equal L (student loan). Account types are maintained on {FCSC-21}.
Student Number	N9	The student number.
Bursary	A7	The bursary/loan code from which money was allocated to the student.
Component	A1	This field indicates whether it is a bursary or a loan.
Year	N2	The year in which the bursary was allocated.
Block	A2	The block in which the bursary was allocated.
Contract	A1	Indicate whether a contract was received for this bursary or loan. Payments will not commence until this indicator is equal to yes if it is stipulated on the bursary or loan that a contract must be handed in by the student.

Example(s):

Block 2: Debtor Loan Code

The information in this block is created the first time when a loan payment is generated on a student's account when {FBLO-8} is run. Only a few fields at the end of the screen regarding the repayment period and interest rates can be updated here.

Field	Type & Length	Description
Debtor	N9	The accounts receivable debtor number for the student. The debtor code is entered in block 1 and displayed here. The name of the debtor is also displayed.
Loan Code	N5	The loan code as queried in block 1.
Student Number	N9	The title, initials and surname of the student are displayed from the student biographical record {SREGB-1}.
Student type	A1	The student type as defined on the student biographical record is displayed.
Address	A30 x 4	The address of the debtor as defined in the accounts receivable system {FARO-21}.
Postal Code	N4	As defined for the debtor in the accounts receivable system.
Language	A1	Preferred language of the debtor.
Statement Interval	N2	As defined for the debtor in the account receivable system.
Non-/Active Debtor	(Y/N)	As indicated on the debtor in the accounts receivable system. Transactions can only be processed for active debtors.
Telephone	A15	As defined for the debtor in the accounts receivable system.
Last Statement Printed	(DD-MON-YYYY)	This field is updated for the debtor by the system when a statement is printed.
Bursary Code	A7	The bursary/loan code from which this loan was allocated. The description of the bursary/loan is displayed.
Year	(YY)	The year for which this loan was allocated.
Block	A2	The block for which this loan was allocated.
Account Type	A8	The account type that that was used for this loan allocation. All transactions regarding this loan must be processed against this account type.
Loan Type	A2	The fund type linked to the bursary code is displayed.
Loan Amount	N10.2	The loan amount that was allocated to the student.
Minimum Monthly Payment	N10.2	The minimum amount that must be repaid per month. This field must be entered here as it is used in the calculation of the redemption schedule.
Repayment Period	N3	The period in months over which this loan must be repaid. This field must be entered here.
Payments per Year	N2	The number of payments per year for the repayment of the loan. This field must be entered here.
Interest Rate Study	N3.2	The interest rate applicable while the student is studying. This field defaults from the loan definition but can be updated here.
Interest Rate Not Study 1	N3.2	The first interest rate which is applicable after the student has completed his studies. This field defaults from the loan definition but can be updated here.
Interest Rate Not Study 2	N3.2	The second interest rate which is applicable after the student has completed his studies. This field defaults from the loan definition but can be updated here.

Example(s):

Block 3: Debtor Loan Code Status Detail

The first record per loan is generated automatically when {FBLO-8} is run. Records can be added as the status of the loan changes. Only records with dates greater than system date can be deleted from this block. Only the date and status code can be changed on this screen.

Field	Type & Length	Description
Loan Code	N5	Loan code as queried in block 1. The query is automatically executed and all the statuses of the loan are displayed.
Date	(DD-MON-YYYY)	The date from which the status will be valid for the loan.
Status	A1	The status that will be applicable to the loan from above date. The description of the status code is displayed.
The rest of the fields are displayed from the status code definition as specified in {FBLC-21}, and cannot be changed here.
Interest Rate	A1	This field indicates which of the three interest rates applies to the loan.
Interest Base	A1	This field indicates whether interest must be calculated in (A)dvance or in a(R)rears.
Interest Interval	A1	This field indicates the frequency of interest calculations, e.g. annually, monthly, etc.
Suspend Payment	A1	This field indicates whether the student must make payments or whether payments are suspended.

Example(s):

Block 4: Debtor Loan Code Amortisation Schedule

With every monthly calculation run {FBLO-24}, a record is inserted in this block. It represents a snapshot of the loan at regular intervals. Records cannot be updated or created in this block. Only existing records can be queried.

Field	Type & Length	Description
Debtor Code	N9	Debtor code from previos block. The name of the debtor is displayed
Loan Code	N5	Loan code from previous block.
Date	(DD-MON-YYYY)	The date on which the interest calculation was run.
Status	A1	The status of the loan
Months to Pay	N2	Outstanding months to pay the loan.
Balance	N10.2	The balance of the loan when interest calculation was run.
Interest	N10.2	The interest as calculated for that period.
Amortise	N10.2	The adjustments to the capital balance, e.g. reduction due to payments or adjustments due to the capitalisation of interest.
Ideal Payment	N10.2	The calculated ideal payment to repay the loan within the remaining period.
Real Payment	N10.2	The actual payments that were made since the previous interest run.
Age analysis Current,+30,+60,+90	N10.2	The age analysis of the loan as at interest calculation.
Total Due	N10.2	The sum of the above four fields.

Example(s):

Block 5: Debtor Loan Code Sureties

In this Block details regarding the sureties can be maintained. If a student falls behind in his payments, an alias debtor in this name can be created. The original debtor can be linked to the alias debtor and statements will in future be sent to the alias debtor.

Field	Type & Length	Description
Loan Code	N5	The loan code from block 1 is displayed in this field or a specific loan can be queried.
Contact Sequence	N1	This field indicates the contact for which the following detail must be entered or will display.
Tel. Type 1	A3	Choose the telephone type from the list of values.
Tel. Number 1	A15	Enter the telephone number.
Tel. Type 2	A3	Choose the telephone type from the list of values.
Tel. Number 2	A15	Enter the telephone number.
Address Type	A3	Choose the address type from the list of values.
Address 1	A30	Enter the address of the contact.

Example(s):

Processing Rules
	No special processing rules

Date	System Version	By Whom	Job	Description
25-Sep-2006	v01.0.0.0	Charlene van der Schyff	t133880	New manual format.
29-Mar-2010	v01.0.0.1	Frans	T156162	Release with T156162