Company Monthly Fee Schedule Changes

The mechanism to compute Monthly Fee rules has been rewritten to provide support for computations based on a Client’s LMA Start date (clientDateStarted). When no date is specified for a rule, it applies from the beginning of time.

There is a new System Permission called FeeSchedule that allows adding/editing rules.

Under System Management/Company, the rules are displayed:

 

Editing a rule:

 

When an Effective Date is specified, the rule is only used for Clients that have an LMA Start date after the effective date. The most recent rule is always used. If no rules apply for a specific state, the DEFAULT rule is used. The DEFAULT rule may also contain effective dates.

A Minimum Amount may be specified and is used when the Formula evaluates to a value lower than this amount.

Maximum Amount may be specified.

Maximum Formula is used when a conditional Maximum Amount is required.

Formula is a PHP expression where listed variables are substituted with their corresponding values.

There is a new formula parameter called campaignID that can be used to vary the monthly fee based on Lead Source.

A Note can be added to each rule. This is a good place to store the rule description or the corresponding legislation.

 

DMA Calculator:

The DMA Calculator displays Monthly Fee rules for the Client’s Company. In the example below, the LMA Payment of the Client is 04/06/2015. As a result, the FL rule with no date is used. The used rule along with its substitutions and evaluations appears under Evaluated Formula.

 

By modifying the date to 02/01/2018 in the Calculator, the more recent rule is used:

 

The Monthly Fee Schedule is Company specific. Any changes made to one Company, should be evaluated to determine if it is necessary to duplicate for another Company.

Task Creation SQL

A new optional Task field Creation SQL will only automatically create the ClientTask when the specified SQL statement returns a positive number.

The SQL statement is evaluated in the same manner as the Expire Time SQL field.

In the example below, the Task is only created when the Client’s state is Florida.

 

The string <CLIENTID> is replaced by the Client’s clientID value.

Task Default Note Update

When a value is specified for a Task’s Default Note, that text appears in the ClientTask note when it is created.

Support has been added to use Smarty syntax to provide support for conditional logic and dynamic text.

In the example below, the text “Check the Monthly Fee Annually” is only appended to a newly created ClientTask when the Client’s state is AZ.

Only the $Client Smarty Template variable is available. Available variables are listed in the DocumentTemplate section.

 

Set Drop Reason when Client is Incomplete

The following changes have been made when setting a Client Phase to Incomplete.

  • The Disposition Code and Creditor Drop Reason are hidden until the phase is changed to Incomplete
  • ClientCredit accounts with an Accepted Proposal Status are updated as follows: Proposal Status is set to Queued, Proposal Reason is set to DR (Drop), and Drop Reason is set to the option provided in the Admin tab.

Positive Pay File Updates

The logic for Positive Pay file and Void Check file creation has been refactored and unified.

Bank records have a new field: Positive Pay File Format. 

If generating Positive Pay files or Void Check files from the CMA, select one of the available formats.

 

The Actions section of the Disbursement Report now allows the selection of a Bank which determines the file format of the Positive Pay file.

 

Generating a Positive Pay file from the Disbursement report creates a File History record of type: Positive Pay.

The File History records now contain the name of the Positive Pay file that was generated.

The benefit of the new format is that a Company with multiple Banks can generate multiple Positive Pay files by selecting the appropriate Bank.

 

NSF_RETURN_CODES

Add new Setting value: NSF_RETURN_CODES

When importing ACH failures, the Return Codes listed in this Setting will generate an NSF Payment/Creditor record.

If no value is specified, the system automatically uses return codes R01, and R10.

An example value for this Setting is:

R01,R08,R09,R10

System Permissions

System Permissions enable customization of default access Groups to specific functionality within the CMA.

System Permissions are available under System Management.

In this sample view, the name of the permission is listed along with the Default Groups specified by the System. The AreaCode permission has been customized to allow access to DMAManager and DMAAdministrator Groups. When Custom Groups are provided, they override the Default Groups.

When customizing a permission, a comma delimited list of permission groups or Users are specified. Autocomplete is enabled in the fields, which allows typing of the Group or User names.

If Allowed Users are specified, the listed Users have access to the permission. This is in addition to the Default/Custom Groups.

Likewise, a list of Excluded Users indicates which Users will not have access to the permission.

To remove a customization, apply the Delete it.

Creating Custom User Groups

Custom User Groups may be created in the System Codes table.

To add a custom Group, create a new Record, with a Table value of UserGroupLink, a Field value of userGroupLinkGroup, and a numeric Value. It is recommended that Custom Groups begin with a value of 900 to differentiate them from System Groups.

An example of a new User Group called, Super Users.

This new Group may now be assigned to Users and used as a Custom Group under System Permissions.

 

A view of available Groups when editing a User.

 

The combination of System Permissions and User Groups allows customization to access within the CMA.

NSF Creditors

In order to facilitate the automatic creation of an NSF Creditor record for a Client whose ACH payment fails, the following changes have been made:

  • Client/Creditor tab now displays balances for Contributors when the balance > 0.
    Since Monthly Fee Creditors do not have a balance, none will be shown for existing accounts.
  • My DMA Tasks now has a Creditor name filter. This facilitates filtering for all Payoff Tasks associated with a specific Creditor.
  • The daily Payoff Task job will now generate a Task for Contributors with a positive clientCreditBalance.
  • Added a new Setting field: NSF_CREDITORID. If a value exists for this field, importing ACH failures will add this Creditor to the Client record instead of creating an NSF Payment record.

Merging a TransUnion Credit Report

When pulling a TransUnion Credit Report, a Merge screen is presented prior to importing the account information.

A set of buckets where accounts can be dragged and dropped are presented:

  • Existing Accounts
  • Add Credit Report Accounts
  • Not In Program
  • Do not Import

If a Credit Report account number matches an existing account, the Credit Report’s account is merged with the existing account and relevant information is updated for the existing account.

Accounts that have remarks indicating CLOsed or INActive are automatically placed in the Do Not Import Bucket.

Example:

CSP Tier Validation

Prior to sending Paperwork in the LMA, if a CSP Tier has been selected for at least one ClientCredit account, validation is performed to ensure that the correct Tier has been selected. If a Tier mismatch occurs, an error message is displayed indicating the Tier that must be selected.

This is useful if information is modified after selecting a CSP Tier.

ClientCredit Closed Reason

There is a new field clientCreditClosedReason.

Default options are:

  • Not In Program
  • Paid in Full
  • Client Removed
  • Creditor Removed
  • Non Participating Creditor
  • Insufficient Information

Additional values can be added under System Management/System Codes

When Closing a ClientCredit record, a reason can be provided.

In the LMA, when an account is not included in the program, the Close reason is automatically set to: Not In Program.

When importing a TransUnion CreditReport and selecting to import an account under the Not In Program bucket, the Close reason is also updated.

The DMA Creditors tab shows NOT IN PROGRAM under the Acct Status column of Closed accounts with that reason.

The Phase TimeLine and Manager Report do not include accounts with a reason of Not In Program when computing Total Creditors per Client.

New Setting: NSF_FEES_BY_STATE

There is a new Setting key: NSF_FEES_BY_STATE.

When a value is provided, it overrides the default NSF Fees when importing failed ACH payments. When blank, the system defaults are used.

Example values:

AZ:0,PA:25,WA:20

 

TransUnion Credit Report Pull

The ability to import Credit Reports along with a Credit Score via the TransUnion API has been added.

A new action, Pull Credit Report is displayed in the LMA / Creditors tab for members of LMAAdministrator and DMAAdministrator.

Pulling the Credit Report via API performs the following functions:

  • saves the TransUnion XML response string as a new ClientDoc.
  • updates the Client’s Credit Score
  • Adds ClientCredit records for all accounts that do not have a remarks of CLOsed or INActive. Accounts with a balance of $0 are imported with an account status of CLOSED

 

Account setup with TransUnion is required prior to using the feature.

Projected Months automatically updated for Leads

In order for the NH Monthly Fee to be correctly computed, the estimated program term in months must be set for Leads. Previously, Projected Months was manually set by the user.

Projected Months is now automatically set whenever a ClientCredit record is updated for a Lead in the LMA. This value will now match estimated program lengths displayed on the Contracts.

DMP Monthly Fee projectedMonths parameter for NH

In order to comply with the NH DMP Monthly Fee rule, a new Monthly Fee Schedule parameter, projectedMonths, has been added.

This value is set in the Client / Admin tab and should be manually entered for all NH Clients.

 

Per: http://gencourt.state.nh.us/rsa/html/XXXVI/399-D/399-D-15.htm

V. The licensee’s fees shall be based on the total indebtedness as stated in the contract and shall not exceed:
(a) 10 percent when the plan of payment is for a period of 10 months or less; or
(b) 12 1/2 percent when the plan of payment is for a period of more than 10 months but less than 18 months; or
(c) 15 percent when the plan of payment is for a period of 18 months or more.

The following formula can be used for the NH Monthly Fee schedule:

NH:MIN:0,MAX:60,FORMULA:projectedMonths <= 10 ? payment*0.10 : (projectedMonths < 18 ? payment*0.125 : payment*.15)

The ternary operators “? :” are used to specify conditional logic and the formula can be read as this:

if projectedMonths <= 10 then use 10% of payment, else  if projectedMonths < 18  use 12.5% of payment, else use 15% of payment

The DMP Fee calculator now includes a Projected Months field.

 

Extranet Contact Information

Step1 of the Extranet now displays the Client Date of Birth when showing the SSN.

CoApps information is also displayed but not required.

 

Using the Settings tab, Clients can now update their address information and and phone numbers.

 

 

 

 

 

Custom Report Filters

CMA Reports/Views that have more than 4 filters allow you to save the current filters so that they can be recalled at another time.

 

To save the current filters, click on the Select a Custom Filter drop down and select Save current settings as a new Filter.

An input box appears to name the filter. Click on Save

To remove an existing custom filter, select the filter and click on Delete.

 

To rename a filter, delete the existing filter and then add a new one with the current settings.

Report Filters are specific to individual User accounts.