HSP_ACCT_CPT_ASSOC_DX

Description: |
This table stores the diagnoses that are linked to a coded Current Procedural Terminology (CPT)/Healthcare Common Procedure Coding System (HCPCS) code on a hospital account.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ACCT_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCT_ID | NUMERIC | No |
The unique identifier for the hospital account record.
2 | GROUP_LINE | INTEGER | No |
The line number of the CPT©/HCPCS code stored on the hospital account to which the diagnoses are linked.
3 | VALUE_LINE | INTEGER | No |
The line number of an associated diagnosis linked to a specific CPT©/HCPCS code on a hospital account.
4 | CPT_LINKED_DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.