HSP_ACCT_CPT_PRVDR

Description: |
This table contains the other providers associated with the hospital account CPT(R)/HCPCS codes list in the Hospital Accounts Receivable (HAR) master file.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HSP_ACCOUNT_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account.
2 | GROUP_LINE | INTEGER | No |
The line number for the information associated with this record.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple values associated with a specific group of data within this record.
4 | CPT_OTHER_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.