HSP_ACCT_ATND_PROV

Description:

This table contains hospital account attending provider 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 of the attending provider for the patient associated with the hospital account. Multiple attending providers can be stored in one hospital account, and each will have a unique line number.
3	ATTENDING_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	ATTEND_DATE_FROM	DATETIME	No
	The date on which a provider began to be an attending provider for the patient associated with the hospital account.
5	ATTEND_DATE_TO	DATETIME	No
	The date on which a provider ceased to be an attending provider for the patient associated with the hospital account.