System Maintained Files

It has the tranche wise outstanding amounts under a facility, broken down into each participant share. This file is used to validate the loan amount in SL.LOANS or SL.ROLLOVER vis a vis commitment available amount under the respective tranche.

When SL.ROLLOVER is authorised, this file is updated with the payment and receipt details currency wise resulting out of such rollover. It also contains an indicator as to the nature of operation used in SL.ROLLOVER, i.e., Rollover / Merger / Split. The share of each participant is stored currency-wise, and is used for netting delivery.

The extent of underwriting done by Temenos Transact bank for each FACILITY is held here along with the currency and the consolidation key for the deal.

Details of currency, original amount, principal movements and their effective dates, interest rate, interest for the current period etc., are held in this file for every live SL.LOANS ID. Amounts are stored in deal currency equivalent. Closing balance alone is held in both deal and facility currency equivalent.

Details of loan accruals (Temenos Transact bank portion only) are held for the period between value and maturity date. Amounts are stored in deal currency.

Similar to SL.LOAN.ACCR.DETAILS, this file holds information for a FACILITY.

This file is written when Liquidation Mode field in the FACILITY or SL.LOANS is set as Internal. On the scheduled date, the commitment fee due (Facility) or interest and principal dues (Loans) are written to this file. Within each asset type, the aggregate dues and the share of each participant in the due are written. One record for every scheduled date, linked with the FACILITY or SL.LOANS reference is written.

Participant level information of overdue is held in this file. SL.OD.DUES holds the information at FACILITY or SL.LOANS level, whereas SL.OD.PART holds information at participant level.

This file is created with details of the currency, initial amount of the FACILITY and Tranches. This is updated when drawings are made using SL.LOANS or SL.ROLLOVER. For every tranche, start and end date tranche level information is updated. Commitment fee details like amount, rate and effective dates are also held. A principal movement to the FACILITYtransacted through SL.BUY.SELL is updated in this file.

Facility balances are held at participant level in this file. The ID of this file is <FACILITY reference plus the customer reference of the Participant>.

For Temenos Transact bank, this file contains the amount accrued for the current period.

This file contains the details of charges taken and that has to be taken in future (scheduled). It also holds the un-amortised portion of the charges wherever amortisation has been set to Yes while taking charges.

Such information is held for FACILITY and SL.LOANS.

Product wise facility balances are held in this file. Tranche level product details such as Tranche outstanding amount against the product type and Tranche level amount utilised by the product type are also recorded in this file.

Lists out the ID’s of the live SL.LOANS drawn under each tranche. This file is updated when fresh loans are drawn, on maturity of loans and on transacting SL.ROLLOVER. The @ID of this file is the <PRE.SYNDICATION.FILE @ID plus the unique tranche code assigned>.

This file contains details of old and new loans under the ID of SL.ROLLOVER. When SL.ROLLOVER is used, this file is updated with details of reference numbers, currency and amount of the old loans (rolled-over, merged or split) and similar details for the new loans emanating out of the transaction.

It also contains an indicator as to the nature of operation used in SL.ROLLOVER, that is Rollover / Merger / Split.

For every date, this file contains the ID’s of SL.ROLLOVER that are to be processed for system date.

This contains the Mnemonic used for each FACILITY or SL.LOANS.

For every SL.LOANS ID concatenated with date, this file contains the details of schedule type and amount that is to be processed. Any charge scheduled for that date, relevant details are also held here.

Contains the loan schedules that have already been processed.

Under every date, this file holds the details of SL.LOANS that are scheduled for maturity. This file would contain details of past as well as future dates.

Contains the list of SL.LOANS that are assigned to a specific BASIC.INTEREST key.

For every date, this file would contain the ID’s of SL.LOANS that are to be processed for system date.

Similar to SL.LOAN.MATURITY, this contains the details of FACILITY records that are scheduled for maturity (including past and future dates).

File that lists out the ID’s of the live SL.LOANS drawn under a particular FACILITY record.

On every tranche start date, updates are required in the FACILITY record and respective balances files to reflect the commitment available amount. This file lists out under each date the tranches that require update.

On every tranche end date, updates are required in the FACILITY record and respective balances files to reflect the commitment available amount. Also, accounting entries are required to be raised on the tranche end date if an undrawn balance is not flagged for carry forward on expiry of tranche. This file lists under each date the tranches that require update/accounting.

This file contains details of unique tranche codes forming part of each FACILITY record. @ID of this file is the PRE.SYNDICATION.FILE reference and all FACILITY records and tranche codes within each FACILITY record are listed.

Similar to SL.LOAN.SCHEDULES, this contains the schedule type and amount that is to be processed for every FACILITY record. Any charge scheduled for that date, relevant details are also held here.

Similar to SL.LOAN.SCHEDULES.PAST this contains the details of past schedules (already processed) for a FACILITY.

When SL.EXPOSURE.LEVEL is built the scheduled dates for reduction is held in this file. On such scheduled date, the amount scheduled for cancellation as held in SL.EXPOSURE.LEVEL is processed.

In order to support group lending, define a FACILITY with allowed and reserved amounts pertaining to each borrower under a tranche. This file contains for each allowed customer (under a tranche) the allowed and reserved amounts defined in the FACILITY. This file is updated when the specific borrower draws under the tranche.

It would be possible to define the maximum number of currencies in which live loans are to exist under each tranche in a FACILITY. This file contains details of live SL.LOANS references and the deal currency of the drawing under each tranche code within a FACILITY.

Similar to SL.LOAN.EOD.LIST contains details for FACILITY record.

This file holds the list of FACILITY or SL.LOANS @ID for which delivery messages are scheduled for a future date. The @ID of this file is <the actual date on which the messages are to be produced>.

A revolving facility could contain stipulations for phased reduction of the facility amount. For a non-revolving facility, the user may define SL.REPAYMENT.SCHEDULES at the facility level. In either case the SL.EXPOSURE.LEVEL file is built containing details of specific dates on which amounts are to be repaid (non-revolving) / scheduled for reduction (revolving). When drawings are made under the facility, the amount of loan is updated in the relevant time period in this file. Also, use of SL.ROLLOVER will result in update of utilised amounts for relevant time blocks.

When loans are drawn or rolled over, the contemplated exposure level is checked while validating the transaction.

When a live FACILITY or SL.LOANS is visited by the user and changes made, this file is updated in order to process static changes, if any.

This file contains details of live FACILITY records pertaining to each customer.

This file contains details of live SL.LOANS records pertaining to each customer.

The list of live contracts under each consolidation key is held in this file.

Sequential file for RE.CONSOL.SL.