Rules

Rules are actions which are configured to occur on any and all loans in the system if and when those loans meet a certain criteria defined by the setup of the rules.

When setting up a rule, a specific To Do action is defined. The point in time at which that action is to take place is defined by the NLS Event for that action. For some combinations of To Do and Event, a Frequency may be specified. A Condition, which determines if the action should be performed at all on the loan in question, can also be set. Finally, the Rule Setup is completed by giving the rule a name.

Rules need not be assigned to loans, loan groups, or portfolios because all rules are in effect across the entire database. For this reason, it is important that the condition be sufficiently restrictive to make sure that the rule will not execute in any cases where it is not intended.

To add a new rule, go to Setup > Loan Setup > Rules. Click Add Add to open the Rules wizard.

To Do

You will first be required to select from a list of To Do items.


To Do Description
Abort Operation Click Abort in the lower pane of the Rules window to bring up a dialog for entering the message that will be displayed when the operation is aborted. The operation to be aborted is either the addition of a transaction, a contact, or a loan, and this will be determined by the NLS Event associated with the rule.
Change Loan Status Click loan status in the lower pane of the Rules window to bring up a dialog for selecting which status code to add to the loan. If the Remove Status Code checkbox is selected, the status code in question will be removed from the loan if it is currently on the loan.
Close Loan This To Do operation will close the loan. This will be accomplished by executing a payment for the amount of $0.00 with the payoff flag selected and setting the Loan Status to Closed.
Click loan in the lower pane of the Rules window to bring up a dialog for selecting the IRS write off event code.5.35+
Execute Transaction Code Click transaction code in the lower pane of the Rules window to bring up a dialog with a drop down list for selecting which transaction code to run. A further step in the wizard will allow you to select the amount for which to run that transaction code.
If the selected transaction code is configured to trigger an IRS event code, an option to select the IRS writeoff event code will appear.5.35+
Pull a Credit Report Click credit report in the lower pane of the Rules window to bring up a dialog for selecting which bureau(s) to pull the report(s) from and if an existing report should be used if it has been pulled recently.
Send Notification Click notification in the lower pane of the Rules window to bring up a dialog for entering the message to be sent in the notification, and to which user and or group that notification should be sent.
When multiple users are selected to receive the notification, a single notification record is created for multiple users instead of individual notification records for each user.5.37+
Run Script Click script in the lower pane of the Rules window for entering a script to be executed. See scripting for more details.
Execute Loan Approval Click loan approval in the lower pane of the Rules window to bring up a dialog for entering the user or group to which to assign this task. The Loan Status will be set to DRAFT until the loan is approved.
Override commitment distribution order Click commitment distribution order in the lower pane of the Rules window to bring up a dialog for configuring the distribution percentage based on the principal balance ratio of the selected loan groups or to use a specific percentage. When specifying a specific ratio, the sum of the ratios must be 100.

NLS Event

Without exception, after selecting a To Do, the next step in the Rules setup process is to select the NLS Event that determines at which precise point this action is to take place. However, the list of possible Events that are appropriate to each To Do is different (although overlapping). The events themselves are self explanatory. The table below will list which NLS events are applicable to each To Do.

To Do NLS Event
Abort Operation
(Defines when and what to abort)
Pre-payment
After contact is added but before committed to database
After loan is added but before committed to database
After loan is updated but before committed to database
After loan is updated and committed
After task is added but before committed to database
Change Loan Status Post-accrual
Post-payment
Pre-transaction
Post-transaction
After payment reversal
After loan is added but before committed to database
After loan is added and committed
After transaction is added
After loan is updated but before committed to database
After loan is updated and committed
Close Loan Pre-accrual
Post-accrual
Post-payment
Execute Transaction Code Pre-accrual
Post-accrual
Post-payment
Pre-transaction
Post-transaction
After payment reversal
After loan is added and committed
After loan status change
Pull a Credit Report Pre-accrual
Post-accrual
Pre-payment
Post-payment
Pre-transaction
Post-transaction
After contact is added and committed
5.7.4+ After contact is updated and committed.
After loan is added but before committed to database
After loan is added and committed
After loan status change
After loan is updated but before committed to database
After loan is updated and committed
Send Notification Pre-accrual
Post-accrual
Pre-payment
Post-payment
Pre-transaction
Post-transaction
After payment reversal
After contact is added but before committed to database
After contact is added and committed
5.7.4+ After contact is updated and committed
After loan is added but before committed to database
After loan is added and committed
After loan status change
After loan is updated but before committed to database
After loan is updated and committed
Before closing NLS
After task is added but before committed to database
After task is added and committed
4.9.3+ After task is updated but before committed to database
4.9.3+ After task is updated and committed
Run Script Pre-payment
Post-payment
Pre-transaction
Post-transaction
After payment reversal
After contact is added but before committed to database
After contact is added and committed
5.7.4+ After contact is updated and committed
After loan is added but before committed to database
After loan is added and committed
After loan status change
After loan is updated but before committed to database
After loan is updated and committed
Before closing NLS
After task is added but before committed to database
After task is added and committed
4.9.3+ After task is updated but before committed to database
4.9.3+ After task is updated and committed
Post batch accrual
  After ACH is created. %ACH_FILE is the full path.
5.27+ Before manual Card payment is processed

Triggered when the Process button is clicked in the manual card payment entry dialog.

Relevant Variables Used in the Script
  
NLS_TRANSACTION_TYPE

Either “borrower present” or “borrower not present” depending on the value of the dialog's corresponding checkbox.

NLS_TRANSACTION_AMOUNT

The amount the user enters in the Amount field, not the Total field.

NLS_ACTIVE_ACCTREFNO

 

Calling nlsapp.Break in the script will cancel the transaction before it is sent to and processed by the payment gateway.
Execute Loan Approval After loan modify
Before loan is added
After transaction is added
Override commitment distribution order Loan:Where loan portfolio is assigned to specific values
Loan:Where loan group is assigned to specific values
Transaction:Transaction is a payment
Transaction:Transaction is a principal advance
Transaction:Transaction is a payment reversal
Transaction:Transaction is a NSF reversal
Transaction:Transaction is a principal reduction
Transaction:Transaction is interest adjustment
Transaction:Transaction is any manual transaction code
Advanced:Where SQL Statement return at least 1 row
Advanced:Where the Event is triggered by GUI (Graphical User Interface)
Advanced:Where the Event is NOT triggered by GUI (Graphical User Interface)

Frequency

Certain combinations of a To Do and an NLS Event involve events (such as the accrual) which occur every day, and it may not be desired that the condition be checked to determine if the To Do should be executed quite this often. Therefore, some combinations allow an optional setting of Frequency. If no Frequency is set, it is assumed to be daily. Frequency options which may be otherwise set are Weekly and Monthly.

If Weekly is selected, clicking Weekly in the lower pane will bring up a dialog box for the selection of a day of the week.

If Monthly is selected, clicking Monthly in the lower pane will bring up a dialog box for the selection of which months the To Do is to be executed. Additionally, a specific day of each month may be selected. Lastly a specific day of the week may be selected along with the Ordinal: First, Second, Third, Fourth, or Last. This allows for the selection of a single day of each month which will be a constant day of the week.

The following table lists all of the combinations of To Do and NLS Event for which a frequency of Weekly or Monthly may be selected.

To Do NLS Event
Close Loan Pre-accrual
Post-accrual
Execute Transaction Code Pre-accrual
Post-accrual

Condition

The Condition portion of a rule setup defines the situations under which the rule should or should not execute. The condition may be defined based on values in the contact that the loan is under, values in the loan account itself, or based on an advanced trigger, as defined in the table below.

Condition Type Available Conditions
Contact Contact Type is assigned to specific values
Entity is assigned to specific values
where setup date is in this date range
where city is located in this location
where state is located in this location
where zip code is in this range
where date of birth(1) is in this date range
where date of birth(2) is in this date range
Loan where interest method changed
where loan portfolio is assigned to specific values
where loan group is assigned to specific values
where loan type is assigned to specific values
5.7.3+ where loan class 1 is assigned to specific values
5.7.3+ where loan class 2 is assigned to specific values
where primary loan status (Loan Status) is assigned to specific values
where secondary loan status (Status Codes) is assigned to specific values
5.38+ where secondary loan status (Status Code) name is added
5.38+ where secondary loan status (Status Code) name is removed
where setup date is in this date range
where open date is in this date range
where maturity date is in this date range
where current principal balance is in this range
where current interest balance is in this range
where current deferred interest balance is in this range
where current fees balance is in this range
where current late charge balance is in this range
where current UDF(1–10) balance is in this range
where current payoff balance is in this range
where days past due is in this range
5.20+ where days past due (adjusted for deferment) is in this range
where past due amount is in this range
where current due amount is in this range
where interest-accrued-thru-date is in this date range
Advanced where SQL statement returns at least 1 row
where the Event is triggered by GUI (Graphical User Interface)
  where the Event is NOT triggered by GUI
5.21+ do not execute on a weekend, advance to next business day
5.21+ do not execute on a US Holiday
5.31+ do not execute on a US Federal Reserve Holiday
5.21+ do not execute on a NYSE Holiday
5.21+ do not execute on a UK Holiday
5.21+ do not execute on a Mexico Holiday
5.21+ do not execute on a Canada Holiday
5.21+ do not execute on an Alberta Holiday
5.21+ do not execute on a British Columbia Holiday
5.21+ do not execute on a Manitoba Holiday
5.21+ do not execute on a New Brunswick Holiday
5.21+ do not execute on a New Foundland & Labrador Holiday
5.21+ do not execute on a Northwest Territories Holiday
5.21+ do not execute on a Nova Scotia Holiday
5.21+ do not execute on a Nunavut Holiday
5.21+ do not execute on an Ontario Holiday
5.21+ do not execute on a Prince Edward Island Holiday
5.21+ do not execute on a Quebec Holiday
5.21+ do not execute on a Saskatchewan Holiday
5.21+ do not execute on a Yukon Holiday

Conditions specifying a date range is configured by clicking on the in this date range link.

Conditions can be set to match either before of after the specified date.

ConditionDescription
Use actual dateThe exact date as specified.
Use current dateDelta from the date of the rule’s creation.

Example

If the date is January 15th, +2 days will use January 17th as the criteria, -2 days will use January 13th as the criteria.
Use this dateDelta from the date on which the rule is applied.

Finish Rule Setup

When the event, frequency, and condition have been defined, and any required parameters for the condition have been configured, click Next> to finalize the rule setup. The rule will be defined on the interface, and to finish the configuration, the only remaining requirement is to give the rule a name.


Click Finish to complete the rule setup.