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	VARCHAR	No
	This column stores the unique identifier for an "other provider" stored in the hospital account. The hospital account can store an attending, admitting, and referring provider, plus any number of other providers. For each other provider, the user can specify a role the provider played in treatment.
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