HH_EPSD_AGENCY

Description:

This table contains episode-level agency information. It stores user-entered information about the outside agencies that will be assisting the patient while the patient is under Home Health care. This information is entered in the Referral Info 2 form as part of an Intake contact.

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	AGENCY_C_NAME	VARCHAR	No
	Link to custom category list of agencies, ZC_AGENCY. May contain organization-specific values: Yes
4	AGENCY_PHONE	VARCHAR	No
	Agency phone number.
5	AGENCY_CONTACT	VARCHAR	No
	Agency contact person.
6	AGENCY_COMMENT	VARCHAR	No
	Agency comment text entered by a user.