PB_DTL_TX_AR_STAT_HX

Description: |
The Status History table contains a history of each time the transaction's status has changed.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TRANSACTION_ID | VARCHAR | No |
The unique identifier for the detail transaction record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | AR_STATUS_CHANGE_UTC_DTTM | DATETIME (UTC) | No |
The instant of the status change.
4 | AR_SYSTEM_UPDATED_STATUS_YN | VARCHAR | No |
Whether the status change occurred automatically by the system (yes or no).
May contain organization-specific values: No
Category Entries:
No
Yes
5 | AR_TX_STATUS_C_NAME | VARCHAR | No |
The status that the transaction was changed to.
May contain organization-specific values: No
Category Entries:
New
Waiting to file
Filing
In Review
Filed
Voided