HSP_ACCT_RFND_TX

Description: |
This table contains refund transaction information from the Hospital Accounts Receivable (HAR) master file.

Primary Key

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

Column Information

| 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.