You use a rollover table to define the current conditions for creating rollover offers and contracts automatically.

A table comprises different variants and modifications, which each make up a condition package for a certain fixed interest period. The tables determine which variants are applied to the selected loan positions. They are used to automate standard procedures.

This function is only supported for loans given.

A table is made up of a table header, containing the table and version keys, the effective period and reservation period for the table and links to any number of variants and modifications.

The variants, which you can display or create in a tab page, contain the most important conditions used by lending institutions. You can group loans due for rollover using various selection criteria, such as loan number, amounts, remaining term or contract currency. This lets you determine the types of loan for which a particular variant may be used.

You can change the conditions in the contract due to be rolled over by creating a variant. The following condition fields can be changed:

• Fixed interest period (required entry):
  Determines the new fixed interest period.
• Disbursement rate (required entry)
• Effective interest method (required entry)
• Interest calculation method (required entry)

• Nominal interest (required entry)

• Payment form
• Exact payment form
• Payment frequency
• Reference interest rate
• +/- sign for reference interest rate

• Payment form
• Exact payment form
• Repayment frequency
• Immediate settlement

• Payment form
• Exact payment form
• Payment settlement frequency

The new fixed period is defined for four years with interest fixed at 6%. Loans that mature in less than two and a half years are to have the rate of 5% valid for 2½ years. All other loans (remaining term > 2½ years) will be given the four-year rate (6%).

Two variants are defined for the table:

1. The first variant uses the interest rate valid for four years. The minus tolerance for this variant is 18 months, since you want to use it for all loans with a remaining term of more than 2½ years.
2. The second variant is to be used for loans which mature within the next 2½ years. Here, you can define tolerances to capture the loans with a remaining term of less than 2½ years and apply the 5% rate up to maturity.

When you configure the main file, you use the main selection criterion to specify that all loans with a defined start of fixed period and end of fixed period are to be selected.

The main file structure is then filled for the rollover process. Having selected all loans to be processed, you can trigger the Create Contract function with the new table.

Your organization wants to roll over all loans with current fixed periods of three years that are due to expire in the next two months. You intend to send offers to your borrowers, in accordance with the table below:

Possible variants when creating the table:

1. 3 years, no selection criteria (applies for all loans)
2. 5 years, product type "mortgage loan" as the selection criterion.
3. 5 years, product type "special purpose loan" and remaining capital > 500,000 as the selection criteria.
4. 10 years, product type "mortgage loan" as the selection criterion.
5. 10 years, product type "mortgage loan", disbursement rate 100% and remaining capital > 500,000 as the selection criteria.
6. 7 years, product type "mortgage loan", disbursement rate < 100% and remaining capital > 500,000 as the selection criteria.
7. 7 years, product type "special purpose loan" and remaining capital > 500,000 as the selection criteria.

The following sections describe how to create, change and display tables for the rollover process.