HSP_TX_DIAG

Description: |
This table contains hospital account transaction diagnoses from the Hospital Permanent Transactions (HTR) master file.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
This column stores the unique identifier for the hospital billing transaction.
2 | LINE | INTEGER | No |
The line number in the results of a query. Because multiple diagnosis codes can be associated with one charge, each diagnosis will have a unique line number.
3 | HSP_ACCOUNT_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account associated with the hospital billing transaction.
4 | POST_DATE | DATETIME | No |
The post date of a transaction.
5 | SERV_AREA_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
6 | DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
7 | DX_QUAL_HA_C_NAME | VARCHAR | No |
A qualifier entered with a diagnosis code in charge entry.
May contain organization-specific values: Yes
Category Entries:
Active
Inactive
Acute
Chronic
Temporary