Installing
AutoAdjust adds several new database tables to the database.
The adjustment tables have foreign key dependencies on tables in the
Transaction Server.
For this reason, the adjustment tables must be installed after the
Transaction Server tables.
The adjustment tables are used to store configuration data and the
actual adjustment data as adjustments are created by the
AutoAdjust engine.
Table 1 gives a description of each of the adjustment
tables.
Table 1. Database Table Description
| Table |
Description |
| ADJUST_ACTION_TYPE |
Defines the allowed adjustment action types
and their description |
| ADJUST_CODE_TYPE |
Defines the allowed adjustment codes and their
description |
| ADJUST_ACTION_CODE |
Defines which adjustment codes to use with an
action. Rows in this table are created and maintained by the AutoAdjust configuration
user interface. |
| ADJUSTMENT_TYPES |
Defines the grouping actions to take for an
adjustment code and customer type combination. Rows in this table
are created and maintained by the AutoAdjust configuration user interface. |
| ADJUSTMENT_ENTRY |
Holds the data for each adjustment entry. Table 2 contains a complete description of this table. |
| ADJUST_DEPOSIT_LOCK |
Allows the engine to lock a batch (ICL) so only
one thread is processing adjustments at a time. |
| SEGMENT_ADJ_XREF |
Holds the adjustment entry ID for each adjustment
made for a segment. |
Table 2 defines the columns in the ADJUSTMENT_ENTRY
table and whether they are required for each adjustment type.
Table 2. ADJUSTMENT_ENTRY
| Column |
Duplicate Bundle (DBDL) |
Reject Bundle (RBDL) |
Out of Balance Bundle (ICLD) |
Non Conforming Item (NCI) |
Transaction Balance (TXOB) |
Item Amount Difference (IAD) |
Description |
| ADJ_ENTRY_ID |
R |
R |
R |
R |
R |
R |
Auto generated ID |
| BDAY_ID |
R |
R |
R |
R |
R |
R |
The business day of the batch (ICL) |
| PRESENTMENT_ID |
R |
R |
R |
R |
R |
R |
The ID of the batch or ICL |
| SEGMENT_ID |
R |
R |
R |
R |
N |
R |
Segment to which the adjustment applies. If
there are multiple segments, it applies to the first segment in the
adjustment. |
| ADJ_CODE |
R |
R |
R |
R |
R |
R |
DBDL, RBDL, ICLD NCI, TXOB |
| GL_ADJ_REC |
R |
R |
R |
R |
R |
R |
Y if it is a GL account; N if it is not a GL
account. Based on the customer type column in Partner Profiles. |
| PROCESS_RT |
R |
R |
R |
R |
R |
R |
Routing number of the processing institution.
Populated from the destination RT in the file header record. |
| DEPOS_OR_SUSP |
R |
R |
R |
R |
R |
R |
Routing number of the originating institution.
Populated from the originator RT in the file header record. |
| ACCT_ENTRY_TYPE |
R |
R |
R |
R |
R |
R |
Debit or credit |
| ACCT_AVAIL |
R |
R |
R |
R |
|
R |
Date accounting is available |
| SENDER_TYPE |
R |
R |
R |
R |
R |
R |
For future use |
| CREATED |
R |
R |
R |
R |
R |
R |
Timestamp for when the row was created |
| ACCOUNTED |
O |
O |
O |
O |
O |
O |
Date and time the accounting entry was created
for this adjustment |
| EXTRACTED |
O |
O |
O |
O |
O |
O |
Date and time the item was extracted |
| ADJ_AMOUNT |
R |
R |
R |
R |
R |
R |
Dollar amount of entry |
| LISTED_AS_AMOUNT |
N |
N |
R |
N |
N |
O |
For out of balance adjustments, this is the
amount the segment was documented as containing. For item amount difference
adjustments, this is the original amount of the item. |
| SHOULD_BE_AMOUNT |
N |
N |
R |
N |
N |
O |
For out of balance adjustments, this is the
calculated amount of the transactions in the segment. For item amount
difference adjustments, this is the changed amount of the item. |
| BEFORE_AMOUNT |
N |
N |
N |
R |
N |
R |
The amount of the transaction before the one
being adjusted. |
| AFTER_AMOUNT |
N |
N |
N |
R |
R |
R |
The amount of the transaction after the one
being adjusted. |
| BATCH_AMOUNT |
R |
R |
R |
R |
R |
R |
The total amount of the segment being adjusted |
| GROUP_ADJ |
N |
N |
N |
O |
N |
O |
Set to 1 if this adjustment represents a group
of adjustments |
| DTF_FLAG |
N |
N |
R |
R |
N |
R |
Set to indicate documentation going to the document
to follow (DTF) archive |
| PAYMENT_ID |
N |
N |
N |
O |
N |
O |
For non-conforming transaction and item amount
difference adjustments that are not grouped; set to the ID of the
payment |
| OPER_ID |
N |
N |
N |
O |
N |
O |
ID of the Payment
Repair or Suspect Image
Review operator who reviewed
the item |
| ERROR_REF1 |
R |
R |
O |
R |
R |
R |
Error value 1: from assigned error codes |
| ERROR_REF2 |
O |
O |
O |
O |
O |
O |
Error value 2: from assigned error codes |
| ERROR_REF3 |
O |
O |
O |
O |
O |
O |
Error value 3: from assigned error codes |
| ERROR_REF4 |
O |
O |
O |
O |
O |
O |
Error value 4: from assigned error codes |
| ERROR_REF5 |
O |
O |
O |
O |
O |
O |
Error value 5: from assigned error codes |
Key:
- R: Required
- O: Optional
- N: Not Applicable
Table 3 defines the columns in the ADJUST_CODE_TYPE
table.
Table 3. ADJUST_CODE_TYPE
| Column |
Description |
| ADJ_CODE |
Adjustment code |
| DESCRIPTION |
Description of the adjustment code |
Table 4 defines the columns in the ADJUST_ACTION_TYPE
table.
Table 4. ADJUST_ACTION_TYPE
| Column |
Description |
| ADJ_ACTION |
AutoAdjust action |
| DESCRIPTION |
Description of the adjustment action |
Table 5 defines the columns in the ADJUST_ACTION_CODE
table.
Table 5. ADJUST_ACTION_CODE
| Column |
Description |
| ADJ_ACTION |
AutoAdjust action |
| ADJ_CODE |
Code to associate with the action |
The ADJUST_ACTION_CODE table is used to relate the adjustment
code to the adjustment action. The adjustment code is stored in the
ADJUSTMENT_ENTRY table in the ADJ_CODE column. The adjustment action
is the command passed to the
AutoAdjust engine to perform the requested
action.