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	VARCHAR	No
	This column stores the unique identifier for the attending provider stored in the hospital account.
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.