CUST_SRVC_FAX_HX

Description:

This table extracts the fax history for the Customer Relationship Management record.

Primary Key

Column Name	Ordinal Position
COMM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	COMM_ID	NUMERIC	No
	The unique identifier for the communication record.
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	FAX_COMM_BY_USER_ID	VARCHAR	No
	This item stores the user who sent the fax.
4	FAX_COMM_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	FAX_COMM_DTTM	DATETIME (Local)	No
	This item stores the instant of communication for the fax.
6	FAX_COMM_INI	VARCHAR	No
	This item stores the master file initials of the fax recipient if the fax recipient is an existing master file record.
7	FAX_COMM_NAME	VARCHAR	No
	This item stores the name of the fax recipient.
8	FAX_COMM_FAX_NUM	VARCHAR	No
	This item stores the fax number of the fax recipient.
9	FAX_COMM_PHONE_NUM	VARCHAR	No
	This item stores the phone number of the fax recipient.
10	FAX_COMM_PROV_ID	VARCHAR	No
	The unique ID of the provider who received the fax.
11	FAX_COMM_DEP_ID	NUMERIC	No
	The unique ID of the department which received the fax.
12	FAX_COMM_LOC_ID	NUMERIC	No
	The unique ID of the location which received the fax.
13	FAX_COMM_PHRM_ID	NUMERIC	No
	The unique ID of the pharmacy which received the fax.
14	FAX_COMM_PHRM_ID_PHARMACY_NAME	VARCHAR	No
	The name of the pharmacy.