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_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
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.