HSP_ACCT_OTHR_PROV

Description: |
This table contains hospital account other providers information from the Hospital Accounts Receivable (HAR) master file.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HSP_ACCOUNT_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. As multiple "other providers" can be stored in one hospital account, each provider will have a unique line number.
3 | 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.
4 | OTH_PRV_ROLE_C_NAME | VARCHAR | No |
This column stores the role associated with an "other provider" stored in the hospital account.
May contain organization-specific values: Yes