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.