HH_EPSD_ANC_PROV
Description:
This table contains Home Health episode-level ancillary providers information. This information is entered in the Episode Info 2 form as part of an Intake encounter in the Ancillary Providers table.

Primary Key
Column Name Ordinal Position
SUMMARY_BLOCK_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 SUMMARY_BLOCK_ID NUMERIC No
Unique identifier for the episode.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 ANC_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 ANC_PROV_CMT VARCHAR No
Ancillary provider comment text entered by a user.
5 RECV_PLAN_OF_CARE_FYI_YN VARCHAR No
Flag for determining whether a provider should be included on FYI messages when new supplemental orders are added to the plan of care.
May contain organization-specific values: No
Category Entries:
No
Yes
6 ANC_PROV_UNQ_ADR_ID VARCHAR No
This item stores the unique ID of the address that should be used for this provider in the ancillary provider table.
7 ANC_PROV_REL_C_NAME VARCHAR No
The ancillary provider's relation to the patient.
May contain organization-specific values: Yes
No Entries Defined
8 ANC_PROV_START_DATE DATETIME No
The date on which the ancillary provider began care of the patient.
9 ANC_PROV_END_DATE DATETIME No
The date on which the ancillary provider ended care of the patient.