|
Name |
Type |
Discontinued? |
|
1 |
TX_ID |
NUMERIC |
No |
|
|
|
The unique identifier for the 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 |
EXT_HX_AGENCY_ID |
NUMERIC |
No |
|
|
|
The unique ID of the collection agency record. |
|
|
4 |
EXT_HX_AGENCY_ID_COLL_AGENCY_NAME |
VARCHAR |
No |
|
|
|
The name of the collection agency. |
|
|
5 |
EXT_HX_ACTIVITY_C_NAME |
VARCHAR |
No |
|
|
|
Collection agency extract insurance amount |
May contain organization-specific values: No |
Category Entries: |
Requested Send to Agency |
Sent to Agency |
Requested Recall From Agency |
Recalled from Agency |
Returned |
Updated |
Payment Collected |
No Balance, Agency Cleared |
User Requested Send to Agency |
Users Requested Recall from Agency |
Manual Request Ignored |
Converted from Account Workqueue Framework |
Request Resulting from Repost |
|
|
6 |
EXT_HX_ACT_DATE |
DATETIME |
No |
|
|
|
Collection agency extract activity date |
|
|
7 |
EXT_HX_PAT_AMT |
NUMERIC |
No |
|
|
|
Collection agency extract patient amount. |
|
|
8 |
EXT_HX_INS_AMT |
NUMERIC |
No |
|
|
|
Collection agency extract insurance amount. |
|
|
9 |
EXT_HX_USER_ID |
VARCHAR |
No |
|
|
|
The collection agency extract user ID for the transaction record. |
|
|
10 |
EXT_HX_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
11 |
EXT_HX_COMMENT |
VARCHAR |
No |
|
|
|
Collection agency extract comment. |
|
|
12 |
EXT_HX_PMT_AMT |
NUMERIC |
No |
|
|
|
Stores the amount of a payment collected by the collection agency extract framework |
|
|
13 |
EXT_HX_RET_REASON_C_NAME |
VARCHAR |
No |
|
|
|
Stores the reason for the agency returning a transaction in the agency extract framework. |
May contain organization-specific values: Yes |
No Entries Defined |
|
|
14 |
EXT_HX_ACCT_INST_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
The extract activity instant. This value is stored as a UTC instant |
|
|