2.2.3 Schedules Maintenance
This topic describes about the procedure to define 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, and special 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.
- Dropline Limit Schedule
- Onetime Limit Schedule
- Recurrence Limit Schedule
Note:
The fields, which are marked with an asterisk, are mandatory.- On Facilities Maintenance screen, click the
Schedules tab.The Schedule Maintenance screen is displayed. For more information on fields, refer to the field description table.
Table 2-19 Schedule Maintenance - Field Description
Field Description Start Date - The Start Date should be between facility start date and end date.
- The start date is set to the dropline limits' line start date, but it can be changed to a future date. For a one-time schedule, it must be later than today's date.
- The start and end dates of each schedule must not overlap. If there are multiple schedules, the next one should start after the previous one ends, and its end date should be before the start of the following schedule.
- It is a mandatory field.
Is Month end When month end selected, subsequent month schedules will fall on corresponding month end dates. Duration and Unit - Duration of the schedule definition can be defined using these fields.
- Duration values in LOV - Days, Months and Years.
- The duration Units shall be captured in the Unit field.
- Validation - Based on the Duration and its Unit, the Schedule's end date will be computed.
End Date - Users can directly set the End Date instead of defining the Duration and Unit of the schedule.
- The end date must be on or before the facility's end date or before the next schedule starts, as schedules cannot overlap.
Basis The option in Basis LOV are Amount & Percentage. User shall capture any one of the value. Percentage - When Percentage is chosen in the Basis field, the user needs to input a value in the Percentage field.
- The Percentage value will be used with the Limit Amount to calculate the Schedule Limit.
Amount - If Amount is selected in Basis field, User must enter value in Amount field.
- The Amount field value will be used with the Limit Amount to calculate the Schedule Limit.
Schedule Frequency - Schedule frequency is applicable for Dropline Limit Schedule.
- The value in Schedule Frequency LOV are Daily, Weekly, Monthly, Quarterly, Half-yearly and Yearly.
- Schedule Frequency must be lesser than equal to Schedule period.
Schedule Action - The value in Schedule Action LOV are Increase, Decrease and Fixed.
- The Percentage / Amount field will be calculated with the Limit Amount on the date of the schedule, and the Schedule Limit amount will be determined.
Schedule Reset - User can enable Schedule Reset to restore the original Limit Amount after the Schedule ends; otherwise, the scheduled limit will remain until the next schedule starts or the facility expires.
- Schedule Reset is applicable for Onetime and Recurrence Schedules. Its not applicable for Dropline Schedule.
Recurrence Frequency & Unit - The limit on the schedule is based on a specific schedule definition that needs further review for updates, referred to as Recurrence Schedule – Frequency & Unit.
- The value in Recurrence Frequency are Weekly, Monthly, Quarterly, Half-yearly and Yearly.
- Recurrence Unit must be captured. Based on the number of Unit, the schedule limit will be recurred.
Schedule Limit Date & Schedule Limit Amount Based on the schedule definition, schedule Limit Date and Schedule Limit Amount will be exploded. However, these values can be modified and updated post generation which will be considered for applying on a facility. Pause Pause can be enabled if the generated schedule is not to be applied as Limit Amount. 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:- 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.
- 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:
Table 2-20 Schedule Definition
Schedule Definition Fields Modification in Schedule definition before commencement of the Schedule Start Date It can be prior or later to the existing Start date. Duration and Unit - The Schedule duration Unit value can also be modified i.e., increased or decreased, from its existing value.
- Validation - The end date of the Schedule will be calculated using the adjusted Duration and its Unit. This end date must not conflict with any other Schedules in the facility and should not go beyond the facility's end date.
End Date - The end date can modified either forward or backward from its current value. It should be greater than the system date.
- Also, it has to be before the start date of the subsequent schedule, as schedules cannot overlap.
Basis and its value in Amount / Percentage fields and Schedule Action - The existing Basis value as Amount can be modified to Percentage and vice versa.
- If the Basis value switches from 'Amount' to 'Percentage', the value in the Percentage field should be recorded, and the Amount field value must be deleted.
- The value in Amount and Percentage fields can be increased or decreased.
- The value in Schedule Action can be modified from the existing value to any one of the other two options in the LOV.
- Based on the value in Amount/Percentage field and Schedule Action, the computed Schedule Amount should not exceed the facility's Approved Amount.
Schedule Reset Schedule Reset can be modified from Enable to Disable and vice versa. 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-21 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 GEDPARAM 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-2024Table 2-22 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-23 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-2025Table 2-24 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-25 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-2024Table 2-26 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-27 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-2025Table 2-28 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-29 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-2025Table 2-30 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-31 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-2025Table 2-32 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-33 Schedules
Schedule Limit Date Schedule Limit Amount 01-Feb-2025 110,000 01-Apr-2025 100,000 System date : 18-Jan-2025Table 2-34 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-35 Schedules
Schedule Limit Date Schedule Limit Amount 20-Jan-2025 75,000 (b) Limit Amount : USD 1,00,000System date : 25-Feb-2025
Facility Start date : 10-Feb-2025
Facility End date : 31-Dec-2025
Limit Amount : USD 1,00,000
Table 2-36 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-37 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-38 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-39 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-40 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 - - - Table 2-41 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-42 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 - - Table 2-43 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-2025Table 2-44 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-45 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 System date : 19-Jan-2025Table 2-46 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-47 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-2025Table 2-48 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-49 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-2025Table 2-50 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-51 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 - Click Save to save the record.
Parent topic: Facilities Maintenance