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.