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