2.4.16 Limit Schedule Functionality

This topics describes about the functionality limit schedule.

The limit schedule definition helps create schedules for different business needs by considering various parameters shown to users in the schedule section. This applies to all types of facilities, including revolving, non-revolving.

User can set limit schedules for a credit line and specify the applicable limit for each period. The Schedule Start Date must be on or after the Limit Start Date, and the Schedule End Date must be on or before the Limit Expiry Date.

The facility batch at BOD checks the schedule limits for a facility and sees if a schedule is due today at the branch. If that's the case, it changes the limit for the facility according to the scheduled amount.

Types of Limit Schedule:
  • Dropline Limit Schedule
  • Onetime Limit Schedule
  • Recurrence Limit Schedule

Types of Limit Schedule:

Dropline Limit Schedule
  • In a Dropline Limit Schedule, the Limit Amount will slowly decrease to zero according to the Amount/Percentage and the frequency outlined in the Schedule definition.
  • Dropline Limit flag at facility level must be enabled. Once a facility is signified as Dropline, it cannot be modified.
  • Dropline limit schedule drawn will be based on limit amount.
  • Dropline limit can be signified even on a facility without expiry date.
  • Dropline limit schedule will be drawn based on parameters like Duration, Percentage/amount.
  • Dropline limit end date will be derived by the system based on start date and signified duration or End date can be specified.
  • Dropline limit schedule will be exploded till the signified end date based on the frequency specified.
  • System will validate the derived end date is within limit expiry date and prompt appropriate message if the limit amount is getting zeroized before expiry date.
  • System will prompt appropriate message if the limit amount is not dropping down to zero on end date based on percentage/amount signified.
  • Multiple instances of schedule definition can be signified for a dropline limit duly ensuring the following.
    • Start date of second schedule should be after the end date of first schedule.
    • Overlapping schedules should not allowed.
    • At the end of first schedule, there should be residual limit amount remaining for the second schedule to consider.
  • Dropline schedule can be signified during facility creation or subsequently as part of facility amendment.
  • When a dropline schedule is set up during facility creation, the start date defaults to the line start date, and the first schedule date is calculated by adding the frequency to the line start date.
  • When a dropline schedule is marked on a facility after the line start date, the start date defaults to today but can be changed to a future date. The amount at that time will be used to create the dropline schedule.
  • Different start date and end dates can be signified with different percentage/amount within the line start date and expiry date with multiple schedule definition.
  • When drop line limit is selected in the main screen, in schedule definition, reduce will be selected as default basis option and not editable.
  • Based on the parameters signified system will draw a dropline limit schedule – reducing limit amount at specified frequencies which will be made applicable to facility on schedule date.
  • Dropline limits can be signified across facilities in the hierarchy.
  • Fee associated with limit amount for a backdated facility will consider the limit amount as per dropline limit applied on facility for fee calculation.
  • Drop line schedules can be signified on a future dated facility as part of facility creation/ amendment.
  • Dropline schedule generated based on schedule definition can be subsequently modified post generation.
  • Generated schedule date and/or amount can be modified by user . Modified amount as per schedule on the schedule date will be applied on the facility.
  • A one-time setup will be given to permit or restrict the application of a limited amount based on the dropline schedule if the used amount exceeds the scheduled limit. The limit will be applied according to this setup.
  • If the applied limit causes the available balance to go negative, it will be recorded as an exception. This information can be used to create a report for review or audit when the configuration is turned on.
  • If the configuration is not enabled, limit amount as per drop line schedule will not be applied on the facility if the utilized amount is more than limit amount as per schedule. Such failures will be logged with details for reporting purposes.
Amendment in Schedule Definition:
  • As part of facility amendment process, additional schedule definitions can be signified on a subsequent date. Limit amount as on date of signifying schedule definition will be considered. Base amount as at the end of first schedule will be considered for the second schedule.
  • Dropline limit schedule definition end date signified on a facility can be modified on a later date during the life cycle of facility after application limit amount as per schedule definition.
  • Modifications like duration of schedule, percentage/amount, start date can be done on future schedule definitions which are yet to start.
  • Validation relating to overlapping of first schedule with existing second schedule to be handled as part of amendment.
  • Modification of second or subsequent schedule definition which is yet to start will regenerate schedule only relating to the modified definition and not the first definition.
  • Deletion of schedule definition after the start date when limit amount has got applied on facility based on exploded schedule is not permitted.
  • Limit amount modification during facility life cycle if done will be effective on the facility till next drop line schedule date.
Onetime Schedule
  • Onetime limit schedule is signifying a limit schedule for predefined duration within the tenor of the facility.
  • Limit amount as on the date of signifying schedule definition will be considered for schedule limit computation.
  • User must specify the period during which the one-time schedule is applicable by specifying start date and Duration & Units or End Date.
  • If the Duration & Unit or End date is not provided, the limit amount according to the schedule will apply from the start date until the limit expiry date or the next scheduled limit instance, unless reinstatement is chosen.
  • User can signify Basis as Percentage or Amount & its value and Schedule Action as Increase/Decrease/Fixed, based on which the Limit Schedule amount will be computed.
  • Multiple definitions of one-time schedule can be signified.
  • Limit to be reinstated after the end date of one-time schedule if the user has enabled Schedule Reset.
  • Once schedule is commenced except end date, other details cannot be modified.
  • Basis amount for the application of second schedule definition is first schedule limit amount if reset is not opted. It will be the limit amount if reset opted.
Computation of Limit Schedule Amount:
  1. When defining a Limit Schedule, if there is no current Schedule or one added after the existing schedule starts, choose Amount as the Basis and set the Schedule Action as:
    • Increase / Decrease: The specified amount will be added / deducted to the previous day's Limit Amount prior to the proposed schedule start date.
    • Fixed: The specified amount will be considered as the Limit Amount for the Schedule period.
  2. Similarly, while signifying a Limit Schedule definition, by selecting Basis as "Percentage" and Schedule Action as:
    When there is no Schedule definition (on-going or future schedule) in the facility:
    • Increase / Decrease: The percentage will be applied to the Limit Amount on the day of adding the proposed schedule and the result will be added / deducted to the previous day's Limit Amount prior to the proposed schedule start date.
    • Fixed: The percentage will be applied to the Limit Amount on the day of adding the proposed schedule and sets the calculated value as the Schedule Limit Amount for the signified schedule period.
    When a Schedule definition is added subsequently before or after commencement of existing schedule definition in the facility:
    • Increase / Decrease: The percentage will be applied to the previous Schedules Definition’s last Schedule Limit Amount and the result will be added / deducted to the previous day's Limit Amount prior to the proposed schedule start date.
    • Fixed: The percentage will be applied to the Limit Amount on the day of adding the proposed schedule and sets the calculated value as the Schedule Limit Amount for the signified schedule period.
Amendment in Schedule definition:
  • As part of facility amendment, new schedule definition can be added to a facility after line start date.
  • Exploded schedule limit date and/or amount can be modified which will be considered for limit amount updating on the facility.
  • Any subsequent addition of schedule definition will consider the limit amount as on date for arriving the new schedule.
  • If a new schedule is added after an ongoing one, and the first schedule has a reset option, the new schedule will use the reset limit amount.
  • Amendment in Limit Schedule definition before commencement of the Schedule:
Recurrence Limit schedule:
  • This is extension of one time schedule with multiple recurrences. Definition is considered recurrence as per defined recurrence frequency duration.
  • Recurrence Frequency must be greater than the Schedule Duration.
  • For the specified duration in Schedule definition, the applicable Recurrence Frequency are:

    Table 2-178 Recurrence Frequency

    Schedule Duration Applicable Recurrence Frequency
    Less than 7 days Weekly / Monthly / Quarterly / Half-yearly / Yearly
    7 days to less than 1 Month (or its equivalent in Days) Monthly / Quarterly / Half-yearly / Yearly
    1 Month to less than 3 Months (or its equivalent in Months/Days) Quarterly / Half-yearly / Yearly
    3 Months to less than 6 Months (or its equivalent in Months/Days) Half-yearly / Yearly
    6 Months to less than 1 Year (or its equivalent in Months/Days) Yearly
    1 Year or more (or its equivalent in Months/Days) Not applicable
  • Limit Schedule Amount applied for a range of dates, with Schedule Reset enabled, the Recurrence Frequency will be based on the resetted Limit Amount, else subsequent Recurrence Frequency limit amount will be based on previous frequency limit amount.
  • Multiple instances of Recurrence Schedules can be signified without overlapping of Schedules.
  • Before commencement of the schedule, the User can modify the values in Recurrence Frequency and its Unit and the revised schedule can be exploded.
  • Before starting the schedule, the Recurrency frequency can be adjusted up or down to match the Schedule duration as part of the Facility Amendment.

Note:

  • If the generated schedule is not to be applied, select the option to pause prior to schedule date.
  • Once the schedule date is crossed, earlier paused schedule cannot be resumed. However, paused scheduled can be resumed before schedule limit date.
  • Deletion of schedule definition before the start date will result in removing both schedule definition as well as exploded schedule.
  • Once the Schedule is applied, except end date, value in no other fields can be modified.
  • If the drop line schedule date is due on a non-working date, same will be applied as per holiday processing setting in Config Service level.
  • Facility history contains details of dropline limits signified/modified on the facility with all details.
  • User can signify schedule limit dates/amounts directly as existing without entering schedule definition.

Illustrations

Dropline Limit Schedule:

(a) Limit Amount : USD 50,000

System date : 30-Dec-2024

Table 2-179 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Jan-2025 - Months 1 01-Feb-2025 Percentage 25 - Weekly Decrease - - -

Table 2-180 Schedules

Schedule Limit Date Schedule Limit Amount
01-Jan-2025 37,500
08-Jan-2025 25,000
15-Jan-2025 12,500
22-Jan-2025 0

Note:

Alert message “Schedule exhausted before the Specified EndDate” will be populated.

(b) Limit Amount : USD 2,00,000

System date : 01-Jan-2025

Table 2-181 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Jan-2025 - Years 1 01-Jan-2026 Amount - 10,000 Monthly Decrease - - -

Table 2-182 Schedules

Schedule Limit Date Schedule Limit Amount
01-Feb-2025 190,000
01-Mar-2025 180,000
01-Apr-2025 170,000
01-May-2025 160,000
01-Jun-2025 150,000
01-Jul-2025 140,000
01-Aug-2025 130,000
01-Sep-2025 120,000
01-Oct-2025 110,000
01-Nov-2025 100,000
01-Dec-2025 90,000
01-Jan-2026 80,000

Note:

Alert message “Schedule is not zeroised at the specified End Date” will be populated.

(c) Limit Amount : USD 2,00,000

System date : 31-Dec-2024

Table 2-183 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Jan-2025 - Months 5 01-Jun-2026 Amount - 10,000 Monthly Decrease - - -

Table 2-184 Schedules

Schedule Limit Date Schedule Limit Amount
01-Jan-2025 190,000
01-Feb-2025 180,000
01-Mar-2025 170,000
01-Apr-2025 160,000
01-May-2025 150,000
01-Jun-2025 140,000

Note:

Alert message “Schedule is not zeroised at the specified End Date” will be populated.

(d) Limit Amount : USD 2,00,000

System date : 01-Jan-2025

Table 2-185 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Jan-2025 - Years 1 01-Jan-2026 Amount - 30,000 Monthly Decrease - - -

Table 2-186 Schedules

Schedule Limit Date Schedule Limit Amount
01-Feb-2025 170,000
01-Mar-2025 140,000
01-Apr-2025 110,000
01-May-2025 80,000
01-Jun-2025 50,000
01-Jul-2025 20,000
01-Aug-2025 0

Note:

Alert message “Schedule exhausted before the Specified EndDate” will be populated.

(e) Limit Amount : USD 2,00,000

System date : 01-Jan-2025

Table 2-187 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
28-Feb-2025 Yes Years 1 28-Feb-2026 Percentage 10% - Quarterly Decrease - - -

Table 2-188 Schedules

Schedule Limit Date Schedule Limit Amount
28-Feb-2025 180,000
31-May-2025 160,000
31-Aug-2025 140,000
30-Nov-2025 120,000
28-Feb-2026 100,000

Note:

Alert message “Schedule is not zeroised at the specified End Date” will be populated.

Onetime Limit Schedule:

(a) Limit Amount : USD 1,00,000

System date : 01-Jan-2025

Table 2-189 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Feb-2025 - Months 2 31-Mar-2025 Amount - 10,000 - Increase Yes - -

Table 2-190 Schedules

Schedule Limit Date Schedule Limit Amount
01-Feb-2025 110,000
01-Apr-2025 100,000
Before commencement of the schedule, on modifying the fields – Start Date, Duration, Units, Basis & its value and Schedule Action in the above schedule definition:
System date : 18-Jan-2025

Table 2-191 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
20-Jan-2025 - Days 10 29-Jan-2025 Percentage 25% - - Decrease - - -

Table 2-192 Schedules

Schedule Limit Date Schedule Limit Amount
20-Jan-2025 75,000
(b) Limit Amount : USD 1,00,000

System date : 25-Feb-2025

Facility Start date : 10-Feb-2025

Facility End date : 31-Dec-2025

Limit Amount : USD 1,00,000

Table 2-193 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Mar-2025 - - - 20-Mar-2025 Amount - 5000 - Increase Yes - -

Table 2-194 Schedules

Schedule Limit Date Schedule Limit Amount
01-Mar-2025 105,000
21-Mar-2025 100,000
(i) If the below Schedule - 2 is added before commencement of Schedule -1:

System date : 28-Feb-2025

Table 2-195 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Mar-2025 - - - 20-Mar-2025 Amount - 5000 - Increase Yes - -
26-Mar-2025 - - - 31-Mar-2025 Amount - 15000 - Increase Yes - -

Table 2-196 Schedules

Schedule Limit Date Schedule Limit Amount
01-Mar-2025 105,000
21-Mar-2025 100,000
26-Mar-2025 115,000
01-Apr-2025 100,000
(ii) If the below Schedule - 2 is added before commencement of Schedule -1:

System date : 28-Feb-2025

Table 2-197 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Mar-2025 - - - 20-Mar-2025 Amount - 5000 - Increase Yes - -
26-Mar-2025 - - - 31-Mar-2025 Amount 20% - - Decrease - - -
Revised exploded Schedule will be:

Table 2-198 Schedules

Schedule Limit Date Schedule Limit Amount
01-Mar-2025 105,000
21-Mar-2025 100,000
26-Mar-2025 80,000
(iii) If the below Schedule - 2 is added after commencement of Schedule -1:

System Date : 05/03/2025

Table 2-199 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Mar-2025 - - - 20-Mar-2025 Amount - 5000 - Increase Yes - -
26-Mar-2025 - - - 31-Mar-2025 Percentage 50% - - Fixed Yes - -
Revised exploded Schedule will be:

Table 2-200 Schedules

Schedule Limit Date Schedule Limit Amount
01-Mar-2025 105,000
21-Mar-2025 100,000
26-Mar-2025 50,000
01-Apr-2025 100,000

Recurrence Limit Schedule:

(a) Limit Amount : USD 1,00,000

System date : 01-Jan-2025

Table 2-201 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Feb-2025 - Days 7 07-Feb-2025 Percentage 20% - - Increase Yes Monthly 3

Table 2-202 Schedules

Schedule Limit Date Schedule Limit Amount
01-Feb-2025 120,000
08-Feb-2025 100,000
01-Mar-2025 120,000
08-Mar-2025 100,000
01-Apr-2025 120,000
08-Apr-2025 100,000
01-May-2025 120,000
08-May-2025 100,000
Before commencement of the schedule, on modifying the fields – Start Date, Duration, Units, Basis & its value and Schedule Action in the above schedule definition:
System date : 19-Jan-2025

Table 2-203 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
20-Jan-2025 - Months 2 19-Mar-2025 Amount - 15,000 - Decrease - Quarterly 3

Table 2-204 Schedules

Schedule Limit Date Schedule Limit Amount
20-Jan-2025 85,000
20-Apr-2025 70,000
20-Jul-2025 55,000
20-Oct-2025 40,000

(b) Limit Amount : USD 1,00,000

System date : 01-Jan-2025

Table 2-205 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Feb-2025 - Days 6 06-Feb-2025 Percentage 20% - - Increase - Weekly 3
05-Apr-2025 - Month 4 04-Aug-2025 Amount - 10,000 - Decrease Yes Hal-yearly 2

Table 2-206 Schedules

Schedule Limit Date Schedule Limit Amount
01-Feb-2025 120,000
08-Feb-2025 140,000
15-Feb-2025 160,000
22-Feb-2025 180,000
05-Apr-2025 170,000
05-Aug-2025 180,000
05-Oct-2025 90,000
05-Feb-2026 180,000
05-Apr-2026 90,000
05-Aug-2026 180,000

(c) Adding Schedule – 2 after commencement of Schedule -1,

Limit Amount : USD 1,00,000

System date : 15-Feb-2025

Table 2-207 Schedule Definition

Start Date Is Month End Duration Unit End Date Basis Percentage Amount Schedule Frequency Schedule Action Schedule Reset Recurrence Frequency Recurrence Unit
01-Feb-2025 - Days 7 06-Feb-2025 Percentage 20% - - Increase - Weekly 3
05-Apr-2025 - Month 4 04-Aug-2025 Percentage - 10% - Decrease Yes Half-yearly 2

Table 2-208 Schedules

Schedule Limit Date Schedule Limit Amount
01-Feb-2025 120,000
08-Feb-2025 140,000
15-Feb-2025 160,000
22-Feb-2025 180,000
05-Apr-2025 162,000
05-Aug-2025 180,000
05-Oct-2025 162,000
05-Feb-2026 180,000
05-Apr-2026 162,000
05-Aug-2026 180,000