HSP_ACCT_COND_HAR

Description: |
This table contains hospital account claim condition codes from the Hospital Account Receivable (HAR) master file.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCT_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account.
2 | LINE | INTEGER | No |
This column stores the line number in the results of a query. Because multiple condition codes can be stored in one hospital account, each condition code will have a unique line number.
3 | CONDITION_CODE_C_NAME | VARCHAR | No |
A condition code used for claims associated with the hospital account.
May contain organization-specific values: Yes