CUST_SERVICE_2

Description:

The CUST_SERVICE_2 table stores information entered into system's Customer Service module. This can be used to report on communication between medical facility staff and patients.

Primary Key

Column Name	Ordinal Position
COMM_ID	1

Column Information

	Name	Type	Discontinued?
1	COMM_ID	NUMERIC	No
	The unique identifier (.1 item) for the communication record.
2	SOURCE_BROKERAGE_ID	VARCHAR	No
	Stores the source agency record (AGY) for the customer service record. If a CRM is created in Tapestry Link by a broker, a source agency can be linked instead of a source provider.
3	SOURCE_BROKERAGE_ID_AGENCY_NAME	VARCHAR	No
	The name of the agency.
4	SUBJECT_AGENCY_ID	VARCHAR	No
	Stores the subject Agency (AGY) for the CRM.
5	SUBJECT_AGENCY_ID_AGENCY_NAME	VARCHAR	No
	The name of the agency.
6	SUBJECT_AGENT_ID_AGENT_NAME	VARCHAR	No
	The name of the agent.