TX_DIAG

Description: |
This table contains information about the diagnoses associated with transactions. Since one transaction may be associated with multiple diagnoses, each row in this table represents one diagnosis and is identified by the transaction ID and line number. The first six diagnosis IDs associated with a transaction are recorded in the CLARITY_TDL table in the columns DX_ ONE_ID through DX_ SIX_ID. This table allows you to easily identify transactions with a specific diagnosis code or range of diagnosis codes. The data for this table is extracted using a KB_SQL query.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | TX_ID | NUMERIC | No |
The unique accounts receivable transaction record ID.
2 | LINE | INTEGER | No |
Line number to identify each row of diagnosis data associated with an individual transaction. Line 1 identifies the primary diagnosis of the charge.
3 | POST_DATE | DATETIME | No |
The post date of the charge transaction
4 | SERV_AREA_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
5 | DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
6 | DX_QUALIFIER_C_NAME | VARCHAR | No |
Diagnosis Qualifier for the diagnosis associated with this charge
May contain organization-specific values: Yes