|
Name |
Type |
Discontinued? |
|
1 |
HSP_ACCOUNT_ID |
NUMERIC |
No |
|
|
|
This column stores the unique identifier for the hospital account that has related transaction information. |
|
|
2 |
LINE |
INTEGER |
No |
|
|
|
The line number in the results of a query. Each refund transaction will have its own line number. |
|
|
3 |
RFND_TX_ID |
NUMERIC |
No |
|
|
|
This column stores the unique identifier for the refund transaction associated with the hospital account. |
|
|
4 |
RFND_TX_UPDATE_DT |
DATETIME |
No |
|
|
|
The date of the last update of the refund transaction associated with the hospital account. |
|
|
5 |
REFUND_TX_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
The status of the refund transaction associated with the hospital account. i.e. 1-Posted 2-Exported 3-Comment Imported - Approved 4-Comment Imported - Rejected 5-Reversed |
May contain organization-specific values: No |
Category Entries: |
Posted |
Exported |
Comment Imported - Approved |
Comment Imported - Rejected |
Reversed |
|
|
6 |
REFUND_AMOUNT_SENT |
NUMERIC |
No |
|
|
|
The amount of the refund associated with the hospital account. |
|
|
7 |
REFUND_REF_NUMBER |
VARCHAR |
No |
|
|
|
The reference number of the refund associated with the hospital account. |
|
|
8 |
REFUND_IP_COMMENT |
VARCHAR |
No |
|
|
|
Import comment for the refund associated with the hospital account. |
|
|