HSP_ATND_PROV

Description:

The HSP_ATND_PROV table contains information on inpatient or outpatient attending providers. This table is based on PAT_ENC_CSN_ID.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	LINE	INTEGER	No
	The line number of the attending provider for the patient.
2	ATTEND_FROM_DATE	DATETIME (Local)	No
	The date and time the attending provider started for the patient. Can be assigned for both hospital encounters and outpatient visits. Dates are not guaranteed to be filled in. If dates are empty, this range is assumed to be open-ended. Date/time range only applies to this encounter. Checking relevant encounter dates should be done in addition to these dates to get the whole picture for an encounter.
3	ATTEND_TO_DATE	DATETIME (Local)	No
	The date and time the attending provider ended for the patient. Can be assigned for both hospital encounters and outpatient visits. Dates are not guaranteed to be filled in. If dates are empty, this range is assumed to be open-ended. Date/time range only applies to this encounter. Checking relevant encounter dates should be done in addition to these dates to get the whole picture for an encounter.
4	PROV_ID	VARCHAR	No
	This column stores the unique identifier for the attending provider for the patient. Can be assigned for both hospital encounters and outpatient visits. From and to dates are not guaranteed to be filled in.
5	ED_ATTEND_YN	VARCHAR	No
	Indicates whether or not this physician was an attending in the ED. May contain organization-specific values: No Category Entries: No Yes
6	PAT_ENC_CSN_ID	NUMERIC	No
	A unique serial number for this encounter. This number is unique across all patients and encounters in the system.