Batch Transaction Import Review

The Batch Transaction Import Review screen enables the ability to view all transactions that have been imported into the Recovery Module during the batch transaction import process that have not been processed due to issues such as missing or incorrect account numbers, payments exceeding the amount of the account, and missing transaction codes. From this screen, users are able to easily review each transaction, resolve any issues, and process or exclude transactions from a batch import profile.

For example, if a transaction is imported in batch and found to have a missing account number during Pre-Processing, the transaction is transferred to staging for review. The transaction is then displayed on this screen, where it can be manually reviewed and the issue resolved before the transaction is committed to a Recovery account.

To access this screen, navigate to System Management > Recovery > Batch Transaction Import Review.

In order to access this screen and process transactions, the Batch Transaction Import Review permission must be set to Change for the User and/or Security Group. This permission appears in the System Management - Recovery category of the Permissions tab in System Management > Users and System Management > Groups > Security Groups.

This screen contains the following functionality to review and manage batch transaction import profiles:

Show Grid

The grid within the Batch Transaction Import Review screen displays the following columns of information for each transaction that must be reviewed:

The Transactions grid displays records in groups of 200 per page. By default, this grid lists all records with a status of Unprocessed that are within one month of the transaction’s posting date and are sorted in ascending order by Posting Date. Users are able to refine the results displayed in the grid by modifying the date range or filtering the transactions by status.

Column

Description

Process Check box

Provides the ability to select or deselect a transaction to process. Selecting this check box enables the

button.

Import Id

Displays the identification number assigned to the transaction when it was imported.

Status

Displays the current status of the imported transaction. The following status types may be displayed:

Processed - Displayed when an imported transaction has been processed successfully and removed from the batch.
Unprocessed - Displayed when an imported transaction has not been processed.
Excluded - Displayed when a transaction import has been removed from a batch.

By default, Unprocessed transactions are displayed.

Status Date

Displays the date and time that the most recent status was assigned to the transaction.

Posting Date

Displays the date and time that the transaction was imported into the Lifecycle Management Suite.

Profile Name

Displays the name of the Batch Transaction Import profile that is associated with the transaction.

Identifier Type

Displays the identifier type used to match the inbound transaction to a corresponding batch within the Recovery module.

Identifier

Displays the number associated with the Identifier Type.

Overridden Identifier Check box

If selected, indicates whether the identifier has been overridden within the Import Record tab in System Management > Recovery > Batch Transaction Import. This is a read-only check box.

Transaction Code

Displays the mapped transaction code based on the inbound mapping or the text that was included in the batch file prior to import.

Payment Amount

Displays the gross payment amount of the transaction.

Fee Transaction Code

Displays the mapped fee transaction code based on the inbound mapping or the text that was included in the batch file prior to import.

Fee Amount

Displays the amount of the fee identified within the Fees tab at import.

Reference Number

Displays the reference number associated with the transaction.

Description

Displays the description associated with the transaction.

Exception(s) Check box

If selected, indicates that an error has occurred within the record. This is a read-only check box.

Show Filters

By default, the Transactions grid displays all Unprocessed records from one month prior to today's date, based on the transaction's posting date. However, users are able to refine the results displayed in the grid by modifying the date range or filtering the transactions by status.

To filter the transactions according to Status, select the View drop-down. Transactions can be sorted by All, Unprocessed, Processed, Excluded, or Exception. Once an option is selected, the view automatically refreshes.

The Exception view displays any Processed, Unprocessed, or Excluded transactions that have missing or incorrect account numbers, payments that exceed the amount of the account, missing transaction codes, or other issues that must be reviewed and modified before the transaction can be submitted to the transaction processing engine.

The date range can be adjusted by using one of the following methods:

Click the or buttons to change the date in one-month increments.
Click within the To and From fields to manually enter dates.
Click the calendar icons to open a calendar tool, which enables the ability to select the desired dates.
Click To to access a drop-down menu which contains pre-configured lengths of time, including:
- Today
- Yesterday
- Last 10 Days
- Last 30 Days
- Last 60 Days
- This Week
- This Month
- This Quarter
- This Year
- Last Week
- Last Month
- Last Quarter
- Last Year

After the desired filter has been applied, click to update the grid.

Show Buttons

In addition to filtering tools, the toolbar at the top of the page includes the following buttons to process and manage the transactions that require review:

Button	Description
	Click this button to process an individual transaction. For more information on processing transactions, see the Processing Transactions section of this topic.
	Click this button to process all transactions displayed according to the filters. For more information on processing all transactions, see the Processing Transactions section of this topic.
	Click this button to modify an existing transaction. This functionality enables the ability to review exclusions and edit batch transaction import data before it is processed. For more information on editing transactions, see the Editing Transactions section of this topic.
	Click this button to exclude an existing transaction. This functionality enables the ability to omit a transaction from batch processing. For more information on excluding transactions, see the Excluding Transactions section of this topic.
	Click this button to turn the automatic refresh of the batch status on or off. By default, this button shows the date and time of the last completed batch automatically every 8 seconds.

Edit Transaction Import Attributes

The Edit Transaction Import window contains two tabs which provide the ability to make any necessary changes to the import record.

Import Record Tab

There are five sections within the Import Record Tab of the Edit Transaction Import screen:

Transaction Import Status
Transaction Import Exceptions
Transaction Import Identifier
Transaction Import
Transaction Import Fee Included From File

If a transaction has an Import Status of Processed, the information displayed within the Import Record tab is read-only and cannot be changed.

Transaction Import Status

The Transaction Import Status section is read-only and displays the following information for the transaction:

Field	Description
Import Status	Displays the current status of the imported transaction. The following status types may be displayed: Processed - Displayed when an imported transaction has been processed successfully and removed from the batch. Unprocessed - Displayed when an imported transaction has not been processed. Excluded - Displayed when a transaction import has been removed from a batch.
Modified By	Displays the name of the last user who modified the transaction record.
Transaction Import Id	Displays the identification number assigned to the transaction when it was imported.
Status Date	Displays the date that the last status was assigned.
Modified Date	Displays the date that the transaction was last modified.
Profile Name	Displays the name of the profile associated with the transaction.

Transaction Import Exceptions

The Transaction Import Exceptions section contains a grid that displays information regarding any exceptions for the transaction record in context. This grid only populates with information when the transaction record includes an exception that occurred during transaction processing.

The grid within this section displays the following columns of information for each exception found:

Column

Description

Level

Displays the level of the exception. The following exception levels may be displayed:

Level	Action	Description
0	Enforcement Action	Critical exceptions that do not allow a transaction to be processed.
1	Verification Action	Warning exceptions that do not allow a transaction to be processed unless the transaction is manually processed from the Edit Transaction Import window.
2	Advisory Action	Informational exceptions that do not stop the transaction from being processed in the Batch Transaction Import Review screen.

Message

Displays the informational or error message associated with the exception.

Date

Displays the date that the message was first returned.

Error Id

Displays the identification number assigned to the error if it is logged in the Error Log.

Transaction Import Identifier

Depending upon Identifier Type configured in the import profile, this section displays the Account Identifier, Account Number and Loan Number, Docket Number, or the Repayment Plan Id. This first field is read-only and cannot be changed.

The Override Identifier textbox allows a user to assign an identifier if the existing identifier is considered invalid.

Transaction Import

The Transaction Import section provides the ability to review and modify the following information for the import record:

The values within the Transaction Import section default to the values included within the transaction record at the time of import; these values can be adjusted as desired.

Field	Description
Effective Date	Enter the date in which the transaction is to be effective. This field defaults to This cannot be a future date.
Code	Select an option from the drop-down list to identify the transaction code for the import record. The drop-down is populated by the active transaction codes defined in System Management > Recovery > Transaction Codes.
Default Used	If selected, identifies that the default transaction code was used for the transaction. This is a read-only check box.
Posting Date	Enter the date on which the transaction was posted. This is a required field.
Credit Amount	Displays the credit amount of the transaction. This field only displays if there is a credit on the record.
Debit Amount	Displays the debit amount of the transaction. This field only displays if there is a debit on the record.
Keyword	Displays the keyword included in the file that was used to map the transaction code. This field only displays if there was a keyword specified for the import record within the Mappings tab in System Management > Recovery > Batch Transaction Import.

Transaction Import Fee Included From File

The Transaction Import Fee Included From File section only displays if there was a fee specified for the import record within the Fees tab in System Management > Recovery > Batch Transaction Import.

The values within the Transaction Import Fee Included from File section default to the values included within the transaction record at the time of import; these values can be adjusted as desired.

This section displays the following information for the import record:

Field	Description
Fee Code	Displays the Fee Transaction Code configured in System Management > Recovery > Batch Transaction Import. This is a read-only field.
Percent	Displays the fee percentage amount if one is specified in System Management > Recovery > Batch Transaction Import. This is an editable field.
Amount	Displays the fee amount if one is specified in System Management > Recovery > Batch Transaction Import. This is an editable field.

If a Fee is included in the transaction import record, both the Percent and Amount fields are displayed and editable, though only one will be populated.

Source Record Tab

The Source Record tab provides a historical overview of the imported transaction record so that it can be compared and audited for any necessary changes.

This tab is read-only and displays the following information for the transaction:

Some fields may be excluded depending on the configuration of the import record.

Record Name	Description
Transaction Import Id	Displays the Transaction Id generated by the transaction. This field is only populated once a record has been processed.
Account Identifier	Displays the Account Identifier included in the transaction import file.
Account Number	Displays the Account Number included in the transaction import file.
Loan Number	Displays the Loan Number included in the transaction import file.
Account Type	Displays the Account Type included in the transaction import file.
Repayment Plan Id	Displays the Repayment Plan Id included in the transaction import file.
Docket Number	Displays the Docket Number included in the transaction import file.
Effective Date	Displays the Effective Date of the transaction included in the transaction import file.
Posting Date	Displays the date the transaction was posted.
Transaction Keyword	Displays the Transaction Keyword included in the transaction import file.
Created Date	Displays the date that the record was created.

Other Tabs

Additional tabs may also appear within the Edit Transaction Import screen depending on different properties of a transaction record, such as the status of the record or whether or not a fee is included.

Reference the table below for an overview of the tabs that are conditionally displayed within the Edit Transaction Import screen:

Tab	Description	Example
Transaction Record	Displays when the transaction has been processed. The data within this tab may be used to verify the transaction import. The Transaction Record tab contains the following fields based on the transaction configuration when it was imported into the Lifecycle Management Suite: Transaction Id Posting Date Effective Date Amount Transaction Code Prompt to Repayment Plan Reverses Transaction Created By Created Date Reference Number Description Received From
Fee Record	Displays when a fee is generated for a transaction import record. This tab contains the same fields as the Transaction Record tab in reference to the fee being charged.
Profile Snapshot	Displays information regarding the state of the Transaction Import Profile when the record was processed, in the event that any changes have occurred since then. This information is useful in assessing the history of a transaction and determining why a transaction is processed in a certain way. The fields contained within this tab reflect the information configured in System Management > Recovery > Batch Transaction Import.
Batch Record	Displays after a record has been processed. This tab includes information about the batch that was used to process the transaction record.

Actions

The following actions can be performed to process and manage transactions within the Batch Transaction Import Review page:

Editing Transactions
- Excluding Transactions
- Including Transactions
- Processing Transactions
Processing Transactions
Excluding Transactions

At the start of processing, the transaction processing engine places a lock on the transaction currently in process. This lock ensures that only one recovery batch import is processed at a time, mitigating the possibility of corrupt transaction data. If a transaction is currently in process and a user attempts to process another transaction, a "transaction in process" message is displayed indicating that the second transaction cannot be processed until the current transaction has completed processing.

Processing a transaction only takes a few seconds.

If a transaction on a repayment plan is being processed and the repayment plan consists of more than one recovery account, a lock is placed on the entire repayment plan.

Editing Transactions

The Edit Transaction Import window enables administrators to modify an existing transaction. To edit a transaction, double-click or highlight the transaction and click .

If a transaction is in an active batch record, a message displays indicating that the transaction cannot be edited.

Show Excluding Transactions

The Exclude function enables administrators to remove the transaction from the batch import profile. The button is only displayed for Unprocessed transactions and transactions with Exceptions, and is disabled for Processed transactions.

Click .
A confirmation message appears. Click Yes to exclude the transaction or No to cancel and return to the Edit window.

Transactions are only excluded, never deleted.

Show Including Transactions

The Include function allows administrators to add an excluded transaction into the batch import profile. The button is only displayed for Excluded transactions.

Click .
A confirmation message appears. Click Yes include the transaction or No to cancel and return to the Edit window.

Show Processing Transactions

To process a transaction:

Click .
A confirmation message appears. Click Yes to process the transaction and bypass all non-critical exceptions found. Click No to cancel and return to the Edit window.
If the transaction is successful, the Edit window closes and the transaction status automatically updates. If the transaction is unsuccessful, an error is received directing the user to review the Transaction Import Exceptions before processing the transaction. Click Close to close the exception error and automatically refresh the Edit window to display details for the exception within the Transaction Import Exceptions grid.

Once changes have been made, click to retain the new transaction profile and return to the Batch Transaction Import Review screen. When clicking , pre-processing is also run on the record to verify that no other errors exist.

Processing Transactions

The Batch Transaction Import Review screen enables administrators to process transactions that have not already been processed, are not excluded, and do not have exceptions.

Select one or more transactions listed in the transactions grid. Click to process the chosen transactions or click to process all transactions simultaneously.
A confirmation message appears; click Yes to proceed with the process or No to cancel the process and return to the transactions grid.
If the process is successful, the will display the current status of the batch in process.
- If the process is still running, the button will indicate that a process is running.
- Once processing is complete, the button will update with today's date and the time that the last batch was completed.

Transactions might be processed in batch based on the amount of transactions that are required to be processed.

If an exception is returned during processing, the exception for the transaction is updated and displayed within the Transaction Import Exceptions grid so that it can be resolved. If the transaction has already been processed, the processing engine ignores the record.

Please see the Batch Transaction Import Process section for more information.

Excluding Transactions

The Exclude function enables administrators to exclude a checked transaction. To exclude a transaction:

Highlight the profile and click .
A confirmation message appears. Click Yes to exclude or No to return to the Batch Transaction Import Review screen without excluding the transaction.

Once a transaction is excluded, changes cannot be made to the record until the record is included again.