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	VARCHAR	No
	Stores the Ancillary provider ID. Links to the provider (SER) master file. Links to table CLARITY_SER.
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.