CUST_SERVICE_FORMS

Description:

This table contains information about the forms associated to this customer service communication.

Primary Key

Column Name	Ordinal Position
COMM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	COMM_ID	NUMERIC	No
	The unique identifier (.1 item) 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	CRM_FORMS_LIST_FORM_ID	VARCHAR	No
	Holds both filed and unfiled forms attached to the communication.
4	CRM_FORMS_LIST_FORM_ID_FORM_NAME	VARCHAR	No
	The name of the form associated with the questionnaire.
5	CRM_FORMS_FILED_YN	VARCHAR	No
	Indicates whether the form is filed or not. May contain organization-specific values: No Category Entries: No Yes
6	FORM_CSN_ID	NUMERIC	No
	This item stores the contact serial number (I LQF 8) of the SmartForms used in this encounter. Additionally, like I NCS 630, this information is passed from the relevant host. If the host does not pass the information, then the SmartForm CSN may not appear in this item.