ARPB_TX_AGCY_HX

Description: |
Stores the history of the changes in the current collection agency assigned to a charge. (Not populated for agency account workqueue based assignment).

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
TX_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique identifier for the transaction record.
2 | LINE | INTEGER | No |
This line number identifies the sequence of changes in the assigned agency for a transaction.
3 | AGENCY_ID | NUMERIC | No |
Stores the collection agency to which a charge is assigned.
4 | AGENCY_ID_COLL_AGENCY_NAME | VARCHAR | No |
The name of the collection agency.
5 | SENT_DTTM | DATETIME (UTC) | No |
Stores the instant a charge was sent to a collection agency. This value is stored as a UTC instant.
6 | RETURN_DTTM | DATETIME (UTC) | No |
Stores the instant a charge returned from its assigned collection agency. This value is stored as a UTC instant.