Feedback

  • Contents
 

Task List

The following table lists the standard tasks that release with Latitude.

Task

Description

Build Custom Queues

Rebuilds custom queues as defined in the CustomQueue table. Calls stored procedure CustomQueue_BuildQueues.

Calculate Interest

Calculates interest accrued on accounts. Calls stored procedure spInterest_Update.

Clean Invalid Socials

Removes invalid social security numbers from the master and debtor tables. Calls stored procedure spCleanInvalidSocials.

Clear Daily Contacted

Removes old or erroneous records from the Daily_Account_Contacted table. Calls stored procedure spClearDailyContacted.

Clear Licenses

Removes old or erroneous records from the User License table. Calls stored procedure spClearLicenses.

Clear Old Account Contacts

Removes old account contact records from the AccountContacts table. Calls stored procedure spClearOldAccountContacts.

Clear Old Desk Stats

Removes old desk status records from the DeskStats table. Calls stored procedure spClearOldDeskStats.

Create NITD for Post Dated Checks

Creates Notice of Intent to Deposit (NITD) letter requests for post-dated checks (PDCs). Calls stored procedure spCreateNitdLetterFromPostDatedChecks.

Create NITD for Post Dated Credit Cards

Creates Notice of Intent to Deposit (NITD) letter requests for post-dated credit cards (PCCs). Calls stored procedure spCreateNitdLetterFromPostDatedCreditCards.

Debtor Credit Bureau Compile

Issues a recompile before calling the bulk Credit Bureau Reporting evaluation process to improve performance. Calls stored procedure sp_recompile cbrevaluatebulk_nocursor.

Debtor Credit Bureau Compile2

Issues a recompile after calling the bulk Credit Bureau Reporting evaluation process to improve performance. Calls stored procedure sp_recompile cbrevaluatebulk_nocursor.

Debtor Credit Bureau Evaluation

Evaluates accounts against Credit Bureau Reporting Console configuration to determine whether to report the accounts to the credit bureaus. Calls stored procedure cbrEvaluate.

Debtor Credit Bureau Force Deletes By Status

Sets the special note for accounts with a closed status that never reported previously so that the system doesn't include the accounts in the report to credit bureaus. Calls stored procedure cbrForceDeletesByStatus.

Debtor Credit Bureau Force Disputes by Status

Evaluates disputed accounts as follows:

  • If the disputed accounts didn't report to the credit bureaus as disputed previously, the stored procedure sets the compliance condition on the pending table to include the code in the next report to the credit bureaus.

  • If the disputed accounts reported to the credit bureaus as disputed previously and have since reported as deleted, the stored procedure sets the compliance condition on the pending table to exclude the code in subsequent reports to the credit bureaus.

Run this task after running the Debtor Credit Bureau Evaluation task. Calls stored procedure cbrForceDisputesByStatus.

Debtor Credit Bureau Reset CbrPrevent

Resets the flag for evaluating disputed accounts. Run this task before running the Debtor Credit Bureau Evaluation task. Calls stored procedure cbrResetCbrPrevent.

Evaluate Arrangements

Evaluates payment arrangements as follows:

  • If a non-linked account is in queue level 998 or 999, the stored procedure places the account's PCCs, PDCs, and promises on hold.

  • If an account has pending post-dated credit cards or checks, the stored procedure updates the queue level and status accordingly.

Calls stored procedure EvaluateArrangements.

Note: To turn off this feature, set the PaymentOnHold parameter to "off."

Evaluate Promises

Evaluates accounts to determine whether the debtor kept or broke the promise and updates the queue level and status accordingly. Calls stored procedure spEvaluatePromises.

Evaluate Qlevel

Evaluates the queue level and "should queue" flag on accounts and updates accounts accordingly. Calls stored procedure spEvaluateQLevelShouldQueue.

Interest Deferral and Settlement Options

Sets reminders and letters for accounts configured to defer interest, hold settlement arrangements, or both.  Also used to reset interest and settlement amounts using grace periods and expirations. Calls stored procedure spInterestDeferralAndSettlementOptions.

Notify End of Day Finished

Sends a notification email that Custodian has finished processing. Attaches log files when requested.

Parse Debtor Names

Occurs once on each debtor record. Uses NetGender utility to place the first and last names into the proper column. Calls stored procedure Debtors_ParseNames.

Purge User History

Purges user history records older than a specific number of days. If a client didn’t specify the days through a parameter in Custodian Editor, Custodian uses the default limit of 90 days. Calls stored procedure spPurgeUserHistory.

Request Letter Series Letters

Creates letter requests for letter series. Calls stored procedure LetterSeries_InsertlLetterRequests.

Schedule Accounts

Sets up night queues, custom queues, new business, NSFs, and broken promises. Assigns the appropriate queue level to accounts based on age. Calls stored procedure spScheduleAccounts.

Schedule Broken Promises Letters

Creates letter requests for accounts with promises due on the current date that the debtor broke.  Not in use for most agencies. Calls stored procedure spScheduleBrokenPromiseLetters.

Schedule Letter Series Letters

Creates letter requests for the letters specified in a letter series. Calls stored procedure spScheduleLetterSeriesLetters.

Schedule New Business

Sets new business accounts for the number of days indicated for the assigned desk to work accounts as new. Calls stored procedure spScheduleNewBusiness.

Schedule Reminder Letters

Creates letter requests for accounts with promises due the indicated number of days (promise days) from the current date. Calls stored procedure spScheduleReminderLetters.

Send Letters to Vendor V7

For Latitude 7 and earlier only.

Creates letter request files in the specified directory for vendor letters that have the Vendor Letter check box selected in Letter Console.

To use this task, click the ellipsis next to the Filename box and click the directory to write the file to.

Send Letters to Vendor V8

For Latitude 8 and later only.

Create letter request files in the specified directory for vendor letters that have the Vendor Letter check box selected in Letter Console.

Disable this task and create a SQL task that calls “c:\collect2000\LetterFileWriter.exe.”

Set Inactive Closed PostDates On Hold

Deactivates PCCs, PDCs, and promises for accounts in queue level 998 or 999 for arrangements that apply to non-linked accounts only. Calls stored procedure spSetInactiveClosedPostDatesOnHold.

Update Control File

Sets the date in the control file. Calls stored procedure spUpdateControlfileEOD.